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