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