admin/qiuyuan/Add.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Text;
using System.Data.SqlClient;
using System.Data;

public partial class admin_qiuyuan_Add : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
    {
        (Master.FindControl("Label1") as Label).Text = "添加赛事";
    }
    /// <summary>
    /// 确认操作
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void btnSave_Click(object sender, EventArgs e)
    {
        //设置Sql
        StringBuilder strSql = new StringBuilder();
        strSql.Append(@"insert into qiuyuan ( haoma,xingming,tupian,weizhi,shengao,tizhong,chushengriqi,qiudui ) ");
        strSql.Append(@" values (@haoma,@xingming,@tupian,@weizhi,@shengao,@tizhong,@chushengriqi,@qiudui)");
        //设置参数
        SqlParameter[] parameters = new SqlParameter[] {
            new SqlParameter("@haoma", SqlDbType.VarChar,50),
            new SqlParameter("@xingming", SqlDbType.VarChar,50),
             new SqlParameter("@tupian", SqlDbType.VarChar,100),
           new SqlParameter("@weizhi", SqlDbType.VarChar,50),
            new SqlParameter("@shengao", SqlDbType.VarChar,100),
            new SqlParameter("@tizhong", SqlDbType.VarChar,100),
            new SqlParameter("@chushengriqi", SqlDbType.VarChar,100),
            new SqlParameter("@qiudui", SqlDbType.VarChar,100)};
        parameters[0].Value = this.txt_haoma.Text;
        parameters[1].Value = this.txt_xingming.Text;
        string addrpic = "";
        if (fppic.HasFile)
        {
            string name = this.fppic.PostedFile.FileName;
            int i = name.LastIndexOf('.');
            string extname = name.Substring(i);
            string filename = DateTime.Now.ToString("yyyyMMddhhmmssfff");
            string path = filename + extname;
            string savePath = Server.MapPath(@"..\..\uploads\" + filename + extname);
            fppic.PostedFile.SaveAs(savePath);
            addrpic = path;
        }
        parameters[2].Value = addrpic;
        parameters[3].Value = this.DropDownList1.Text;
        parameters[4].Value = this.txt_shengao.Text;
        parameters[5].Value = this.txt_tizhong.Text;
        parameters[6].Value = this.riqi.Text;
        parameters[7].Value = this.DropDownList2.Text;
       
        //提交到数据库
        DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);