public ActionResult AddCheckData() { string OrderNum = WebUtil.GetFormValue<string>("OrderNum",string.Empty); string LocalNum = WebUtil.GetFormValue<string>("LocalNum", string.Empty); string LocalName = WebUtil.GetFormValue<string>("LocalName", string.Empty); string ProductNum = WebUtil.GetFormValue<string>("ProductNum", string.Empty); string BarCode = WebUtil.GetFormValue<string>("BarCode", string.Empty); string ProductName = WebUtil.GetFormValue<string>("ProductName", string.Empty); string BatchNum = WebUtil.GetFormValue<string>("BatchNum", string.Empty); double FirstQty = WebUtil.GetFormValue<double>("FirstQty", 0); string StorageNum = this.DefaultStore; string FirstUser = this.LoginUser.UserCode; CheckDataEntity entity = new CheckDataEntity(); entity.OrderNum = OrderNum; entity.LocalNum = LocalNum; entity.LocalName = LocalName; entity.StorageNum = StorageNum; entity.ProductNum = ProductNum; entity.ProductName = ProductName; entity.BarCode = BarCode; entity.BatchNum = BatchNum; entity.LocalQty = 0; entity.FirstQty = FirstQty; entity.SecondQty = 0; entity.DifQty = 0; entity.FirstUser = FirstUser; entity.SecondUser = ""; entity.CreateTime = DateTime.Now; CheckDataProvider provider = new CheckDataProvider(); int line = provider.AddCheckData(entity); if (line > 0) { this.ReturnJson.AddProperty("Key", "1000"); } return Content(this.ReturnJson.ToString()); }
public ActionResult CheckData() { CheckDataEntity entity = new CheckDataEntity(); string OrderNum = WebUtil.GetFormValue<string>("OrderNum", string.Empty); string LocalNum = WebUtil.GetFormValue<string>("LocalNum", string.Empty); string ProductNum = WebUtil.GetFormValue<string>("ProductNum", string.Empty); string BarCode = WebUtil.GetFormValue<string>("BarCode", string.Empty); string BatchNum = WebUtil.GetFormValue<string>("BatchNum", string.Empty); string StorageNum = ResourceManager.GetSettingEntity("STORE_DEFAULT_PRODUCT").Value; string LocalName = WebUtil.GetFormValue<string>("LocalName", string.Empty); double Qty = WebUtil.GetFormValue<double>("Qty", 0); int ID = WebUtil.GetFormValue<int>("ID",0); entity.ID = ID; entity.OrderNum = OrderNum; entity.LocalNum = LocalNum; entity.LocalName = LocalName; entity.ProductNum = ProductNum; entity.BarCode = BarCode; entity.StorageNum = StorageNum; entity.FirstQty = Qty; entity.BatchNum = BatchNum; CheckDataProvider provider = new CheckDataProvider(); int line = provider.UpdateCheckInfoNum(entity); if (line > 0) { this.ReturnJson.AddProperty("Key", "1000"); this.ReturnJson.AddProperty("Value", "盘点单创建成功"); } return Content(this.ReturnJson.ToString()); }
public ActionResult ToCheckExcel() { string orderNum = WebUtil.GetFormValue<string>("OrderNum", string.Empty); List<CheckDataEntity> listResult = new CheckDataProvider().GetCheckOrder(orderNum); if (!listResult.IsNullOrEmpty()) { DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("库位名称")); dt.Columns.Add(new DataColumn("库位编号")); dt.Columns.Add(new DataColumn("产品编码")); dt.Columns.Add(new DataColumn("产品条码")); dt.Columns.Add(new DataColumn("产品名称")); dt.Columns.Add(new DataColumn("批次")); dt.Columns.Add(new DataColumn("盘点数")); foreach (CheckDataEntity t in listResult) { DataRow row = dt.NewRow(); row[0] = t.LocalName; row[1] = t.LocalNum; row[2] = t.ProductNum; row[3] = t.BarCode; row[4] = t.ProductName; row[5] = t.BatchNum; row[6] = ""; dt.Rows.Add(row); } string filePath = Server.MapPath("~/UploadFiles/"); if (!System.IO.Directory.Exists(filePath)) { System.IO.Directory.CreateDirectory(filePath); } string filename = string.Format("盘点管理{0}.xls", DateTime.Now.ToString("yyyyMMddHHmmss")); NPOIExcel excel = new NPOIExcel("盘点管理", "盘点单", System.IO.Path.Combine(filePath, filename)); excel.ToExcel(dt); this.ReturnJson.AddProperty("Path", ("/UploadFiles/" + filename).Escape()); } else { this.ReturnJson.AddProperty("d", "无数据导出!"); } return Content(this.ReturnJson.ToString()); }
public ActionResult GetCheckDif() { string OrderNum = WebUtil.GetFormValue<string>("OrderNum", string.Empty); int pageIndex = WebUtil.GetFormValue<int>("PageIndex", 1); int pageSize = WebUtil.GetFormValue<int>("PageSize", 10); PageInfo pageInfo = new PageInfo() { PageIndex = pageIndex, PageSize = pageSize }; CheckDataProvider provider = new CheckDataProvider(); List<CheckDataEntity> listResult = provider.GetCheckDifList(OrderNum, ref pageInfo); listResult = listResult == null ? new List<CheckDataEntity>() : listResult; System.Threading.Tasks.Parallel.ForEach(listResult, item => { item.LocalQty = ConvertHelper.ToType<double>(item.LocalQty.ToString()); item.FirstQty = ConvertHelper.ToType<double>(item.FirstQty.ToString()); item.DifQty = ConvertHelper.ToType<double>((item.FirstQty - item.LocalQty).ToString()); item.LocalName = LocalHelper.GetLocalNumList(this.DefaultStore,item.LocalNum); }); string json = ConvertJson.ListToJson<CheckDataEntity>(listResult, "List"); this.ReturnJson.AddProperty("Data", json); this.ReturnJson.AddProperty("RowCount", pageInfo.PageCount); return Content(this.ReturnJson.ToString()); }
public ActionResult DeleteCheckData() { int id = WebUtil.GetFormValue<int>("id",0); CheckDataEntity entity = new CheckDataEntity(); entity.Where(a => a.ID == id); CheckDataProvider provider = new CheckDataProvider(); int line = provider.DeleteCheckData(entity); if (line > 0) { this.ReturnJson.AddProperty("Key", "1000"); } return Content(this.ReturnJson.ToString()); }
public ActionResult Complete() { string OrderNum = WebUtil.GetFormValue<string>("OrderNum", string.Empty); CheckStockEntity entity = new CheckStockEntity(); entity.IsComplete = (int)EBool.Yes; entity.OrderNum = OrderNum; CheckDataProvider provider = new CheckDataProvider(); int line = provider.CompleteCheck(entity); if (line > 0) { if (line > 0) { this.ReturnJson.AddProperty("Key", "1000"); this.ReturnJson.AddProperty("Value", "操作完成"); } } return Content(this.ReturnJson.ToString()); }
public ActionResult CheckData() { string Url = WebUtil.GetFormValue<string>("Url", string.Empty); string OrderNum = WebUtil.GetFormValue<string>("OrderNum", string.Empty); DataSet dataset = ExcelHelper.LoadDataFromExcel(Server.MapPath(Url), "盘点管理$"); if (dataset != null && dataset.Tables.Count > 0) { DataTable table = dataset.Tables[0]; int index = 0; int line = 0; foreach (DataRow row in table.Rows) { if (index > 0) { CheckDataEntity entity = new CheckDataEntity(); string LocalNum = row[1].ToString(); string ProductNum = row[2].ToString(); string BarCode = row[3].ToString(); string StorageNum = this.DefaultStore; string BatchNum = row[5].ToString(); double Qty = ConvertHelper.ToType<double>(row[6].ToString(), 0); entity.OrderNum = OrderNum; entity.LocalNum = LocalNum; entity.ProductNum = ProductNum; entity.BarCode = BarCode; entity.StorageNum = StorageNum; entity.FirstQty = Qty; entity.BatchNum = BatchNum; CheckDataProvider provider = new CheckDataProvider(); line += provider.UpdateCheckInfoNum(entity); } index++; } if (line > 0) { this.ReturnJson.AddProperty("Key","1000"); this.ReturnJson.AddProperty("Value", "提交数据成功"); } } return Content(this.ReturnJson.ToString()); }