private void GetItem(string SuppBatchGuid)
{
List<V_ERP_SuppOrder> items = null;
using (var db = new Database(SQLCONN.Conn))
{
if (!string.IsNullOrEmpty(UserName) && UserName != "admin")
{
items = db.Fetch<V_ERP_SuppOrder>("select * from V_ERP_SuppOrder where SuppBatchGuid=@0 and SuppName =@1", SuppBatchGuid, UserName);
}
else
{
items = db.Fetch<V_ERP_SuppOrder>("select * from V_ERP_SuppOrder where SuppBatchGuid=@0", SuppBatchGuid);
}
items.ForEach(j =>
{
j.Reserved2 = KyGYS.Controls.CommonUtil.GetItemImgFileName(j.Reserved2);
j.CusSavedFileName = j.CusSavedFileName!=null?KyGYS.Controls.CommonUtil.GetItemImgFileName(j.CusSavedFileName):null;
j.CtmSavedFileName = j.CtmSavedFileName != null ? KyGYS.Controls.CommonUtil.GetItemImgFileName(j.CtmSavedFileName) : null;
});
var grd = new EasyGridData<V_ERP_SuppOrder>();
grd.total = items.Count().ToString();
grd.rows = items;
string data = Newtonsoft.Json.JsonConvert.SerializeObject(grd);
Response.Write(data);
Response.End();
}
}
private void Reflesh()
{
using (var db = new Database(SQLCONN.Conn))
{
var items = db.Fetch<V_ERP_User>("select * from V_ERP_User");
var grd = new EasyGridData<V_ERP_User>();
grd.total = items.Count().ToString();
grd.rows = items;
string data = Newtonsoft.Json.JsonConvert.SerializeObject(grd);
Response.Write(data);
Response.End();
}
}
private void Refreash(int page, int rows)
{
string[] list = null;
var objs = new List<object>();
string whr = " where IsSendGoods=0";
string prefixWhr = string.Empty;
var idx = 0;
if (Session["queryStr"] != null)
{
string queryStr = Session["queryStr"].ToString();
list = queryStr.Split(',');
}
if (Session["IsManager"] != null && UserName != "")
{
if (Session["IsManager"].ToString() != "True" && UserName != "admin")
{
whr += " and SuppName in (select UserName from T_ERP_MapUser where SuppName = @" + (idx++).ToString() + ")";
objs.Add(UserName);
prefixWhr = "select * from V_ERP_SuppXBatch ";
}
else
{
prefixWhr = "select * from V_ERP_SuppXBatch ";
}
if (list != null && list.Count() > 0)
{
if (!string.IsNullOrEmpty(list[0]))
{
whr += " and BuyerNick=@" + (idx++).ToString();
objs.Add(list[0].ToString());
}
//if (!string.IsNullOrEmpty(list[1]))
//{
// whr += " and OrderFrom=@" + (idx++).ToString();
// objs.Add(list[1].ToString());
//}
if (!string.IsNullOrEmpty(list[1]))
{
whr += " and SellerNick=@" + (idx++).ToString();
objs.Add(list[1].ToString());
}
if (!string.IsNullOrEmpty(list[2]))
{
whr += " and ReceiverName=@" + (idx++).ToString();
objs.Add(list[2].ToString());
}
if (!string.IsNullOrEmpty(list[3]))
{
whr += " and ReceiverMobile=@" + (idx++).ToString();
objs.Add(list[3].ToString());
}
if (!string.IsNullOrEmpty(list[4]))
{
whr += " and ReceiverAddress like @" + (idx++).ToString();
objs.Add("%" + list[4].ToString() + "%");
}
}
using (var db = new Database(SQLCONN.Conn))
{
whr += " order by OrderTime desc";
var pages = db.Page<V_ERP_SuppXBatch>(page, rows, prefixWhr + whr, objs.ToArray());
var grd = new EasyGridData<V_ERP_SuppXBatch>();
grd.Init(pages);
string data = Newtonsoft.Json.JsonConvert.SerializeObject(grd);
Response.Write(data);
}
}
else
{
string data = "{\"IsError\":\"true\",\"ErrMsg\":\"登录超时,请刷新页面重新登录\"}";
Response.Write(data);
}
}
