private void btn_Save_Click(object sender, System.EventArgs e) { string strMingCheng = "'" + this.list_Name.SelectedItem.Text.Trim() + "',"; string strYuanyin = "'" + this.TextBox2.Text.Trim() + "',"; string strDanwei = "'" + this.TextBox4.Text.Trim() + "',"; string strFuzeren = "'" + this.TextBox3.Text.Trim() + "',"; string strBeiZhu = "'" + this.TextBox5.Text.Trim() + "'"; string strFukuanfou = "'" + this.list_blPay.SelectedItem.Text.Trim() + "',"; string strRiqi = "'" + this.list_Year.SelectedItem.Text + "/" + this.list_Month.SelectedItem.Text + "/" + this.list_Day.SelectedItem.Text + "',"; try { if (theID.Value.Length > 0) //修改 { strSQL = "update shebei_weixiu set" + " mingcheng=" + strMingCheng + "yuanyin=" + strYuanyin + "danwei=" + strDanwei + "fuzeren=" + strFuzeren + "riqi=" + strRiqi + "fukuanfou=" + strFukuanfou + "beizhu=" + strBeiZhu + " where id='" + theID.Value.Trim() + "'"; Utility.Execute(strSQL); } else //添加新记录 { strSQL = "insert into shebei_weixiu values (" + strMingCheng + strYuanyin + strDanwei + strFuzeren + strRiqi + strFukuanfou + strBeiZhu + ")"; Utility.Execute(strSQL); this.TextBox2.Text = ""; this.TextBox3.Text = ""; this.TextBox4.Text = ""; this.TextBox5.Text = ""; } this.lblErrMsg.Text = "数据保存成功!"; this.lblErrMsg.Visible = true; } catch { this.lblErrMsg.Text = "保存时出错,请重新输入!"; this.lblErrMsg.Visible = true; } }
private void DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { DataGrid1.EditItemIndex = -1; int idNum = (int)DataGrid1.DataKeys[e.Item.ItemIndex]; string strDelSQL = "delete from shebei_weixiu where id=" + idNum; Utility.Execute(strDelSQL); BindDataGrid(); }
private void DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { DataGrid1.EditItemIndex = -1; string idNum = DataGrid1.DataKeys[e.Item.ItemIndex].ToString().Trim(); string strDelSQL = "delete from zhuhu where bianhao='" + idNum + "'"; Utility.Execute(strDelSQL); BindDataGrid(); }
private void btn_Save_Click(object sender, System.EventArgs e) { string strMingCheng = "'" + this.TextBox1.Text.Trim() + "',"; string strGuiGe = "'" + this.TextBox2.Text.Trim() + "',"; string strChangShang = "'" + this.TextBox4.Text.Trim() + "',"; string strZhouQi = "'" + this.TextBox5.Text.Trim() + "',"; string strBeiZhu = "'" + this.TextBox7.Text.Trim() + "'"; string strShuLiang = ""; int intShuLiang = 0; try { this.lblErrMsg.Visible = false; strShuLiang = this.TextBox3.Text.Trim(); intShuLiang = Convert.ToInt32(strShuLiang); } catch { strShuLiang = intShuLiang.ToString(); this.lblErrMsg.Text = "输入的数量值不是合法的数字,存入数据库时已忽略该值!"; this.lblErrMsg.Visible = true; } strShuLiang = "'" + strShuLiang + "',"; string strRiQi = "'" + this.list_Year.SelectedItem.Text + "/" + this.list_Month.SelectedItem.Text + "/" + this.list_Day.SelectedItem.Text + "',"; try { if (theID.Value.Length > 0) { strSQL = "update shebei_mingxi set" + " mingcheng=" + strMingCheng + "guige=" + strGuiGe + "shuliang=" + strShuLiang + "changshang=" + strChangShang + "riqi=" + strRiQi + "zhouqi=" + strZhouQi + "beizhu=" + strBeiZhu + " where id='" + theID.Value.Trim() + "'"; Utility.Execute(strSQL); } else { strSQL = "insert into shebei_mingxi values (" + strMingCheng + strGuiGe + strShuLiang + strChangShang + strRiQi + strZhouQi + strBeiZhu + ")"; Utility.Execute(strSQL); this.TextBox1.Text = "必填项"; this.TextBox2.Text = ""; this.TextBox3.Text = ""; this.TextBox4.Text = ""; this.TextBox5.Text = ""; this.TextBox7.Text = ""; } this.lblErrMsg.Text = "数据保存成功!"; this.lblErrMsg.Visible = true; } catch { this.lblErrMsg.Text = "保存时出错,请重新输入!"; this.lblErrMsg.Visible = true; } }