コード例 #1
0
 public bool UploadtoERPDBForFinishedGoods(FinishedGoodsItems fgItems, DataTable dtADMMF, DataTable dtLotMODETAIL, string TB002, string TransNo)
 {
     try
     {
         if (fgItems != null)
         {
             GetDataERPTable getDataERPTable = new GetDataERPTable();
             DataTable       dtSFCTA         = getDataERPTable.GetDataTableSFCTA(fgItems.productCode);
             var             InsertSFCTC     = InsertSFCTCForFinishedGoods(fgItems, dtADMMF, dtSFCTA, dtLotMODETAIL, TB002);
             if (InsertSFCTC == false)
             {
                 SystemLog.Output(SystemLog.MSG_TYPE.War, "InsertSFCTCForFinishedGoods(fgItems, TB002))", "False");
             }
             var InsertSFCTB = InsertSFCTBForFinishedGoods(fgItems, dtADMMF, dtSFCTA, dtLotMODETAIL, TransNo, TB002);
             if (InsertSFCTB == false)
             {
                 SystemLog.Output(SystemLog.MSG_TYPE.War, "InsertSFCTBForFinishedGoods(fgItems, TransNo, TB002)", "False");
             }
             var InsertOrUpdate = InsertOrUpdateSFCTA(fgItems);
             if (InsertOrUpdate == false)
             {
                 SystemLog.Output(SystemLog.MSG_TYPE.War, "InsertOrUpdateSFCTA(fgItems)", "false");
             }
             if (InsertSFCTC && InsertSFCTB && InsertOrUpdate)
             {
                 return(true);
             }
         }
     }
     catch (Exception ex)
     {
         SystemLog.Output(SystemLog.MSG_TYPE.Err, "UploadtoERPDBForFinishedGoods(FinishedGoodsItems fgItems)", ex.Message);
         return(false);
     }
     return(false);
 }
コード例 #2
0
 public bool InsertSFCTCForFinishedGoods(FinishedGoodsItems fgItems, DataTable dtADMMF, DataTable dtSFCTA, DataTable dtMODELLOT, string TB002)
 {
     try
     {
         GetDataERPTable getDataERPTable = new GetDataERPTable();
         DataTable       dtHeader        = getDataERPTable.GetDataTableSFCTC();
         StringBuilder   stringBuilder   = new StringBuilder();
         StringBuilder   stringFun       = new StringBuilder();
         stringBuilder.Append(" insert into SFCTC ( ");
         for (int i = 0; i < dtHeader.Columns.Count; i++)
         {
             if (i < dtHeader.Columns.Count - 1)
             {
                 stringBuilder.Append(dtHeader.Columns[i].ColumnName + ",");
             }
             else
             {
                 stringBuilder.Append(dtHeader.Columns[i].ColumnName + ") values ( ");
             }
         }
         if (dtHeader != null && dtHeader.Rows.Count == 1)
         {
             for (int j = 0; j < dtHeader.Columns.Count; j++)
             {
                 string valueCell = "";
                 if (dtHeader.Columns[j].ColumnName == "COMPANY")
                 {
                     valueCell = dtSFCTA.Rows[0]["COMPANY"].ToString();
                 }
                 else if (dtHeader.Columns[j].ColumnName == "CREATOR")
                 {
                     valueCell = Class.valiballecommon.GetStorage().UserName;
                 }
                 else if (dtHeader.Columns[j].ColumnName == "USR_GROUP")
                 {
                     valueCell = dtADMMF.Rows[0]["MF004"].ToString();
                 }
                 else if (dtHeader.Columns[j].ColumnName == "CREATE_DATE")
                 {
                     valueCell = DateTime.Now.ToString("yyyyMMdd");
                 }
                 else if (dtHeader.Columns[j].ColumnName == "FLAG")
                 {
                     valueCell = "1";
                 }
                 else if (dtHeader.Columns[j].ColumnName == "CREATE_TIME")
                 {
                     valueCell = DateTime.Now.ToString("HH:mm:ss");
                 }
                 else if (dtHeader.Columns[j].ColumnName == "MODIFIER")
                 {
                     valueCell = "NULL";
                 }
                 else if (dtHeader.Columns[j].ColumnName == "MODI_DATE")
                 {
                     valueCell = "NULL";
                 }
                 else if (dtHeader.Columns[j].ColumnName == "CREATE_AP")
                 {
                     valueCell = "SFT";
                 }
                 else if (dtHeader.Columns[j].ColumnName == "CREATE_PRID")
                 {
                     valueCell = "Sftb03";
                 }
                 else if (dtHeader.Columns[j].ColumnName == "TC001")
                 {
                     valueCell = Class.valiballecommon.GetStorage().DocNo;
                 }
                 else if (dtHeader.Columns[j].ColumnName == "TC002")
                 {
                     valueCell = TB002;
                 }
                 else if (dtHeader.Columns[j].ColumnName == "TC003")
                 {
                     valueCell = "0001";
                 }
                 else if (dtHeader.Columns[j].ColumnName == "TC004")
                 {
                     valueCell = fgItems.productCode.Split('-')[0];
                 }
                 else if (dtHeader.Columns[j].ColumnName == "TC005")
                 {
                     valueCell = fgItems.productCode.Split('-')[1];
                 }
                 else if (dtHeader.Columns[j].ColumnName == "TC006")
                 {
                     valueCell = "0020";
                 }
                 else if (dtHeader.Columns[j].ColumnName == "TC007")
                 {
                     valueCell = dtSFCTA.Rows[0]["TA004"].ToString();
                 }
                 else if (dtHeader.Columns[j].ColumnName == "TC010")
                 {
                     valueCell = dtSFCTA.Rows[0]["TA020"].ToString();
                 }
                 else if (dtHeader.Columns[j].ColumnName == "TC013")
                 {
                     valueCell = "1";
                 }
                 else if (dtHeader.Columns[j].ColumnName == "TC014")
                 {
                     valueCell = fgItems.TotalQty.ToString();
                 }
                 else if (dtHeader.Columns[j].ColumnName == "TC015")
                 {
                     valueCell = "0";
                 }
                 else if (dtHeader.Columns[j].ColumnName == "TC016")
                 {
                     valueCell = "0";
                 }
                 else if (dtHeader.Columns[j].ColumnName == "TC017")
                 {
                     valueCell = "0";
                 }
                 else if (dtHeader.Columns[j].ColumnName == "TC018")
                 {
                     valueCell = "0";
                 }
                 else if (dtHeader.Columns[j].ColumnName == "TC019")
                 {
                     valueCell = "0";
                 }
                 else if (dtHeader.Columns[j].ColumnName == "TC020")
                 {
                     valueCell = "0";
                 }
                 else if (dtHeader.Columns[j].ColumnName == "TC021")
                 {
                     valueCell = "0";
                 }
                 else if (dtHeader.Columns[j].ColumnName == "TC022")
                 {
                     valueCell = "Y";
                 }
                 else if (dtHeader.Columns[j].ColumnName == "TC023")
                 {
                     valueCell = dtSFCTA.Rows[0]["TA006"].ToString();
                 }
                 else if (dtHeader.Columns[j].ColumnName == "TC025")
                 {
                     valueCell = "0";
                 }
                 else if (dtHeader.Columns[j].ColumnName == "TC026")
                 {
                     valueCell = "N";
                 }
                 else if (dtHeader.Columns[j].ColumnName == "TC027")
                 {
                     valueCell = "N";
                 }
                 else if (dtHeader.Columns[j].ColumnName == "TC035")
                 {
                     valueCell = "N";
                 }
                 else if (dtHeader.Columns[j].ColumnName == "TC036")
                 {
                     valueCell = fgItems.TotalQty.ToString();
                 }
                 else if (dtHeader.Columns[j].ColumnName == "TC037")
                 {
                     valueCell = "0";
                 }
                 else if (dtHeader.Columns[j].ColumnName == "TC038")
                 {
                     valueCell = DateTime.Now.ToString("yyyyMMdd");
                 }
                 else if (dtHeader.Columns[j].ColumnName == "TC039")
                 {
                     valueCell = "0";
                 }
                 else if (dtHeader.Columns[j].ColumnName == "TC041")
                 {
                     valueCell = fgItems.INDEPID;
                 }
                 else if (dtHeader.Columns[j].ColumnName == "TC042")
                 {
                     valueCell = (double.Parse(dtMODELLOT.Rows[0]["PKQTYPER"].ToString()) * fgItems.TotalQty).ToString();
                 }
                 else if (dtHeader.Columns[j].ColumnName == "TC043")
                 {
                     valueCell = (double.Parse(dtMODELLOT.Rows[0]["PKQTYPER"].ToString()) * fgItems.TotalQty).ToString();
                 }
                 else if (dtHeader.Columns[j].ColumnName == "TC044")
                 {
                     valueCell = "0";
                 }
                 else if (dtHeader.Columns[j].ColumnName == "TC045")
                 {
                     valueCell = "0";
                 }
                 else if (dtHeader.Columns[j].ColumnName == "TC046")
                 {
                     valueCell = "0";
                 }
                 else if (dtHeader.Columns[j].ColumnName == "TC047")
                 {
                     valueCell = fgItems.product;
                 }
                 else if (dtHeader.Columns[j].ColumnName == "TC048")
                 {
                     valueCell = dtMODELLOT.Rows[0]["MO021"].ToString();
                 }
                 else if (dtHeader.Columns[j].ColumnName == "TC050")
                 {
                     valueCell = dtMODELLOT.Rows[0]["PKUNIT"].ToString();                            //cai nay lay o dau
                 }
                 else if (dtHeader.Columns[j].ColumnName == "TC051")
                 {
                     valueCell = "0";
                 }
                 else if (dtHeader.Columns[j].ColumnName == "TC052")
                 {
                     valueCell = fgItems.location;
                 }
                 else if (dtHeader.Columns[j].ColumnName == "TC053")
                 {
                     valueCell = "0";
                 }
                 else if (dtHeader.Columns[j].ColumnName == "TC054")
                 {
                     valueCell = "0";
                 }
                 else if (dtHeader.Columns[j].ColumnName == "TC055")
                 {
                     valueCell = "N";
                 }
                 else if (dtHeader.Columns[j].ColumnName == "TC060")
                 {
                     valueCell = "0";
                 }
                 else if (dtHeader.Columns[j].ColumnName == "UDF06")
                 {
                     valueCell = "0";
                 }
                 else if (dtHeader.Columns[j].ColumnName == "UDF07")
                 {
                     valueCell = "0";
                 }
                 else if (dtHeader.Columns[j].ColumnName == "UDF08")
                 {
                     valueCell = "0";
                 }
                 else if (dtHeader.Columns[j].ColumnName == "UDF09")
                 {
                     valueCell = "0";
                 }
                 else if (dtHeader.Columns[j].ColumnName == "UDF10")
                 {
                     valueCell = "0";
                 }
                 if (j < dtHeader.Columns.Count - 1)
                 {
                     if (valueCell == "NULL")
                     {
                         stringFun.Append(" " + valueCell + " ,");
                     }
                     else
                     {
                         stringFun.Append(" '" + valueCell + "',");
                     }
                 }
                 else
                 {
                     if (valueCell == "NULL")
                     {
                         stringFun.Append(" " + valueCell + ")");
                     }
                     else
                     {
                         stringFun.Append(" '" + valueCell + "')");
                     }
                 }
             }
             string   sqlInsert = stringBuilder.ToString() + stringFun.ToString();
             SqlTLVN2 sqlTLVN2  = new SqlTLVN2();
             if (sqlTLVN2.sqlExecuteNonQuery(sqlInsert, false) == false)
             {
                 //MessageBox.Show("Insert SFT_TRANSORDER fail", "Information", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                 return(false);
             }
             return(true);
         }
     }
     catch (Exception ex)
     {
         SystemLog.Output(SystemLog.MSG_TYPE.Err, " InsertSFCTCForFinishedGoods(FinishedGoodsItems fgItems)", ex.Message);
     }
     return(false);
 }
コード例 #3
0
        public bool InsertSFCTBForFinishedGoods(FinishedGoodsItems fgItems, DataTable dtADMMF, DataTable dtSFCTA, DataTable dtMODELLOT, string TransNo, string TB002)
        {
            try
            {
                GetDataERPTable getDataERPTable = new GetDataERPTable();
                DataTable       dtHeader        = getDataERPTable.GetDataTableSFCTB();
                StringBuilder   stringBuilder   = new StringBuilder();
                StringBuilder   stringFun       = new StringBuilder();
                stringBuilder.Append(" insert into SFCTB ( ");
                for (int i = 0; i < dtHeader.Columns.Count - 1; i++)
                {
                    if (i < dtHeader.Columns.Count - 2)
                    {
                        if (dtHeader.Columns[i].ColumnName != "CFIELD01")
                        {
                            stringBuilder.Append(dtHeader.Columns[i].ColumnName + ",");
                        }
                    }
                    else
                    {
                        stringBuilder.Append(dtHeader.Columns[i].ColumnName + ") values ( ");
                    }
                }
                if (dtHeader != null && dtHeader.Rows.Count == 1)
                {
                    for (int j = 0; j < dtHeader.Columns.Count - 1; j++)
                    {
                        string valueCell = "";
                        if (dtHeader.Columns[j].ColumnName == "COMPANY")
                        {
                            valueCell = dtSFCTA.Rows[0]["COMPANY"].ToString();
                        }
                        else if (dtHeader.Columns[j].ColumnName == "CREATOR")
                        {
                            valueCell = Class.valiballecommon.GetStorage().UserName;
                        }
                        else if (dtHeader.Columns[j].ColumnName == "USR_GROUP")
                        {
                            valueCell = dtADMMF.Rows[0]["MF004"].ToString();
                        }
                        else if (dtHeader.Columns[j].ColumnName == "CREATE_DATE")
                        {
                            valueCell = DateTime.Now.ToString("yyyyMMdd");
                        }
                        else if (dtHeader.Columns[j].ColumnName == "FLAG")
                        {
                            valueCell = "1";
                        }
                        else if (dtHeader.Columns[j].ColumnName == "CREATE_TIME")
                        {
                            valueCell = DateTime.Now.ToString("HH:mm:ss");
                        }
                        else if (dtHeader.Columns[j].ColumnName == "CREATE_AP")
                        {
                            valueCell = "SFT";
                        }
                        else if (dtHeader.Columns[j].ColumnName == "CREATE_PRID")
                        {
                            valueCell = "Sftb03";
                        }
                        else if (dtHeader.Columns[j].ColumnName == "TB001")
                        {
                            valueCell = Class.valiballecommon.GetStorage().DocNo;
                        }
                        else if (dtHeader.Columns[j].ColumnName == "TB002")
                        {
                            valueCell = TB002;
                        }
                        else if (dtHeader.Columns[j].ColumnName == "TB003")
                        {
                            valueCell = DateTime.Now.ToString("yyyyMMdd");
                        }
                        else if (dtHeader.Columns[j].ColumnName == "TB004")
                        {
                            valueCell = "1";
                        }
                        else if (dtHeader.Columns[j].ColumnName == "TB005")
                        {
                            valueCell = dtSFCTA.Rows[0]["TA006"].ToString();
                        }
                        else if (dtHeader.Columns[j].ColumnName == "TB006")
                        {
                            valueCell = dtSFCTA.Rows[0]["TA007"].ToString();
                        }
                        else if (dtHeader.Columns[j].ColumnName == "TB007")
                        {
                            valueCell = "3";
                        }
                        else if (dtHeader.Columns[j].ColumnName == "TB008")
                        {
                            valueCell = fgItems.INDEPID;
                        }
                        else if (dtHeader.Columns[j].ColumnName == "TB009")
                        {
                            valueCell = fgItems.INDEPNAME;                            // Ten kho den
                        }
                        else if (dtHeader.Columns[j].ColumnName == "TB010")
                        {
                            valueCell = dtMODELLOT.Rows[0]["FACTORYID"].ToString();
                        }
                        else if (dtHeader.Columns[j].ColumnName == "TB011")
                        {
                            valueCell = "0";
                        }
                        else if (dtHeader.Columns[j].ColumnName == "TB012")
                        {
                            valueCell = "N";
                        }
                        else if (dtHeader.Columns[j].ColumnName == "TB013")
                        {
                            valueCell = "Y";
                        }
                        else if (dtHeader.Columns[j].ColumnName == "TB014")
                        {
                            valueCell = "";
                        }
                        else if (dtHeader.Columns[j].ColumnName == "TB015")
                        {
                            valueCell = DateTime.Now.ToString("yyyyMMdd");
                        }
                        else if (dtHeader.Columns[j].ColumnName == "TB016")
                        {
                            valueCell = Class.valiballecommon.GetStorage().UserName;
                        }
                        else if (dtHeader.Columns[j].ColumnName == "TB017")
                        {
                            valueCell = "N";
                        }
                        else if (dtHeader.Columns[j].ColumnName == "TB018")
                        {
                            valueCell = "";
                        }
                        else if (dtHeader.Columns[j].ColumnName == "TB019")
                        {
                            valueCell = "1";
                        }
                        else if (dtHeader.Columns[j].ColumnName == "TB022")
                        {
                            valueCell = "1";
                        }
                        else if (dtHeader.Columns[j].ColumnName == "TB023")
                        {
                            valueCell = "1";
                        }
                        else if (dtHeader.Columns[j].ColumnName == "TB025")
                        {
                            valueCell = DateTime.Now.ToString("yyyyMM");
                        }
                        else if (dtHeader.Columns[j].ColumnName == "TB026")
                        {
                            valueCell = "0.2";
                        }
                        else if (dtHeader.Columns[j].ColumnName == "TB027")
                        {
                            valueCell = "0";
                        }
                        else if (dtHeader.Columns[j].ColumnName == "TB029")
                        {
                            valueCell = "0";
                        }
                        else if (dtHeader.Columns[j].ColumnName == "TB030")
                        {
                            valueCell = "0";
                        }
                        else if (dtHeader.Columns[j].ColumnName == "TB031")
                        {
                            valueCell = "0";
                        }
                        else if (dtHeader.Columns[j].ColumnName == "TB036")
                        {
                            valueCell = dtSFCTA.Rows[0]["TA018"].ToString();
                        }
                        else if (dtHeader.Columns[j].ColumnName == "TB037")
                        {
                            valueCell = "1";
                        }
                        else if (dtHeader.Columns[j].ColumnName == "TB038")
                        {
                            valueCell = Class.valiballecommon.GetStorage().DocNo;
                        }
                        else if (dtHeader.Columns[j].ColumnName == "TB039")
                        {
                            valueCell = TransNo;
                        }
                        else if (dtHeader.Columns[j].ColumnName == "UDF06")
                        {
                            valueCell = "0";
                        }
                        else if (dtHeader.Columns[j].ColumnName == "UDF07")
                        {
                            valueCell = "0";
                        }
                        else if (dtHeader.Columns[j].ColumnName == "UDF08")
                        {
                            valueCell = "0";
                        }
                        else if (dtHeader.Columns[j].ColumnName == "UDF09")
                        {
                            valueCell = "0";
                        }
                        else if (dtHeader.Columns[j].ColumnName == "UDF10")
                        {
                            valueCell = "0";
                        }
                        else if (dtHeader.Columns[j].ColumnName == "TB200")
                        {
                            valueCell = "0";
                        }
                        else if (dtHeader.Columns[j].ColumnName == "TB201")
                        {
                            valueCell = "0";
                        }
                        else if (dtHeader.Columns[j].ColumnName == "TB202")
                        {
                            valueCell = "0";
                        }
                        else if (dtHeader.Columns[j].ColumnName == "TB042")
                        {
                            valueCell = "";
                        }
                        //if (j < dtHeader.Columns.Count - 1)
                        //{
                        //	if (dtHeader.Columns[j].ColumnName != "CFIELD01")
                        //		stringFun.Append(" '" + valueCell + "',");
                        //}

                        //else stringFun.Append("'" + valueCell + "')");

                        if (j < dtHeader.Columns.Count - 2)
                        {
                            if (valueCell == "NULL")
                            {
                                stringFun.Append(" " + valueCell + " ,");
                            }
                            else
                            {
                                stringFun.Append(" '" + valueCell + "',");
                            }
                        }
                        else
                        {
                            if (valueCell == "NULL")
                            {
                                stringFun.Append(" " + valueCell + " )");
                            }
                            else
                            {
                                stringFun.Append(" '" + valueCell + "')");
                            }
                        }
                    }
                    string   sqlInsert = stringBuilder.ToString() + stringFun.ToString();
                    SqlTLVN2 sqlTLVN2  = new SqlTLVN2();
                    if (sqlTLVN2.sqlExecuteNonQuery(sqlInsert, false) == false)
                    {
                        //MessageBox.Show("Insert SFT_TRANSORDER fail", "Information", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                        return(false);
                    }
                    return(true);
                }
            }
            catch (Exception ex)
            {
                SystemLog.Output(SystemLog.MSG_TYPE.Err, " InsertSFCTCForFinishedGoods(FinishedGoodsItems fgItems)", ex.Message);
            }
            return(false);
        }