From 7ff74f599084561338eef1230db5aa45f74565f8 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期一, 15 四月 2024 18:03:33 +0800
Subject: [PATCH] 1.ERP订单关闭增加单据id 2.MES工单关闭增加源单id关联

---
 VueWebCoreApi/DLL/DAL/ProductionManagementDAL.cs |  807 ++++++++++++++-------------------------------------------
 1 files changed, 203 insertions(+), 604 deletions(-)

diff --git a/VueWebCoreApi/DLL/DAL/ProductionManagementDAL.cs b/VueWebCoreApi/DLL/DAL/ProductionManagementDAL.cs
index 0fcd0c3..dc28dba 100644
--- a/VueWebCoreApi/DLL/DAL/ProductionManagementDAL.cs
+++ b/VueWebCoreApi/DLL/DAL/ProductionManagementDAL.cs
@@ -34,7 +34,7 @@
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -42,408 +42,7 @@
         #endregion
 
 
-        #region[ERP璁㈠崟鏌ヨ]
-        public static ToMessage ErpOrderSearch(string stu_torgcode, string stu_torgtypecode, string erporderstus, string erpordercode, string partcode, string partname, string partspec, int startNum, string paydatestartdate, string paydateenddate, string paydatestartdate1, string paydateenddate2, string creatuser, int endNum, string prop, string order)
-        {
-            var dynamicParams = new DynamicParameters();
-            string search = "";
-            try
-            {
-                switch (stu_torgtypecode)
-                {
-                    case "":
-                        break;
-                    case "D":
-                        search += "and L.org_code=@stu_torgcode ";
-                        dynamicParams.Add("@stu_torgcode", stu_torgcode);
-                        break;
-                    case "W":
-                        search += "and C.org_code=@stu_torgcode ";
-                        dynamicParams.Add("@stu_torgcode", stu_torgcode);
-                        break;
-                    default:
-                        break;
-                }
-                if (erporderstus != "" && erporderstus != null)
-                {
-                    search += "and A.status=@erporderstus ";
-                    dynamicParams.Add("@erporderstus", erporderstus);
-                }
-                if (erpordercode != "" && erpordercode != null)
-                {
-                    search += "and A.wo like '%'+@erpordercode+'%' ";
-                    dynamicParams.Add("@erpordercode", erpordercode);
-                }
-                if (partcode != "" && partcode != null)
-                {
-                    search += "and A.materiel_code like '%'+@partcode+'%' ";
-                    dynamicParams.Add("@partcode", partcode);
-                }
-                if (partname != "" && partname != null)
-                {
-                    search += "and B.partname like '%'+@partname+'%' ";
-                    dynamicParams.Add("@partname", partname);
-                }
-                if (partspec != "" && partspec != null)
-                {
-                    search += "and B.partspec like '%'+@partspec+'%' ";
-                    dynamicParams.Add("@partspec", partspec);
-                }
-                if (paydatestartdate != "" && paydatestartdate != null)
-                {
-                    search += "and A.planstartdate between @paydatestartdate and @paydateenddate ";
-                    dynamicParams.Add("@paydatestartdate", paydatestartdate + " 00:00:00");
-                    dynamicParams.Add("@paydateenddate", paydateenddate + " 23:59:59");
-                }
-                if (paydatestartdate1 != "" && paydatestartdate1 != null)
-                {
-                    search += "and A.planenddate between @paydatestartdate1 and @paydateenddate2 ";
-                    dynamicParams.Add("@paydatestartdate1", paydatestartdate1);
-                    dynamicParams.Add("@paydateenddate2", paydateenddate2 + " 23:59:59");
-                }
-                if (creatuser != "" && creatuser != null)
-                {
-                    search += "and U.username like '%'+@creatuser+'%' ";
-                    dynamicParams.Add("@creatuser", creatuser);
-                }
-
-                if (search == "")
-                {
-                    search = "and 1=1 ";
-                }
-                // --------------鏌ヨ鎸囧畾鏁版嵁--------------
-                var total = 0; //鎬绘潯鏁�
-                var sql = @"select A.id, A.status,A.wo,A.materiel_code as partcode,B.partname,B.partspec,A.qty,A.relse_qty,A.wkshp_code,C.org_name as wkshp_name,
-                            A.stck_code,D.name as stck_name,saleOrderDeliveryDate,A.planstartdate,A.planenddate,U.username as createuser,A.createdate 
-                            from TKimp_Ewo A
-                            left join TMateriel_Info B on A.materiel_code=B.partcode
-                            left join TOrganization C on A.wkshp_code=C.org_code
-                            left join T_Sec_Stck D on A.stck_code=D.code 
-                            left join TUser U on A.createuser=U.usercode 
-                            left join TOrganization L on  C.parent_id=L.id
-                            where A.is_delete<>'1' " + search;
-                var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
-                mes.code = "200";
-                mes.Message = "鏌ヨ鎴愬姛!";
-                mes.count = total;
-                mes.data = data.ToList();
-            }
-            catch (Exception e)
-            {
-                mes.code = "300";
-                mes.count = 0;
-                mes.Message = e.Message;
-                mes.data = null;
-            }
-            return mes;
-        }
-        #endregion
-
-        #region[ERP璁㈠崟涓嬭揪]
-        public static ToMessage MarkSaveErpOrder(string erporderid, string erpordercode, string partcode, string wkshopcode, string warehousecode, string erpqty, string markqty, string ordernum, string relse_qty, string saleOrderDeliveryDate, string username)
-        {
-            var sql = "";
-            List<object> list = new List<object>();
-            var dynamicParams = new DynamicParameters();
-
-            try
-            {
-                list.Clear();
-                //鑾峰彇鎷嗗崟鏁伴噺:鍚戜笅鍙栨暣
-                decimal cdqty = Math.Floor(decimal.Parse(markqty) / decimal.Parse(ordernum));
-                //瀹氫箟绱涓嬪崟鏁伴噺
-                decimal sumqty = 0;
-                //瀹氫箟鏈�鏂扮敓鎴愮殑宸ュ崟鍙�
-                string wo = "";
-                //瀹氫箟宸ュ崟娴佹按鍙�
-                int num = 0;
-                //寰幆涓嬪崟鍗曟暟(鐢熸垚瀵瑰簲鍑犲紶MES宸ュ崟)
-                for (int i = 1; i <= Convert.ToInt32(ordernum); i++)
-                {
-                    sumqty += cdqty;
-                    //鑾峰彇鏈�澶у崟鎹彿
-                    if (i == 1)  //棣栧崟鑾峰彇宸ュ崟鍙�
-                    {
-                        sql = @"select isnull(max(cast(substring(wo_code,charindex('_',wo_code)+1,len(wo_code)-charindex('_',wo_code)) as numeric)),0)+1 as worknumb   
-                                from TK_Wrk_Man where m_po=@erpordercode";
-                        dynamicParams.Add("@erpordercode", erpordercode);
-                        var data = DapperHelper.selectdata(sql, dynamicParams);
-                        num = Convert.ToInt32(data.Rows[0]["WORKNUMB"].ToString());
-                        wo = erpordercode + "_" + num;
-                    }
-                    else
-                    {
-                        num = num + 1;
-                        wo = erpordercode + "_" + num;
-                    }
-                    if (i == Convert.ToInt32(ordernum))  //鏈�鍚庝竴鍗曟椂
-                    {
-                        sql = @"insert into TK_Wrk_Man(wo_code,wotype,status,wkshp_code,plan_qty,stck_code,materiel_code,sourceid,m_po,lm_user,lm_date,saleOrderDeliveryDate) values(@wo_code,@wotype,@status,@wkshp_code,@plan_qty,@stck_code,@materiel_code,@sourceid,@m_po,@username,@CreateDate,@saleOrderDeliveryDate)";
-                        list.Add(new
-                        {
-                            str = sql,
-                            parm = new
-                            {
-                                wo_code = wo,
-                                wotype = "PO",
-                                status = "NEW",
-                                wkshp_code = wkshopcode,
-                                plan_qty = cdqty + (decimal.Parse(markqty) - sumqty),  //鏈崟涓嬪崟鏁伴噺=鍒囧垎鏁伴噺+(涓嬪崟鏁伴噺-绱鍒囧垎涓嬪崟鏁伴噺)
-                                stck_code = warehousecode,
-                                materiel_code = partcode,
-                                sourceid = erporderid,
-                                m_po = erpordercode,
-                                username = username,
-                                CreateDate = DateTime.Now.ToString(),
-                                saleOrderDeliveryDate = Convert.ToDateTime(saleOrderDeliveryDate)
-                            }
-                        });
-                        sumqty = sumqty + (decimal.Parse(markqty) - sumqty);
-                    }
-                    else
-                    {
-
-                        sql = @"insert into TK_Wrk_Man(wo_code,wotype,status,wkshp_code,plan_qty,stck_code,materiel_code,sourceid,m_po,lm_user,lm_date,saleOrderDeliveryDate) values(@wo_code,@wotype,@status,@wkshp_code,@plan_qty,@stck_code,@materiel_code,@sourceid,@m_po,@username,@CreateDate,@saleOrderDeliveryDate)";
-                        list.Add(new
-                        {
-                            str = sql,
-                            parm = new
-                            {
-                                wo_code = wo,
-                                wotype = "PO",
-                                status = "NEW",
-                                wkshp_code = wkshopcode,
-                                plan_qty = cdqty,
-                                stck_code = warehousecode,
-                                materiel_code = partcode,
-                                sourceid = erporderid,
-                                m_po = erpordercode,
-                                username = username,
-                                CreateDate = DateTime.Now.ToString(),
-                                saleOrderDeliveryDate = Convert.ToDateTime(saleOrderDeliveryDate)
-                            }
-                        });
-                    }
-                }
-                if (decimal.Parse(erpqty) == decimal.Parse(markqty) + decimal.Parse(relse_qty))   //濡傛灉ERP璁㈠崟=涓嬪崟鏁伴噺+宸蹭笅鍗曟暟閲�,鍒欐洿鏂癊RP璁㈠崟琛ㄧ姸鎬佷负CREATED:宸插垱寤�
-                {
-                    sql = @"update  TKimp_Ewo set status='CREATED',saleOrderDeliveryDate=@saleOrderDeliveryDate,relse_qty=relse_qty+@sumqty where wo=@wo and id=@erporderid";
-                    list.Add(new
-                    {
-                        str = sql,
-                        parm = new
-                        {
-                            wo = erpordercode,
-                            erporderid = erporderid,
-                            sumqty = sumqty,
-                            saleOrderDeliveryDate = Convert.ToDateTime(saleOrderDeliveryDate)
-                        }
-                    });
-                }
-                else   //鏇存柊ERP璁㈠崟琛ㄧ姸鎬佷负CREATING:鍒涘缓涓�
-                {
-                    sql = @"update  TKimp_Ewo set status='CREATING',saleOrderDeliveryDate=@saleOrderDeliveryDate,relse_qty=relse_qty+@sumqty where wo=@wo and id=@erporderid";
-                    list.Add(new
-                    {
-                        str = sql,
-                        parm = new
-                        {
-                            wo = erpordercode,
-                            erporderid = erporderid,
-                            sumqty = sumqty,
-                            saleOrderDeliveryDate = Convert.ToDateTime(saleOrderDeliveryDate)
-                        }
-                    });
-                }
-                bool aa = DapperHelper.DoTransaction(list);
-                if (aa)
-                {
-                    mes.code = "200";
-                    mes.count = 0;
-                    mes.Message = "涓嬭揪MES宸ュ崟鎴愬姛!";
-                    mes.data = null;
-                }
-                else
-                {
-                    mes.code = "300";
-                    mes.count = 0;
-                    mes.Message = "涓嬭揪MES宸ュ崟鎴愬姛澶辫触!";
-                    mes.data = null;
-                }
-            }
-            catch (Exception e)
-            {
-                mes.code = "300";
-                mes.count = 0;
-                mes.Message = e.Message;
-                mes.data = null;
-            }
-            return mes;
-        }
-        #endregion
-
-        #region[ERP璁㈠崟鍏抽棴]
-        public static ToMessage ClosedErpOrder(string erporderid, string erpordercode, string username)
-        {
-            var sql = "";
-            List<object> list = new List<object>();
-            var dynamicParams = new DynamicParameters();
-            try
-            {
-                sql = @"select *  from TK_Wrk_Man where m_po=@erpordercode and status<> 'CLOSED'";
-                dynamicParams.Add("@erpordercode", erpordercode);
-                var data = DapperHelper.selectdata(sql, dynamicParams);
-                if (data.Rows.Count > 0)
-                {
-                    mes.code = "300";
-                    mes.count = 0;
-                    mes.Message = "褰撳墠璁㈠崟鏈変笅杈炬湭鍏抽棴鐨凪ES宸ュ崟,璁㈠崟涓嶅厑璁稿叧闂�,璇峰厛鍒犻櫎鎴栧叧闂浉鍏冲伐鍗�!";
-                    mes.data = null;
-                }
-                else
-                {
-                    //鍏抽棴璁㈠崟
-                    sql = @"update  TKimp_Ewo set status='CLOSED' where wo=@wo and id=@erporderid";
-                    list.Add(new
-                    {
-                        str = sql,
-                        parm = new
-                        {
-                            wo = erpordercode,
-                            erporderid = erporderid
-                        }
-                    });
-                }
-                bool aa = DapperHelper.DoTransaction(list);
-                if (aa)
-                {
-                    mes.code = "200";
-                    mes.count = 0;
-                    mes.Message = "璁㈠崟鍏抽棴鎴愬姛!";
-                    mes.data = null;
-                }
-                else
-                {
-                    mes.code = "300";
-                    mes.count = 0;
-                    mes.Message = "璁㈠崟鍏抽棴澶辫触!";
-                    mes.data = null;
-                }
-            }
-            catch (Exception e)
-            {
-                mes.code = "300";
-                mes.count = 0;
-                mes.Message = e.Message;
-                mes.data = null;
-            }
-            return mes;
-        }
-        #endregion
-
-
-
-        #region[MES宸ュ崟鏌ヨ]
-        public static ToMessage MesOrderSearch(string stu_torgcode, string stu_torgtypecode, string mesorderstus, string mesordercode, string sourceorder, string ordertype, string partcode, string partname, string partspec, int startNum, string creatuser, string createdate, int endNum, string prop, string order)
-        {
-            var dynamicParams = new DynamicParameters();
-            string search = "";
-            try
-            {
-                switch (stu_torgtypecode)
-                {
-                    case "":
-                        break;
-                    case "D":
-                        search += "and L.org_code=@stu_torgcode ";
-                        dynamicParams.Add("@stu_torgcode", stu_torgcode);
-                        break;
-                    case "W":
-                        search += "and C.org_code=@stu_torgcode ";
-                        dynamicParams.Add("@stu_torgcode", stu_torgcode);
-                        break;
-                    default:
-                        break;
-                }
-                if (mesorderstus != "" && mesorderstus != null)
-                {
-                    search += "and A.status=@mesorderstus ";
-                    dynamicParams.Add("@mesorderstus", mesorderstus);
-                }
-                if (mesordercode != "" && mesordercode != null)
-                {
-                    search += "and A.wo_code like '%'+@mesordercode+'%' ";
-                    dynamicParams.Add("@mesordercode", mesordercode);
-                }
-                if (sourceorder != "" && sourceorder != null)
-                {
-                    search += "and A.m_po like '%'+@sourceorder+'%' ";
-                    dynamicParams.Add("@sourceorder", sourceorder);
-                }
-                if (ordertype != "" && ordertype != null)
-                {
-                    search += "and A.wotype like '%'+@ordertype+'%' ";
-                    dynamicParams.Add("@ordertype", ordertype);
-                }
-                if (partcode != "" && partcode != null)
-                {
-                    search += "and A.materiel_code like '%'+@partcode+'%' ";
-                    dynamicParams.Add("@partcode", partcode);
-                }
-                if (partname != "" && partname != null)
-                {
-                    search += "and B.partname like '%'+@partname+'%' ";
-                    dynamicParams.Add("@partname", partname);
-                }
-                if (partspec != "" && partspec != null)
-                {
-                    search += "and B.partspec like '%'+@partspec+'%' ";
-                    dynamicParams.Add("@partspec", partspec);
-                }
-                if (createdate != "" && createdate != null)
-                {
-                    search += "and CONVERT(varchar(100),A.lm_date,23)=@createdate ";
-                    dynamicParams.Add("@createdate", createdate);
-                }
-                if (creatuser != "" && creatuser != null)
-                {
-                    search += "and U.username like '%'+@creatuser+'%' ";
-                    dynamicParams.Add("@creatuser", creatuser);
-                }
-
-                if (search == "")
-                {
-                    search = "and 1=1 ";
-                }
-                // --------------鏌ヨ鎸囧畾鏁版嵁--------------
-                var total = 0; //鎬绘潯鏁�
-                var sql = @"select A.id, A.status,A.wotype,A.wo_code,A.materiel_code as partcode,B.partname,B.partspec,A.plan_qty,A.wkshp_code,C.org_name as wkshp_name,
-                            A.route_code,E.name as route_name,A.stck_code,F.name as stck_name,A.plan_startdate,A.plan_enddate,A.piroque,A.sourceid,A.m_po,U.username as lm_user,A.lm_date
-                            from TK_Wrk_Man A
-                            left join TMateriel_Info B on A.materiel_code=B.partcode
-                            left join TOrganization C on A.wkshp_code=C.org_code
-                            left join T_Sec_Stck D on A.stck_code=D.code 
-                            left join TFlw_Rout E on A.route_code=E.code
-                            left join T_Sec_Stck F on A.stck_code=F.code 
-                            left join TUser U on A.lm_user=U.usercode 
-                            left join TOrganization L on  C.parent_id=L.id
-                            where A.is_delete<>'1' " + search;
-                var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
-                mes.code = "200";
-                mes.Message = "鏌ヨ鎴愬姛!";
-                mes.count = total;
-                mes.data = data.ToList();
-            }
-            catch (Exception e)
-            {
-                mes.code = "300";
-                mes.count = 0;
-                mes.Message = e.Message;
-                mes.data = null;
-            }
-            return mes;
-        }
-        #endregion
+        
 
         #region[MES鎶ュ簾琛ュ崟宸ュ崟鏌ヨ]
         public static ToMessage MesBadOrderSearch(string mesordercode, string sourceorder, string partcode, string partname, string partspec, int startNum, string creatuser, string createdate, int endNum, string prop, string order)
@@ -507,7 +106,7 @@
                             where A.is_delete<>'1'  and A.status='START' and A.wotype='PO' and S.bad_qty>0 " + search;
                 var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
                 mes.code = "200";
-                mes.Message = "鏌ヨ鎴愬姛!";
+                mes.message = "鏌ヨ鎴愬姛!";
                 mes.count = total;
                 mes.data = data.ToList();
             }
@@ -515,7 +114,7 @@
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -538,14 +137,14 @@
                 dynamicParams.Add("@torg_code", wkshopcode);
                 var data = DapperHelper.selectdata(sql, dynamicParams);
                 mes.code = "200";
-                mes.Message = "鏌ヨ鎴愬姛!";
+                mes.message = "鏌ヨ鎴愬姛!";
                 mes.data = data;
             }
             catch (Exception e)
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -587,14 +186,14 @@
                 dynamicParams.Add("@partcode", partcode);
                 var data = DapperHelper.selectdata(sql, dynamicParams);
                 mes.code = "200";
-                mes.Message = "鏌ヨ鎴愬姛!";
+                mes.message = "鏌ヨ鎴愬姛!";
                 mes.data = data;
             }
             catch (Exception e)
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -615,14 +214,14 @@
                 dynamicParams.Add("@partcode", routecode);
                 var data = DapperHelper.selectdata(sql, dynamicParams);
                 mes.code = "200";
-                mes.Message = "鏌ヨ鎴愬姛!";
+                mes.message = "鏌ヨ鎴愬姛!";
                 mes.data = data;
             }
             catch (Exception e)
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -640,14 +239,14 @@
                 dynamicParams.Add("@partnumber", partnumber);
                 var data = DapperHelper.selectdata(sql, dynamicParams);
                 mes.code = "200";
-                mes.Message = "鏌ヨ鎴愬姛!";
+                mes.message = "鏌ヨ鎴愬姛!";
                 mes.data = data;
             }
             catch (Exception e)
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -662,7 +261,7 @@
             try
             {
                 mes.code = "200";
-                mes.Message = "";
+                mes.message = "";
                 mes.data = null;
                 //鍒ゆ柇宸ヨ壓璺嚎瀵瑰簲宸ュ簭鏄惁閮芥湁鍏宠仈宸ヤ綔绔�
                 sql = @"select B.step_code,C.eqp_code from TFlw_Rout A
@@ -678,7 +277,7 @@
                     {
                         mes.code = "300";
                         mes.count = 0;
-                        mes.Message = "褰撳墠宸ヨ壓璺嚎瀵瑰簲宸ュ簭銆�" + dtck.Rows[i]["step_code"].ToString() + "銆戯紝鏈叧鑱旇澶囷紝璇峰叧鑱旀墍鏈夊伐搴忓搴旇澶�!";
+                        mes.message = "褰撳墠宸ヨ壓璺嚎瀵瑰簲宸ュ簭銆�" + dtck.Rows[i]["step_code"].ToString() + "銆戯紝鏈叧鑱旇澶囷紝璇峰叧鑱旀墍鏈夊伐搴忓搴旇澶�!";
                         mes.data = null;
                         return mes;
                     }
@@ -705,7 +304,7 @@
                     {
                         mes.code = "300";
                         mes.count = 0;
-                        mes.Message = "褰撳墠宸ヨ壓璺嚎瀵瑰簲宸ュ簭銆�" + dtck.Rows[i]["step_code"].ToString() + "銆戯紝璁惧涓嶅彲鐢�!";
+                        mes.message = "褰撳墠宸ヨ壓璺嚎瀵瑰簲宸ュ簭銆�" + dtck.Rows[i]["step_code"].ToString() + "銆戯紝璁惧涓嶅彲鐢�!";
                         mes.data = null;
                         return mes;
                     }
@@ -732,7 +331,7 @@
                         {
                             mes.code = "300";
                             mes.count = 0;
-                            mes.Message = "鑺傛媿宸ヤ环涓細褰撳墠浜у搧銆�" + partcode + "銆戯紝瀵瑰簲宸ヨ壓璺嚎銆�" + routecode + "銆戞湭璁剧疆(鎴栨湭璁剧疆鍏�)鎴栧伐浠峰皬浜庣瓑浜�0!";
+                            mes.message = "鑺傛媿宸ヤ环涓細褰撳墠浜у搧銆�" + partcode + "銆戯紝瀵瑰簲宸ヨ壓璺嚎銆�" + routecode + "銆戞湭璁剧疆(鎴栨湭璁剧疆鍏�)鎴栧伐浠峰皬浜庣瓑浜�0!";
                             mes.data = null;
                             return mes;
                         }
@@ -743,7 +342,7 @@
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -763,14 +362,14 @@
                         FROM TK_Wrk_Man where wo_code like '%SGPO%'";
                 var data = DapperHelper.selecttable(sql);
                 mes.code = "200";
-                mes.Message = "鏌ヨ鎴愬姛!";
+                mes.message = "鏌ヨ鎴愬姛!";
                 mes.data = data.Rows[0]["numct"].ToString();
             }
             catch (Exception e)
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -795,7 +394,7 @@
                 {
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "宸ュ崟瀵瑰簲宸ヨ壓璺嚎娌℃湁缁戝畾宸ュ簭!";
+                    mes.message = "宸ュ崟瀵瑰簲宸ヨ壓璺嚎娌℃湁缁戝畾宸ュ簭!";
                     mes.data = null;
                     return mes;
                 }
@@ -813,7 +412,7 @@
                         {
                             mes.code = "300";
                             mes.count = 0;
-                            mes.Message = "宸ュ崟瀵瑰簲鐨勪骇鍝佹病鏈夊缓绔婤OM鎴朆OM鏈鏍革紒";
+                            mes.message = "宸ュ崟瀵瑰簲鐨勪骇鍝佹病鏈夊缓绔婤OM鎴朆OM鏈鏍革紒";
                             mes.data = null;
                             return mes;
                         }
@@ -906,14 +505,14 @@
                     {
                         mes.code = "200";
                         mes.count = 0;
-                        mes.Message = "MES宸ュ崟鏂板缓娲惧彂鎴愬姛!";
+                        mes.message = "MES宸ュ崟鏂板缓娲惧彂鎴愬姛!";
                         mes.data = null;
                     }
                     else
                     {
                         mes.code = "300";
                         mes.count = 0;
-                        mes.Message = "MES宸ュ崟鏂板缓娲惧彂澶辫触!";
+                        mes.message = "MES宸ュ崟鏂板缓娲惧彂澶辫触!";
                         mes.data = null;
                     }
                 }
@@ -930,7 +529,7 @@
                         {
                             mes.code = "300";
                             mes.count = 0;
-                            mes.Message = "宸ュ崟瀵瑰簲鐨勪骇鍝佹病鏈夊缓绔婤OM鎴朆OM鏈鏍革紒";
+                            mes.message = "宸ュ崟瀵瑰簲鐨勪骇鍝佹病鏈夊缓绔婤OM鎴朆OM鏈鏍革紒";
                             mes.data = null;
                             return mes;
                         }
@@ -1026,14 +625,14 @@
                     {
                         mes.code = "200";
                         mes.count = 0;
-                        mes.Message = "淇敼鎿嶄綔鎴愬姛!";
+                        mes.message = "淇敼鎿嶄綔鎴愬姛!";
                         mes.data = null;
                     }
                     else
                     {
                         mes.code = "300";
                         mes.count = 0;
-                        mes.Message = "淇敼鎿嶄綔澶辫触!";
+                        mes.message = "淇敼鎿嶄綔澶辫触!";
                         mes.data = null;
                     }
                 }
@@ -1042,7 +641,7 @@
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -1100,7 +699,7 @@
                 {
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "宸ュ崟鎵ц涓垨宸插叧闂紝涓嶅厑璁稿垹闄�!";
+                    mes.message = "宸ュ崟鎵ц涓垨宸插叧闂紝涓嶅厑璁稿垹闄�!";
                     mes.data = null;
                 }
                 bool aa = DapperHelper.DoTransaction(list);
@@ -1108,14 +707,14 @@
                 {
                     mes.code = "200";
                     mes.count = 0;
-                    mes.Message = "鍒犻櫎鎴愬姛!";
+                    mes.message = "鍒犻櫎鎴愬姛!";
                     mes.data = null;
                 }
                 else
                 {
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "鍒犻櫎澶辫触!";
+                    mes.message = "鍒犻櫎澶辫触!";
                     mes.data = null;
                 }
             }
@@ -1123,7 +722,7 @@
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -1149,14 +748,14 @@
                 {
                     mes.code = "200";
                     mes.count = 0;
-                    mes.Message = "宸ュ崟鍏抽棴鎴愬姛!";
+                    mes.message = "宸ュ崟鍏抽棴鎴愬姛!";
                     mes.data = null;
                 }
                 else
                 {
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "宸ュ崟鍏抽棴澶辫触!";
+                    mes.message = "宸ュ崟鍏抽棴澶辫触!";
                     mes.data = null;
                 }
             }
@@ -1164,7 +763,7 @@
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -1187,14 +786,14 @@
                 dynamicParams.Add("@wo_code", wo_code);
                 var data = DapperHelper.selectdata(sql, dynamicParams);
                 mes.code = "200";
-                mes.Message = "鏌ヨ鎴愬姛!";
+                mes.message = "鏌ヨ鎴愬姛!";
                 mes.data = data;
             }
             catch (Exception e)
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -1220,7 +819,7 @@
                         ordercode = arra[0]; //鑾峰彇鎸囧畾瀛楃涓插墠闈㈢殑瀛楃
                         mes.code = "300";
                         mes.count = 0;
-                        mes.Message = "璇锋壂鎻忓伐搴忎簩缁寸爜!";
+                        mes.message = "璇锋壂鎻忓伐搴忎簩缁寸爜!";
                         mes.data = null;
                         return mes;
                     }
@@ -1242,7 +841,7 @@
                         {
                             mes.code = "300";
                             mes.count = 0;
-                            mes.Message = "褰撳墠宸ュ簭浠诲姟涓哄鍗忓伐搴忎换鍔�,璇峰墠寰�澶栧崗鎿嶄綔椤电鎵ц!";
+                            mes.message = "褰撳墠宸ュ簭浠诲姟涓哄鍗忓伐搴忎换鍔�,璇峰墠寰�澶栧崗鎿嶄綔椤电鎵ц!";
                             mes.data = null;
                             return mes;
                         }
@@ -1261,7 +860,7 @@
                 {
                     mes.code = "200";
                     mes.count = 0;
-                    mes.Message = "鏌ヨ鎴愬姛!";
+                    mes.message = "鏌ヨ鎴愬姛!";
                     mes.data = data;
                     return mes;
                 }
@@ -1269,7 +868,7 @@
                 {
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "褰撳墠宸ュ簭浠诲姟鏃犲彲鎵ц璁惧!";
+                    mes.message = "褰撳墠宸ュ簭浠诲姟鏃犲彲鎵ц璁惧!";
                     mes.data = null;
                     return mes;
                 }
@@ -1278,7 +877,7 @@
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -1303,7 +902,7 @@
                         ordercode = arra[0]; //鑾峰彇鎸囧畾瀛楃涓插墠闈㈢殑瀛楃
                         mes.code = "300";
                         mes.count = 0;
-                        mes.Message = "璇锋壂鎻忓伐搴忎簩缁寸爜!";
+                        mes.message = "璇锋壂鎻忓伐搴忎簩缁寸爜!";
                         mes.data = null;
                         return mes;
                     }
@@ -1325,7 +924,7 @@
                         {
                             mes.code = "300";
                             mes.count = 0;
-                            mes.Message = "褰撳墠宸ュ簭浠诲姟涓鸿嚜鍒跺伐搴忎换鍔�,璇峰墠寰�鑷埗鎿嶄綔椤电鎵ц!";
+                            mes.message = "褰撳墠宸ュ簭浠诲姟涓鸿嚜鍒跺伐搴忎换鍔�,璇峰墠寰�鑷埗鎿嶄綔椤电鎵ц!";
                             mes.data = null;
                             return mes;
                         }
@@ -1344,7 +943,7 @@
                 {
                     mes.code = "200";
                     mes.count = 0;
-                    mes.Message = "鏌ヨ鎴愬姛!";
+                    mes.message = "鏌ヨ鎴愬姛!";
                     mes.data = data;
                     return mes;
                 }
@@ -1352,7 +951,7 @@
                 {
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "褰撳墠宸ュ簭鏃犲彲鎵ц澶栧崗渚涙柟!";
+                    mes.message = "褰撳墠宸ュ簭鏃犲彲鎵ц澶栧崗渚涙柟!";
                     mes.data = null;
                     return mes;
                 }
@@ -1361,7 +960,7 @@
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -1387,7 +986,7 @@
                         ordercode = arra[0]; //鑾峰彇鎸囧畾瀛楃涓插墠闈㈢殑瀛楃
                         mes.code = "300";
                         mes.count = 0;
-                        mes.Message = "璇锋壂鎻忓伐搴忎簩缁寸爜!";
+                        mes.message = "璇锋壂鎻忓伐搴忎簩缁寸爜!";
                         mes.data = null;
                         return mes;
                     }
@@ -1414,7 +1013,7 @@
                 //{
                 //    mes.code = "300";
                 //    mes.count = 0;
-                //    mes.Message = "浜岀淮鐮佷俊鎭负绌�!";
+                //    mes.message = "浜岀淮鐮佷俊鎭负绌�!";
                 //    mes.data = null;
                 //    return mes;
                 //}
@@ -1430,7 +1029,7 @@
                         {
                             mes.code = "300";
                             mes.count = 0;
-                            mes.Message = "褰撳墠宸ュ簭浠诲姟涓哄鍗忓伐搴忎换鍔�,璇峰墠寰�澶栧崗鎿嶄綔椤电鎵ц!";
+                            mes.message = "褰撳墠宸ュ簭浠诲姟涓哄鍗忓伐搴忎换鍔�,璇峰墠寰�澶栧崗鎿嶄綔椤电鎵ц!";
                             mes.data = null;
                             return mes;
                         }
@@ -1466,7 +1065,7 @@
                 {
                     mes.code = "200";
                     mes.count = total;
-                    mes.Message = "鏌ヨ鎴愬姛!";
+                    mes.message = "鏌ヨ鎴愬姛!";
                     mes.data = data.ToList();
                     return mes;
                 }
@@ -1474,7 +1073,7 @@
                 {
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "鏃犲彲鎵ц鐨勭敓浜т换鍔�,浠诲姟宸插畬鎴愭垨宸插叧闂�!";
+                    mes.message = "鏃犲彲鎵ц鐨勭敓浜т换鍔�,浠诲姟宸插畬鎴愭垨宸插叧闂�!";
                     mes.data = null;
                     return mes;
                 }
@@ -1483,7 +1082,7 @@
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -1509,7 +1108,7 @@
                         ordercode = arra[0]; //鑾峰彇鎸囧畾瀛楃涓插墠闈㈢殑瀛楃
                         mes.code = "300";
                         mes.count = 0;
-                        mes.Message = "璇锋壂鎻忓伐搴忎簩缁寸爜!";
+                        mes.message = "璇锋壂鎻忓伐搴忎簩缁寸爜!";
                         mes.data = null;
                         return mes;
                     }
@@ -1535,7 +1134,7 @@
                 //{
                 //    mes.code = "300";
                 //    mes.count = 0;
-                //    mes.Message = "浜岀淮鐮佷俊鎭负绌�!";
+                //    mes.message = "浜岀淮鐮佷俊鎭负绌�!";
                 //    mes.data = null;
                 //    return mes;
                 //}
@@ -1551,7 +1150,7 @@
                         {
                             mes.code = "300";
                             mes.count = 0;
-                            mes.Message = "褰撳墠宸ュ簭浠诲姟涓鸿嚜鍒跺伐搴忎换鍔�,璇峰墠寰�鑷埗鎿嶄綔椤电鎵ц!";
+                            mes.message = "褰撳墠宸ュ簭浠诲姟涓鸿嚜鍒跺伐搴忎换鍔�,璇峰墠寰�鑷埗鎿嶄綔椤电鎵ц!";
                             mes.data = null;
                             return mes;
                         }
@@ -1587,7 +1186,7 @@
                 {
                     mes.code = "200";
                     mes.count = total;
-                    mes.Message = "鏌ヨ鎴愬姛!";
+                    mes.message = "鏌ヨ鎴愬姛!";
                     mes.data = data.ToList();
                     return mes;
                 }
@@ -1595,7 +1194,7 @@
                 {
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "鏃犲彲鎵ц鐨勭敓浜т换鍔�,浠诲姟宸插畬鎴愭垨宸插叧闂�!";
+                    mes.message = "鏃犲彲鎵ц鐨勭敓浜т换鍔�,浠诲姟宸插畬鎴愭垨宸插叧闂�!";
                     mes.data = null;
                     return mes;
                 }
@@ -1604,7 +1203,7 @@
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -1630,7 +1229,7 @@
                         ordercode = arra[0]; //鑾峰彇鎸囧畾瀛楃涓插墠闈㈢殑瀛楃
                         mes.code = "300";
                         mes.count = 0;
-                        mes.Message = "璇锋壂鎻忓伐搴忎簩缁寸爜!";
+                        mes.message = "璇锋壂鎻忓伐搴忎簩缁寸爜!";
                         mes.data = null;
                         return mes;
                     }
@@ -1663,7 +1262,7 @@
                     {
                         mes.code = "300";
                         mes.count = 0;
-                        mes.Message = "褰撳墠宸ュ簭浠诲姟涓嶅瓨鍦�,鏃犳晥鏉$爜!";
+                        mes.message = "褰撳墠宸ュ簭浠诲姟涓嶅瓨鍦�,鏃犳晥鏉$爜!";
                         mes.data = null;
                         return mes;
                     }
@@ -1698,7 +1297,7 @@
                 {
                     mes.code = "200";
                     mes.count = total;
-                    mes.Message = "鏌ヨ鎴愬姛!";
+                    mes.message = "鏌ヨ鎴愬姛!";
                     mes.data = data.ToList();
                     return mes;
                 }
@@ -1706,7 +1305,7 @@
                 {
                     mes.code = "301";
                     mes.count = 0;
-                    mes.Message = "鏃犲彲鎵ц鐨勭敓浜т换鍔�,浠诲姟宸插畬鎴愭垨宸插叧闂�!";
+                    mes.message = "鏃犲彲鎵ц鐨勭敓浜т换鍔�,浠诲姟宸插畬鎴愭垨宸插叧闂�!";
                     mes.data = null;
                     return mes;
                 }
@@ -1715,7 +1314,7 @@
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -1744,7 +1343,7 @@
                         ordercode = arra[0]; //鑾峰彇鎸囧畾瀛楃涓插墠闈㈢殑瀛楃
                         mes.code = "300";
                         mes.count = 0;
-                        mes.Message = "璇锋壂鎻忓伐搴忎簩缁寸爜!";
+                        mes.message = "璇锋壂鎻忓伐搴忎簩缁寸爜!";
                         mes.data = null;
                         return mes;
                     }
@@ -1801,7 +1400,7 @@
                 {
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "褰撳墠鎵爜宸ュ簭浠诲姟涓嶅瓨鍦�!";
+                    mes.message = "褰撳墠鎵爜宸ュ簭浠诲姟涓嶅瓨鍦�!";
                     mes.data = null;
                     return mes;
                 }
@@ -1817,14 +1416,14 @@
                     list.Add("data2", dt);
                     mes.code = "200";
                     mes.count = 0;
-                    mes.Message = "鏌ヨ鎴愬姛!";
+                    mes.message = "鏌ヨ鎴愬姛!";
                     mes.data = list;
                 }
                 else
                 {
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "鏃犲彲鎵ц鐨勭敓浜т换鍔�,浠诲姟宸插畬鎴愭垨宸插叧闂�!";
+                    mes.message = "鏃犲彲鎵ц鐨勭敓浜т换鍔�,浠诲姟宸插畬鎴愭垨宸插叧闂�!";
                     mes.data = null;
                 }
             }
@@ -1832,7 +1431,7 @@
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -1857,7 +1456,7 @@
                     {
                         mes.code = "300";
                         mes.count = 0;
-                        mes.Message = "璇锋壂鎻忓伐搴忔潯鐮�!";
+                        mes.message = "璇锋壂鎻忓伐搴忔潯鐮�!";
                         mes.data = null;
                         return mes;
                     }
@@ -1869,10 +1468,10 @@
                     switch (OperType)
                     {
                         case "ZZ":
-                            mes = ScanStartReport.ZZEncodingSeach(stu_torgcode, ordercode, stepcode);
+                            mes = ScanStartReport.ZZEncodingSeach(ordercode, stepcode);
                             break;
                         case "WX":
-                            mes = ScanStartReport.WXEncodingSeach(stu_torgcode, SelectType, ordercode, stepcode);
+                            mes = ScanStartReport.WXEncodingSeach(SelectType, ordercode, stepcode);
                             break;
                         default:
                             break;
@@ -1882,7 +1481,7 @@
                 {
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "浜岀淮鐮佷俊鎭负绌�!";
+                    mes.message = "浜岀淮鐮佷俊鎭负绌�!";
                     mes.data = null;
                     return mes;
                 }
@@ -1891,7 +1490,7 @@
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -1925,7 +1524,7 @@
                 {
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "浜岀淮鐮佷俊鎭负绌�!";
+                    mes.message = "浜岀淮鐮佷俊鎭负绌�!";
                     mes.data = null;
                     return mes;
                 }
@@ -1939,14 +1538,14 @@
                 dynamicParams.Add("@stepcode", stepcode);
                 var data = DapperHelper.selectdata(sql, dynamicParams);
                 mes.code = "200";
-                mes.Message = "鏌ヨ鎴愬姛!";
+                mes.message = "鏌ヨ鎴愬姛!";
                 mes.data = data;
             }
             catch (Exception e)
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -1987,14 +1586,14 @@
                         where 1=1 " + search;
                 var data = DapperHelper.selectdata(sql, dynamicParams);
                 mes.code = "200";
-                mes.Message = "鏌ヨ鎴愬姛!";
+                mes.message = "鏌ヨ鎴愬姛!";
                 mes.data = data;
             }
             catch (Exception e)
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -2014,14 +1613,14 @@
                 dynamicParams.Add("@usergroupcode", usergroupcode);
                 var data = DapperHelper.selectdata(sql, dynamicParams);
                 mes.code = "200";
-                mes.Message = "鏌ヨ鎴愬姛!";
+                mes.message = "鏌ヨ鎴愬姛!";
                 mes.data = data;
             }
             catch (Exception e)
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -2046,14 +1645,14 @@
                 dynamicParams.Add("@usercode", usercode);
                 var data = DapperHelper.selectdata(sql, dynamicParams);
                 mes.code = "200";
-                mes.Message = "鏌ヨ鎴愬姛!";
+                mes.message = "鏌ヨ鎴愬姛!";
                 mes.data = data;
             }
             catch (Exception e)
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -2086,7 +1685,7 @@
                 {
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "浜岀淮鐮佷俊鎭负绌�!";
+                    mes.message = "浜岀淮鐮佷俊鎭负绌�!";
                     mes.data = null;
                     return mes;
                 }
@@ -2097,14 +1696,14 @@
                 dynamicParams.Add("@stepcode", stepcode);
                 var data = DapperHelper.selectdata(sql, dynamicParams);
                 mes.code = "200";
-                mes.Message = "鏌ヨ鎴愬姛!";
+                mes.message = "鏌ヨ鎴愬姛!";
                 mes.data = data;
             }
             catch (Exception e)
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -2137,7 +1736,7 @@
                 {
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "浜岀淮鐮佷俊鎭负绌�!";
+                    mes.message = "浜岀淮鐮佷俊鎭负绌�!";
                     mes.data = null;
                     return mes;
                 }
@@ -2148,14 +1747,14 @@
                 dynamicParams.Add("@stepcode", stepcode);
                 var data = DapperHelper.selectdata(sql, dynamicParams);
                 mes.code = "200";
-                mes.Message = "鏌ヨ鎴愬姛!";
+                mes.message = "鏌ヨ鎴愬姛!";
                 mes.data = data;
             }
             catch (Exception e)
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -2181,7 +1780,7 @@
                 {
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "褰撳墠宸ュ簭浠诲姟宸插紑宸�!";
+                    mes.message = "褰撳墠宸ュ簭浠诲姟宸插紑宸�!";
                     mes.data = null;
                     return mes;
                 }
@@ -2206,14 +1805,14 @@
                 {
                     mes.code = "200";
                     mes.count = 0;
-                    mes.Message = "寮�宸ユ垚鍔�!";
+                    mes.message = "寮�宸ユ垚鍔�!";
                     mes.data = null;
                 }
                 else
                 {
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "寮�宸ュけ璐�!";
+                    mes.message = "寮�宸ュけ璐�!";
                     mes.data = null;
                 }
             }
@@ -2221,7 +1820,7 @@
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -2264,7 +1863,7 @@
                 {
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "鎿嶄綔澶辫触,褰撳墠鎶ュ伐浜х嚎搴斾负锛�" + da.Rows[0]["NAME"].ToString() + "!";
+                    mes.message = "鎿嶄綔澶辫触,褰撳墠鎶ュ伐浜х嚎搴斾负锛�" + da.Rows[0]["NAME"].ToString() + "!";
                     mes.data = null;
                     return mes;
                 }
@@ -2406,14 +2005,14 @@
                 {
                     mes.code = "200";
                     mes.count = 0;
-                    mes.Message = "鎿嶄綔鎴愬姛!";
+                    mes.message = "鎿嶄綔鎴愬姛!";
                     mes.data = null;
                 }
                 else
                 {
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "鎿嶄綔澶辫触!";
+                    mes.message = "鎿嶄綔澶辫触!";
                     mes.data = null;
                 }
             }
@@ -2421,7 +2020,7 @@
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -2483,14 +2082,14 @@
                 {
                     mes.code = "200";
                     mes.count = 0;
-                    mes.Message = "鍙戞枡鎴愬姛!";
+                    mes.message = "鍙戞枡鎴愬姛!";
                     mes.data = null;
                 }
                 else
                 {
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "鍙戞枡澶辫触!";
+                    mes.message = "鍙戞枡澶辫触!";
                     mes.data = null;
                 }
             }
@@ -2498,7 +2097,7 @@
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -2549,7 +2148,7 @@
                     string wxstring = (string.Join(",", dr.Select(x => x.ToString()).ToArray()));
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "鎿嶄綔澶辫触,褰撳墠鏀舵枡澶栧崗渚涙柟涓庡彂鏂欏鍗忎緵搴斿晢涓嶅尮閰�,搴斾负锛氥��" + wxstring + "銆�!";
+                    mes.message = "鎿嶄綔澶辫触,褰撳墠鏀舵枡澶栧崗渚涙柟涓庡彂鏂欏鍗忎緵搴斿晢涓嶅尮閰�,搴斾负锛氥��" + wxstring + "銆�!";
                     mes.data = null;
                     return mes;
                 }
@@ -2557,7 +2156,7 @@
                 {
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "鎿嶄綔澶辫触,褰撳墠鏀舵枡鏁伴噺+涓嶈壇鏁伴噺,涓嶈兘澶т簬鍙戞枡鏁伴噺:" + da.Rows[0]["FQTY"].ToString() + "!";
+                    mes.message = "鎿嶄綔澶辫触,褰撳墠鏀舵枡鏁伴噺+涓嶈壇鏁伴噺,涓嶈兘澶т簬鍙戞枡鏁伴噺:" + da.Rows[0]["FQTY"].ToString() + "!";
                     mes.data = null;
                     return mes;
                 }
@@ -2565,7 +2164,7 @@
                 //{
                 //    mes.code = "300";
                 //    mes.count = 0;
-                //    mes.Message = "鎿嶄綔澶辫触,褰撳墠鏀舵枡澶栧崗渚涙柟搴斾负锛�" + da.Rows[0]["NAME"].ToString() + "!";
+                //    mes.message = "鎿嶄綔澶辫触,褰撳墠鏀舵枡澶栧崗渚涙柟搴斾负锛�" + da.Rows[0]["NAME"].ToString() + "!";
                 //    mes.data = null;
                 //    return mes;
                 //}
@@ -2577,7 +2176,7 @@
                     {
                         mes.code = "300";
                         mes.count = 0;
-                        mes.Message = "鎿嶄綔澶辫触,褰撳墠鏀舵枡鏁伴噺+涓嶈壇鏁伴噺,涓嶈兘澶т簬寰呮敹鏁伴噺:" + (sum_fqty - sum_sqty) + "!";
+                        mes.message = "鎿嶄綔澶辫触,褰撳墠鏀舵枡鏁伴噺+涓嶈壇鏁伴噺,涓嶈兘澶т簬寰呮敹鏁伴噺:" + (sum_fqty - sum_sqty) + "!";
                         mes.data = null;
                         return mes;
                     }
@@ -2675,14 +2274,14 @@
                 {
                     mes.code = "200";
                     mes.count = 0;
-                    mes.Message = "鏀舵垚鍔�!";
+                    mes.message = "鏀舵垚鍔�!";
                     mes.data = null;
                 }
                 else
                 {
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "鏀舵枡澶辫触!";
+                    mes.message = "鏀舵枡澶辫触!";
                     mes.data = null;
                 }
             }
@@ -2690,7 +2289,7 @@
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -2845,14 +2444,14 @@
                 {
                     mes.code = "200";
                     mes.count = 0;
-                    mes.Message = "鎿嶄綔鎴愬姛!";
+                    mes.message = "鎿嶄綔鎴愬姛!";
                     mes.data = null;
                 }
                 else
                 {
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "鎿嶄綔澶辫触!";
+                    mes.message = "鎿嶄綔澶辫触!";
                     mes.data = null;
                 }
             }
@@ -2860,7 +2459,7 @@
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -2886,7 +2485,7 @@
                     {
                         mes.code = "300";
                         mes.count = 0;
-                        mes.Message = "璇锋壂鎻忓伐搴忔潯鐮�!";
+                        mes.message = "璇锋壂鎻忓伐搴忔潯鐮�!";
                         mes.data = null;
                         return mes;
                     }
@@ -2904,7 +2503,7 @@
                     {
                         mes.code = "300";
                         mes.count = 0;
-                        mes.Message = "褰撳墠宸ュ崟宸插叧闂�,涓嶅厑璁告楠屾搷浣�!";
+                        mes.message = "褰撳墠宸ュ崟宸插叧闂�,涓嶅厑璁告楠屾搷浣�!";
                         mes.data = null;
                         return mes;
                     }
@@ -2918,7 +2517,7 @@
                     {
                         mes.code = "300";
                         mes.count = 0;
-                        mes.Message = "涓嶆槸鏈溅闂寸敓浜т换鍔�,涓嶅厑璁告楠屾搷浣�!";
+                        mes.message = "涓嶆槸鏈溅闂寸敓浜т换鍔�,涓嶅厑璁告楠屾搷浣�!";
                         mes.data = null;
                         return mes;
                     }
@@ -2953,14 +2552,14 @@
                                 list.Add("chekstand", data1);
                                 mes.code = "200";
                                 mes.count = 0;
-                                mes.Message = "鏌ヨ鎴愬姛!";
+                                mes.message = "鏌ヨ鎴愬姛!";
                                 mes.data = list;
                             }
                             else
                             {
                                 mes.code = "300";
                                 mes.count = 0;
-                                mes.Message = "褰撳墠浜у搧銆�" + data.Rows[0]["partname"].ToString() + "銆�,瀵瑰簲宸ュ簭銆�" + data.Rows[0]["stepname"].ToString() + "銆戯紝鏈寚瀹氳川妫�鏂规!";
+                                mes.message = "褰撳墠浜у搧銆�" + data.Rows[0]["partname"].ToString() + "銆�,瀵瑰簲宸ュ簭銆�" + data.Rows[0]["stepname"].ToString() + "銆戯紝鏈寚瀹氳川妫�鏂规!";
                                 mes.data = null;
                                 return mes;
                             }
@@ -2969,7 +2568,7 @@
                         {
                             mes.code = "300";
                             mes.count = 0;
-                            mes.Message = "褰撳墠宸ュ簭浠诲姟鏃犳姤宸ヤ骇鍑�!";
+                            mes.message = "褰撳墠宸ュ簭浠诲姟鏃犳姤宸ヤ骇鍑�!";
                             mes.data = null;
                             return mes;
                         }
@@ -2978,7 +2577,7 @@
                     {
                         mes.code = "300";
                         mes.count = 0;
-                        mes.Message = "鐢熶骇浠诲姟涓嶅瓨鍦�!";
+                        mes.message = "鐢熶骇浠诲姟涓嶅瓨鍦�!";
                         mes.data = null;
                         return mes;
                     }
@@ -2987,7 +2586,7 @@
                 {
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "浜岀淮鐮佷俊鎭负绌�!";
+                    mes.message = "浜岀淮鐮佷俊鎭负绌�!";
                     mes.data = null;
                     return mes;
                 }
@@ -2996,7 +2595,7 @@
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -3023,14 +2622,14 @@
                 {
                     mes.code = "200";
                     mes.count = 0;
-                    mes.Message = "鏌ヨ鎴愬姛!";
+                    mes.message = "鏌ヨ鎴愬姛!";
                     mes.data = data;
                 }
                 else
                 {
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "褰撳墠璐ㄦ鏂规鏃犳楠岄」!";
+                    mes.message = "褰撳墠璐ㄦ鏂规鏃犳楠岄」!";
                     mes.data = null;
                 }
             }
@@ -3038,7 +2637,7 @@
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -3127,14 +2726,14 @@
                 {
                     mes.code = "200";
                     mes.count = 0;
-                    mes.Message = "鎿嶄綔鎴愬姛!";
+                    mes.message = "鎿嶄綔鎴愬姛!";
                     mes.data = null;
                 }
                 else
                 {
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "鎿嶄綔澶辫触!";
+                    mes.message = "鎿嶄綔澶辫触!";
                     mes.data = null;
                 }
             }
@@ -3142,7 +2741,7 @@
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -3242,7 +2841,7 @@
                             where A.is_delete<>'1' " + search;
                 var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
                 mes.code = "200";
-                mes.Message = "鏌ヨ鎴愬姛!";
+                mes.message = "鏌ヨ鎴愬姛!";
                 mes.count = total;
                 mes.data = data.ToList();
             }
@@ -3250,7 +2849,7 @@
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -3279,14 +2878,14 @@
                 {
                     mes.code = "200";
                     mes.count = 0;
-                    mes.Message = "宸ュ崟鍏抽棴鎴愬姛!";
+                    mes.message = "宸ュ崟鍏抽棴鎴愬姛!";
                     mes.data = null;
                 }
                 else
                 {
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "宸ュ崟鍏抽棴澶辫触!";
+                    mes.message = "宸ュ崟鍏抽棴澶辫触!";
                     mes.data = null;
                 }
             }
@@ -3294,7 +2893,7 @@
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -3323,14 +2922,14 @@
                 {
                     mes.code = "200";
                     mes.count = 0;
-                    mes.Message = "宸ュ崟鍏抽棴鎴愬姛!";
+                    mes.message = "宸ュ崟鍏抽棴鎴愬姛!";
                     mes.data = null;
                 }
                 else
                 {
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "宸ュ崟鍏抽棴澶辫触!";
+                    mes.message = "宸ュ崟鍏抽棴澶辫触!";
                     mes.data = null;
                 }
             }
@@ -3338,7 +2937,7 @@
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -3358,14 +2957,14 @@
                         from  TBas_wkshift_info";
                 var data = DapperHelper.selecttable(sql);
                 mes.code = "200";
-                mes.Message = "鏌ヨ鎴愬姛!";
+                mes.message = "鏌ヨ鎴愬姛!";
                 mes.data = data;
             }
             catch (Exception e)
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -3388,7 +2987,7 @@
                 {
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "缂栫爜宸插瓨鍦�,涓嶈兘閲嶅!";
+                    mes.message = "缂栫爜宸插瓨鍦�,涓嶈兘閲嶅!";
                     mes.data = null;
                     return mes;
                 }
@@ -3400,7 +2999,7 @@
                 {
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "鍚嶇О宸插瓨鍦�,涓嶈兘閲嶅!";
+                    mes.message = "鍚嶇О宸插瓨鍦�,涓嶈兘閲嶅!";
                     mes.data = null;
                     return mes;
                 }
@@ -3433,14 +3032,14 @@
                 {
                     mes.code = "200";
                     mes.count = 0;
-                    mes.Message = "鎿嶄綔鎴愬姛!";
+                    mes.message = "鎿嶄綔鎴愬姛!";
                     mes.data = null;
                 }
                 else
                 {
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "鎿嶄綔澶辫触!";
+                    mes.message = "鎿嶄綔澶辫触!";
                     mes.data = null;
                 }
             }
@@ -3448,7 +3047,7 @@
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -3471,7 +3070,7 @@
                 {
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "鍒犻櫎澶辫触锛�,璇ユ柟妗堝凡缁忚浜ц兘瑙勫垝璧勬簮寮曠敤!";
+                    mes.message = "鍒犻櫎澶辫触锛�,璇ユ柟妗堝凡缁忚浜ц兘瑙勫垝璧勬簮寮曠敤!";
                     mes.data = null;
                     return mes;
                 }
@@ -3493,14 +3092,14 @@
                 {
                     mes.code = "200";
                     mes.count = 0;
-                    mes.Message = "鍒犻櫎鎴愬姛!";
+                    mes.message = "鍒犻櫎鎴愬姛!";
                     mes.data = null;
                 }
                 else
                 {
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "鍒犻櫎澶辫触!";
+                    mes.message = "鍒犻櫎澶辫触!";
                     mes.data = null;
                 }
             }
@@ -3508,7 +3107,7 @@
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -3586,7 +3185,7 @@
                             where C.description='W' " + search;
                 var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
                 mes.code = "200";
-                mes.Message = "鏌ヨ鎴愬姛!";
+                mes.message = "鏌ヨ鎴愬姛!";
                 mes.count = total;
                 mes.data = data.ToList();
             }
@@ -3594,7 +3193,7 @@
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -3623,14 +3222,14 @@
                     {
                         mes.code = "200";
                         mes.count = 0;
-                        mes.Message = "鏂板鎿嶄綔鎴愬姛!";
+                        mes.message = "鏂板鎿嶄綔鎴愬姛!";
                         mes.data = null;
                     }
                     else
                     {
                         mes.code = "300";
                         mes.count = 0;
-                        mes.Message = "鏂板鎿嶄綔澶辫触!";
+                        mes.message = "鏂板鎿嶄綔澶辫触!";
                         mes.data = null;
                     }
                 }
@@ -3646,14 +3245,14 @@
                     {
                         mes.code = "200";
                         mes.count = 0;
-                        mes.Message = "淇敼鎿嶄綔鎴愬姛!";
+                        mes.message = "淇敼鎿嶄綔鎴愬姛!";
                         mes.data = null;
                     }
                     else
                     {
                         mes.code = "300";
                         mes.count = 0;
-                        mes.Message = "淇敼鎿嶄綔澶辫触!";
+                        mes.message = "淇敼鎿嶄綔澶辫触!";
                         mes.data = null;
                     }
                 }
@@ -3662,7 +3261,7 @@
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -3690,14 +3289,14 @@
                     list.Add(cmp);
                 }
                 mes.code = "200";
-                mes.Message = "鏌ヨ鎴愬姛!";
+                mes.message = "鏌ヨ鎴愬姛!";
                 mes.data = list;
             }
             catch (Exception e)
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -3746,14 +3345,14 @@
                     list.Add(cmp);
                 }
                 mes.code = "200";
-                mes.Message = "鏌ヨ鎴愬姛!";
+                mes.message = "鏌ヨ鎴愬姛!";
                 mes.data = list;
             }
             catch (Exception e)
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -3773,7 +3372,7 @@
                 {
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "榛樿鏂规閫夋嫨涓嶈兘涓虹┖!";
+                    mes.message = "榛樿鏂规閫夋嫨涓嶈兘涓虹┖!";
                     mes.data = null;
                     return mes;
                 }
@@ -3781,7 +3380,7 @@
                 {
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "宸ヤ綔鏃ュ巻閫夋嫨涓嶈兘涓虹┖!";
+                    mes.message = "宸ヤ綔鏃ュ巻閫夋嫨涓嶈兘涓虹┖!";
                     mes.data = null;
                     return mes;
                 }
@@ -3807,14 +3406,14 @@
                     {
                         mes.code = "200";
                         mes.count = 0;
-                        mes.Message = "鎿嶄綔鎴愬姛!";
+                        mes.message = "鎿嶄綔鎴愬姛!";
                         mes.data = null;
                     }
                     else
                     {
                         mes.code = "200";
                         mes.count = 0;
-                        mes.Message = "鎿嶄綔澶辫触!";
+                        mes.message = "鎿嶄綔澶辫触!";
                         mes.data = null;
                     }
 
@@ -3877,7 +3476,7 @@
                                         {
                                             mes.code = "300";
                                             mes.count = 0;
-                                            mes.Message = "淇敼澶辫触锛�,鏃ユ湡锛�" + dt4.Rows[g]["TIME_START"] + "鏈夈��" + dt4.Rows[g]["STATUS"] + "銆戝伐鍗曪細" + dt4.Rows[g]["WO_CODE"] + "";
+                                            mes.message = "淇敼澶辫触锛�,鏃ユ湡锛�" + dt4.Rows[g]["TIME_START"] + "鏈夈��" + dt4.Rows[g]["STATUS"] + "銆戝伐鍗曪細" + dt4.Rows[g]["WO_CODE"] + "";
                                             mes.data = null;
                                             return mes;
                                         }
@@ -3930,14 +3529,14 @@
                     {
                         mes.code = "200";
                         mes.count = 0;
-                        mes.Message = "鎿嶄綔鎴愬姛!";
+                        mes.message = "鎿嶄綔鎴愬姛!";
                         mes.data = null;
                     }
                     else
                     {
                         mes.code = "300";
                         mes.count = 0;
-                        mes.Message = "鎿嶄綔澶辫触!";
+                        mes.message = "鎿嶄綔澶辫触!";
                         mes.data = null;
                     }
                 }
@@ -3946,7 +3545,7 @@
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -4023,7 +3622,7 @@
 	                         where E.isbott = 'Y' and A.status='NOSCHED' and A.isaps='Y' " + search;
                 var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
                 mes.code = "200";
-                mes.Message = "鏌ヨ鎴愬姛!";
+                mes.message = "鏌ヨ鎴愬姛!";
                 mes.count = total;
                 mes.data = data.ToList();
             }
@@ -4031,7 +3630,7 @@
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -4054,7 +3653,7 @@
                 {
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "瑕佹眰浜や粯鏃堕棿涓嶈兘灏忎簬褰撳墠绯荤粺鏃堕棿锛�";
+                    mes.message = "瑕佹眰浜や粯鏃堕棿涓嶈兘灏忎簬褰撳墠绯荤粺鏃堕棿锛�";
                     mes.data = null;
                     return list;
                 }
@@ -4085,7 +3684,7 @@
                     {
                         mes.code = "300";
                         mes.count = 0;
-                        mes.Message = "璁惧涓嶅彲鐢紒";
+                        mes.message = "璁惧涓嶅彲鐢紒";
                         mes.data = null;
                         return list;
                     }
@@ -4094,7 +3693,7 @@
                 {
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "宸ヨ壓璺嚎鏈叧鑱旇澶囷紒";
+                    mes.message = "宸ヨ壓璺嚎鏈叧鑱旇澶囷紒";
                     mes.data = null;
                     return list;
                 }
@@ -4128,7 +3727,7 @@
                     {
                         mes.code = "300";
                         mes.count = 0;
-                        mes.Message = "鎺掍骇璁惧杞﹂棿涓庡伐鍗曞垱寤虹殑杞﹂棿涓嶅悓锛�";
+                        mes.message = "鎺掍骇璁惧杞﹂棿涓庡伐鍗曞垱寤虹殑杞﹂棿涓嶅悓锛�";
                         mes.data = null;
                         return list;
                     }
@@ -4146,7 +3745,7 @@
                                 {
                                     mes.code = "300";
                                     mes.count = 0;
-                                    mes.Message = "鎺掔▼璁惧" + listData[j].eqp_id.ToString() + "绋煎姩鐜囦笉鑳戒负0鎴栦负绌猴紒";
+                                    mes.message = "鎺掔▼璁惧" + listData[j].eqp_id.ToString() + "绋煎姩鐜囦笉鑳戒负0鎴栦负绌猴紒";
                                     mes.data = null;
                                     return list;
                                 }
@@ -4154,7 +3753,7 @@
                                 {
                                     mes.code = "300";
                                     mes.count = 0;
-                                    mes.Message = "鎺掔▼璁惧" + listData[j].eqp_id.ToString() + "鏈缃妭鎷嶏紒";
+                                    mes.message = "鎺掔▼璁惧" + listData[j].eqp_id.ToString() + "鏈缃妭鎷嶏紒";
                                     mes.data = null;
                                     return list;
                                 }
@@ -4210,7 +3809,7 @@
                             {
                                 mes.code = "300";
                                 mes.count = 0;
-                                mes.Message = "褰撳墠宸ュ崟鍔犲伐浜у搧瀵瑰簲宸ヨ壓璺嚎璁惧鏈缃骇鑳芥垨鏈缃敓浜ц妭鎷嶏紒";
+                                mes.message = "褰撳墠宸ュ崟鍔犲伐浜у搧瀵瑰簲宸ヨ壓璺嚎璁惧鏈缃骇鑳芥垨鏈缃敓浜ц妭鎷嶏紒";
                                 mes.data = null;
                             }
                         }
@@ -4220,7 +3819,7 @@
                 {
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "璁惧娌℃湁鍏宠仈杞﹂棿锛�";
+                    mes.message = "璁惧娌℃湁鍏宠仈杞﹂棿锛�";
                     mes.data = null;
                 }
                 return list;
@@ -4229,7 +3828,7 @@
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return list;
@@ -4295,7 +3894,7 @@
                     {
                         mes.code = "300";
                         mes.count = 0;
-                        mes.Message = "瑕佹眰浜や粯鏃堕棿涓嶈兘灏忎簬褰撳墠绯荤粺鏃堕棿锛�";
+                        mes.message = "瑕佹眰浜や粯鏃堕棿涓嶈兘灏忎簬褰撳墠绯荤粺鏃堕棿锛�";
                         mes.data = null;
                         return list;
                     }
@@ -4326,7 +3925,7 @@
                         {
                             mes.code = "300";
                             mes.count = 0;
-                            mes.Message = "璁惧涓嶅彲鐢紒";
+                            mes.message = "璁惧涓嶅彲鐢紒";
                             mes.data = null;
                             return list;
                         }
@@ -4335,7 +3934,7 @@
                     {
                         mes.code = "300";
                         mes.count = 0;
-                        mes.Message = "宸ヨ壓璺嚎鏈叧鑱旇澶囷紒";
+                        mes.message = "宸ヨ壓璺嚎鏈叧鑱旇澶囷紒";
                         mes.data = null;
                         return list;
                     }
@@ -4369,7 +3968,7 @@
                         {
                             mes.code = "300";
                             mes.count = 0;
-                            mes.Message = "鎺掍骇璁惧杞﹂棿涓庡伐鍗曞垱寤虹殑杞﹂棿涓嶅悓锛�";
+                            mes.message = "鎺掍骇璁惧杞﹂棿涓庡伐鍗曞垱寤虹殑杞﹂棿涓嶅悓锛�";
                             mes.data = null;
                             return list;
                         }
@@ -4388,7 +3987,7 @@
                                     {
                                         mes.code = "300";
                                         mes.count = 0;
-                                        mes.Message = "鎺掔▼璁惧" + listData[j].eqp_id.ToString() + "绋煎姩鐜囦笉鑳戒负0鎴栦负绌猴紒";
+                                        mes.message = "鎺掔▼璁惧" + listData[j].eqp_id.ToString() + "绋煎姩鐜囦笉鑳戒负0鎴栦负绌猴紒";
                                         mes.data = null;
                                         return list;
                                     }
@@ -4396,7 +3995,7 @@
                                     {
                                         mes.code = "300";
                                         mes.count = 0;
-                                        mes.Message = "鎺掔▼璁惧" + listData[j].eqp_id.ToString() + "鏈缃妭鎷嶏紒";
+                                        mes.message = "鎺掔▼璁惧" + listData[j].eqp_id.ToString() + "鏈缃妭鎷嶏紒";
                                         mes.data = null;
                                         return list;
                                     }
@@ -4452,7 +4051,7 @@
                                 {
                                     mes.code = "300";
                                     mes.count = 0;
-                                    mes.Message = "褰撳墠宸ュ崟鍔犲伐浜у搧瀵瑰簲宸ヨ壓璺嚎璁惧鏈缃骇鑳芥垨鏈缃敓浜ц妭鎷嶏紒";
+                                    mes.message = "褰撳墠宸ュ崟鍔犲伐浜у搧瀵瑰簲宸ヨ壓璺嚎璁惧鏈缃骇鑳芥垨鏈缃敓浜ц妭鎷嶏紒";
                                     mes.data = null;
                                 }
                             }
@@ -4462,7 +4061,7 @@
                     {
                         mes.code = "300";
                         mes.count = 0;
-                        mes.Message = "璁惧娌℃湁鍏宠仈杞﹂棿锛�";
+                        mes.message = "璁惧娌℃湁鍏宠仈杞﹂棿锛�";
                         mes.data = null;
                     }
                 }
@@ -4472,7 +4071,7 @@
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return list;
@@ -4551,7 +4150,7 @@
                 {
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "褰撳墠鎺掔▼浠诲姟宸茬粡娲惧彂,鎻愪氦鍙栨秷锛�";
+                    mes.message = "褰撳墠鎺掔▼浠诲姟宸茬粡娲惧彂,鎻愪氦鍙栨秷锛�";
                     mes.data = null;
                     return mes;
                 }
@@ -4559,7 +4158,7 @@
                 {
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "褰撳墠鎺掔▼浠诲姟宸茬粡鎺掔▼,鎻愪氦鍙栨秷锛�";
+                    mes.message = "褰撳墠鎺掔▼浠诲姟宸茬粡鎺掔▼,鎻愪氦鍙栨秷锛�";
                     mes.data = null;
                     return mes;
                 }
@@ -4590,7 +4189,7 @@
                 {
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "鍏堥鎺�,鍐嶇偣鍑绘彁浜わ紒";
+                    mes.message = "鍏堥鎺�,鍐嶇偣鍑绘彁浜わ紒";
                     mes.data = null;
                     return mes;
                 }
@@ -4613,7 +4212,7 @@
                 {
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "鐢熸垚璁惧浠诲姟姹囨�昏〃鍑洪敊锛屾帓浜уけ璐ワ紒";
+                    mes.message = "鐢熸垚璁惧浠诲姟姹囨�昏〃鍑洪敊锛屾帓浜уけ璐ワ紒";
                     mes.data = null;
                     return mes;
                 }
@@ -4662,13 +4261,13 @@
                 {
                     mes.code = "200";
                     mes.count = 0;
-                    mes.Message = "鎻愪氦鎺掔▼鎴愬姛锛�";
+                    mes.message = "鎻愪氦鎺掔▼鎴愬姛锛�";
                 }
                 else
                 {
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "鎻愪氦鎺掔▼澶辫触锛�";
+                    mes.message = "鎻愪氦鎺掔▼澶辫触锛�";
                     mes.data = null;
                 }
             }
@@ -4676,7 +4275,7 @@
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -4713,14 +4312,14 @@
                 dynamicParams.Add("@ordercode", ordercode);
                 var data = DapperHelper.selectdata(sql, dynamicParams);
                 mes.code = "200";
-                mes.Message = "鏌ヨ鎴愬姛!";
+                mes.message = "鏌ヨ鎴愬姛!";
                 mes.data = data;
             }
             catch (Exception e)
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -4770,14 +4369,14 @@
                 dynamicParams.Add("@wkshopcode", wkshopcode);
                 var data = DapperHelper.selectdata(sql, dynamicParams);
                 mes.code = "200";
-                mes.Message = "鏌ヨ鎴愬姛!";
+                mes.message = "鏌ヨ鎴愬姛!";
                 mes.data = data;
             }
             catch (Exception e)
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -4854,7 +4453,7 @@
                             ) as AA  where AA.good_qty>AA.inhouseqty " + search;
                 var data = DapperHelper.selectdata(sql, dynamicParams);
                 mes.code = "200";
-                mes.Message = "鏌ヨ鎴愬姛!";
+                mes.message = "鏌ヨ鎴愬姛!";
                 mes.count = total;
                 mes.data = data;
             }
@@ -4862,7 +4461,7 @@
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -5085,14 +4684,14 @@
                 {
                     mes.code = "200";
                     mes.count = 0;
-                    mes.Message = "鎿嶄綔鎴愬姛!";
+                    mes.message = "鎿嶄綔鎴愬姛!";
                     mes.data = null;
                 }
                 else
                 {
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "鎿嶄綔澶辫触!";
+                    mes.message = "鎿嶄綔澶辫触!";
                     mes.data = null;
                 }
 
@@ -5101,7 +4700,7 @@
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -5133,7 +4732,7 @@
                 if (data0.Rows.Count <= 0)
                 {
                     mes.code = "300";
-                    mes.Message = "鏃犳晥鏉$爜!";
+                    mes.message = "鏃犳晥鏉$爜!";
                     mes.data = null;
                     return mes;
                 }
@@ -5156,7 +4755,7 @@
                 if (data1.Rows.Count <= 0)
                 {
                     mes.code = "300";
-                    mes.Message = "褰撳墠鏉$爜宸插叆搴�!";
+                    mes.message = "褰撳墠鏉$爜宸插叆搴�!";
                     mes.data = null;
                     return mes;
                 }
@@ -5190,13 +4789,13 @@
                 if (data.Rows.Count > 0)
                 {
                     mes.code = "200";
-                    mes.Message = "鏌ヨ鎴愬姛!";
+                    mes.message = "鏌ヨ鎴愬姛!";
                     mes.data = data;
                 }
                 else
                 {
                     mes.code = "300";
-                    mes.Message = "鏆傛棤鐗╂枡鏁版嵁!";
+                    mes.message = "鏆傛棤鐗╂枡鏁版嵁!";
                     mes.data = null;
                 }
             }
@@ -5204,7 +4803,7 @@
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;

--
Gitblit v1.9.3