/// <summary>
/// 获得盘点盘差信息
/// </summary>
/// <param name="orderNum"></param>
/// <param name="pageInfo"></param>
/// <returns></returns>
public List<CheckDataEntity> GetCheckDifList(string orderNum, ref PageInfo pageInfo)
{
CheckDataEntity entity = new CheckDataEntity();
entity.IncludeAll();
entity.Where(a => a.OrderNum == orderNum);
entity.OrderBy(a => a.ID, EOrderBy.ASC);
int rowCount = 0;
List<CheckDataEntity> listResult = this.CheckData.GetList(entity,pageInfo.PageSize,pageInfo.PageIndex,out rowCount);
pageInfo.PageCount = rowCount;
return listResult;
}
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());
}
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 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());
}
/// <summary>
/// 获取盘点单据Excel数据
/// </summary>
/// <returns></returns>
public List<CheckDataEntity> GetCheckOrder(string orderNum)
{
CheckDataEntity entity = new CheckDataEntity();
entity.IncludeAll();
entity.Where(a => a.OrderNum == orderNum);
List<CheckDataEntity> listResult = this.CheckData.GetList(entity);
return listResult;
}
/// <summary>
/// 删除盘点数据
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public int DeleteCheckData(CheckDataEntity entity)
{
int line = this.CheckData.Delete(entity);
return line;
}
/// <summary>
/// 新增盘点数据
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public int AddCheckData(CheckDataEntity entity)
{
entity.IncludeAll();
int line = this.CheckData.Add(entity);
return line;
}
/// <summary>
/// 修改盘点差异表中盘点的数据
/// </summary>
/// <returns></returns>
public int UpdateCheckInfoNum(CheckDataEntity entity)
{
entity.IncludeFirstQty(true);
entity.Where(a => a.OrderNum == entity.OrderNum)
.And(a => a.LocalNum == entity.LocalNum)
.And(a => a.StorageNum == entity.StorageNum)
.And(a => a.ProductNum == entity.ProductNum)
.And(a => a.BarCode == entity.BarCode)
.And(a=>a.BatchNum==entity.BatchNum)
;
int line = this.CheckData.Update(entity);
return line;
}