MES研发
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
王 垚
2021-03-21 e2b0f85331c972a77ed6e0e179d736c4c6eb1abc 
 src/BLL/Demo.BillView/PRD/Pro_ScDayImport.cs


@@ -17,6 +17,7 @@


using System.Linq;


using ZD.Share.Common;


using ZD.Cloud.WebApi;


using Demo.Utility;




namespace Demo.BillView.PRD


{


@@ -80,8 +81,13 @@


            {


                if (!string.IsNullOrEmpty(fileFullPath))


                {


                    DataSet ds = helper.ReadFromFile(fileFullPath, 1);


                    NpoiHelper np = new NpoiHelper();


                    DataSet ds = np.ReadExcel(fileFullPath, 1);


                    DataTable dt = ds.Tables[0];


                    RemoveEmpty(dt);//去除空行


                    dt.Rows.RemoveAt(0);//去除标题行


                    //DataSet ds = helper.ReadFromFile(fileFullPath, 1);


                    //DataTable dt = ds.Tables[0];


                    LogHelper.Info("导入功能：dt行数：" + dt.Rows.Count);


                    DateTime date = Convert.ToDateTime(this.Model.GetValue("F_Paez_Date"));


                    if (dt.Rows.Count > 0)


@@ -157,7 +163,7 @@


                            this.Model.SetValue("FBatch", dt.Rows[i][9].ToString(), i);


                            this.Model.SetValue("FSalOrderCount", dt.Rows[i][10].ToString(), i);


                            this.Model.SetValue("FCompleteSetCount", dt.Rows[i][12].ToString(), i);


                            this.Model.SetValue("FDeliveryDate", ToDateTimeValue(dt.Rows[i][13].ToString()), i);


                            this.Model.SetValue("FDeliveryDate", dt.Rows[i][13].ToString(), i);


                            this.Model.SetValue("FOrderLevel", OrderType(dt.Rows[i][14].ToString()), i);


                            this.Model.SetValue("FOrderQuantity", FQTY, i);


                            this.Model.SetValue("FDayPlanID", fDayPlanID, i);//日计划工单ID


@@ -295,6 +301,8 @@


                    string FQTY = "";//FQTY 生产订单数量


                    string FBILLNO = "";//FBILLNO 原单号 


                    string FHUnitID = "";//单位


                    string FPlanBeginDate = "";//开始日期


                    string FPlanEndDate = "";//结束日期


                    if (dt.Rows.Count > 0)


                    {


                        FID = dt.Rows[0]["FID"].ToString();


@@ -303,6 +311,8 @@


                        FQTY = dt.Rows[0]["FQTY"].ToString();


                        FBILLNO = dt.Rows[0]["FBILLNO"].ToString();


                        FHUnitID = dt.Rows[0]["FUnitNumber"].ToString();


                        FPlanBeginDate = dt.Rows[0]["FPlanStartDate"].ToString();


                        FPlanEndDate = dt.Rows[0]["FPlanFinishDate"].ToString();


                    }


                    JObject jsonRoot = new JObject();


                    jsonRoot.Add("Creator", "");


@@ -320,6 +330,9 @@


                    jsonModel.Add("FHOrderQty", Convert.ToString(current["FSalOrderCount"]));//销售订单数量


                    jsonModel.Add("FHOrderCommitDate", Convert.ToString(current["FDeliveryDate"]));//交货期HOrderCommitDate


                    jsonModel.Add("FHUnitID", new JObject() { ["Fnumber"] = FHUnitID });//单位




                    jsonModel.Add("FHPlanBeginDate",FPlanBeginDate);//计划开始日期


                    jsonModel.Add("FHPlanEndDate", FPlanEndDate);//计划完工日期




                    //jsonModel.Add("FBatch", current["FBatch"].ToString());//批次


                    jsonModel.Add("FBatch", FLOT);//批次


@@ -374,7 +387,7 @@


                            Entry.Add(jsonFPOOrderEntry);


                        }


                        jsonModel.Add("FEntity", Entry);


                        jsonModel.Add("FID", Convert.ToString(current["FDayPlanID"])); ;//源单编号


                        jsonModel.Add("FID", Convert.ToString(current["FDayPlanID"]));


                        jsonRoot.Add("Model", jsonModel);


                        var result = cloudClient.Save("Paez_Sc_WorkBillAutoSortBill", jsonRoot.ToString());


                        JObject saveObj = JObject.Parse(result);


@@ -512,6 +525,8 @@


                    string FQTY = "";//FQTY 生产订单数量


                    string FBILLNO = "";//FBILLNO 原单号 


                    string FHUnitID = "";//单位


                    string FPlanBeginDate = "";//开始日期


                    string FPlanEndDate = "";//结束日期


                    if (dt.Rows.Count > 0)


                    {


                        FID = dt.Rows[0]["FID"].ToString();


@@ -520,6 +535,8 @@


                        FQTY = dt.Rows[0]["FQTY"].ToString();


                        FBILLNO = dt.Rows[0]["FBILLNO"].ToString();


                        FHUnitID = dt.Rows[0]["FUnitNumber"].ToString();


                        FPlanBeginDate = dt.Rows[0]["FPlanStartDate"].ToString();


                        FPlanEndDate = dt.Rows[0]["FPlanFinishDate"].ToString();


                    }


                    JObject jsonRoot = new JObject();


                    jsonRoot.Add("Creator", "");


@@ -537,7 +554,8 @@


                    jsonModel.Add("FHOrderQty", Convert.ToString(current["FSalOrderCount"]));//销售订单数量


                    jsonModel.Add("FHOrderCommitDate", Convert.ToString(current["FDeliveryDate"]));//交货期HOrderCommitDate


                    jsonModel.Add("FHUnitID", new JObject() { ["Fnumber"] = FHUnitID });//单位




                    jsonModel.Add("FHPlanBeginDate", FPlanBeginDate);//计划开始日期


                    jsonModel.Add("FHPlanEndDate", FPlanEndDate);//计划完工日期


                    //jsonModel.Add("FBatch", current["FBatch"].ToString());//批次


                    jsonModel.Add("FBatch", FLOT);//批次


                    jsonModel.Add("FHOrderNeedQty", FQTY);// 订单需求数量


@@ -598,5 +616,33 @@


                LogHelper.Error("生产日计划导入记录日志跳出:" + ex.Message.ToString());


            }


        }




        /// <summary>


        /// dt去空行


        /// </summary>


        /// <param name="dt"></param>


        public void RemoveEmpty(DataTable dt)


        {


            List<DataRow> removelist = new List<DataRow>();


            for (int i = 0; i < dt.Rows.Count; i++)


            {


                bool IsNull = true;


                for (int j = 0; j < dt.Columns.Count; j++)


                {


                    if (!string.IsNullOrEmpty(dt.Rows[i][j].ToString().Trim()))


                    {


                        IsNull = false;


                    }


                }


                if (IsNull)


                {


                    removelist.Add(dt.Rows[i]);


                }


            }


            for (int i = 0; i < removelist.Count; i++)


            {


                dt.Rows.Remove(removelist[i]);


            }


        }


    }


}