protected void Save_Click(object sender, EventArgs e) { //判断btn Button btn = (Button)sender; string s = btn.ID; int srxzStr = hkdb.GetValueChk_Int(srxz.Checked); int cfStr = hkdb.GetValueChk_Int(cf.Checked); int txStr = hkdb.GetValueChk_Int(tx.Checked); string sdateStr = null; string edateStr = null; sdateStr = hkdb.GetStr(srq.Text) + " " + sxs.SelectedValue + sfz.SelectedValue; edateStr = hkdb.GetStr(erq.Text) + " " + exs.SelectedValue + efz.SelectedValue; if (Convert.ToDateTime(edateStr) < Convert.ToDateTime(sdateStr)) { mydb.Alert("开始时间必须小于结束时间!"); return; } if (scheid == 0) { SqlHelper.ExecuteSql("INSERT INTO HK_JSB (EMPID,SUBJECT,SCHTYPE,PLACE,CONTENT,PRIVFLAG,REPEATFLAG,REQUENCATE,UPTODATE,REMINDFLAG,REMINDDAY,FDATE,TDATE,CDATE,YYRY) VALUES('" + this.Session["userid"] + "','" + hkdb.GetStr(zt.Text) + "','" + lx.SelectedValue + "','" + hkdb.GetStr(dd.Text) + "','" + hkdb.GetStr(nr.Text) + "'," + srxzStr + "," + cfStr + ",'" + cfzq.SelectedValue + "','" + hkdb.GetStr(jzrq.Text) + "'," + txStr + ",'" + hkdb.GetStr(txts.Text) + "','" + hkdb.GetStr(sdateStr) + "','" + hkdb.GetStr(edateStr) + "',GETDATE(),'" + hkdb.GetStr(UserID.Text).TrimEnd(',') + "')"); } else { SqlHelper.ExecuteSql("UPDATE HK_JSB SET Subject='" + hkdb.GetStr(zt.Text) + "',SchType='" + lx.SelectedValue + "',Place='" + hkdb.GetStr(dd.Text) + "',Content='" + hkdb.GetStr(nr.Text) + "',PrivFlag=" + srxzStr + ",RepeatFlag=" + cfStr + ",RequenCate='" + cfzq.SelectedValue + "',UpToDate='" + hkdb.GetStr(jzrq.Text) + "',RemindFlag=" + txStr + ",RemindDay='" + hkdb.GetStr(txts.Text) + "',FDate='" + hkdb.GetStr(sdateStr) + "',TDate='" + hkdb.GetStr(edateStr) + "',yyry='" + hkdb.GetStr(UserID.Text).TrimEnd(',') + "' WHERE SchID=" + scheid + ""); } //Msg if (xxtz.Checked == true | dxtz.Checked == true) { string message = this.Session["username"].ToString() + "就[" + hkdb.GetStr(zt.Text) + "]事情在" + sdateStr + "至" + edateStr + "向您预约时间!"; hkdb.SendMsg(xxtz.Checked, dxtz.Checked, this.Session["userid"].ToString(), UserID.Text, message); } //判断btn if (s == "SaveAddBtn") { zt.Text = ""; lx.SelectedValue = ""; dd.Text = ""; sxs.SelectedValue = ""; sfz.SelectedValue = ""; exs.SelectedValue = ""; efz.SelectedValue = ""; txts.Text = ""; tx.Checked = false; nr.Text = ""; srxz.Checked = false; cfzq.SelectedValue = "0"; jzrq.Text = ""; cf.Checked = false; UserName.Text = ""; UserID.Text = ""; mydb.Alert_Refresh("保存成功,请新增下一条记录!", "Wdjsb.aspx"); } else { Server.Transfer((reurl + "?i=2&date=" + date)); } }