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 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())); }
public static CheckData_CE ToCE(CheckDataEntity item) { CheckData_CE target = new CheckData_CE(); target.ID = item.ID; target.OrderNum = item.OrderNum; target.LocalNum = item.LocalNum; target.LocalName = item.LocalName; target.StorageNum = item.StorageNum; target.ProductNum = item.ProductNum; target.BarCode = item.BarCode; target.ProductName = item.ProductName; target.LocalQty = item.LocalQty; target.FirstQty = item.FirstQty; target.SecondQty = item.SecondQty; target.DifQty = item.DifQty; target.FirstUser = item.FirstUser; target.SecondUser = item.SecondUser; target.CreateTime = item.CreateTime; return(target); }
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())); }
/// <summary> /// 编辑入库单 /// </summary> /// <param name="entity"></param> /// <param name="list"></param> /// <returns></returns> public override string EditOrder(CheckStockEntity entity, List <CheckStockInfoEntity> list) { int line = 0; using (TransactionScope ts = new TransactionScope()) { entity.Include(a => new { a.Type, a.ProductType, a.ContractOrder, a.Remark, a.CreateUser }); entity.Where(a => a.OrderNum == entity.OrderNum); CheckStockInfoEntity detail = new CheckStockInfoEntity(); detail.Where(a => a.OrderNum == entity.OrderNum); this.CheckStockInfo.Delete(detail); foreach (CheckStockInfoEntity item in list) { item.OrderNum = entity.OrderNum; item.IncludeAll(); } line = this.CheckStock.Update(entity); this.CheckStockInfo.Add(list); ts.Complete(); } CheckDataEntity checkData = new CheckDataEntity(); checkData.Where(a => a.OrderNum == entity.OrderNum); this.CheckData.Delete(checkData); //调用存储过程备份数据 生成盘点差异表 Proc_CreateCheckEntity checkEntity = new Proc_CreateCheckEntity(); checkEntity.OrderNum = entity.OrderNum; checkEntity.CreateUser = entity.CreateUser; checkEntity.CreateName = ""; line += this.Proc_CreateCheck.ExecuteNonQuery(checkEntity); return(line > 0 && checkEntity.ReturnValue == "1000" ? EnumHelper.GetEnumDesc <EReturnStatus>(EReturnStatus.Success) : string.Empty); }
/// <summary> /// 删除盘点数据 /// </summary> /// <param name="entity"></param> /// <returns></returns> public int DeleteCheckData(CheckDataEntity entity) { int line = this.CheckData.Delete(entity); return(line); }