/// <summary> /// 添加图书信息 /// </summary> /// <param name="context"></param> /// <param name="msg"></param> /// <param name="P1"></param> /// <param name="P2"></param> /// <param name="UserInfo"></param> public void ADDTSINFO(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { SZHL_TSGL_TS Info = JsonConvert.DeserializeObject <SZHL_TSGL_TS>(P1); if (string.IsNullOrEmpty(Info.TSType)) { msg.ErrorMsg = "请选择图书类型"; return; } if (string.IsNullOrEmpty(Info.TSNum)) { msg.ErrorMsg = "请填写图书编码"; return; } if (Info.ID == 0) { SZHL_TSGL_TS MODEL = new SZHL_TSGL_TSB().GetEntity(d => d.TSNum == Info.TSNum && d.ComId == UserInfo.User.ComId); if (MODEL != null) { msg.ErrorMsg = "已有此编码的图书"; } else { Info.CRDate = DateTime.Now; Info.CRUser = UserInfo.User.UserName; Info.ComId = UserInfo.User.ComId; Info.IsDel = 0; new SZHL_TSGL_TSB().Insert(Info); } } else { new SZHL_TSGL_TSB().Update(Info); } }
/// <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 GETTSINFO(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { int Id = int.Parse(P1); var info = new SZHL_TSGL_TSB().GetEntity(d => d.ID == Id && d.ComId == UserInfo.User.ComId); msg.Result = info; if (!string.IsNullOrEmpty(info.Files)) { msg.Result4 = new FT_FileB().GetEntities(" ID in (" + info.Files + ")"); } msg.Result2 = new SZHL_TSGLB().GetEntities(" ','+TSID+',' like '%," + info.ID + ",%'"); }
/// <summary> /// 查看可用图书列表(微信端) /// </summary> /// <param name="context"></param> /// <param name="msg"></param> /// <param name="P1"></param> /// <param name="P2"></param> /// <param name="UserInfo"></param> public void GETKYTSLIST(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { string strwhere = string.Empty; DataTable dt = new SZHL_TSGL_TSB().GetDTByCommand("select * from dbo.SZHL_TSGL_TS where IsDel=0 and Status='0' and comid=" + UserInfo.QYinfo.ComId + strwhere); dt.Columns.Add("tsTypeName", 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) { } 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 GETTSLIST_PAGE(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { string strWhere = string.Format(" SZHL_TSGL_TS.ComId=" + UserInfo.User.ComId); if (P1 != "") //图书码 { strWhere += string.Format("and SZHL_TSGL_TS.TSName like '%{0}%'", P1); } if (P2 != "")//图书类型 { strWhere += string.Format(" And SZHL_TSGL_TS.TSType='{0}'", P2);; } string kystatus = context.Request["kystatus"] ?? ""; if (kystatus != "")//图书类型 { strWhere += string.Format(" And SZHL_TSGL_TS.Status='{0}'", kystatus); } string jystatus = context.Request["jystatus"] ?? ""; if (jystatus != "")//图书类型 { strWhere += string.Format(" And SZHL_TSGL_TS.jystatus='{0}'", jystatus); } int recordCount = 0; int page = 0; int pagecount = 8; int.TryParse(context.Request["p"] ?? "1", out page); int.TryParse(context.Request["pagecount"] ?? "8", out pagecount);//页数 DataTable dt = new SZHL_TSGL_TSB().GetDataPager("SZHL_TSGL_TS left join JH_Auth_ZiDian zd on SZHL_TSGL_TS.tsType=zd.ID and zd.Class=24 ", "SZHL_TSGL_TS.*,zd.TypeName,'' dghsj", pagecount, page, "SZHL_TSGL_TS.CRDate desc", strWhere, ref recordCount); for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["jystatus"].ToString() != "0") { dt.Rows[i]["dghsj"] = new SZHL_TSGLB().getTSGHDATA(dt.Rows[i]["ID"].ToString()); } } msg.Result = dt; msg.Result1 = recordCount; }