/// <summary>
/// 图书列表//手机端
/// </summary>
/// <param name="context"></param>
/// <param name="msg"></param>
/// <param name="P1"></param>
/// <param name="P2"></param>
/// <param name="UserInfo"></param>
public void GETTSLIST(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
DataTable dt = new JH_Auth_ZiDianB().GetDTByCommand("select TypeNO,TypeName,ID from JH_Auth_ZiDian where class=24 and (comid=" + UserInfo.User.ComId + " or comid=0)");
dt.Columns.Add("Item", Type.GetType("System.Object"));
dt.Columns.Add("Qty", Type.GetType("System.String"));
dt.Columns.Add("xsQty", Type.GetType("System.String"));
List <SZHL_TSGL_TS> LISTTS = new SZHL_TSGL_TSB().GetEntities(D => D.Status != "1" && D.ComId == UserInfo.User.ComId).ToList();
foreach (DataRow dr in dt.Rows)
{
String rid = dr["ID"].ToString();
var list = LISTTS.Where(D => D.TSType == rid).OrderByDescending(p => p.CRDate).Select(p => new
{
p.ID,
p.CRDate,
p.auther,
p.SL,
p.TSName,
p.TSTypeName,
p.jystatus,
p.Files,
dghsj = p.jystatus == "0" ? "" : new SZHL_TSGLB().getTSGHDATA(p.ID.ToString()),
Qty = 0
});
dr["Item"] = list;
dr["Qty"] = 0;
dr["xsQty"] = list.Count();
}
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 GETSQLB(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
try
{
string strBranCode = UserInfo.User.BranchCode.ToString();
var MODEL = new JH_Auth_ZiDianB().GetEntities(D => D.Class == 19);
// msg.Result = MODEL.Where(D => D.Remark3.Contains(strBranCode));
msg.Result = MODEL;
}
catch (Exception ex)
{
msg.ErrorMsg = ex.Message;
}
}
/// <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 ADDJYGL(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
SZHL_TSGL jygl = JsonConvert.DeserializeObject <SZHL_TSGL>(P1);
JH_Auth_ZiDian ZD = new JH_Auth_ZiDianB().GetEntities(d => d.Class == 25).FirstOrDefault();
if (jygl == null)
{
msg.ErrorMsg = "操作失败";
return;
}
if (new SZHL_TSGLB().getYHYJTS(UserInfo.User.UserName, UserInfo.User.ComId.Value) + jygl.TSID.Split(',').Count() > int.Parse(ZD.Remark1))
{
msg.ErrorMsg = "超出借书数量限制,数量限制为" + ZD.Remark1 + "本";
return;
}
double hours = (jygl.EndTime.Value.AddDays(1) - jygl.StartTime.Value).TotalDays;
if (hours > double.Parse(ZD.Remark2))
{
msg.ErrorMsg = "超出借书时间限制,时间限制为" + ZD.Remark2 + "天";
return;
}
if (jygl.ID == 0)
{
jygl.CRDate = DateTime.Now;
jygl.CRUser = UserInfo.User.UserName;
jygl.ComId = UserInfo.User.ComId;
jygl.Status = "0";
jygl.BackBZ = "";
jygl.IsDel = 0;
new SZHL_TSGLB().Insert(jygl);
new SZHL_TSGL_TSB().UPSTATUS(jygl.TSID, "1", UserInfo.User.ComId.ToString());//更新为借阅状态
}
else
{
new SZHL_TSGLB().Update(jygl);
}
msg.Result = jygl;
}
/// <summary>
/// 获取话题BYID
/// </summary>
/// <param name="context"></param>
/// <param name="msg"></param>
/// <param name="P1"></param>
/// <param name="P2"></param>
/// <param name="UserInfo"></param>
public void GETHTMODEL(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
int Id = 0;
int.TryParse(P1, out Id);
SZHL_TSSQ sg = new SZHL_TSSQB().GetEntity(d => d.ID == Id && d.ComId == UserInfo.User.ComId);
msg.Result = sg;
if (sg != null)
{
if (!string.IsNullOrWhiteSpace(sg.Files))
{
msg.Result1 = new FT_FileB().GetEntities(" ID in (" + sg.Files + ")");
}
if (sg.LeiBie != null && !string.IsNullOrWhiteSpace(sg.LeiBie.ToString()))
{
var SS = new JH_Auth_ZiDianB().GetEntity(p => p.ID == sg.LeiBie);
if (SS != null)
{
msg.Result2 = SS.TypeName;
}
}
//msg.Result3 = new JH_Auth_TLB().GetEntities(d => d.ComId == UserInfo.User.ComId && d.MSGType == "TSSQ" && d.MSGTLYID == P1 && (d.MsgISShow != "Y" && d.MsgISShow != "N")).ToList();
DataTable dtPL = new SZHL_GZBGB().GetDTByCommand(" SELECT * FROM JH_Auth_TL WHERE MSGType='TSSQ' AND MSGTLYID='" + P1 + "' and MsgISShow!='Y' and MsgISShow!='N')");
dtPL.Columns.Add("FileList", Type.GetType("System.Object"));
foreach (DataRow dr in dtPL.Rows)
{
if (dr["MSGisHasFiles"] != null && dr["MSGisHasFiles"].ToString() != "")
{
int[] fileIds = dr["MSGisHasFiles"].ToString().SplitTOInt(',');
dr["FileList"] = new FT_FileB().GetEntities(d => fileIds.Contains(d.ID));
}
}
msg.Result3 = dtPL;
}
}
/// <summary>
/// 获取出差请假信息
/// </summary>
/// <param name="context"></param>
/// <param name="msg"></param>
/// <param name="P1"></param>
/// <param name="P2"></param>
/// <param name="UserInfo"></param>
public void GETCCXJMODEL(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
{
int Id = int.Parse(P1);
SZHL_CCXJ ccxj = new SZHL_CCXJB().GetEntity(d => d.ID == Id);
msg.Result = ccxj;
if (ccxj != null)
{
int id = Int32.Parse(ccxj.LeiBie);
var zd = new JH_Auth_ZiDianB().GetEntity(p => p.ID == id);
msg.Result1 = zd.TypeName;
if (!string.IsNullOrEmpty(ccxj.Files))
{
msg.Result2 = new FT_FileB().GetEntities(" ID in (" + ccxj.Files + ")");
}
if (ccxj.intProcessStanceid != 0)
{
msg.Result3 = new JH_Auth_User_CenterB().GetDTByCommand("select dbo.fn_PDStatus(" + ccxj.intProcessStanceid + ") AS StateName");
}
new JH_Auth_User_CenterB().ReadMsg(UserInfo, ccxj.ID, "CCXJ");
}
}
