C# DBConnector.ExecuteNonQuery方法代码示例

 protected void ButtonCommit_Click(object sender, EventArgs e)
 {
     //评论字数不能过小
     if (TextBoxComment.Text.Length < 5)
     {
         Helper.MsgBox("请至少输入五个字");
     }
     else
     {
         //插入评论记录
         DBConnector db = new DBConnector();
         String strSql = String.Format("Insert into Comments(CommenterId, FileMD5, CommentTime, Comment) Values({0}, '{1}', '{2}', '{3}')", Helper.UserId,
             StrMd5, DateTime.Now.ToString(), TextBoxComment.Text);
         db.ExecuteNonQuery(strSql);
         //增加文件的评论数
         strSql = String.Format("update Files set CommentCount = (Select CommentCount from Files where MD5='{0}') + 1 where MD5 = '{0}'", StrMd5);
         db.ExecuteNonQuery(strSql);
         //Helper.MsgBox("添加成功");
         //清空输入评价文本框
         TextBoxComment.Text = "";
         //显示评价
         ShowComments();
     }
 }

 protected void ButtonDelete_Click(object sender, EventArgs e)
 {
     //修改是否已删除为“是”
     //删除文件
     //跳转到主页
     DBConnector db = new DBConnector();
     db.ExecuteNonQuery("Update Files set IdDeleted = 1 where MD5 = '" + StrMd5 + "'");
     try
     {
         System.IO.File.Delete(Server.MapPath(StrFilePathName));
     }
     catch (System.Exception ex)
     {
         Helper.MsgBox("删除文件错误", ".\\Default.aspx");
     }
     Helper.MsgBox("删除成功", ".\\Default.aspx");
 }

 protected void ButtonUpload2_Click(object sender, EventArgs e)
 {
     String strMd5 = "";
     int iLength = 0;
     String strFileName = "";
     //如果上传控件已选择文件
     if (FileUpload1.HasFile)
     {
         strFileName = FileUpload1.FileName;
         //将文件上传到零时目录下
         FileUpload1.SaveAs(Server.MapPath(".\\Temp\\" + strFileName));
         //将文件读取到字符串
         String contents = File.ReadAllText(Server.MapPath(".\\Temp\\" + strFileName));
         //计算文件 MD5 值
         strMd5 = Helper.CalMD5(contents);
         //检查 MD5 是否在系统中存在，即文件是否重复。
         DBConnector db = new DBConnector();
         int n = (int)db.ExecuteObject("Select count(*) From Files Where MD5='" + strMd5 + "'");
         if (n > 0)
         {
             //如果重复，删除该文件
             File.Delete(Server.MapPath(".\\Temp\\" + strFileName));
             Helper.MsgBox("系统中已存在该文件", "./ViewFile.aspx?MD5=" + strMd5);
         }
         else//否则
         {
             //将文件移动到上传目录下
             File.Move(Server.MapPath(".\\Temp\\" + strFileName), Server.MapPath(".\\Uploads\\" + strFileName));
             //计算文件长度
             iLength = FileUpload1.PostedFile.ContentLength;
             //插入文件记录
             String strSql = String.Format("Insert into Files (MD5, Title, Brief, Size, Point, UploadTime, UploaderId, FilePath, FileName)" +
                 " Values('{0}', '{1}', '{2}', {3}, {4}, '{5}', {6}, '.\\Uploads\\', '{7}')", strMd5,
                 TextBoxTitle.Text, TextBoxBrief.Text, iLength, TextBoxPoint.Text, DateTime.Now.ToString(),
                 Helper.UserId, strFileName);
             db.ExecuteNonQuery(strSql);
             Helper.MsgBox("上传成功", "./ViewFile.aspx?MD5=" + strMd5);
         }
     }
 }

    protected void ButtonAddUser_Click(object sender, EventArgs e)
    {
        //1、检查学号是否已存在
        String strSql = String.Format("Select Count(*) From Users Where ID = '{0}'", TextBoxUserId.Text);
        DBConnector db = new DBConnector();

        if ((Int32)db.ExecuteObject(strSql) != 0 )
        {
            Helper.MsgBox("该用户已存在");
            return;
        }
        else
        {
            //是否管理员
            Int32 iIsAdmin;
            if (CheckBoxIsAdmin.Checked == true)
            {
                iIsAdmin = 1;
            }
            else
            {
                iIsAdmin = 0;
            }

            strSql = String.Format(@"Insert Into Users(ID, Pwd, Name, ClassId, Point, AddTime, IsAdmin, IsDeleted)
                Values({0}, '{1}', '{2}', {3}, 0, '{4}', {5}, 0)", TextBoxUserId.Text, Helper.CalMD5(TextBoxPwd.Text),
                TextBoxName.Text, DropDownListClass.SelectedIndex, DateTime.Now, iIsAdmin);
            if (db.ExecuteNonQuery(strSql) == true)
            {
                Helper.MsgBox("添加失败");
            }
            else
            {
                Helper.MsgBox("添加成功", "Default.aspx");
            }
        }
    }

 protected void ButtonDownload_Click(object sender, EventArgs e)
 {
     //如果下载地址为空
     if (StrFilePathName == null)
     {
         Helper.MsgBox("下载地址错误");
         return;
     }
     DBConnector db = new DBConnector();
     //增加文件的下载数
     String strSql = "Update Files set DownloadCount = (Select DownloadCount From Files Where MD5='" + StrMd5 +
                     "') + 1 Where MD5='" + StrMd5 + "'";
     db.ExecuteNonQuery(strSql);
     //插入下载记录
     strSql = "Insert Into Downloads(DownloaderId, FileMd5, DownloadTime) values(" + "61287, '" +
         StrMd5 + "', '" + System.DateTime.Now + "')";
     db.ExecuteNonQuery(strSql);
     //减少下载者的积分
     strSql = "Update Users set Point = (Select Point From Users Where ID=" + Helper.UserId + ") - " + IFilePoint +
         " where ID=" + Helper.UserId;
     db.ExecuteNonQuery(strSql);
     //增加上传者的积分
     strSql = "Update Users set Point = (Select Point From Users Where ID=" + IUploaderId + ") + " + IFilePoint +
         " where ID=" + IUploaderId;
     db.ExecuteNonQuery(strSql);
     Response.Redirect(StrFilePathName);
 }

    protected void Page_Load(object sender, EventArgs e)
    {
        if (Helper.UserId == 0)
        {
            ButtonDownload.Enabled = false;
        }
        if (!IsPostBack)
        {
            //获取下载地址
            if (Request.QueryString["MD5"] != null)
            {
                StrMd5 = Request.QueryString["MD5"];

                String strSql = "Select UploaderId, FilePath, FileName, Point From Files Where MD5='"
                    + Request.QueryString["MD5"] + "'";
                DBConnector db = new DBConnector();
                using (SqlDataReader dr = db.ExecuteReader(strSql))
                {
                    while (dr.Read())
                    {
                        StrFilePathName = dr.GetString(1) + dr.GetString(2);
                        IUploaderId = dr.GetInt32(0);
                        IFilePoint = dr.GetInt32(3);
                    }
                    dr.Close();
                }
                //如果不是管理员或者上传者，应取消编辑和删除按钮，取消下载记录
                if (!(Helper.IsAdmin || IUploaderId == Helper.UserId))
                {
                    ButtonEdit.Visible = false;
                    ButtonDelete.Visible = false;
                    GridViewDownload.Visible = false;
                    LabelDownloads.Visible = false;
                }
                else
                {
                    ButtonEdit.Visible = true;
                    ButtonDelete.Visible = true;
                    GridViewDownload.Visible = true;
                    LabelDownloads.Visible = true;
                }

                //增加下载次数
                strSql = "Update Files set ViewCount = (Select ViewCount From Files Where MD5='" + StrMd5 +
                    "') + 1 Where MD5='" + StrMd5 + "'";

                db.ExecuteNonQuery(strSql);

                ShowComments();
            }
            else
            {
                Response.Redirect("Default.aspx");
            }

        }
    }

 public static int UpdateInfoWithKey(string key, string newInfo, DBConnector connector)
 {
     var commandQuery = string.Format("{0} {1} = '{2}' WHERE {3} = '{4}'", CommandBuilder.InitUpdateStatement(Constants.StatusTableName), Constants.ValueColumn, newInfo, Constants.StatusColumn, key);
     SqlCommand command = new SqlCommand(commandQuery);
     return connector.ExecuteNonQuery(command);
 }