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);
}
