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 CheckInfo SelectByID(int checkID)
{
CheckDataProvider objCon = new CheckDataProvider();
CheckInfo objCheckInfo = objCon.SelectByID(checkID);
return(objCheckInfo);
}
public List <CheckInfo> CheckGetAll()
{
CheckDataProvider objCon = new CheckDataProvider();
List <CheckInfo> lstCheckInfo = objCon.CheckGetAll();
return(lstCheckInfo);
}
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 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 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 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 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 void CheckDelete(int checkID)
{
CheckDataProvider objCon = new CheckDataProvider();
objCon.CheckDelete(checkID);
}
public void CheckUpdate(CheckInfo checkInfo)
{
CheckDataProvider objCon = new CheckDataProvider();
objCon.CheckUpdate(checkInfo);
}
