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;
}
}
