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