富尔达Api
blame | 历史 | 补丁 | 提交 | 提交对比 | 忽略空白
yl
2022-10-15 d9bbbbc58972514a003ba372f9ff10ca88def338 
 VueWebApi/DLL/DAL/ProductionManagementDAL.cs


@@ -477,7 +477,7 @@


        #endregion




        #region[MES工单新增、编辑提交]


        public static ToMessage AddUpdateMesOrder(string mesorderstus, string sourceorder, string ordertype, string mesordercode, string partcode, string mesqty, string routecode, string wkshopcode, string planstartdate, string planenddate, string orderlev, string username, string opertype,string is_aps)


        public static ToMessage AddUpdateMesOrder(string mesorderstus, string sourceorder, string ordertype, string mesordercode, string partcode, string mesqty, string routecode, string wkshopcode, string planstartdate, string planenddate, string orderlev, string username, string opertype)


        {


            var sql = "";


            var dynamicParams = new DynamicParameters();


@@ -534,12 +534,12 @@


                            CreateDate = DateTime.Now.ToString()


                        }


                    });


                    if (is_aps == "Y")  //是否排程


                    {


                        //string sql1 = "select id from TBom_Main  where materiel_code='" + PartNumber + "' and status='Y' and version='" + VsionId + "'";


                        //DataTable dt1 = DBHelper.GetTable(sql1);


                    }


                    


                    //if (is_aps == "Y")  //是否排程


                    //{


                    //    string sql1 = "select id from TBom_Main  where materiel_code='" + PartNumber + "' and status='Y' and version='" + VsionId + "'";


                    //    DataTable dt1 = DBHelper.GetTable(sql1);


                    //}




                    //增加工单用料表（子件）  




                    bool aa = DapperHelper.DoTransaction(list);


@@ -2623,14 +2623,14 @@


            {


                if (type == "Add")


                {


                    var sql = @"insert into TWkm_capac_plan(wkshop, eqp_typecode, wkshift_code, enable, lm_user, lm_time,classtype) 


                            values(@wkshop,@eqp_typecode,@wkshift_code,@enable,@lm_user,@lm_time,@classtype)";


                    var sql = @"insert into TWkm_capac_plan(wkshop, eqp_typecode, wkshift_code, enable, lm_user, lm_date,classtype) 


                            values(@wkshop,@eqp_typecode,@wkshift_code,@enable,@lm_user,@lm_date,@classtype)";


                    dynamicParams.Add("@wkshop", wkshopcode);


                    dynamicParams.Add("@eqp_typecode", capunitcode);


                    dynamicParams.Add("@wkshift_code", capsetupcode);


                    dynamicParams.Add("@enable", "Y");


                    dynamicParams.Add("@lm_user", username);


                    dynamicParams.Add("@lm_time", DateTime.Now.ToString());


                    dynamicParams.Add("@lm_date", DateTime.Now.ToString());


                    dynamicParams.Add("@classtype", captplantype);


                    int cont = DapperHelper.SQL(sql, dynamicParams);


                    if (cont > 0)


@@ -2694,10 +2694,10 @@


                sql = @"select CONVERT(varchar(100), wkdate, 23) DataTime,wkshift_code   from TWkm_capac_plan_sub where m_id=@captplanid";


                dynamicParams.Add("@captplanid", captplanid);


                var data = DapperHelper.selectdata(sql, dynamicParams);


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


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


                {


                    string DataTime = dt.Rows[i]["DataTime"].ToString();//日期


                    string key = dt.Rows[i]["wkshift_code"].ToString(); //方案编码


                    string DataTime = data.Rows[i]["DataTime"].ToString();//日期


                    string key = data.Rows[i]["wkshift_code"].ToString(); //方案编码


                    CapaPlan cmp = new CapaPlan();


                    cmp.name = DataTime;


                    cmp.key = key;


@@ -2735,11 +2735,11 @@


                dynamicParams.Add("@captplanid", captplanid);


                dynamicParams.Add("@datetime", datetime);


                var data = DapperHelper.selectdata(sql, dynamicParams);


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


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


                {


                    string code = dt.Rows[i]["code"].ToString();//方案编码


                    string name = dt.Rows[i]["name"].ToString();//方案名称


                    string flag = dt.Rows[i]["flag"].ToString();   //选中方案标识


                    string code = data.Rows[i]["code"].ToString();//方案编码


                    string name = data.Rows[i]["name"].ToString();//方案名称


                    string flag = data.Rows[i]["flag"].ToString();   //选中方案标识


                    CapacityPlanSect cmp = new CapacityPlanSect();


                    cmp.CapCode = code;


                    cmp.CapName = name;


@@ -2748,7 +2748,7 @@




                    string sql1 = @"select wktme1_start,wktme2_start,wktme3_start,wktme4_start,wktme5_start  from TBas_wkshift_info where code=@code";


                    dynamicParams.Add("@code", code);


                    var db = DapperHelper.selectdata(sql, dynamicParams);


                    var db = DapperHelper.selectdata(sql1, dynamicParams);




                    for (int j = 0; j < db.Columns.Count; j++) //时间段


                    {