/// <summary> /// 已审核和待审批列表 /// </summary> /// <param name="context"></param> /// <param name="msg"></param> /// <param name="P1"></param> /// <param name="P2"></param> /// <param name="UserInfo"></param> public void GETYSPHDSPYCGLLIST_PAGE(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { List <Yan_WF_TI> ListData = new Yan_WF_TIB().GetEntities("TaskUserID ='" + UserInfo.User.UserName + "' AND isnull(TaskUserView,'')!='发起表单'").ToList(); List <string> intPro = ListData.Select(d => d.PIID.ToString()).ToList(); int page = 0; int.TryParse(context.Request.QueryString["p"] ?? "1", out page); page = page == 0 ? 1 : page; if (intPro.Count > 0) { string tableName = string.Format(@" SZHL_YCGL ycgl inner join SZHL_YCGL_CAR car on ycgl.CarID=car.ID inner join Yan_WF_PI wfpi on ycgl.intProcessStanceid=wfpi.ID"); string tableColumn = "ycgl.* ,car.CarBrand,car.CarType,car.CarNum , case when wfpi.isComplete='Y' then '已审批' WHEN wfpi.IsCanceled='Y' then '已退回' else '正在审批' END StateName "; string strWhere = " ycgl.ComId=" + UserInfo.User.ComId + " And ycgl.intProcessStanceid in (" + intPro.ListTOString(',') + ")"; if (P1 != "") { strWhere += string.Format(" And ycgl.XCType='{0}'", P1); } if (P2 != "") { strWhere += string.Format(" And ycgl.Remark like '%{0}%'", P2); } int total = 0; DataTable dt = new SZHL_YCGLB().GetDataPager(tableName, tableColumn, 8, page, " ycgl.CRDate desc", strWhere, ref total); msg.Result = dt; msg.Result1 = total; } }
public void EXPORTYCGL(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { int total = 0; DataTable dt = new SZHL_YCGLB().GetDataPager("SZHL_YCGL yc left join SZHL_YCGL_CAR car on yc.CarID=car.ID", "yc.*,car.CarBrand,car.CarType,car.CarNum ,dbo.fn_PDStatus(yc.intProcessStanceid) AS StateName", 2000, 1, " yc.CRDate desc", "", ref total); string sqlCol = "SYUser|使用人,XCType|行程类别,CarNum|使用车辆,SYRS|用车人数,JSR|驾驶员,Remark|使用说明,StartTime|开始时间,EndTime|结束时间,StartAddress|出发地点,EndAddress|到达地点"; CommonHelp ch = new CommonHelp(); DataTable dt2 = dt.DelTableCol(sqlCol); foreach (DataRow dr in dt2.Rows) { try { dr["使用人"] = new JH_Auth_UserB().GetUserRealName(UserInfo.QYinfo.ComId, dr["使用人"].ToString()); if (!string.IsNullOrEmpty(dr["驾驶员"].ToString())) { dr["驾驶员"] = new JH_Auth_UserB().GetUserRealName(UserInfo.QYinfo.ComId, dr["驾驶员"].ToString()); } } catch (Exception) { } } msg.ErrorMsg = ch.ExportToExcel("用车记录", dt2); }
/// <summary> /// 更新归还车辆记录 /// </summary> /// <param name="context"></param> /// <param name="msg"></param> /// <param name="P1"></param> /// <param name="P2"></param> /// <param name="UserInfo"></param> public void BACKCLJL(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { int ID = int.Parse(P1); SZHL_YCGL ycgl = new SZHL_YCGLB().GetEntity(d => d.ID == ID && d.ComId == UserInfo.User.ComId); ycgl.Status = "0";//0 归还 1正在使用 ycgl.BackDate = DateTime.Now; new SZHL_YCGLB().Update(ycgl); msg.Result = ycgl; }
/// <summary> /// 获取会议人员情况 /// </summary> /// <param name="context"></param> /// <param name="msg"></param> /// <param name="P1"></param> /// <param name="P2"></param> /// <param name="UserInfo"></param> public void GETRYLIST_PAGE(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { int page = 0; int.TryParse(context.Request["p"] ?? "1", out page); page = page == 0 ? 1 : page; int total = 0; DataTable dt = new SZHL_YCGLB().GetDataPager("JH_Auth_TL", "*", 8, page, " CRDate desc", "MSGType='HYGL' and MSGTLYID='" + P1 + "' and MsgISShow='" + P2 + "' and ComId=" + UserInfo.User.ComId, ref total); msg.Result = dt; msg.Result1 = total; }
/// <summary> /// 查看可用车辆列表(微信端) /// </summary> /// <param name="context"></param> /// <param name="msg"></param> /// <param name="P1"></param> /// <param name="P2"></param> /// <param name="UserInfo"></param> public void GETKYCLLIST(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { //var list = new SZHL_HYGL_ROOMB().GetEntities(p => p.Status == "1" && p.IsDel == 0); string strwhere = string.Empty; if (P1 != "all") { strwhere = " and isnull(CarBrand,'')!='' "; } DataTable dt = new SZHL_YCGL_CARB().GetDTByCommand("select * from dbo.SZHL_YCGL_CAR where IsDel=0 and Status='0' and comid=" + UserInfo.QYinfo.ComId + strwhere); dt.Columns.Add("CarTypeName", Type.GetType("System.String")); dt.Columns.Add("ZT", Type.GetType("System.String")); dt.Columns.Add("ZYSJ", Type.GetType("System.String")); foreach (DataRow dr in dt.Rows) { int rid = Int32.Parse(dr["ID"].ToString()); int tid = Int32.Parse(dr["CarType"].ToString()); var st = DateTime.Now; var et = DateTime.Now.AddDays(1); var jaz = new JH_Auth_ZiDianB().GetEntity(p => p.ID == tid); if (jaz != null) { dr["CarTypeName"] = jaz.TypeName; } var list = new SZHL_YCGLB().GetEntities(p => p.ComId == UserInfo.QYinfo.ComId && p.CarID == rid && p.IsDel == 0 && ((st > p.StartTime && st < p.EndTime) || (et > p.StartTime && et < p.EndTime))).OrderBy(p => p.StartTime); if (list.Count() == 0) { dr["ZT"] = "0"; dr["ZYSJ"] = ""; } else { dr["ZT"] = "1"; dr["ZYSJ"] = list.First().StartTime.Value.ToString("yyyy-MM-dd HH:mm") + "~" + list.First().EndTime.Value.ToString("yyyy-MM-dd HH:mm"); } } msg.Result = dt; }
/// <summary> /// 已审核,待审批列表 /// </summary> /// <param name="context"></param> /// <param name="msg"></param> /// <param name="P1"></param> /// <param name="P2"></param> /// <param name="UserInfo"></param> public void GETYSPYCGLLIST_PAGE(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { #region 已审核 List <Yan_WF_TI> ListData = new Yan_WF_TIB().GetEntities("TaskUserID ='" + UserInfo.User.UserName + "' AND EndTime IS NOT NULL AND TaskUserView!='发起表单'").ToList(); List <string> intPro = ListData.Select(d => d.PIID.ToString()).ToList(); int page = 0; int.TryParse(P2, out page); page = page == 0 ? 1 : page; if (intPro.Count > 0) { string tableName = string.Format(@" SZHL_YCGL ycgl inner join SZHL_YCGL_CAR car on ycgl.CarID=car.ID inner join Yan_WF_PI wfpi on ycgl.intProcessStanceid=wfpi.ID"); string tableColumn = "ycgl.* ,car.CarBrand,car.CarType,car.CarNum , case when wfpi.IsCanceled is null then '已审批' WHEN wfpi.IsCanceled='Y' then '已退回' END StateName "; string strWhere = " ycgl.ComId=" + UserInfo.User.ComId + " And ycgl.intProcessStanceid in (" + intPro.ListTOString(',') + ")"; if (P1 != "") { strWhere += string.Format(" And ycgl.XCType='{0}'", P1); } if (P2 != "") { strWhere += string.Format(" And ycgl.Remark like '%{0}%'", P2); } int total = 0; DataTable dt = new SZHL_YCGLB().GetDataPager(tableName, tableColumn, 8, page, " ycgl.CRDate desc", strWhere, ref total); msg.Result = dt; msg.Result1 = total; } #endregion #region 待审核 if (page == 1 && P1 == "" && P2 == "") { List <string> intProD = new Yan_WF_PIB().GetDSH(UserInfo.User).Select(d => d.PIID.ToString()).ToList(); if (intProD.Count() > 0) { string tableNameD = string.Format(@" SZHL_YCGL ycgl inner join SZHL_YCGL_CAR car on ycgl.CarID=car.ID"); string tableColumnD = "ycgl.* ,car.CarBrand,car.CarType,car.CarNum , '正在审批' StateName"; string strWhereD = " ycgl.ComId=" + UserInfo.User.ComId + " And ycgl.intProcessStanceid in (" + intProD.ListTOString(',') + ")"; string strSql = string.Format("Select {0} From {1} where {2} order by ycgl.CRDate desc", tableColumnD, tableNameD, strWhereD); msg.Result2 = new SZHL_YCGLB().GetDTByCommand(strSql); } } #endregion }
public void SENDMSG(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { int Id = int.Parse(P1); var model = new SZHL_YCGLB().GetEntity(d => d.ID == Id && d.ComId == UserInfo.User.ComId); string strContent = "发起人:" + new JH_Auth_UserB().GetUserRealName(UserInfo.User.ComId.Value, model.CRUser) + "\r\n驾驶人:" + new JH_Auth_UserB().GetUserRealName(UserInfo.User.ComId.Value, model.JSR) + "\r\n您有新的用车通知,请尽快查看"; Article ar0 = new Article(); ar0.Title = "用车通知"; ar0.Description = strContent; ar0.Url = model.ID.ToString(); List <Article> al = new List <Article>(); al.Add(ar0); //new JH_Auth_User_CenterB().SendMsg(UserInfo, "HYGL", strContent, model.ID.ToString(), model.JSR, "B", model.intProcessStanceid); WXHelp wx = new WXHelp(UserInfo.QYinfo); wx.SendTH(al, "YCGL", "A", model.JSR); }
/// <summary> /// 获取用车信息 /// </summary> /// <param name="context"></param> /// <param name="msg"></param> /// <param name="P1"></param> /// <param name="P2"></param> /// <param name="UserInfo"></param> public void GETYCGLMODEL(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { int Id = int.Parse(P1); var model = new SZHL_YCGLB().GetEntity(d => d.ID == Id && d.ComId == UserInfo.User.ComId); if (model != null) { msg.Result = model; if (!string.IsNullOrEmpty(model.Files)) { msg.Result1 = new FT_FileB().GetEntities(" ID in (" + model.Files + ")"); } if (model.CarID != null) { msg.Result2 = new SZHL_YCGL_CARB().GetEntity(p => p.ID == model.CarID); } new JH_Auth_User_CenterB().ReadMsg(UserInfo, model.ID, "YCGL"); } }
/// <summary> /// 获取车辆信息 /// </summary> /// <param name="context"></param> /// <param name="msg"></param> /// <param name="P1"></param> /// <param name="P2"></param> /// <param name="UserInfo"></param> public void GETCLINFO(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { int Id = int.Parse(P1); var car = new SZHL_YCGL_CARB().GetEntity(d => d.ID == Id && d.ComId == UserInfo.User.ComId); msg.Result = car; //string strSql = string.Format("SELECT ycgl.* from SZHL_YCGL ycgl inner join SZHL_YCGL_CAR car on ycgl.CarID=car.ID inner join Yan_WF_PI wfpi on ycgl.intProcessStanceid=wfpi.ID where wfpi.isComplete='Y' and ycgl.ComId={0} and ycgl.CarID={1}", UserInfo.User.ComId, Id); //msg.Result1 = new SZHL_YCGL_CARB().GetDTByCommand(strSql); int tid = Int32.Parse(car.CarType); msg.Result3 = new JH_Auth_ZiDianB().GetEntity(p => p.ID == tid); #region 微信端 var st = DateTime.Now; var list = new SZHL_YCGLB().GetEntities(p => p.CarID == Id && p.IsDel == 0 && st < p.EndTime).OrderBy(p => p.StartTime); List <int> li = new List <int>(); foreach (var l in list) { var pi = new Yan_WF_PIB().GetEntity(p => p.ID == l.intProcessStanceid); if (pi != null && pi.IsCanceled == "Y") { li.Add(l.ID); } } var list1 = list.Where(p => !li.Contains(p.ID)); msg.Result2 = list1; #endregion if (!string.IsNullOrEmpty(car.Files)) { msg.Result4 = new FT_FileB().GetEntities(" ID in (" + car.Files + ")"); } }