public ActionResult Export() { int count = 0; object footer = null; var dt = TakeStockService.FindPageList(Request.Params, out count, ref footer, false); if (dt == null || dt.Rows.Count <= 0) { return(RedirectAlert("Index", "暂无数据!")); } dt.Columns.Add("盘点员工号"); dt.Columns.Add("序号"); //string[] fields = { "StoreTitle", "CheckBatch", "Barcode", "Title", "BrandTitle", "SubUnit", "ActualNumber"}; //string[] names = { "盘点门店", "盘点批次", "条码", "品名", "品牌", "单位", "实盘数量" }; string[] fields = { "序号", "CategoryTitle", "Barcode", "Title", "BrandTitle", "SubUnit", "ActualNumber", "盘点员工号" }; string[] names = { "序号", "品类", "条码", "品名", "品牌", "单位", "实盘数量", "盘点员工号" }; var title = ""; var i = 1; foreach (DataRow dr in dt.Rows) { dr["ActualNumber"] = DBNull.Value; dr["序号"] = i++; } int[] merger = { }; new ExportExcel() { IsBufferOutput = true, HeaderText = title }.ToExcel(dt.Rows[0]["StoreTitle"] + "_盘点_" + dt.Rows[0]["CheckBatch"], dt, fields, names, merger, formatFileName: false); return(new EmptyResult()); }
public ActionResult StockLock(TreasuryLocks obj) { obj.LockCategorySN = Request["selectCategorySN"]; var op = TakeStockService.AddStockLock(obj); return(Content(op.ToJson())); }
public ActionResult SubExport(string storeId, string checkBatch) { int count = 0; var nl = new System.Collections.Specialized.NameValueCollection() { Request.Params }; //nl.Add("state", "1"); object footer = null; var dt = TakeStockService.ReportList(nl, out count, ref footer, false); if (dt == null || dt.Rows.Count <= 0) { return(RedirectAlert("Report", "暂无数据,请先确认是否已审核!")); } dt.Columns.Add("序号"); dt.Columns.Add("复盘数量"); dt.Columns.Add("盘点员工号"); for (var i = 0; i < dt.Rows.Count; i++) { dt.Rows[i]["序号"] = i + 1; } string[] fields = { "序号", "SureTitle", "SupplierTitle", "CategoryTitle", "Barcode", "Title", "Size", "SubUnit", "SysPrice", "LockNumber", "ActualNumber", "复盘数量", "盘点员工号" }; string[] names = { "序号", "差异确认", "供应商", "品类", "条码", "品名", "规格", "单位", "系统售价", "锁库库存", "盘点数量", "复盘数量", "盘点员工号" }; var totalCols = new int[] { }; var title = ""; new ExportExcel() { IsBufferOutput = true, HeaderText = title }.ToExcel("盘点", dt, fields, names, null, totalCols); return(new EmptyResult()); }
public ActionResult FindStockList(string lockStoreID, string checkBatch) { int count = 0; var list = TakeStockService.FindStockList(lockStoreID, checkBatch); return(ToDataGrid(list, count)); }
public ActionResult CheckerSelect(string batchNo) { var list = TakeStockService.GetCheckerByBatchnoList(batchNo).ToList(); list.Insert(0, new DropdownItem("", "全部", true)); return(new JsonNetResult(list)); }
public void SaveStock(string data, int cid) { //SaveStock([FromBody]SaveTakeStockRequest requestParams) /*string storeId = requestParams.Property("storeId", true); * string checkBatch = requestParams.Property("checkBatch", true); * string userCode = requestParams.Property("userCode", true); * string barcodes = requestParams.Property("barcodes", true); * var barnums = new Dictionary<string, decimal>(); * if (!string.IsNullOrWhiteSpace(barcodes)) * { * var bars = JArray.Parse(barcodes); * for (var i = 0; i < bars.Count; i++) * { * var barjson = JObject.Parse(bars[i].ToString()); * var barc = barjson.Property("barcode", true); * var num = barjson.Property("num", true); * if (string.IsNullOrWhiteSpace(barc) || string.IsNullOrWhiteSpace(num)) * continue; * barnums[barc] = Convert.ToDecimal(num); * } * }*/ if (string.IsNullOrWhiteSpace(data)) { throw new MessageException("参数不能为空!"); } var requestParams = data.ToObject <SaveTakeStockRequest>(); if (requestParams == null) { throw new MessageException("JSON参数不正确!"); } TakeStockService.SaveStock(requestParams.StoreId, requestParams.CheckBatch, requestParams.UserCode, requestParams.TakeStockList.ToDictionary(o => o.Barcode, o => o.Number)); }
public object GetTakestockByinputBarcode([FromBody] JObject requestParams) { string storeId = requestParams.Property("storeId", true); string checkBatch = requestParams.Property("checkBatch", true); string barcode = requestParams.Property("barcode", true); return(TakeStockService.GetTakestockByinputBarcode(storeId, checkBatch, barcode)); }
public object GetTakestockList([FromBody] TakeStockRequest requestParams) { if (requestParams.BaseList == null) { throw new MessageException("BaseList为空!"); } return(TakeStockService.GetTakestockList(requestParams.StoreId, requestParams.CheckBatch, requestParams.Barcode, requestParams.UserCode, "3", requestParams.BaseList.PageIndex, requestParams.BaseList.PageSize, requestParams.Sure)); }
public PageResult <object> GetTakestockUnList([FromBody] TakeStockRequest requestParams) { if (requestParams.BaseList == null) { throw new MessageException("BaseList为空!"); } return(TakeStockService.GetTakestockList(requestParams.StoreId, requestParams.CheckBatch, requestParams.Barcode, "", "2", requestParams.BaseList.PageIndex, requestParams.BaseList.PageSize, "")); }
public ActionResult FindPageList() { int count = 0; var footer = new object(); var list = TakeStockService.FindPageList(Request.Params, out count, ref footer); //var l = list.FirstOrDefault(o => o.CheckBatch == "2_0722_1"); return(ToDataGrid(list, count, footer)); }
public ActionResult SetSure(string ids, short sure) { var idls = ids.Split(',').Select(o => int.Parse(o)).ToList(); var list = TakeStockService.FindList(o => idls.Contains(o.Id)); list.Each(o => o.Sure = sure); var op = TakeStockService.Update(list); return(new JsonNetResult(op)); }
public ActionResult Save(TreasuryLocks obj, short state, short hasrepeat) { var op = TakeStockService.SaveOrUpdate(obj, Request["Updated"], Request["Inserted"], Request["Deleted"], Request["ActualDate"], state, hasrepeat); if (op.Successed) { TakeStockService.RemoveCache(obj.CheckBatch); } return(Content(op.ToJson())); }
public ActionResult FindApprovalList(string storeId, string checkBatch) { int count = 0; object list = null, footer = null; if (!storeId.IsNullOrEmpty() && !checkBatch.IsNullOrEmpty()) { list = TakeStockService.FindPageList(Request.Params, out count, ref footer); } return(ToDataGrid(list, count, footer)); }
public ActionResult FindStockLogList(string checkBatch, string checkUID, string state) { int count = 0; var list = TakeStockService.FindStockLogList(checkBatch, checkUID, state); var footer = new List <object>() { new { Number = 0, SubUnit = "小计:" } }; return(ToDataGrid(list, count, footer)); }
public ActionResult ReSave(int id) { var obj = TakeStockService.GetObjByid(id); string storeId = Convert.ToString(obj.GetPropertyValue("LockStoreID")); var users = ListToSelect(_userBLL.GetStoreUser(storeId, null, 0).Select(o => new SelectListItem() { Value = o.UID, Text = o.FullName }), emptyTitle: "请选择"); ViewBag.users = users; return(View(obj)); }
public ActionResult ReportList(string storeId, string checkBatch) { int count = 0; DataTable dt = null; object footer = null; if (!storeId.IsNullOrEmpty() && !checkBatch.IsNullOrEmpty()) { dt = TakeStockService.ReportList(Request.Params, out count, ref footer); } return(ToDataGrid(dt, count, footer)); }
public void ReSaveStock(string data, int cid) { //[FromBody]SaveTakeStockRequest requestParams if (string.IsNullOrWhiteSpace(data)) { throw new MessageException("参数不能为空!"); } var requestParams = data.ToObject <SaveTakeStockRequest>(); if (requestParams == null) { throw new MessageException("JSON参数不正确!"); } string barcode = ""; decimal?number = null; if (requestParams.TakeStockList.Any()) { barcode = requestParams.TakeStockList[0].Barcode; number = requestParams.TakeStockList[0].Number; } TakeStockService.ReSaveStock(requestParams.StoreId, requestParams.CheckBatch, requestParams.UserCode, barcode, number, requestParams.Sure); }
public ActionResult ReBatchSelect(string storeId, string batchNo) { var list = TakeStockService.FindBarcodesByBatch(batchNo, 1); return(Json(list)); }
public object GetStoreBatchnoList([FromBody] BaseApiParams requestParams) { //string storeId = requestParams.Property("storeId", true); return(TakeStockService.GetStoreBatchnoList(requestParams.StoreId)); }
public object GetCheckerListByBatchno([FromBody] TakeStockBatchRequest requestParams) { //string storeId = requestParams.Property("storeId", true); return(TakeStockService.GetCheckerByBatchnoList(requestParams.CheckBatch)); }
public ActionResult ReSave(StockTaking stock) { var op = TakeStockService.ReSave(stock); return(Content(op.ToJson())); }
public ActionResult TakeStockLogs(string checkBatch, string barcode) { var list = TakeStockService.TakeStockLogs(checkBatch, barcode); return(ToDataGrid(list, list.Count())); }
public void AutoBalance() { TakeStockService.AutoInventoryBalance(); }
public void PostCache(string rows, string checkBatch) { TakeStockService.PostCache(rows, checkBatch); }
public ActionResult GetProductInput(string searchName, string checkBatch, string storeId, short?state) { var list = TakeStockService.GetProductInput(searchName, checkBatch, storeId, state); return(ToDataGrid(list, 0)); }
public ActionResult CrrectSave(int id) { var obj = TakeStockService.GetObjByid(id); return(View(obj)); }
public ActionResult CrrectSave(int id, decimal correctNumber) { var op = TakeStockService.CrrectSave(id, correctNumber); return(Content(op.ToJson())); }
public ActionResult Import(TreasuryLocks obj, char codeCol, char countCol, int?minRow, int?maxRow, string checkUID) { var re = TakeStockService.Import(obj, Request.Files, codeCol, countCol, minRow.GetValueOrDefault(), maxRow.GetValueOrDefault(), checkUID); return(Content(re.ToJson())); }
public ActionResult ApprovalPass(string checkBatch) { var op = TakeStockService.ApprovalPass(checkBatch); return(new JsonNetResult(op)); }
public ActionResult GetBatchAndCategory(string storeId) { var no = TakeStockService.GetBatchAndCategory(storeId); return(Content(no)); }