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