1.丽德单据区分江西和宁波推送

南骏 池

2024-11-06 e3f3ce1d8a06d72cc63bccbd2b39834145d028a9

1.丽德单据区分江西和宁波推送

 HandleData/AE_MES_ERP.cs

@@ -1883,11 +1883,21 @@
                                if (dr.Table.Columns.Contains("CGAORG"))
                                {
                                    org = "丽德";
                                 
                                    string UP = string.Format(@"EXEC [WMS_CGLD_TOJX] '{0}' ", rtaskid);
                                    _sqlHelper.ExecuteNonQuery(UP);
                                    dr["NEWERPID"] = "LD"+dr["ERPID"].ToString();
                                    IDList.Add("LD"+dr["ERPID"].ToString());
                                    dr["NEWERPID"] = "LD" + dr["ERPID"].ToString();
                                    IDList.Add("LD" + dr["ERPID"].ToString());

                                    if (dr["CGA0018"].ToString() == "103")
                                    {
                                        string UP = string.Format(@"EXEC [WMS_CGLD_TOJX] '{0}' ", rtaskid);
                                        _sqlHelper.ExecuteNonQuery(UP);

                                        string SYSDEC = string.Format(@"UPDATE SYSDEC SET STATES='IGNORE' WHERE task_name='TB_ERPTOMES_CG' AND  STATES='NEW' AND TASK_ID ='{0}'", rtaskid);
                                        _sqlHelper.ExecuteNonQuery(SYSDEC);

                                        return true;
                                    }


                                }
                                else
                                {