public void BulkToMySQL(String host, List <String> linfox) { String ConnectionString = "", bbb = "", errMsg = "", processFlag = "", validateFlag = ""; XcustLinfoxPrTblDB xclfptdb = new XcustLinfoxPrTblDB(); if (host == "kfc_po") { ConnectionString = connKFC.ConnectionString; } StringBuilder sCommand = new StringBuilder("INSERT INTO " + xclfptdb.xCLFPT.table + " (" + xclfptdb.xCLFPT.COMPANY + ", " + xclfptdb.xCLFPT.DELIVERY_INSTRUCTION + "," + xclfptdb.xCLFPT.ERROR_MSG + "," + xclfptdb.xCLFPT.ITEM_NUMBER + "," + xclfptdb.xCLFPT.LINE_NUMBER + "," + xclfptdb.xCLFPT.ORDER_DATE + "," + xclfptdb.xCLFPT.ORDER_TIME + "," + xclfptdb.xCLFPT.PO_NUMBER + "," + xclfptdb.xCLFPT.PROCESS_FLAG + "," + xclfptdb.xCLFPT.QTY + "," + xclfptdb.xCLFPT.SUPPLIER_CODE + "," + xclfptdb.xCLFPT.UOM + "," + xclfptdb.xCLFPT.VALIDATE_FLAG + //xclfptdb.xCLFPT.COMPANY + "," + xclfptdb.xCLFPT.COMPANY + "," + xclfptdb.xCLFPT.COMPANY + ") VALUES "); using (MySqlConnection mConnection = new MySqlConnection(ConnectionString)) { List <string> Rows = new List <string>(); bbb = ""; for (int i = 0; i < linfox.Count; i++) { String[] aaa = linfox[i].Split('|'); errMsg = ""; processFlag = ""; validateFlag = ""; //aaa = string.Format("('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}')", MySqlHelper.EscapeString(linfox[i]), // MySqlHelper.EscapeString(linfox[i]), MySqlHelper.EscapeString(linfox[i]), MySqlHelper.EscapeString(linfox[i]), // MySqlHelper.EscapeString(linfox[i]), MySqlHelper.EscapeString(linfox[i]), MySqlHelper.EscapeString(linfox[i]), // MySqlHelper.EscapeString(linfox[i]), MySqlHelper.EscapeString(linfox[i]), MySqlHelper.EscapeString(linfox[i]), // MySqlHelper.EscapeString(linfox[i]), MySqlHelper.EscapeString(linfox[i]), MySqlHelper.EscapeString(linfox[i])); bbb += "('" + aaa[0] + "','" + aaa[11] + "','" + errMsg + "','" + aaa[6] + "','" + aaa[2] + "','" + aaa[4] + "','" + aaa[5] + "','" + aaa[1] + "','" + processFlag + "','" + aaa[7] + "','" + aaa[3] + "','" + aaa[8] + "','" + validateFlag + "'),"; ConnectionString = ""; //Rows.Add(string.Format("('{0}','{1}')", MySqlHelper.EscapeString("test"), MySqlHelper.EscapeString("test"))); //linfox[i] } bbb = bbb.Substring(0, bbb.Length - 1); //aaa = string.Join(",", linfox); sCommand.Append(bbb); sCommand.Append(";"); mConnection.Open(); using (MySqlCommand myCmd = new MySqlCommand(sCommand.ToString(), mConnection)) { myCmd.CommandType = CommandType.Text; myCmd.ExecuteNonQuery(); } } }
public ControlRDPO() { iniFile = new IniFile(Environment.CurrentDirectory + "\\" + Application.ProductName + ".ini"); initC = new InitC(); GetConfig(); conn = new ConnectDB("kfc_po", initC); xCLFPTDB = new XcustLinfoxPrTblDB(conn); xCPRHIADB = new XcustPorReqHeaderIntAllDB(conn); xCPRLIADB = new XcustPorReqLineIntAllDB(conn); xCPRDIADB = new XcustPorReqDistIntAllDB(conn); fontSize9 = 9.75f; fontSize8 = 8.25f; fV1B = new Font(fontName, fontSize9, FontStyle.Bold); fV1 = new Font(fontName, fontSize8, FontStyle.Regular); }