1.投料单判断返工符号改为“*”

南骏 池

2024-10-31 6e1fa4b55b1ae533a544b156541e08cb30e57f36

1.投料单判断返工符号改为“*”

 HandleData/AE_MES_ERP.cs

@@ -2242,7 +2242,22 @@
                            {
                                if (dF["TLA020"].ToString().Contains("装配"))
                                {
                                    if (dF["TLA023"].ToString().Contains("-"))
                                    if (dF["TLA023"].ToString().Contains("*"))
                                    {
                                        string[] tr = dF["TLA023"].ToString().Split('*');

                                        //int i = dF["TLA023"].ToString().LastIndexOf('-');
                                        string StrNew = tr[1].ToString();//dF["TLA023"].ToString().Substring(i + 1, 10);
                                        string SQLT = string.Format(@"SELECT TOP 1 * FROM WOMCAA(NOLOCK) WHERE CAA018='{0}' ", StrNew);
                                        DataTable CAA = _sqlHelper.ExecuteDataTable(SQLT);
                                        if (CAA.Rows.Count > 0)
                                        {
                                            string UP = string.Format(@"UPDATE WOMCAA SET CAA016='{0}',CAA017='{1}',CAA018='{2}' WHERE CAA002='{3}'  ", CAA.Rows[0]["CAA016"].ToString(), CAA.Rows[0]["CAA017"].ToString(), CAA.Rows[0]["CAA018"].ToString(), dF["TLA002"].ToString());
                                            _sqlHelper.ExecuteNonQuery(UP);
                                        }

                                    }
                                    else if (dF["TLA023"].ToString().Contains("-"))
                                    {
                                        string[] tr = dF["TLA023"].ToString().Split('-');