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