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);
}
