public ActionResult Queryqj() { //窗体加载时要先显示职员的请假信息 string id = Request.QueryString["id"];//请假信息的主键 RenshiServiceSoapClient renshiService = new RenshiServiceSoapClient(); RenshiService.HEX001TB hex001tb = new RenshiService.HEX001TB(); hex001tb.id = id; hex001tb.ex_date = DateTime.Now; DataTable dt = renshiService.SearchHEX001TB(hex001tb); Models.HEX001TB hEX001TB = new Models.HEX001TB(); if (dt.Rows.Count > 0) { hEX001TB.emp_no = dt.Rows[0]["emp_no"].ToString(); hEX001TB.emp_nm = dt.Rows[0]["emp_nm"].ToString(); hEX001TB.entr_dt = dt.Rows[0]["entr_dt"].ToString(); hEX001TB.dept_nm = dt.Rows[0]["dept_nm"].ToString(); hEX001TB.ex_date = dt.Rows[0]["ex_date"].ToString(); hEX001TB.dilig_nm = dt.Rows[0]["dilig_nm"].ToString(); hEX001TB.ex_btime = dt.Rows[0]["ex_btime"].ToString(); hEX001TB.ex_etime = dt.Rows[0]["ex_etime"].ToString(); hEX001TB.ex_hh = dt.Rows[0]["ex_hh"].ToString(); hEX001TB.ex_remark = dt.Rows[0]["ex_remark"].ToString(); hEX001TB.ck_flg = dt.Rows[0]["ck_flg"].ToString(); hEX001TB.ck_flg_nm = dt.Rows[0]["ck_flg_nm"].ToString(); hEX001TB.ck_remark = dt.Rows[0]["ck_remark"].ToString(); } return(View(hEX001TB)); }
public ActionResult Check(FormCollection collection) { string id = Request.QueryString["id"];//请假信息的主键 //把审核后的信息发送给申请的人 //先更新数据库的审核状态 RenshiServiceSoapClient renshiService = new RenshiServiceSoapClient(); RenshiService.HEX001TB hex001tb = new RenshiService.HEX001TB(); hex001tb.id = id; hex001tb.ex_date = DateTime.Now; hex001tb.ck_remark = collection["ck_remark"]; hex001tb.ck_flg = collection["check"]; DataTable dt = renshiService.CheckHEX001TB(hex001tb); if (dt.Rows.Count > 0) { //请假审核后,调用推送信息的函数 string agentid = ConfigurationManager.AppSettings["AgentIdForRenshi"]; SendMessageServiceSoapClient sendMessageService = new SendMessageServiceSoapClient(); sendMessageService.QingJiaPushMessage(id, agentid, hex001tb.ck_flg, "check_succeed"); } dt = null; dt = renshiService.SearchHEX001TB(hex001tb); Models.HEX001TB hEX001TB = new Models.HEX001TB(); if (dt.Rows.Count > 0) { hEX001TB.emp_no = dt.Rows[0]["emp_no"].ToString(); hEX001TB.emp_nm = dt.Rows[0]["emp_nm"].ToString(); hEX001TB.entr_dt = dt.Rows[0]["entr_dt"].ToString(); hEX001TB.dept_nm = dt.Rows[0]["dept_nm"].ToString(); hEX001TB.ex_date = dt.Rows[0]["ex_date"].ToString(); hEX001TB.dilig_nm = dt.Rows[0]["dilig_nm"].ToString(); hEX001TB.ex_btime = dt.Rows[0]["ex_btime"].ToString(); hEX001TB.ex_etime = dt.Rows[0]["ex_etime"].ToString(); hEX001TB.ex_hh = dt.Rows[0]["ex_hh"].ToString(); hEX001TB.ex_remark = dt.Rows[0]["ex_remark"].ToString(); hEX001TB.ck_flg = dt.Rows[0]["ck_flg"].ToString(); hEX001TB.ck_flg_nm = dt.Rows[0]["ck_flg_nm"].ToString(); hEX001TB.ck_remark = dt.Rows[0]["ck_remark"].ToString(); } return(View(hEX001TB)); }