public ActionResult Change_pwd(FormCollection collection)
{
string id = Request.QueryString["id"];
string old = collection["old"];
string pwd = collection["password"];
string pwd1 = collection["password1"];
if (pwd != pwd1)
{
return(View(2));
}
else
{
RenshiServiceSoapClient renshiService = new RenshiServiceSoapClient();
bool bl = renshiService.UserCheck(id, old);
if (bl == true)
{
bl = false;
bl = renshiService.Change_pwd(id, pwd);
if (bl == true)
{
return(View(1));
}
else
{
return(View(0));
}
}
else
{
return(View(3));
}
}
}
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 Login(FormCollection collection)
{
string id = Request.QueryString["id"];
string pwd = collection["password"];
RenshiServiceSoapClient renshiService = new RenshiServiceSoapClient();
bool bl = renshiService.UserCheck(id, pwd);
if (bl == true)
{
return(Redirect("~/renshi/gongzi?id=" + id));
}
else
{
return(View(0));
}
}
/// <summary>
/// 职员档案信息
/// </summary>
/// <returns></returns>
public ActionResult Dangan()
{
string emp_no = Request.QueryString["id"];
RenshiServiceSoapClient renshiService = new RenshiServiceSoapClient();
DataTable dt = renshiService.SearchUserinfo(emp_no);
Dangan dangan = new Dangan();
if (dt.Rows.Count > 0)
{
dangan.Emp_no = dt.Rows[0]["emp_no"].ToString();
dangan.Emp_nm = dt.Rows[0]["emp_nm"].ToString();
dangan.Entr_dt = dt.Rows[0]["entr_dt"].ToString();
dangan.Dept_nm = dt.Rows[0]["dept_nm"].ToString();
}
return(View(dangan));
}
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));
}
public ActionResult Qrkq(FormCollection collection)
{
string emp_no = Request.QueryString["id"];
RenshiServiceSoapClient renshiService = new RenshiServiceSoapClient();
DataTable dt = renshiService.SearchMonth("queren", "");
string month = dt.Rows[0]["msg_text"].ToString();
dt = null;
dt = renshiService.Qrkq("post", emp_no, month);
Message message = new Message();
message.Msg_cd = dt.Rows[0]["msg_cd"].ToString();
message.Msg_text = dt.Rows[0]["msg_text"].ToString();
DataSet ds = renshiService.SearchKaoqin(emp_no, month);
//加班项目
if (ds.Tables[0].Rows.Count > 0)
{
List <Kaoqin_Jiaban> ltjiaban = new List <Kaoqin_Jiaban>();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Kaoqin_Jiaban kaoqin_Jiaban = new Kaoqin_Jiaban();
kaoqin_Jiaban.Rt_date = ds.Tables[0].Rows[i]["rt_date"].ToString();
kaoqin_Jiaban.Wd_day = ds.Tables[0].Rows[i]["wd_day"].ToString();
kaoqin_Jiaban.Dilig_nm = ds.Tables[0].Rows[i]["dilig_nm"].ToString();
kaoqin_Jiaban.Fq_name = ds.Tables[0].Rows[i]["fq_name"].ToString();
kaoqin_Jiaban.Rt_btime = ds.Tables[0].Rows[i]["rt_btime"].ToString();
kaoqin_Jiaban.Rt_etime = ds.Tables[0].Rows[i]["rt_etime"].ToString();
kaoqin_Jiaban.Rt_hh = Convert.ToDecimal(ds.Tables[0].Rows[i]["rt_hh"].ToString());
ltjiaban.Add(kaoqin_Jiaban);
ViewData["jiaban"] = ltjiaban;
}
}
else
{
List <Kaoqin_Jiaban> ltjiaban = new List <Kaoqin_Jiaban>();
Kaoqin_Jiaban kaoqin_Jiaban = new Kaoqin_Jiaban();
ltjiaban.Add(kaoqin_Jiaban);
ViewData["jiaban"] = ltjiaban;
}
//请假项目
if (ds.Tables[1].Rows.Count > 0)
{
List <Kaoqin_Qingjia> ltqingjia = new List <Kaoqin_Qingjia>();
for (int i = 0; i < ds.Tables[1].Rows.Count; i++)
{
Kaoqin_Qingjia kaoqin_Qingjia = new Kaoqin_Qingjia();
kaoqin_Qingjia.Ex_date = ds.Tables[1].Rows[i]["ex_date"].ToString();
kaoqin_Qingjia.Wd_day = ds.Tables[1].Rows[i]["wd_day"].ToString();
kaoqin_Qingjia.Dilig_nm = ds.Tables[1].Rows[i]["dilig_nm"].ToString();
kaoqin_Qingjia.Fq_name = ds.Tables[1].Rows[i]["fq_name"].ToString();
kaoqin_Qingjia.Ex_btime = ds.Tables[1].Rows[i]["ex_btime"].ToString();
kaoqin_Qingjia.Ex_etime = ds.Tables[1].Rows[i]["ex_etime"].ToString();
kaoqin_Qingjia.Ex_hh = Convert.ToDecimal(ds.Tables[1].Rows[i]["ex_hh"].ToString());
ltqingjia.Add(kaoqin_Qingjia);
ViewData["qingjia"] = ltqingjia;
}
}
else
{
List <Kaoqin_Qingjia> ltqingjia = new List <Kaoqin_Qingjia>();
Kaoqin_Qingjia kaoqin_Qingjia = new Kaoqin_Qingjia();
ltqingjia.Add(kaoqin_Qingjia);
ViewData["qingjia"] = ltqingjia;
}
//异常出勤
if (ds.Tables[2].Rows.Count > 0)
{
List <Kaoqin_Yichang> ltyichang = new List <Kaoqin_Yichang>();
for (int i = 0; i < ds.Tables[2].Rows.Count; i++)
{
Kaoqin_Yichang kaoqin_Yichang = new Kaoqin_Yichang();
kaoqin_Yichang.Rt_date = ds.Tables[2].Rows[i]["rt_date"].ToString();
kaoqin_Yichang.Wd_day = ds.Tables[2].Rows[i]["wd_day"].ToString();
kaoqin_Yichang.Dilig_nm = ds.Tables[2].Rows[i]["dilig_nm"].ToString();
kaoqin_Yichang.Fq_name = ds.Tables[2].Rows[i]["fq_name"].ToString();
kaoqin_Yichang.Rt_btime = ds.Tables[2].Rows[i]["rt_btime"].ToString();
kaoqin_Yichang.Rt_etime = ds.Tables[2].Rows[i]["rt_etime"].ToString();
kaoqin_Yichang.Rt_hh = Convert.ToDecimal(ds.Tables[2].Rows[i]["rt_hh"].ToString());
ltyichang.Add(kaoqin_Yichang);
ViewData["yichang"] = ltyichang;
}
}
else
{
List <Kaoqin_Yichang> ltyichang = new List <Kaoqin_Yichang>();
Kaoqin_Yichang kaoqin_Yichang = new Kaoqin_Yichang();
ltyichang.Add(kaoqin_Yichang);
ViewData["yichang"] = ltyichang;
}
return(View(message));
}
public ActionResult Qingjia(FormCollection collection)
{
string emp_no = Request.QueryString["id"];//职员工号
RenshiServiceSoapClient renshiService = new RenshiServiceSoapClient();
DataTable dt = renshiService.SearchUserinfo(emp_no);
Dangan dangan = new Dangan();
if (dt.Rows.Count > 0)
{
dangan.Emp_no = dt.Rows[0]["emp_no"].ToString();
dangan.Emp_nm = dt.Rows[0]["emp_nm"].ToString();
dangan.Entr_dt = dt.Rows[0]["entr_dt"].ToString();
dangan.Dept_nm = dt.Rows[0]["dept_nm"].ToString();
}
//把用户提交的请假申请insert到数据表中，然后接收返回的信息
RenshiService.HEX001TB hex001tb = new RenshiService.HEX001TB();
//生成一个随机串，用作主键
string ss = System.Guid.NewGuid().ToString();
string s2 = ss.Substring(24, 12);
hex001tb.id = s2;
hex001tb.emp_no = emp_no;
hex001tb.ex_date = Convert.ToDateTime(collection["ex_date"]);
hex001tb.dilig_cd = collection["combox_dilig"];
hex001tb.ex_btime = collection["ex_btime"];
hex001tb.ex_etime = collection["ex_etime"];
hex001tb.ex_remark = collection["ex_remark"];
hex001tb.ins_no = emp_no;
dt = null;
dt = renshiService.AddHEX001TB(hex001tb);
if (dt.Rows.Count > 0)
{
string msg_cd = dt.Rows[0]["msg_cd"].ToString();
string msg_text = dt.Rows[0]["msg_text"].ToString();
//如果返回0，则说明保存成功，此时需要发送消息给管理员审核
if (msg_cd == "0")
{
//保存成功后发送信息给审核人员
string agentid = ConfigurationManager.AppSettings["AgentIdForRenshi"];
string send_class = ConfigurationManager.AppSettings["PushMsgForQingJiaRenshi"];
SendMessageServiceSoapClient sendMessageService = new SendMessageServiceSoapClient();
Error error = new Error();
//推送请假审核信息给审核者
error = sendMessageService.QingJiaPushMessage(hex001tb.id, agentid, send_class, "insert_succeed");
//根据返回的信息来判断是否推送信息成功
if (error.errcode == 0) //推送成功
{
dangan.msg_cd = msg_cd;
dangan.msg_text = msg_text;
}
else//推送失败，则要把登记的请假信息删除，并推送一条信息给申请的用户，告知推送失败了。
{
dangan.msg_cd = error.errcode.ToString();
dangan.msg_text = error.errmsg;
//推送失败信息给请假申请者
sendMessageService.QingJiaPushMessage(hex001tb.id, agentid, send_class, "sending_failure");
//删除请假申请信息
renshiService.DeleteHEX001TB(hex001tb);
}
}
}
return(View(dangan));
}
public ActionResult Gongzi(FormCollection collection)
{
string month = collection["combox_year"];
month = month + collection["combox_month"];
string emp_no = Request.QueryString["id"];
RenshiServiceSoapClient renshiService = new RenshiServiceSoapClient();
DataTable dt = renshiService.SearchMonth("gongzi", month);
Message message = new Message();
message.Msg_cd = dt.Rows[0]["msg_cd"].ToString();
message.Msg_text = dt.Rows[0]["msg_text"].ToString();
if (message.Msg_cd == "N")
{
List <Gongzi_Zhifu> ltzhifu = new List <Gongzi_Zhifu>();
Gongzi_Zhifu gongzi_Zhifu = new Gongzi_Zhifu();
ltzhifu.Add(gongzi_Zhifu);
ViewData["zhifu"] = ltzhifu;
List <Gongzi_Kouchu> ltkouchu = new List <Gongzi_Kouchu>();
Gongzi_Kouchu gongzi_Kouchu = new Gongzi_Kouchu();
ltkouchu.Add(gongzi_Kouchu);
ViewData["kouchu"] = ltkouchu;
List <Gongzi_Heji> ltheji = new List <Gongzi_Heji>();
Gongzi_Heji gongzi_Heji = new Gongzi_Heji();
ltheji.Add(gongzi_Heji);
ViewData["heji"] = ltheji;
return(View(message));
}
DataSet ds = renshiService.SearchGongzi(emp_no, month);
//津贴项目
if (ds.Tables[0].Rows.Count > 0)
{
List <Gongzi_Zhifu> ltzhifu = new List <Gongzi_Zhifu>();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Gongzi_Zhifu gongzi_Zhifu = new Gongzi_Zhifu();
gongzi_Zhifu.Emp_no = ds.Tables[0].Rows[i]["emp_no"].ToString();
gongzi_Zhifu.Allow_cd = ds.Tables[0].Rows[i]["allow_cd"].ToString();
gongzi_Zhifu.Allow_nm1 = ds.Tables[0].Rows[i]["allow_nm1"].ToString();
gongzi_Zhifu.Allow = Convert.ToDecimal(ds.Tables[0].Rows[i]["allow"].ToString());
ltzhifu.Add(gongzi_Zhifu);
ViewData["zhifu"] = ltzhifu;
}
}
else
{
List <Gongzi_Zhifu> ltzhifu = new List <Gongzi_Zhifu>();
Gongzi_Zhifu gongzi_Zhifu = new Gongzi_Zhifu();
ltzhifu.Add(gongzi_Zhifu);
ViewData["zhifu"] = ltzhifu;
}
//扣除项目
if (ds.Tables[1].Rows.Count > 0)
{
List <Gongzi_Kouchu> ltkouchu = new List <Gongzi_Kouchu>();
for (int i = 0; i < ds.Tables[1].Rows.Count; i++)
{
Gongzi_Kouchu gongzi_Kouchu = new Gongzi_Kouchu();
gongzi_Kouchu.Emp_no = ds.Tables[1].Rows[i]["emp_no"].ToString();
gongzi_Kouchu.Sub_cd = ds.Tables[1].Rows[i]["sub_cd"].ToString();
gongzi_Kouchu.Allow_nm1 = ds.Tables[1].Rows[i]["allow_nm1"].ToString();
gongzi_Kouchu.Sub_amt = Convert.ToDecimal(ds.Tables[1].Rows[i]["sub_amt"].ToString());
ltkouchu.Add(gongzi_Kouchu);
ViewData["kouchu"] = ltkouchu;
}
}
else
{
List <Gongzi_Kouchu> ltkouchu = new List <Gongzi_Kouchu>();
Gongzi_Kouchu gongzi_Kouchu = new Gongzi_Kouchu();
ltkouchu.Add(gongzi_Kouchu);
ViewData["kouchu"] = ltkouchu;
}
//合计金额
if (ds.Tables[2].Rows.Count > 0)
{
List <Gongzi_Heji> ltheji = new List <Gongzi_Heji>();
for (int i = 0; i < ds.Tables[2].Rows.Count; i++)
{
Gongzi_Heji gongzi_Heji = new Gongzi_Heji();
gongzi_Heji.PROV_TOT_AMT = Convert.ToDecimal(ds.Tables[2].Rows[i]["PROV_TOT_AMT"].ToString());
gongzi_Heji.REAL_PROV_AMT = Convert.ToDecimal(ds.Tables[2].Rows[i]["REAL_PROV_AMT"].ToString());
gongzi_Heji.SUB_TOT_AMT = Convert.ToDecimal(ds.Tables[2].Rows[i]["SUB_TOT_AMT"].ToString());
ltheji.Add(gongzi_Heji);
ViewData["heji"] = ltheji;
}
}
else
{
List <Gongzi_Heji> ltheji = new List <Gongzi_Heji>();
Gongzi_Heji gongzi_Heji = new Gongzi_Heji();
ltheji.Add(gongzi_Heji);
ViewData["heji"] = ltheji;
}
return(View(message));
}
