/// <summary>
/// 工资单信息
/// </summary>
/// <param name="context"></param>
/// <param name="msg"></param>
/// <param name="P1"></param>
/// <param name="P2"></param>
/// <param name="UserInfo"></param>
public void GETGZDMODEL(JObject context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
int id = 0;
int.TryParse(P1, out id);
SZHL_XZ_GZD xzjl = new SZHL_XZ_GZDB().GetEntity(d => d.ID == id);
msg.Result = xzjl;
}
/// <summary>
/// 已读工资单
/// </summary>
/// <param name="context"></param>
/// <param name="msg"></param>
/// <param name="P1"></param>
/// <param name="P2"></param>
/// <param name="UserInfo"></param>
public void READGZD(JObject context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
int id = 0;
int.TryParse(P1, out id);
SZHL_XZ_GZD xzjl = new SZHL_XZ_GZDB().GetEntity(d => d.ID == id);
if (xzjl != null)
{
xzjl.IsRead = 1;
}
new SZHL_XZ_GZDB().Update(xzjl);
}
/// <summary>
/// 发放记录列表
/// </summary>
/// <param name="context"></param>
/// <param name="msg"></param>
/// <param name="P1"></param>
/// <param name="P2"></param>
/// <param name="UserInfo"></param>
public void GETFFJLLIST(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
int page = 0;
int pagecount = 8;
int.TryParse(context.Request["p"] ?? "1", out page); //页码
int.TryParse(context.Request["pagecount"] ?? "8", out pagecount); //页数
page = page == 0 ? 1 : page;
int recordCount = 0;
string strWhere = string.Format(" ComId={0} ", UserInfo.User.ComId, UserInfo.User.UserName);
string strContent = context.Request["Content"] ?? "";
strContent = strContent.TrimEnd();
if (strContent != "")
{
strWhere += string.Format(" And ( title like '%{0}%' )", strContent);
}
DataTable dt = new SZHL_XZ_GZDB().GetDataPager(" SZHL_XZ_JL ", " * ", pagecount, page, " CRDate desc ", strWhere, ref recordCount);
msg.Result = dt;
msg.Result1 = recordCount;
}
/// <summary>
/// 个人工资条列表
/// </summary>
/// <param name="context"></param>
/// <param name="msg"></param>
/// <param name="P1"></param>
/// <param name="P2"></param>
/// <param name="UserInfo"></param>
public void GETGZDLIST(JObject context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
string strWhere = string.Format(" ComId={0} and UserName='******' ", UserInfo.User.ComId, UserInfo.User.UserName);
int DataID = -1;
int.TryParse(context.Request("ID") ?? "-1", out DataID);//记录Id
if (DataID != -1)
{
string strIsHasDataQX = new JH_Auth_QY_ModelB().ISHASDATAREADQX("XZFF", DataID, UserInfo);
if (strIsHasDataQX == "Y")
{
strWhere += string.Format(" And ID = '{0}'", DataID);
}
}
int page = 0;
int pagecount = 8;
int.TryParse(context.Request("p") ?? "1", out page); //页码
int.TryParse(context.Request("pagecount") ?? "8", out pagecount); //页数
page = page == 0 ? 1 : page;
int recordCount = 0;
string strContent = context.Request("Content") ?? "";
if (strContent != "")
{
strWhere += string.Format(" And ( title like '%{0}%' )", strContent);
}
var dt = new SZHL_XZ_GZDB().Db.Queryable <SZHL_XZ_GZD>().Where(strWhere).OrderBy(it => it.CRDate, OrderByType.Desc).ToPageList(page, pagecount, ref recordCount);
msg.Result = dt;
msg.Result1 = recordCount;
}
/// <summary>
/// 个人工资条列表
/// </summary>
/// <param name="context"></param>
/// <param name="msg"></param>
/// <param name="P1"></param>
/// <param name="P2"></param>
/// <param name="UserInfo"></param>
public void GETGZDLIST(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
string strWhere = string.Format(" ComId={0} and UserName='******' ", UserInfo.User.ComId, UserInfo.User.UserName);
int DataID = -1;
int.TryParse(context.Request["ID"] ?? "-1", out DataID);//记录Id
if (DataID != -1)
{
string strIsHasDataQX = new JH_Auth_QY_ModelB().ISHASDATAREADQX("XZFF", DataID, UserInfo);
if (strIsHasDataQX == "Y")
{
strWhere += string.Format(" And ID = '{0}'", DataID);
}
}
int page = 0;
int pagecount = 8;
int.TryParse(context.Request["p"] ?? "1", out page); //页码
int.TryParse(context.Request["pagecount"] ?? "8", out pagecount); //页数
page = page == 0 ? 1 : page;
int recordCount = 0;
string strContent = context.Request["Content"] ?? "";
if (strContent != "")
{
strWhere += string.Format(" And ( title like '%{0}%' )", strContent);
}
DataTable dt = new SZHL_XZ_GZDB().GetDataPager(" SZHL_XZ_GZD ", " * ", pagecount, page, " CRDate desc ", strWhere, ref recordCount);
msg.Result = dt;
msg.Result1 = recordCount;
}
/// <summary>
/// 直接添加（用户列表）
/// </summary>
/// <param name="context"></param>
/// <param name="msg"></param>
/// <param name="P1"></param>
/// <param name="P2"></param>
/// <param name="UserInfo"></param>
public void GETUSERLIST(JObject context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
DataTable dt = new SZHL_XZ_GZDB().GetDTByCommand("select u.UserRealName '姓名',b.DeptName '部门',u.mobphone '用户编码' from JH_Auth_User u left join JH_Auth_Branch b on u.BranchCode=b.DeptCode where u.ComId='" + UserInfo.QYinfo.ComId + "' and b.DeptRoot!=-1 order by b.DeptName");
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 NOREADGZD(JObject context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
var xzjl = new SZHL_XZ_GZDB().GetEntities(d => d.UserName == UserInfo.User.UserName && d.IsRead != 1);
msg.Result = xzjl.ToList().Count;
}
/// <summary>
/// 最近上传的4条工资单
/// </summary>
/// <param name="context"></param>
/// <param name="msg"></param>
/// <param name="P1"></param>
/// <param name="P2"></param>
/// <param name="UserInfo"></param>
public void GETGZTLAST(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
DataTable dt = new SZHL_XZ_GZDB().GetDTByCommand("select top 4 * from SZHL_XZ_JL where ComId='" + UserInfo.QYinfo.ComId + "' and CRUser='******' order by CRDate desc");
msg.Result = dt;
}
