/// <summary> /// 获取考勤异常上报页面数据源 /// </summary> /// <param name="obj"></param> /// <returns></returns> public TableModel GetExcptionUpSoure(object obj) { FormCollection param = (FormCollection)obj; int rows = int.Parse(param["rows"]); int page = int.Parse(param["page"]); TableModel model = new TableModel(); string UnitID = param["UnitID"]; if (string.IsNullOrEmpty(UnitID)) { var dataUnit = new B01BLL().GetPerUnitByUserID(HCQ2UI_Helper.OperateContext.Current.Usr.user_id); UnitID = string.Join("','", dataUnit.Select(o => o.UnitID)); } List <View_A02> attList = DBSession.IView_A02DAL.GetAttendsByUnit("'" + UnitID + "'"); if (!string.IsNullOrEmpty(param["txtSreachName"])) { string txtName = param["txtSreachName"]; attList = attList.Where(o => o.A0101.Contains(txtName)).ToList(); } model.total = attList.Count(); model.rows = attList.Skip((rows * page) - rows).Take(rows); return(model); }
/// <summary> /// 获取完善企业信息显示数据源 /// </summary> /// <param name="obj"></param> /// <returns></returns> public TableModel GetComPerfectSoure(object obj) { FormCollection param = (FormCollection)obj; B01BLL unit = new B01BLL(); TableModel model = new TableModel(); int rows = int.Parse(param["rows"]); int page = int.Parse(param["page"]); string com_id = param["com_id"]; if (string.IsNullOrEmpty(com_id)) { int user_id = HCQ2UI_Helper.OperateContext.Current.Usr.user_id; List <B01> unitList = new B01BLL().GetPerUnitByUserID(user_id); com_id = unitList[0].in_compay; } if (string.IsNullOrEmpty(com_id)) { return(model); } var data = GetComPro().Where(o => o.com_id == Convert.ToInt32(com_id)); if (!string.IsNullOrEmpty(param["txtSearchName"])) { string txtSearchName = param["txtSearchName"]; data = data.Where(o => o.dwmc.Contains(txtSearchName)); } model.total = data.Count(); model.rows = data.Skip((rows * page) - rows).Take(rows); return(model); }
/// <summary> /// 获取页面显示的数据源 /// </summary> /// <param name="obj"></param> /// <returns></returns> public TableModel GetPageViewSoure(object obj) { FormCollection param = (FormCollection)obj; int rows = int.Parse(param["rows"]); int page = int.Parse(param["page"]); int user_id = HCQ2UI_Helper.OperateContext.Current.Usr.user_id; List <B01> unitList = new B01BLL().GetPerUnitByUserID(user_id); string unitidInfo = "'" + string.Join("','", unitList.Select(o => o.UnitID)) + "'"; List <T_PayAccount> payList = new List <T_PayAccount>(); StringBuilder sbSql = new StringBuilder(); sbSql.AppendFormat("select * from T_PayAccount where if_remove=0 and UnitID in ({0}) ", unitidInfo); if (!string.IsNullOrEmpty(param["bank_name"])) { sbSql.AppendFormat(" and khh like '{0}' ", param["bank_name"]); } DataTable dt = HCQ2_Common.SQL.SqlHelper.ExecuteDataTable(sbSql.ToString()); payList = HCQ2_Common.Data.DataTableHelper.DataTableToIList <T_PayAccount>(dt); TableModel model = new TableModel(); model.rows = payList.Skip((rows * page) - rows).Take(rows); model.total = payList.Count(); return(model); }
/// <summary> /// 根据ItemCode表的itemid和unitid来获取字段 /// </summary> /// <param name="item_id"></param> /// <param name="unit_id"></param> /// <returns></returns> public List <T_ItemCodeMenum> GetByItemId(int item_id, string unit_id) { List <T_ItemCodeMenum> menuList = Select(o => o.item_id == item_id); B01 unit = new B01BLL().GetByUnitID(unit_id); if (unit == null) { return(menuList); } menuList = menuList.Where(o => o.code_type == unit.UnitName || o.code_type == "" || o.code_type == null).ToList(); return(menuList); }
private string GetRealUnitID(string UnitID) { B01 unit = new B01BLL().GetByUnitID(UnitID); if (!string.IsNullOrEmpty(unit.if_upload)) { return(unit.if_upload); } else { return(UnitID); } }
/// <summary> /// 根据用户ID获取该用户权限下的项目信息以及企业信息 /// </summary> /// <param name="user_id"></param> /// <returns></returns> public List <T_CompProInfo> GetPerCompanyByUserID(int user_id) { List <T_CompProInfo> list = new List <T_CompProInfo>(); List <T_CompProInfo> comList = new List <T_CompProInfo>(); B01BLL unit = new B01BLL(); List <B01> unitList = unit.GetPerUnitByUserID(user_id); string strPerUnitjoin = "'" + string.Join("','", unitList.Select(o => o.UnitID)) + "'"; StringBuilder sbSql = new StringBuilder(); sbSql.AppendFormat("select * from B01 where UnitID in ({0})", strPerUnitjoin); DataTable unitDt = HCQ2_Common.SQL.SqlHelper.ExecuteDataTable(sbSql.ToString()); if (unitDt == null) { return(comList); } for (int i = 0; i < unitDt.Rows.Count; i++) { string in_compay = unitDt.Rows[i]["in_compay"].ToString(); if (!string.IsNullOrEmpty(in_compay)) { list = new List <T_CompProInfo>(); sbSql = new StringBuilder(); sbSql.AppendFormat(" select * from T_CompProInfo where compath like ( "); sbSql.AppendFormat(" select dwmc from T_CompProInfo where com_id ='{0}' ) + '%' order by com_id ", in_compay); list = HCQ2_Common.Data.DataTableHelper.DataTableToIList <T_CompProInfo>( HCQ2_Common.SQL.SqlHelper.ExecuteDataTable(sbSql.ToString())); if (comList != null) { if (list == null) { continue; } foreach (var item in list) { if (comList.Where(o => o.com_id == item.com_id).Count() > 0) { continue; } comList.Add(item); } } else { comList = list; } } } return(comList); }
/// <summary> /// 根据用户ID获取所分配权限项目的所有征信记录 /// </summary> /// <param name="user_id"></param> /// <returns></returns> public List <T_EnterDetail> GetEnterByUserid(int user_id) { StringBuilder sbSql = new StringBuilder(); List <B01> unitList = new B01BLL().GetPerUnitByUserID(user_id); string strUnit = "'" + string.Join("','", unitList.Select(o => o.UnitID)) + "'"; sbSql.AppendFormat("select b.* from ( select * from T_CompProInfo where com_id in"); sbSql.AppendFormat(" ( select in_compay from b01 where UnitID in ({0})))a ", strUnit); sbSql.AppendFormat(" inner join T_EnterDetail b on a.com_id=b.ent_id where b.is_success=0 and b.solve_type=0 "); sbSql.AppendFormat(" union all "); sbSql.AppendFormat(" select b.* from ( select * from T_CompProInfo where QXLB<>'01' and QXLB<>'02')a "); sbSql.AppendFormat(" inner join T_EnterDetail b on a.com_id=b.ent_id where b.is_success=0 and b.solve_type=0 "); return(HCQ2_Common.Data.DataTableHelper.DataTableToIList <T_EnterDetail>( HCQ2_Common.SQL.SqlHelper.ExecuteDataTable(sbSql.ToString()))); }
/// <summary> /// 用工接口 /// </summary> /// <param name="work"></param> /// <returns></returns> public object GetApiWorkTime(CheckUseWorker work) { B01BLL unit = new B01BLL(); List <B01> unitList = unit.GetB01Info(); var data = unitList.Where(o => o.UnitName == work.unitName); if (data.Count() > 0) { string unit_code = data.FirstOrDefault().UnitID; return(NoCard(unit_code, work.checkDate)); } else { //项目名称不正确 return(null); } }
/// <summary> /// 打卡上报 /// </summary> /// <param name="PersonID"></param> /// <param name="checkDate"></param> /// <param name="checkTip"></param> public void UpCheck(string PersonID, string checkDate, string checkTip, string RowID) { View_A02 item = new View_A02BLL().Select(o => o.RowID == RowID).FirstOrDefault(); string UnitID = item.UnitID; B01 Unit = new B01BLL().Select(o => o.UnitID == UnitID).FirstOrDefault(); string realUnitID = string.IsNullOrEmpty(Unit.upLoadId) ? Unit.UnitID : Unit.UnitID; string param = "<?xml version=\"1.0\" encoding=\"GBK\"?><p>"; param += "<d k=\"vds\">"; param += " <r "; param += " kqid=\"" + RowID + "\""; param += " ryid=\"" + item.PersonID + "\""; param += " xxly=\"" + xxly + "\""; param += " xmbh=\"" + realUnitID + "\""; param += " sfzh=\"" + item.A0177 + "\""; param += " xm=\"" + item.A0101 + "\""; param += " kqsj=\"" + HCQ2_Common.DateHelper.GetCSTDate(checkDate) + "\""; param += " sbbs=\"" + (item.A0203 == "1" ? 1 : 2) + "\""; param += " kqtz=\"9\""; param += " kqsbbm=\"\""; param += " />"; param += "</d>"; param += "</p>"; WebUpData.uddi client2 = new WebUpData.uddi(); ServicePointManager.ServerCertificateValidationCallback = ValidateServerCertificate; client2.Url = "https://222.85.128.67:8088/dwlesbserver/services/uddi?wsdl"; X509Certificate xs = new X509Certificate("E:\\RSA2008root.cer"); client2.ClientCertificates.Add(xs); //基本信息上报字符串 string serviceName = "HSMWService"; string methodName = "UploadProAttendInfo"; string mess = client2.invokeService(serviceName, methodName, param); if (mess.Contains("调用服务成功")) { //修改记录状态 A02 att = new A02(); att.if_upattend = "1"; string updateRowID = item.RowID; base.Modify(att, o => o.RowID == updateRowID, "if_upattend"); } }
/// <summary> /// 获取补签数据源 /// </summary> /// <param name="obj"></param> /// <returns></returns> public TableModel GetBuCheckSoure(object obj) { FormCollection param = (FormCollection)obj; TableModel model = new TableModel(); if (string.IsNullOrEmpty(param["txtSearchDate"])) { return(model); } string[] checkDate = param["txtSearchDate"].Split('-'); if (checkDate.Length != 3) { return(model); } string UnitID = param["UnitID"]; if (string.IsNullOrEmpty(UnitID)) { int user_id = HCQ2UI_Helper.OperateContext.Current.Usr.user_id; B01BLL unit = new B01BLL(); UnitID = unit.GetB01PerData(user_id)[0].UnitID; } StringBuilder sbSql = new StringBuilder(); //sbSql.AppendFormat("select PersonID,A0177,A0101,C0104,UnitID from A01 where UnitID='{0}' and PersonID not in (", UnitID); //sbSql.AppendFormat(" select distinct PersonID from View_A02 where YEAR(A0201)={0} ", checkDate[0]); //sbSql.AppendFormat(" and MONTH(A0201)={0} and DAY(A0201)={1} ", checkDate[1], checkDate[2]); //sbSql.AppendFormat(" and UnitID='{0}') ", UnitID); sbSql.AppendFormat(" select PersonID,A0177,A0101,C0104,UnitID from A01 "); sbSql.AppendFormat(" where UnitID='{0}' ", UnitID); DataTable dt = HCQ2_Common.SQL.SqlHelper.ExecuteDataTable(sbSql.ToString()); if (dt == null) { return(model); } List <A01> userList = HCQ2_Common.Data.DataTableHelper.DataTableToIList <A01>(dt); model.total = userList.Count(); model.rows = userList; return(model); }
/// <summary> /// 自动写入上报提示 /// </summary> /// <param name="user_id"></param> public void WriteRepostLog(int user_id) { List <HCQ2_Model.TreeModel.B01PerTreeModel> treeList = HCQ2UI_Helper.OperateContext.Current.bllSession.B01.GetB01PerData(user_id); if (treeList.Count() > 0) { List <B01> unitList = new B01BLL().GetB01Info(); StringBuilder sbContent = new StringBuilder(); //根据项目挨个循环,获取上报未上报项目,人员信息 foreach (var item in treeList) { if (sbContent.Length > 0) { sbContent.Append("<br />"); } string UnitID = item.UnitID; B01 Unit = unitList.Where(o => o.UnitID == UnitID).FirstOrDefault(); if (Unit.if_upload == "1") { sbContent.AppendFormat("<strong style='color:Blue'>" + Unit.UnitName + "</strong>:项目信息<strong>已经上报!</strong>"); } else { sbContent.AppendFormat("<strong style='color:Red'>" + Unit.UnitName + "</strong>:项目信息<strong style='color:red;'>未上报!</strong>"); } List <A01> userList = new A01BLL().GetByUnitID(UnitID); List <A01> accUserList = userList.Where(o => o.if_uparchive == "1").ToList(); if (accUserList.Count() > 0) { sbContent.AppendFormat("<br /><strong style='color:blue;'>已上报的人员总数"); sbContent.AppendFormat(":{0}</strong>", accUserList.Count()); } List <A01> lowUserList = userList.Where(o => o.if_uparchive == "0" || o.if_uparchive == null || o.if_uparchive == "").ToList(); if (lowUserList.Count() > 0) { sbContent.AppendFormat("<br /><strong style='color:red;'>未上报的人员总数"); sbContent.AppendFormat(":{0}</strong>", lowUserList.Count()); } } //推送 if (sbContent.Length > 0) { List <T_TodoList> todoList = Select(o => o.to_user_id == user_id.ToString() && o.to_title.Contains("上报消息") && o.to_send_user_id == 1 && o.to_send_user_name == "管理员"); if (todoList.Count() > 0) { foreach (var to in todoList) { int to_id = to.to_id; Delete(o => o.to_id == to_id); } } T_TodoList todo = new T_TodoList(); todo.to_user_id = user_id.ToString(); todo.to_user_name = HCQ2UI_Helper.OperateContext.Current.Usr.user_name; todo.to_title = "上报消息" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); todo.to_content = sbContent.ToString(); todo.to_send_user_id = 1; todo.to_send_user_name = "管理员"; todo.to_send_date = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); todo.is_system = 1; todo.to_remove = 0; Add(todo); } } }