public ActionResult GetPageCount(int pageSize, string checkStockID, string goodsID, string sysQty, string qty, string profitLoss) { return(Json(checkStockDetailOper.GetPageCount( delegate(object sender, ICriteria criteria) { if (!string.IsNullOrEmpty(checkStockID)) { ICriterion criterion = Restrictions.Eq("CheckStockID", PojoUtil.InitPojo <CheckStock>(checkStockID)); criteria.Add(criterion); } if (!string.IsNullOrEmpty(goodsID)) { ICriterion criterion = Restrictions.Eq("GoodsID", PojoUtil.InitPojo <GoodsInfo>(goodsID)); criteria.Add(criterion); } if (!string.IsNullOrEmpty(sysQty)) { ICriterion criterion = Restrictions.Like("SysQty", sysQty, MatchMode.Anywhere); criteria.Add(criterion); } if (!string.IsNullOrEmpty(qty)) { ICriterion criterion = Restrictions.Like("Qty", qty, MatchMode.Anywhere); criteria.Add(criterion); } if (!string.IsNullOrEmpty(profitLoss)) { ICriterion criterion = Restrictions.Like("ProfitLoss", profitLoss, MatchMode.Anywhere); criteria.Add(criterion); } } , pageSize))); }
public ActionResult GetPageCount(int pageSize, string goodsCode, string goodsName, string barCode, string goodsTypeID, string modelNum) { return(Json(goodsInfoOper.GetPageCount( delegate(object sender, ICriteria criteria) { if (!string.IsNullOrEmpty(goodsCode)) { ICriterion criterion = Restrictions.Like("GoodsCode", goodsCode, MatchMode.Anywhere); criteria.Add(criterion); } if (!string.IsNullOrEmpty(goodsName)) { ICriterion criterion = Restrictions.Like("GoodsName", goodsName, MatchMode.Anywhere); criteria.Add(criterion); } if (!string.IsNullOrEmpty(barCode)) { ICriterion criterion = Restrictions.Like("BarCode", barCode, MatchMode.Anywhere); criteria.Add(criterion); } if (!string.IsNullOrEmpty(goodsTypeID)) { ICriterion criterion = Restrictions.Eq("GoodsType", PojoUtil.InitPojo <GoodsType>(goodsTypeID)); criteria.Add(criterion); } if (!string.IsNullOrEmpty(modelNum)) { ICriterion criterion = Restrictions.Like("ModelNum", modelNum, MatchMode.Anywhere); criteria.Add(criterion); } } , pageSize))); }
public ActionResult Get(int pageSize, int pageNum, string roleFlag, string roleId, string modId) { return(Json(empModOper.Get( delegate(object sender, ICriteria criteria) { if (!string.IsNullOrEmpty(roleFlag)) { ICriterion criterion = Restrictions.Eq("RoleFlag", roleFlag); criteria.Add(criterion); } if (!string.IsNullOrEmpty(roleId)) { ICriterion criterion = Restrictions.Eq("RoleId", new Guid(roleId)); criteria.Add(criterion); } if (!string.IsNullOrEmpty(modId)) { ICriterion criterion = Restrictions.Eq("Mod", PojoUtil.InitPojo <Mod>(modId)); criteria.Add(criterion); } //创建对象属性别名 criteria.CreateAlias("Mod", "m"); criteria.AddOrder(Order.Asc("m.Name")); } , pageSize, pageNum))); }
public ActionResult GetPageCount(int pageSize, string retOrderID, string goodsID, string price, string qty) { return(Json(retOrderDetailOper.GetPageCount( delegate(object sender, ICriteria criteria) { if (!string.IsNullOrEmpty(retOrderID)) { ICriterion criterion = Restrictions.Eq("RetOrderID", PojoUtil.InitPojo <RetOrder>(retOrderID)); criteria.Add(criterion); } if (!string.IsNullOrEmpty(goodsID)) { ICriterion criterion = Restrictions.Eq("GoodsID", PojoUtil.InitPojo <GoodsInfo>(goodsID)); criteria.Add(criterion); } if (!string.IsNullOrEmpty(price)) { ICriterion criterion = Restrictions.Like("Price", price, MatchMode.Anywhere); criteria.Add(criterion); } if (!string.IsNullOrEmpty(qty)) { ICriterion criterion = Restrictions.Like("Qty", qty, MatchMode.Anywhere); criteria.Add(criterion); } } , pageSize))); }
public ActionResult GetCustomerScore(int pageSize, int pageNum, string workId) { return(Json(customerScoreOper.Get( delegate(object sender, ICriteria criteria) { ICriterion criterion = Restrictions.Eq("Work", PojoUtil.InitPojo <Work>(workId)); criteria.Add(criterion); criteria.AddOrder(Order.Desc("ModDate")); } , pageSize, pageNum))); }
public ActionResult GetWorkDetail(int pageSize, int pageNum, string workSubId) { return(Json(workDetailOper.Get( delegate(object sender, ICriteria criteria) { ICriterion criterion = Restrictions.Eq("WorkSub", PojoUtil.InitPojo <WorkSub>(workSubId)); criteria.Add(criterion); criteria.AddOrder(Order.Desc("ModDate")); } , pageSize, pageNum))); }
public ActionResult Get(int pageSize, int pageNum, string retOrderCode, string vendorID, string storeHouseID, string retMember, string approvalID, string approvalTime, string state, string totalMoney) { return(Json(retOrderOper.Get( delegate(object sender, ICriteria criteria) { if (!string.IsNullOrEmpty(retOrderCode)) { ICriterion criterion = Restrictions.Like("RetOrderCode", retOrderCode, MatchMode.Anywhere); criteria.Add(criterion); } if (!string.IsNullOrEmpty(vendorID)) { ICriterion criterion = Restrictions.Eq("VendorID", PojoUtil.InitPojo <VendorInfo>(vendorID)); criteria.Add(criterion); } if (!string.IsNullOrEmpty(storeHouseID)) { ICriterion criterion = Restrictions.Eq("StoreHouseID", PojoUtil.InitPojo <Storehouse>(storeHouseID)); criteria.Add(criterion); } if (!string.IsNullOrEmpty(retMember)) { ICriterion criterion = Restrictions.Like("RetMember", retMember, MatchMode.Anywhere); criteria.Add(criterion); } if (!string.IsNullOrEmpty(approvalID)) { ICriterion criterion = Restrictions.Eq("ApprovalID", PojoUtil.InitPojo <Employee>(approvalID)); criteria.Add(criterion); } if (!string.IsNullOrEmpty(approvalTime)) { ICriterion criterion = Restrictions.Like("ApprovalTime", approvalTime, MatchMode.Anywhere); criteria.Add(criterion); } if (!string.IsNullOrEmpty(state)) { ICriterion criterion = Restrictions.Like("State", state, MatchMode.Anywhere); criteria.Add(criterion); } if (!string.IsNullOrEmpty(totalMoney)) { ICriterion criterion = Restrictions.Like("TotalMoney", totalMoney, MatchMode.Anywhere); criteria.Add(criterion); } criteria.AddOrder(Order.Asc("RetOrderCode")); } , pageSize, pageNum))); }
public ActionResult Get(int pageSize, int pageNum, string reqOrderCode, string srcHouseID, string destHouseID, string carrier, string approvalID, string oPerTime, string approvalTime, string state) { return(Json(reqOrderOper.Get( delegate(object sender, ICriteria criteria) { if (!string.IsNullOrEmpty(reqOrderCode)) { ICriterion criterion = Restrictions.Like("ReqOrderCode", reqOrderCode, MatchMode.Anywhere); criteria.Add(criterion); } if (!string.IsNullOrEmpty(srcHouseID)) { ICriterion criterion = Restrictions.Eq("SrcHouseID", PojoUtil.InitPojo <Storehouse>(srcHouseID)); criteria.Add(criterion); } if (!string.IsNullOrEmpty(destHouseID)) { ICriterion criterion = Restrictions.Eq("DestHouseID", PojoUtil.InitPojo <Storehouse>(destHouseID)); criteria.Add(criterion); } if (!string.IsNullOrEmpty(carrier)) { ICriterion criterion = Restrictions.Like("Carrier", carrier, MatchMode.Anywhere); criteria.Add(criterion); } if (!string.IsNullOrEmpty(approvalID)) { ICriterion criterion = Restrictions.Eq("ApprovalID", PojoUtil.InitPojo <Employee>(approvalID)); criteria.Add(criterion); } if (!string.IsNullOrEmpty(oPerTime)) { ICriterion criterion = Restrictions.Like("OPerTime", oPerTime, MatchMode.Anywhere); criteria.Add(criterion); } if (!string.IsNullOrEmpty(approvalTime)) { ICriterion criterion = Restrictions.Like("ApprovalTime", approvalTime, MatchMode.Anywhere); criteria.Add(criterion); } if (!string.IsNullOrEmpty(state)) { ICriterion criterion = Restrictions.Like("State", state, MatchMode.Anywhere); criteria.Add(criterion); } criteria.AddOrder(Order.Asc("ReqOrderCode")); } , pageSize, pageNum))); }
public ActionResult GetPageCount(int pageSize, string rentOrderCode, string storeHouseID, string borrID, string borrDeptID, string oPerTime, string approvalID, string approvalTime, string state) { return(Json(rentOrderOper.GetPageCount( delegate(object sender, ICriteria criteria) { if (!string.IsNullOrEmpty(rentOrderCode)) { ICriterion criterion = Restrictions.Like("RentOrderCode", rentOrderCode, MatchMode.Anywhere); criteria.Add(criterion); } if (!string.IsNullOrEmpty(storeHouseID)) { ICriterion criterion = Restrictions.Eq("StoreHouseID", PojoUtil.InitPojo <Storehouse>(storeHouseID)); criteria.Add(criterion); } if (!string.IsNullOrEmpty(borrID)) { ICriterion criterion = Restrictions.Eq("BorrID", PojoUtil.InitPojo <Employee>(borrID)); criteria.Add(criterion); } if (!string.IsNullOrEmpty(borrDeptID)) { ICriterion criterion = Restrictions.Eq("BorrDeptID", PojoUtil.InitPojo <Department>(borrID)); criteria.Add(criterion); } if (!string.IsNullOrEmpty(oPerTime)) { ICriterion criterion = Restrictions.Like("OPerTime", oPerTime, MatchMode.Anywhere); criteria.Add(criterion); } if (!string.IsNullOrEmpty(approvalID)) { ICriterion criterion = Restrictions.Eq("ApprovalID", PojoUtil.InitPojo <Employee>(approvalID)); criteria.Add(criterion); } if (!string.IsNullOrEmpty(approvalTime)) { ICriterion criterion = Restrictions.Like("ApprovalTime", approvalTime, MatchMode.Anywhere); criteria.Add(criterion); } if (!string.IsNullOrEmpty(state)) { ICriterion criterion = Restrictions.Like("State", state, MatchMode.Anywhere); criteria.Add(criterion); } } , pageSize))); }
public ActionResult GetPageCount(int pageSize, string storehouseId, string goodsId) { return(Json(stockInitOper.GetPageCount( delegate(object sender, ICriteria criteria) { if (!string.IsNullOrEmpty(storehouseId)) { ICriterion criterion = Restrictions.Eq("Storehouse", PojoUtil.InitPojo <Storehouse>(storehouseId)); criteria.Add(criterion); } if (!string.IsNullOrEmpty(goodsId)) { ICriterion criterion = Restrictions.Eq("Goods", PojoUtil.InitPojo <GoodsInfo>(goodsId)); criteria.Add(criterion); } } , pageSize))); }
public ActionResult Get(int pageSize, int pageNum, string storehouseID, string goodsID) { return(Json(sellPriceInfoOper.Get( delegate(object sender, ICriteria criteria) { if (!string.IsNullOrEmpty(storehouseID)) { ICriterion criterion = Restrictions.Eq("Storehouse", PojoUtil.InitPojo <Storehouse>(storehouseID)); criteria.Add(criterion); } if (!string.IsNullOrEmpty(goodsID)) { ICriterion criterion = Restrictions.Eq("Goods", PojoUtil.InitPojo <GoodsInfo>(goodsID)); criteria.Add(criterion); } } , pageSize, pageNum))); }
public ActionResult GetPageCount(int pageSize, string purOrderCode, string vendorID, string storeHouseID, string buyer, string approvalTime, string state, string totalMoney) { return(Json(purOrderOper.GetPageCount( delegate(object sender, ICriteria criteria) { if (!string.IsNullOrEmpty(purOrderCode)) { ICriterion criterion = Restrictions.Like("PurOrderCode", purOrderCode, MatchMode.Anywhere); criteria.Add(criterion); } if (!string.IsNullOrEmpty(vendorID)) { ICriterion criterion = Restrictions.Eq("VendorID", PojoUtil.InitPojo <VendorInfo>(vendorID)); criteria.Add(criterion); } if (!string.IsNullOrEmpty(storeHouseID)) { ICriterion criterion = Restrictions.Eq("StoreHouseID", PojoUtil.InitPojo <Storehouse>(storeHouseID)); criteria.Add(criterion); } if (!string.IsNullOrEmpty(buyer)) { ICriterion criterion = Restrictions.Like("Buyer", buyer, MatchMode.Anywhere); criteria.Add(criterion); } if (!string.IsNullOrEmpty(approvalTime)) { ICriterion criterion = Restrictions.Like("ApprovalTime", approvalTime, MatchMode.Anywhere); criteria.Add(criterion); } if (!string.IsNullOrEmpty(state)) { ICriterion criterion = Restrictions.Like("State", state, MatchMode.Anywhere); criteria.Add(criterion); } if (!string.IsNullOrEmpty(totalMoney)) { ICriterion criterion = Restrictions.Like("TotalMoney", approvalTime, MatchMode.Anywhere); criteria.Add(criterion); } } , pageSize))); }
public ActionResult Get(int pageSize, int pageNum, string storehouseId, string goodsId) { return(Json(stockInitOper.Get( delegate(object sender, ICriteria criteria) { if (!string.IsNullOrEmpty(storehouseId)) { ICriterion criterion = Restrictions.Eq("Storehouse", PojoUtil.InitPojo <Storehouse>(storehouseId)); criteria.Add(criterion); } if (!string.IsNullOrEmpty(goodsId)) { ICriterion criterion = Restrictions.Eq("Goods", PojoUtil.InitPojo <GoodsInfo>(goodsId)); criteria.Add(criterion); } //创建对象属性别名 criteria.CreateAlias("Storehouse", "sh"); criteria.AddOrder(Order.Asc("sh.StoreName")); } , pageSize, pageNum))); }
public ActionResult Get(int pageSize, int pageNum, string sellOrderID, string goodsID, string qty, string sellPrice, string realSellPrice, string totalMoney) { return(Json(sellOrderDetailOper.Get( delegate(object sender, ICriteria criteria) { if (!string.IsNullOrEmpty(sellOrderID)) { ICriterion criterion = Restrictions.Eq("SellOrderID", PojoUtil.InitPojo <SellOrder>(sellOrderID)); criteria.Add(criterion); } if (!string.IsNullOrEmpty(goodsID)) { ICriterion criterion = Restrictions.Eq("GoodsID", PojoUtil.InitPojo <GoodsInfo>(goodsID)); criteria.Add(criterion); } if (!string.IsNullOrEmpty(qty)) { ICriterion criterion = Restrictions.Like("Qty", qty, MatchMode.Anywhere); criteria.Add(criterion); } if (!string.IsNullOrEmpty(sellPrice)) { ICriterion criterion = Restrictions.Like("SellPrice", sellPrice, MatchMode.Anywhere); criteria.Add(criterion); } if (!string.IsNullOrEmpty(realSellPrice)) { ICriterion criterion = Restrictions.Like("RealSellPrice", realSellPrice, MatchMode.Anywhere); criteria.Add(criterion); } if (!string.IsNullOrEmpty(totalMoney)) { ICriterion criterion = Restrictions.Like("TotalMoney", totalMoney, MatchMode.Anywhere); criteria.Add(criterion); } criteria.AddOrder(Order.Asc("SellOrderID")); } , pageSize, pageNum))); }
public ActionResult Get(int pageSize, int pageNum, string sellOrderCode, string storeHouseID, string salespersonID, string salespersonDeptID, string sellDateTime, string totalMoney) { return(Json(sellOrderOper.Get( delegate(object sender, ICriteria criteria) { if (!string.IsNullOrEmpty(sellOrderCode)) { ICriterion criterion = Restrictions.Like("SellOrderCode", sellOrderCode, MatchMode.Anywhere); criteria.Add(criterion); } if (!string.IsNullOrEmpty(storeHouseID)) { ICriterion criterion = Restrictions.Eq("StoreHouseID", PojoUtil.InitPojo <Storehouse>(storeHouseID)); criteria.Add(criterion); } if (!string.IsNullOrEmpty(salespersonID)) { ICriterion criterion = Restrictions.Eq("SalespersonID", PojoUtil.InitPojo <Employee>(salespersonID)); criteria.Add(criterion); } if (!string.IsNullOrEmpty(salespersonDeptID)) { ICriterion criterion = Restrictions.Eq("SalespersonDeptID", PojoUtil.InitPojo <Department>(salespersonDeptID)); criteria.Add(criterion); } if (!string.IsNullOrEmpty(sellDateTime)) { ICriterion criterion = Restrictions.Like("SellDateTime", sellDateTime, MatchMode.Anywhere); criteria.Add(criterion); } if (!string.IsNullOrEmpty(totalMoney)) { ICriterion criterion = Restrictions.Like("TotalMoney", totalMoney, MatchMode.Anywhere); criteria.Add(criterion); } criteria.AddOrder(Order.Asc("SellOrderCode")); } , pageSize, pageNum))); }
public ActionResult GetPageCount(int pageSize, string roleFlag, string roleId, string modId) { return(Json(empModOper.GetPageCount( delegate(object sender, ICriteria criteria) { if (!string.IsNullOrEmpty(roleFlag)) { ICriterion criterion = Restrictions.Eq("RoleFlag", roleFlag); criteria.Add(criterion); } if (!string.IsNullOrEmpty(roleId)) { ICriterion criterion = Restrictions.Eq("RoleId", new Guid(roleId)); criteria.Add(criterion); } if (!string.IsNullOrEmpty(modId)) { ICriterion criterion = Restrictions.Eq("Mod", PojoUtil.InitPojo <Mod>(modId)); criteria.Add(criterion); } } , pageSize))); }
/// <summary> /// 查询仓库登记页数 /// </summary> /// <param name="pageSize"></param> /// <returns></returns> //[PowerActionFilterAttribute(FuncName = PowerActionFilterAttribute.FuncEnum.Get)] public ActionResult GetPageCount(int pageSize, string storeCode, string storeName, string deptID) { return(Json(storehouseOper.GetPageCount( delegate(object sender, ICriteria criteria) { if (!string.IsNullOrEmpty(storeCode)) { ICriterion criterion = Restrictions.Like("StoreCode", storeCode, MatchMode.Anywhere); criteria.Add(criterion); } if (!string.IsNullOrEmpty(storeName)) { ICriterion criterion = Restrictions.Like("StoreName", storeName, MatchMode.Anywhere); criteria.Add(criterion); } if (!string.IsNullOrEmpty(deptID)) { ICriterion criterion = Restrictions.Eq("Dept", PojoUtil.InitPojo <Department>(deptID)); criteria.Add(criterion); } } , pageSize))); }
public ActionResult Get(int pageSize, int pageNum, string retRentIOrderD, string goodsID, string qty) { return(Json(retRentOrderDetailOper.Get( delegate(object sender, ICriteria criteria) { if (!string.IsNullOrEmpty(retRentIOrderD)) { ICriterion criterion = Restrictions.Eq("RetRentIOrderD", PojoUtil.InitPojo <RetRentOrder>(retRentIOrderD)); criteria.Add(criterion); } if (!string.IsNullOrEmpty(goodsID)) { ICriterion criterion = Restrictions.Eq("GoodsID", PojoUtil.InitPojo <GoodsInfo>(goodsID)); criteria.Add(criterion); } if (!string.IsNullOrEmpty(qty)) { ICriterion criterion = Restrictions.Like("Qty", qty, MatchMode.Anywhere); criteria.Add(criterion); } criteria.AddOrder(Order.Asc("RetRentIOrderD")); } , pageSize, pageNum))); }
/// <summary> /// 根据类型1获取所有类型2 /// </summary> /// <param name="workCodeType1"></param> /// <returns></returns> public ActionResult GetWorkCodeType2ForWeiXin(string workCodeType1Id) { IList <WorkCodeType> wcts = workCodeTypeOper.Get(delegate(object sender, ICriteria criteria) { ICriterion criterion = Restrictions.Eq("Type1", PojoUtil.InitPojo <WorkCodeType1>(workCodeType1Id)); criteria.Add(criterion); ICriteria criteria2 = criteria.CreateCriteria("Type2", "t2"); criteria2.AddOrder(Order.Asc("Code")); }); IList <WorkCodeType2> retVal = new List <WorkCodeType2>(); if (wcts.Count > 0) { foreach (WorkCodeType wct in wcts) { retVal.Add(wct.Type2); } } wcts.Clear(); return(Json(retVal)); }