public PQGridData GetUsers()
{
PQGridData data = new PQGridData();
HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"];
HttpRequestBase request = context.Request;
string user_id = User.Identity.Name;
UserManager userMgr = new UserManager(int.Parse(user_id), null);
int page = 1;
int pageSize = 30;
int total = 0;
int.TryParse(request["page"],out page);
int.TryParse(request["pageSize"],out pageSize);
data.data = userMgr.GetUsers(page, pageSize, out total);
data.totalRecords = total;
return data;
}
public PQGridData SearchShopUsers()
{
PQGridData data = new PQGridData();
HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"];
HttpRequestBase request = context.Request;
string user_id = User.Identity.Name;
UserManager userMgr = new UserManager(int.Parse(user_id), null);
BUser user = userMgr.CurrentUser;
ShopManager shopManager = new ShopManager(userMgr.CurrentUser, userMgr.Shop, userMgr.CurrentUserPermission, userMgr);
int page = 1;
int pageSize = 30;
int shop_id = 0;
int.TryParse(request["page"],out page);
int.TryParse(request["pageSize"],out pageSize);
int.TryParse(request["shop"], out shop_id);
if (page <= 0)
{
page = 1;
}
if (pageSize <= 0)
{
pageSize = 30;
}
long total = 0;
List<BUser> users = shopManager.SearchShopUsers(page, pageSize, out total, shop_id);
data.data = users;
data.curPage = page;
data.totalRecords = total;
return data;
}
public PQGridData SearchSentChildRequets()
{
PQGridData data = new PQGridData();
HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"];
HttpRequestBase request = context.Request;
string user_id = User.Identity.Name;
UserManager userMgr = new UserManager(int.Parse(user_id), null);
BUser user = userMgr.CurrentUser;
ShopManager shopManager = new ShopManager(userMgr.CurrentUser, userMgr.Shop, userMgr.CurrentUserPermission, userMgr);
List<BAddChildRequest> requests = shopManager.SearchSentAddChildRequests();
data.data = requests;
data.totalRecords = requests.Count;
data.curPage = 1;
return data;
}
public PQGridData SearchOnSaleProducts()
{
PQGridData data = new PQGridData();
HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"];
HttpRequestBase request = context.Request;
string user_id = User.Identity.Name;
UserManager userMgr = new UserManager(int.Parse(user_id), null);
BUser user = userMgr.CurrentUser;
ShopManager shopManager = new ShopManager(userMgr.CurrentUser, userMgr.Shop, userMgr.CurrentUserPermission, userMgr);
int total = 0;
int page = 1;
int pageSize = 30;
bool? connected = null;
int.TryParse(request["page"], out page);
int.TryParse(request["pageSize"], out pageSize);
string keyword=request["keyword"];
if (page <= 0)
{
page = 1;
}
if (pageSize <= 0)
{
pageSize = 30;
}
if (request["connected"] != null)
{
if (request["connected"] == "1")
{
connected = true;
}
else if (request["connected"] == "0")
{
connected = false;
}
}
List<BMallProduct> products = shopManager.SearchOnSaleMallProducts(keyword, page, pageSize, out total, connected);
data.data = products;
data.curPage = page;
data.totalRecords = total;
return data;
}
public PQGridData SearchBackSaleDetails()
{
PQGridData data = new PQGridData();
HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"];
HttpRequestBase request = context.Request;
string user_id = User.Identity.Name;
UserManager userMgr = new UserManager(int.Parse(user_id), null);
BUser user = userMgr.CurrentUser;
StockManager stockManager = new StockManager(userMgr.CurrentUser, userMgr.Shop, userMgr.CurrentUserPermission);
SalesManager saleManager = new SalesManager(userMgr.CurrentUser, userMgr.Shop, userMgr.CurrentUserPermission);
int page = 1;
int pageSize = 30;
int sale_id = 0;
int back_id = 0;
int uid = 0;
long stime = 0;
long etime = 0;
int? status = null;
int status1 = 0;
string state=request["status"];
if (!string.IsNullOrEmpty(state))
{
int.TryParse(state, out status1);
status = status1;
}
if (!string.IsNullOrEmpty(request["sdate"]))
{
DateTime sdate = DateTime.MinValue;
DateTime.TryParse(request["sdate"], out sdate);
if (sdate != DateTime.MinValue)
{
stime = DateTimeUtil.ConvertDateTimeToInt(sdate);
}
}
if (!string.IsNullOrEmpty(request["edate"]))
{
DateTime edate = DateTime.MinValue;
DateTime.TryParse(request["edate"], out edate);
if (edate != DateTime.MinValue)
{
etime = DateTimeUtil.ConvertDateTimeToInt(edate);
}
}
int.TryParse(request["page"], out page);
int.TryParse(request["pageSize"], out pageSize);
int.TryParse(request["sale_id"], out sale_id);
int.TryParse(request["back_id"], out back_id);
int.TryParse(request["user_id"], out uid);
int total = 0;
int[] backids = null;
if (back_id > 0)
{
backids = new int[] { back_id };
}
int[] userids = null;
if (uid > 0)
{
userids = new int[] { uid };
}
string[] saleids = null;
if (sale_id > 0)
{
saleids = new string[] { sale_id.ToString() };
}
data.data = saleManager.SearchBackSaleDetails(saleids, userids,status, stime, etime, page, pageSize, out total);
data.curPage = page;
data.totalRecords = total;
return data;
}
public PQGridData ExportBuyOrders()
{
PQGridData data = new PQGridData();
HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"];
HttpRequestBase request = context.Request;
string user_id = User.Identity.Name;
UserManager userMgr = new UserManager(int.Parse(user_id), null);
BUser user = userMgr.CurrentUser;
BuyManager buyManager = new BuyManager(userMgr.CurrentUser, userMgr.Shop, userMgr.CurrentUserPermission);
int total = 0;
int page = 1;
int pageSize = 30;
int.TryParse(request["page"], out page);
int.TryParse(request["pageSize"], out pageSize);
int order_id = 0;
int supplier_id = 0;
int.TryParse(request["order_id"], out order_id);
int.TryParse(request["supplier_id"], out supplier_id);
string keyword = request["keyword"];
int[] orders = null;
if (order_id > 0)
{
orders = new int[] { order_id };
}
int[] suppliers = null;
if (supplier_id > 0)
{
suppliers = new int[] { supplier_id };
}
data.data = buyManager.SearchBuyOrders(orders, null, suppliers, null, keyword, 0, 0, page, pageSize, out total);
data.totalRecords = total;
return data;
}
public PQGridData SearchProducts()
{
PQGridData data = new PQGridData();
int page = 0;
int pageSize = 30;
int total = 0;
int? category_id = null;
string keyword = "";
HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"];
HttpRequestBase request = context.Request;
string user_id = User.Identity.Name;
UserManager userMgr = new UserManager(int.Parse(user_id), null);
BUser user = userMgr.CurrentUser;
ProductManager pdtManager = new ProductManager(userMgr.CurrentUser, userMgr.Shop, userMgr.CurrentUserPermission);
int.TryParse(request["page"],out page);
int.TryParse(request["pageSize"],out pageSize);
if (page <= 0)
{
page = 1;
}
if (pageSize <= 0)
{
pageSize = 30;
}
if (request["cid"] != null && request["cid"].ToString() != "" && request["cid"].ToString()!="0")
{
int cid = 0;
int.TryParse(request["cid"],out cid);
if (cid > 0) {
category_id = cid;
}
}
keyword = request["keyword"];
int[] sids = null;
string suppliers = request["suppliers"];
if (!string.IsNullOrEmpty(suppliers))
{
string[] ss = suppliers.Split(',');
sids = new int[ss.Length];
for (int i = 0; i < ss.Length; i++)
{
sids[i] = int.Parse(ss[i]);
}
}
bool includeProps = false;
if (!string.IsNullOrEmpty(request["include_prop"]) && request["include_prop"] == "1")
{
includeProps = true;
}
else
{
includeProps = false;
}
int[] product_ids = null;
if (!string.IsNullOrEmpty(request["product_ids"]))
{
product_ids = base.ConvertToIntArrar(request["product_ids"]);
}
bool paging = true;
if (!string.IsNullOrEmpty(request["paging"]) && request["paging"]=="0")
{
paging=false;
}
bool includeSupplier = false;
if (!string.IsNullOrEmpty(request["include_supplier"]) && request["include_supplier"] == "1")
{
includeSupplier = true;
}
else
{
includeSupplier = false;
}
data.data = pdtManager.SearchProducts(product_ids, sids, keyword, "", 0, 0, category_id, page, pageSize, out total, includeProps, paging, includeSupplier);
data.totalRecords = total;
data.curPage = page;
data.pageSize = pageSize;
return data;
}
public PQGridData GetPropertyValues()
{
string user_id = User.Identity.Name;
UserManager userMgr = new UserManager(int.Parse(user_id), null);
PQGridData data = new PQGridData();
BUser user = userMgr.CurrentUser;
ShopCategoryManager cateMgr = new ShopCategoryManager(userMgr.CurrentUser, userMgr.Shop, userMgr.CurrentUserPermission);
int property_id = 0;
HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"];
HttpRequestBase request = context.Request;
int.TryParse(request["pid"], out property_id);
data.data = cateMgr.GetPropertyValues(property_id);
return data;
}
public PQGridData SearchProductWastage()
{
PQGridData data = new PQGridData();
HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"];
HttpRequestBase request = context.Request;
string user_id = User.Identity.Name;
UserManager userMgr = new UserManager(int.Parse(user_id), null);
BUser user = userMgr.CurrentUser;
StockManager stockManager = new StockManager(userMgr.CurrentUser, userMgr.Shop, userMgr.CurrentUserPermission);
BuyManager buyManager = new BuyManager(userMgr.CurrentUser, userMgr.Shop, userMgr.CurrentUserPermission);
int page = 1;
int pageSize = 30;
int? category_id = null;
int.TryParse(request["page"], out page);
int.TryParse(request["pageSize"], out pageSize);
string keyword = request["keyword"];
int[] sids = null;
string suppliers = request["suppliers"];
sids = base.ConvertToIntArrar(suppliers);
if (request["cid"] != null && request["cid"].ToString() != "" && request["cid"].ToString() != "0")
{
int cid = 0;
int.TryParse(request["cid"], out cid);
if (cid > 0)
{
category_id = cid;
}
}
int total = 0;
data.data = stockManager.SearchProductWastage(sids, keyword, category_id, page, pageSize, out total);
data.curPage = page;
data.totalRecords = total;
return data;
}
public PQGridData SearchProductsStore()
{
PQGridData data = new PQGridData();
HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"];
HttpRequestBase request = context.Request;
string user_id = User.Identity.Name;
UserManager userMgr = new UserManager(int.Parse(user_id), null);
BUser user = userMgr.CurrentUser;
StockManager stockManager = new StockManager(userMgr.CurrentUser, userMgr.Shop, userMgr.CurrentUserPermission);
BuyManager buyManager = new BuyManager(userMgr.CurrentUser, userMgr.Shop, userMgr.CurrentUserPermission);
int page = 1;
int pageSize = 30;
int category = 0;
int storeHouse = 0;
int.TryParse(request["cid"],out category);
int.TryParse(request["house"],out storeHouse);
int.TryParse(request["page"],out page);
int.TryParse(request["pageSize"],out pageSize);
string keyword = request["keyword"];
int total = 0;
data.data=stockManager.SearchProductsStocks(null, category, storeHouse, keyword, page, pageSize, out total);
data.curPage = page;
data.totalRecords = total;
return data;
}
public PQGridData SearchLeaveStock()
{
PQGridData data = new PQGridData();
HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"];
HttpRequestBase request = context.Request;
string user_id = User.Identity.Name;
UserManager userMgr = new UserManager(int.Parse(user_id), null);
BUser user = userMgr.CurrentUser;
StockManager stockManager = new StockManager(userMgr.CurrentUser, userMgr.Shop, userMgr.CurrentUserPermission);
BuyManager buyManager = new BuyManager(userMgr.CurrentUser, userMgr.Shop, userMgr.CurrentUserPermission);
int page = 1;
int pageSize = 30;
string sale_id = request["sale_id"];
int leave_id=0;
int uid = 0;
long stime = 0;
long etime = 0;
if (!string.IsNullOrEmpty(request["sdate"]))
{
DateTime sdate = DateTime.MinValue;
DateTime.TryParse(request["sdate"],out sdate);
if (sdate != DateTime.MinValue)
{
stime = DateTimeUtil.ConvertDateTimeToInt(sdate);
}
}
if (!string.IsNullOrEmpty(request["edate"]))
{
DateTime edate = DateTime.MinValue;
DateTime.TryParse(request["edate"], out edate);
if (edate != DateTime.MinValue)
{
etime = DateTimeUtil.ConvertDateTimeToInt(edate);
}
}
int.TryParse(request["page"], out page);
int.TryParse(request["pageSize"], out pageSize);
int.TryParse(request["leave_id"], out leave_id);
int.TryParse(request["user_id"], out uid);
int total = 0;
int[] leave_ids = null;
int[] user_ids = null;
string[] sale_ids = null;
if (leave_id > 0)
{
leave_ids = new int[] { leave_id };
}
if (uid > 0)
{
user_ids = new int[] { uid };
}
if (!string.IsNullOrEmpty(sale_id))
{
sale_ids = new string[] { sale_id };
}
data.data = stockManager.SearchLeaveStocks(leave_ids, sale_ids, user_ids, stime, etime, page, pageSize, out total);
data.curPage = page;
data.totalRecords = total;
return data;
}
public PQGridData SearchBatches()
{
PQGridData data = new PQGridData();
HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"];
HttpRequestBase request = context.Request;
string user_id = User.Identity.Name;
UserManager userMgr = new UserManager(int.Parse(user_id), null);
BUser user = userMgr.CurrentUser;
StockManager stockManager = new StockManager(userMgr.CurrentUser, userMgr.Shop, userMgr.CurrentUserPermission);
int page = 1;
int pageSize = 30;
int.TryParse(request["page"], out page);
int.TryParse(request["pageSize"], out pageSize);
string keyword = request["product_key"];
int total = 0;
if (page <= 0)
{
page = 1;
}
if (pageSize <= 0)
{
pageSize = 30;
}
data.data = stockManager.SearchBatches(0, null, keyword, page, pageSize, out total);
data.curPage = page;
data.pageSize = pageSize;
return data;
}
public PQGridData GetStoreHouses()
{
PQGridData data = new PQGridData();
HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"];
HttpRequestBase request = context.Request;
string user_id = User.Identity.Name;
UserManager userMgr = new UserManager(int.Parse(user_id), null);
BUser user = userMgr.CurrentUser;
StockManager stockManager = new StockManager(userMgr.CurrentUser, userMgr.Shop, userMgr.CurrentUserPermission);
BuyManager buyManager = new BuyManager(userMgr.CurrentUser, userMgr.Shop, userMgr.CurrentUserPermission);
List<BStoreHouse> houses = stockManager.GetStoreHouses();
data.totalRecords = houses.Count;
data.data = houses;
data.curPage = 1;
return data;
}
public PQGridData SearchTradeSyncLog()
{
PQGridData data = new PQGridData();
HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"];
HttpRequestBase request = context.Request;
string user_id = User.Identity.Name;
UserManager userMgr = new UserManager(int.Parse(user_id), null);
BUser user = userMgr.CurrentUser;
SalesManager saleManager = new SalesManager(userMgr.CurrentUser, userMgr.Shop, userMgr.CurrentUserPermission);
int page = 1;
int.TryParse(request["page"],out page);
if (page == 0)
{
page = 1;
}
int pageSize = 20;
int.TryParse(request["pageSize"],out pageSize);
if (pageSize == 0)
{
pageSize = 20;
}
int total = 0;
data.data = saleManager.SearchTradeSyncLog(0, 0, 0, null, page, pageSize, out total);
data.totalRecords = total;
data.curPage = page;
return data;
}
public PQGridData SearchSales()
{
PQGridData data = new PQGridData();
HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"];
HttpRequestBase request = context.Request;
string user_id = User.Identity.Name;
UserManager userMgr = new UserManager(int.Parse(user_id), null);
BUser user = userMgr.CurrentUser;
StockManager stockManager = new StockManager(userMgr.CurrentUser, userMgr.Shop, userMgr.CurrentUserPermission);
SalesManager saleManager = new SalesManager(userMgr.CurrentUser, userMgr.Shop, userMgr.CurrentUserPermission);
int page = 1;
int pageSize = 30;
long stime = 0;
long etime = 0;
if (!string.IsNullOrEmpty(request["sdate"]))
{
DateTime sdate = DateTime.MinValue;
DateTime.TryParse(request["sdate"], out sdate);
if (sdate != DateTime.MinValue)
{
stime = DateTimeUtil.ConvertDateTimeToInt(sdate);
}
}
if (!string.IsNullOrEmpty(request["edate"]))
{
DateTime edate = DateTime.MinValue;
DateTime.TryParse(request["edate"], out edate);
if (edate != DateTime.MinValue)
{
etime = DateTimeUtil.ConvertDateTimeToInt(edate);
}
}
int.TryParse(request["page"], out page);
int.TryParse(request["pageSize"], out pageSize);
int total = 0;
data.data = saleManager.SearchSales(null,null,null,null, null,null, stime, etime, page, pageSize, out total);
data.totalRecords = total;
return data;
}
public PQGridData GetCategories()
{
PQGridData data = new PQGridData();
string user_id = User.Identity.Name;
UserManager userMgr = new UserManager(int.Parse(user_id), null);
BUser user = userMgr.CurrentUser;
Shop MainShop = userMgr.Main_Shop;
ShopCategoryManager cateMgr = new ShopCategoryManager(userMgr.CurrentUser, MainShop, userMgr.CurrentUserPermission);
HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"];
HttpRequestBase request = context.Request;
int id = 0;
if (!string.IsNullOrEmpty(request["parent_id"]))
{
id = int.Parse(request["parent_id"].ToString());
}
List<BCategory> categories = new List<BCategory>();
categories = cateMgr.GetCategories(id);
data.curPage = 1;
data.totalRecords = categories.Count;
data.data = categories;
return data;
}
public PQGridData GetPropertiesT()
{
string user_id = User.Identity.Name;
UserManager userMgr = new UserManager(int.Parse(user_id), null);
ApiMessage message = new ApiMessage();
BUser user = userMgr.CurrentUser;
ShopCategoryManager cateMgr = new ShopCategoryManager(userMgr.CurrentUser, userMgr.Shop, userMgr.CurrentUserPermission);
int categoryId = 0;
HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"];
HttpRequestBase request = context.Request;
int.TryParse(request["cid"], out categoryId);
string sortBy = "";
string dir = "";
if (request["sortBy"] != null)
{
sortBy = request["sortBy"];
}
if (request["dir"] != null)
{
sortBy = request["dir"];
}
List<BProperty> properties = cateMgr.GetProperties(categoryId,0,sortBy,dir);
PQGridData grid = new PQGridData();
grid.curPage = 1;
grid.totalRecords = properties.Count;
grid.data = properties;
message.Item = grid;
message.Status="ok";
return grid;
}
public PQGridData SearchStocks()
{
PQGridData data = new PQGridData();
HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"];
HttpRequestBase request = context.Request;
string user_id = User.Identity.Name;
UserManager userMgr = new UserManager(int.Parse(user_id), null);
BUser user = userMgr.CurrentUser;
StockManager stockManager = new StockManager(userMgr.CurrentUser, userMgr.Shop, userMgr.CurrentUserPermission);
BuyManager buyManager = new BuyManager(userMgr.CurrentUser, userMgr.Shop, userMgr.CurrentUserPermission);
int page = 1;
int pageSize = 30;
int storeHouse = 0;
bool paging = false;
string product_ids = request["products"];
int.TryParse(request["house"], out storeHouse);
int.TryParse(request["page"], out page);
int.TryParse(request["pageSize"], out pageSize);
string keyword = request["keyword"];
int total = 0;
List<int> storeHouses = new List<int>();
if (storeHouse > 0)
{
storeHouses.Add(storeHouse);
}
List<int> products = new List<int>();
if (!string.IsNullOrEmpty(product_ids))
{
string[] ids = product_ids.Split(',');
foreach (string id in ids)
{
products.Add(int.Parse(id));
}
}
if (!string.IsNullOrEmpty(request["paging"]) && request["paging"] == "1")
{
paging = true;
}
else
{
paging = false;
}
if (page <= 0)
{
page = 1;
}
if (pageSize <= 0)
{
pageSize = 30;
}
data.data = stockManager.SearchStocks(products, storeHouses, page, pageSize, out total, paging);
data.curPage = page;
data.totalRecords = total;
return data;
}
public PQGridData GetBuys()
{
PQGridData data = new PQGridData();
HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"];
HttpRequestBase request = context.Request;
string user_id = User.Identity.Name;
UserManager userMgr = new UserManager(int.Parse(user_id), null);
BUser user = userMgr.CurrentUser;
BuyManager buyManager = new BuyManager(userMgr.CurrentUser, userMgr.Shop, userMgr.CurrentUserPermission);
int total = 0;
int page = 1;
int pageSize = 30;
int.TryParse(request["page"], out page);
int.TryParse(request["pageSize"], out pageSize);
if (page <= 0)
{
page = 1;
}
if (pageSize <= 0)
{
pageSize = 30;
}
data.data = buyManager.SearchBuys(null,null,null,null,null,0,0,page,pageSize,out total);
data.totalRecords = total;
return data;
}
public PQGridData GetSuppliers()
{
PQGridData data = new PQGridData();
HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"];
HttpRequestBase request = context.Request;
string user_id = User.Identity.Name;
UserManager userMgr = new UserManager(int.Parse(user_id), null);
BUser user = userMgr.CurrentUser;
SupplierManager supplierManager = new SupplierManager(userMgr.CurrentUser, userMgr.Shop, userMgr.CurrentUserPermission);
int page = 1;
int pageSize = 30;
int total = 0;
int.TryParse(request["page"],out page);
int.TryParse(request["pageSize"], out pageSize);
data.data = supplierManager.SearchSupplies(0, page, pageSize, out total);
return data;
}
public PQGridData GetBuyPrices()
{
PQGridData data = new PQGridData();
HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"];
HttpRequestBase request = context.Request;
string user_id = User.Identity.Name;
UserManager userMgr = new UserManager(int.Parse(user_id), null);
BUser user = userMgr.CurrentUser;
BuyManager buyManager = new BuyManager(userMgr.CurrentUser, userMgr.Shop, userMgr.CurrentUserPermission);
string keyword = request["keyword"];
int total = 0;
int page = 1;
int pageSize = 30;
int.TryParse(request["page"], out page);
int.TryParse(request["pageSize"], out pageSize);
int price_user_id = 0;
int supplier_id = 0;
int.TryParse(request["user_id"], out price_user_id);
int.TryParse(request["supplier_id"], out supplier_id);
int buyPriceId = 0;
int.TryParse(request["price_id"], out buyPriceId);
string keyWord = request["keyword"];
if (page <= 0)
{
page = 1;
}
if (pageSize <= 0)
{
pageSize = 30;
}
data.data = buyManager.SearchBuyPrices(buyPriceId, price_user_id, supplier_id, 0,keyword, page, pageSize, out total);
data.totalRecords = total;
data.curPage = page;
data.pageSize = pageSize;
return data;
}
public PQGridData SearchExpresses()
{
PQGridData data = new PQGridData();
HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"];
HttpRequestBase request = context.Request;
string user_id = User.Identity.Name;
UserManager userMgr = new UserManager(int.Parse(user_id), null);
BUser user = userMgr.CurrentUser;
ShopManager shopManager = new ShopManager(userMgr.CurrentUser, userMgr.Shop, userMgr.CurrentUserPermission, userMgr);
data.data = shopManager.SearchExpresses();
return data;
}
public PQGridData GetStockReport()
{
PQGridData data = new PQGridData();
HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"];
HttpRequestBase request = context.Request;
string user_id = User.Identity.Name;
UserManager userMgr = new UserManager(int.Parse(user_id), null);
BUser user = userMgr.CurrentUser;
ReportFactory reportManager = new ReportFactory(userMgr.CurrentUser, userMgr.Shop, userMgr.CurrentUserPermission);
int page = 1;
int pageSize = 50;
int totalProducts = 0;
int[] product_id = null;
bool paging = false;
int.TryParse(request["page"], out page);
int.TryParse(request["pageSize"], out pageSize);
if (!string.IsNullOrEmpty(request["products"]))
{
product_id = base.ConvertToIntArrar(request["products"]);
}
if (page <= 0)
{
page = 1;
}
if (pageSize <= 0)
{
pageSize = 50;
}
if (!string.IsNullOrEmpty(request["paging"]) && request["paging"] == "1")
{
paging = true;
}
else
{
paging = false;
}
try
{
string json = reportManager.GetStockReport(product_id, page, pageSize, out totalProducts, paging);
data.totalRecords = totalProducts;
if (!string.IsNullOrEmpty(json))
{
data.data = JArray.Parse(json);
}
data.curPage = page;
}
catch (Exception ex)
{
data.data = JArray.Parse("[]");
data.totalRecords = 0;
data.curPage = 1;
}
finally
{
}
return data;
}
public PQGridData SearchBugs()
{
PQGridData data = new PQGridData();
HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"];
HttpRequestBase request = context.Request;
string user_id = User.Identity.Name;
BugManager bugManager = new BugManager(int.Parse(user_id));
int page = 0;
int pageSize = 0;
int u_id = 0;
int feature_id = 0;
int total = 0;
int status_id=0;
int.TryParse(request["page"],out page);
int.TryParse(request["pageSize"],out pageSize);
int.TryParse(request["status"],out status_id);
int.TryParse(request["feature"],out feature_id);
int.TryParse(request["user"],out u_id);
if (pageSize <= 0)
{
pageSize = 20;
}
if (page <= 0)
{
page = 1;
}
data.data = bugManager.SearchBugs(u_id, feature_id, status_id, page, pageSize, out total);
data.curPage = page;
data.totalRecords = total;
return data;
}
