public Boolean CreateTextProductFile(string aFlag, MySqlDataReader aRead)
{
if (aFlag == "master")
{
MasterKingPower lsMaster = new MasterKingPower();
if (lsGdb.Gdb.State == System.Data.ConnectionState.Closed)
{
lsGdb.ConnectDatabase();
}
if (lsIniT.TblMember.Count == 0)
{
lsIniT.CreateTblMember(lsGdb.Gdb);
}
if (lsIniT.TblNationality.Count == 0)
{
lsIniT.CreateTblNationality(lsGdb.Gdb);
}
if (lsIniT.TblCounter.Count == 0)
{
lsIniT.CreateTblCounter(lsGdb.Gdb);
}
if (lsIniT.TblShift.Count == 0)
{
lsIniT.CreateTblShift(lsGdb.Gdb);
}
if (lsIniT.TblTypeMem.Count == 0)
{
lsIniT.CreateTblTypeMem(lsGdb.Gdb);
}
if (lsIniT.TblTypeRoom.Count == 0)
{
lsIniT.CreateTblTypeRoom(lsGdb.Gdb);
}
//lsIniT.CreateTblInitial(lsGdb.Gdb);
lsMaster.ShopCode = lsIni.GetString("kingpower", "shopcode", "0");
string lsFileName = "", lsPath = "D://thahr30//";
lsFileName = lsMaster.ShopCode + "_Product_" + System.DateTime.Now.Year.ToString("0000") + System.DateTime.Now.Month.ToString("00") + System.DateTime.Now.Day.ToString("00") + System.DateTime.Now.Hour.ToString("00") + System.DateTime.Now.Minute.ToString("00") + System.DateTime.Now.Second.ToString("00");
lsPath = lsIni.GetString("kingpower", "pathtextfilekingpower", "D://thahr30//text//");
lsTextFileName = lsPath + lsFileName + ".Txt";
StreamWriter lsSW = new StreamWriter(lsPath + lsFileName + ".Txt");
//KingPower lsGen = new KingPower();
string[] lsData = new string[2000];
lsData = GenMasterFileKingPower(aRead);
//if (lsData[1] != "")
//{
// MessageBox.Show("àµÃÕÂÁ¢éÍÁÙÅ·Ñé§ËÁ´ àÃÕºÃéÍÂ", "Prepare Data All", MessageBoxButtons.OK);
//}
lsSW.WriteLine("[Product]");
foreach (string lsD in lsData)
{
if (lsD != null)
{
lsSW.WriteLine(lsD);
}
}
//lsSW.WriteLine(lsData);
lsSW.Close();
}
return(true);
}
public void CreateTextProductFile(string[] aData, string aYYYYMMDDHHMMSS)
{
string lsFileName = "", lsPath = "D://thahr30//";
try
{
MasterKingPower lsMaster = new MasterKingPower();
lsPath = lsIni.GetString("kingpower", "pathtextfilekingpower", "D://thahr30//text//");
lsMaster.ShopCode = lsIni.GetString("kingpower", "shopcode", "0");
//lsPath = lsIni.GetString("kingpower", "pathtextfilekingpower", "D://thahr30//");
lsFileName = lsMaster.ShopCode + "_Product_" + aYYYYMMDDHHMMSS.Substring(0, 4) + aYYYYMMDDHHMMSS.Substring(5, 2) + aYYYYMMDDHHMMSS.Substring(8, 8);
lsTextFileName = lsPath + lsFileName + ".Txt";
StreamWriter lsSW = new StreamWriter(lsPath + lsFileName + ".Txt");
//lsSW.WriteLine("[Product]");
foreach (string lsD in aData)
{
if (lsD != null)
{
lsSW.WriteLine(lsD);
}
}
lsSW.Close();
}
catch (Exception e)
{
string ls = "äÁèÊÒÁÒöÊÃéÒ§ Text Fileä´é " + lsPath + lsFileName;
lsGdb.WriteLogError(ls, e, "", "CreateTextFile");
//MessageBox.Show(ls + " " + e.Message.ToString(), e.Source.ToString(), MessageBoxButtons.OK);
}
}
private string[] GenMasterFileKingPower(MySqlDataReader aRead)
{
Int32 i = 0, j = 0;
double ldoPriceStart;
string[] lsData = new string[3000];
string lsSQL = "", lsVouDate = "", lsDay = "", lsTRoomName = "";
string lsData1_10 = "", lsData11_23 = "", lsMemID = "", lsMemName = "";
string lsUserName = lsIni.GetString("thahr30", "username", "janepop");
string lsPassword = lsIni.GetString("thahr30", "password", "Ekartc2c5");
string lsServer = lsIni.GetString("thahr30", "serverdatabasename", "localhost");
string lsDatabase = lsIni.GetString("thahr30", "databasename", "localhost");
string StrConn = "Data Source=" + lsServer + ";Database=" + lsDatabase + ";User ID=" + lsUserName + ";Password="******"";
MySqlConnection Conn = new MySqlConnection(StrConn);
MasterKingPower lsMaster = new MasterKingPower();
double ldoMulti = 0;
try
{
//lsIniT.CreateTblTypeRoom(lsGdb.Gdb);
lsMaster.ReVat = 1.07;
lsMaster.ShopCode = lsIni.GetString("kingpower", "shopcode", "0");
lsMaster.Std_Cate_Code = lsIni.GetString("kingpower", "std_cate_code", "0");
lsMaster.Branch_Code = lsIni.GetString("kingpower", "branch_code", "0");
lsMaster.ShpBnd_Code = lsIni.GetString("kingpower", "shpbnd_code", "0");
lsMaster.Currency_code = lsIni.GetString("kingpower", "currency_code", "0");
lsMaster.Rate = lsIni.GetString("kingpower", "rate", "0");
lsMaster.Unit_Code = lsIni.GetString("kingpower", "unit_code", "0");
lsMaster.VatRate = lsIni.GetString("thahr30", "vatrate", "0");
lsMaster.UStoBaht = lsIni.GetString("thahr30", "USTOBAHT", "0");
ldoMulti = Convert.ToDouble(lsIni.GetString("kingpower", "ratekingpower", "15.00"));
//lsMaster.ReVat = lsMaster.Vat_Rate;
Conn.Open();
lsDay = Convert.ToString(System.DateTime.Now.Day - 1);
lsVouDate = System.DateTime.Now.Year.ToString("0000") + "-" + System.DateTime.Now.Month.ToString("00") + "-" + lsDay;
if (aRead.HasRows)
{
//lsVat_Rate = lsMaster.lsVatRate;
lsMaster.Vat_Type = lsIni.GetString("kingpower", "vat_type", "1");
lsMaster.ReQuest_Date = System.DateTime.Now.Year.ToString("0000") + "-" + System.DateTime.Now.Month.ToString("00") + "-" + System.DateTime.Now.Day.ToString("00");
//lsMaster.ReQuest_Date = "2006-09-28";
lsMaster.Request_Exc_Vat = "";
lsMaster.Request_Inc_Vat = "";
lsMaster.RequestEFF_SDate = System.DateTime.Now.Year.ToString("0000") + "-" + System.DateTime.Now.Month.ToString("00") + "-" + System.DateTime.Now.Day.ToString("00") + " " + System.DateTime.Now.Hour.ToString("00") + ":" + System.DateTime.Now.Minute.ToString("00") + ":" + System.DateTime.Now.Second.ToString("00");
/*if ((System.DateTime.Now.Year.ToString("0000") + "-" + System.DateTime.Now.Month.ToString("00") + "-" + System.DateTime.Now.Day.ToString("00") + " " + System.DateTime.Now.Hour.ToString("00") + ":" + System.DateTime.Now.Minute.ToString("00") + ":" + System.DateTime.Now.Second.ToString("00")) > (System.DateTime.Now.AddYears(1).Year.ToString("0000") + "-09-27 23:59:59"))
* {
* lsMaster.RequestEFF_EDate = System.DateTime.Now.AddYears(1).Year.ToString("0000") + "-09-27 23:59:59";
* lsMaster.Ref_Price_Date = "2006-09-27";
* }
* else
* {*/
lsMaster.RequestEFF_EDate = System.DateTime.Now.AddYears(1).Year.ToString("0000") + "-09-27 23:59:59";
lsMaster.Ref_Price_Date = System.DateTime.Now.AddYears(1).Year.ToString("0000") + "-09-27";
//}
//lsMaster.RequestEFF_SDate = "2006-09-28 00:00:00";
//lsMaster.RequestEFF_EDate = "2011-09-27 23:59:59";
//lsMaster.RequestEFF_EDate = DateTime.Now.AddYears(1).tos;
lsMaster.Ref_Price = "7.0";
lsMaster.Ref_Price_SRC = "Don Muang";
//lsMaster.Ref_Price_Date = "2006-09-27";
lsMaster.Ref_Code_1 = "";
lsMaster.Ref_Code_2 = "";
lsMaster.Ref_Code_3 = "";
lsMaster.Ref_Code_4 = "";
lsMaster.Ref_Code_5 = "";
while (aRead.Read())
{
lsMemID = aRead.GetValue(0).ToString();
if (lsMemID == "-")
{
lsSQL = "";
}
lsSQL = "select * From memberpricelist Where memid = '" + lsMemID + "' and flagsendkingpower = '1'";
MySqlCommand Comm = new MySqlCommand(lsSQL, Conn);
MySqlDataReader Read;
Read = Comm.ExecuteReader();
if (Read.HasRows)
{
j = 0;
while (Read.Read())
{
i++;
if (Read["flagoldkingpower"].ToString() == "1")
{
lsMaster.Trans_Type = "1";
}
else
{
lsMaster.Trans_Type = "2";
}
lsSQL = aRead.GetValue(1).ToString();
lsMemName = aRead.GetValue(1).ToString();
lsMaster.Ref_Price_SRC = lsMemName;
ldoPriceStart = Convert.ToDouble(aRead.GetValue(12));
lsSQL = Convert.ToString(aRead.GetValue(12));
decimal cc = Convert.ToDecimal(aRead.GetValue(12));
//ldoPriceStart = (Convert.ToDouble(aRead.GetValue(12)) * Convert.ToDouble(lsMaster.UStoBaht));
if (Read["remark"].ToString() == "US$")
{
ldoPriceStart = (Convert.ToDouble(Read["pricestart"]) * Convert.ToDouble(lsMaster.UStoBaht));
}
else
{
ldoPriceStart = Convert.ToDouble(Read["pricestart"]);
}
ldoPriceStart = (ldoPriceStart * ldoMulti) / 100;
//decimal bbb = Convert.ToDecimal(ldoPriceStart);
decimal aa = decimal.Round(Convert.ToDecimal(ldoPriceStart * lsMaster.ReVat), 2); //lsMaster.Request_Inc_Vat = Convert.ToString(decimal.Round(Convert.ToDecimal(ldoPriceStart), 2));
//lsMaster.Request_Inc_Vat = ldoPriceStart.ToString("0.00");
//lsMaster.Vat_Type;
//lsMaster.Request_Inc_Vat = ldoPriceStart.ToString("0.00");
if (lsMaster.Vat_Type == "2")
{
decimal aaa = Convert.ToDecimal(ldoPriceStart + (ldoPriceStart * Convert.ToDouble(lsMaster.VatRate) / 100));
lsMaster.Request_Inc_Vat = aaa.ToString("0.00");
lsMaster.Request_Exc_Vat = ldoPriceStart.ToString("0.00");
}
else
{
lsMaster.Request_Inc_Vat = Convert.ToString(aa);
lsMaster.Request_Exc_Vat = Convert.ToString(ldoPriceStart);
}
//lsMaster.Request_Inc_Vat = lsMaster.Request_Inc_Vat;
lsMaster.Ref_Price = lsMaster.Request_Exc_Vat;
lsTRoomName = lsIniT.SelectInitial(lsIniT.TblTypeRoom, Read["plcode"].ToString(), Initial.WhereSelect.aCodetoName);
j++;
lsData1_10 = lsMaster.ShopCode + "|" + lsMaster.Std_Cate_Code + "|" + lsMemID + Read["plcode"].ToString() + "|" + lsMemName + "[" + lsTRoomName + "]" + "|" + lsMaster.ShpBnd_Code + "|" + lsMaster.BarCode + "|" + lsMaster.Trans_Type + "|" + lsMaster.Vat_Type + "|" + lsMaster.VatRate + "|" + lsMaster.Unit_Code;
lsData11_23 = lsMaster.ReQuest_Date + "|" + lsMaster.Request_Exc_Vat + "|" + lsMaster.Request_Inc_Vat + "|" + lsMaster.RequestEFF_SDate + "|" + lsMaster.RequestEFF_EDate + "|" + lsMaster.Ref_Price + "|" + lsMaster.Ref_Price_SRC + "|" + lsMaster.Ref_Price_Date + "|" + lsMaster.Ref_Code_1 + "|" + lsMaster.Ref_Code_2 + "|" + lsMaster.Ref_Code_3 + "|" + lsMaster.Ref_Code_4 + "|" + lsMaster.Ref_Code_5;
lsData[i] = lsData1_10 + "|" + lsData11_23;
}
}
Read.Close();
}
}
Conn.Close();
}
catch (Exception e)
{
string ls = "äÁèÊÒÁÒöàµÃÕÂÁ¢éÍÁÙÅ Print ä´é ";
lsGdb.WriteLogError(ls, e, "", "GenMasterFileKingPower ");
//MessageBox.Show(ls + " " + eAcc.Message.ToString(), eAcc.Source.ToString(), MessageBoxButtons.OK);
}
return(lsData);
}
private string[] GenMasterFileKingPower(MySqlDataReader aRead, double aPriceBaht)
{
MasterKingPower lsMaster = new MasterKingPower();
if (lsGdb.Gdb.State == System.Data.ConnectionState.Closed)
{
lsGdb.ConnectDatabase();
}
lsIniT.CreateTblMember(lsGdb.Gdb);
lsIniT.CreateTblNationality(lsGdb.Gdb);
lsIniT.CreateTblCounter(lsGdb.Gdb);
lsIniT.CreateTblShift(lsGdb.Gdb);
lsIniT.CreateTblTypeMem(lsGdb.Gdb);
lsMaster.ReVat = 1.07;
lsMaster.ShopCode = lsIni.GetString("kingpower", "shopcode", "0");
lsMaster.Std_Cate_Code = lsIni.GetString("kingpower", "std_cate_code", "0");
lsMaster.Branch_Code = lsIni.GetString("kingpower", "branch_code", "0");
lsMaster.ShpBnd_Code = lsIni.GetString("kingpower", "shpbnd_code", "0");
lsMaster.Currency_code = lsIni.GetString("kingpower", "currency_code", "0");
lsMaster.Rate = lsIni.GetString("kingpower", "rate", "0");
lsMaster.Unit_Code = lsIni.GetString("kingpower", "unit_code", "0");
lsMaster.VatRate = lsIni.GetString("thahr30", "vatrate", "0");
lsMaster.UStoBaht = lsIni.GetString("thahr30", "USTOBAHT", "0");
Int32 i = 0;
double ldoPriceStart, ldoPriceEnd;
string[] lsData = new string[2000];
string lsSQL = "", lsVouDate = "", lsDay = "";
string lsData1_10 = "", lsData11_23 = "", lsMemID = "", lsMemName = "";
lsDay = Convert.ToString(System.DateTime.Now.Day - 1);
lsVouDate = System.DateTime.Now.Year.ToString("0000") + "-" + System.DateTime.Now.Month.ToString("00") + "-" + lsDay;
if (aRead.HasRows)
{
//lsVat_Rate = lsMaster.lsVatRate;
lsMaster.Vat_Type = lsIni.GetString("kingpower", "vat_type", "1");
lsMaster.ReQuest_Date = System.DateTime.Now.Year.ToString("0000") + "-" + System.DateTime.Now.Month.ToString("00") + "-" + System.DateTime.Now.Day.ToString("00");
lsMaster.Request_Exc_Vat = "";
lsMaster.Request_Inc_Vat = "";
lsMaster.RequestEFF_SDate = System.DateTime.Now.Year.ToString("0000") + "-" + System.DateTime.Now.Month.ToString("00") + "-" + System.DateTime.Now.Day.ToString("00") + " " + System.DateTime.Now.Hour.ToString("00") + ":" + System.DateTime.Now.Minute.ToString("00") + ":" + System.DateTime.Now.Second.ToString("00");
lsMaster.RequestEFF_SDate = "2006-09-28 00:00:00";
lsMaster.RequestEFF_EDate = "2011-09-27 23:59:59";
lsMaster.Ref_Price = "7.0";
lsMaster.Ref_Price_SRC = "Don Muang";
lsMaster.Ref_Price_Date = "2006-09-27";
lsMaster.Ref_Code_1 = "";
lsMaster.Ref_Code_2 = "";
lsMaster.Ref_Code_3 = "";
lsMaster.Ref_Code_4 = "";
lsMaster.Ref_Code_5 = "";
while (aRead.Read())
{
i++;
lsMaster.Trans_Type = "1";
lsMemID = aRead.GetValue(0).ToString();
lsSQL = aRead.GetValue(1).ToString();
lsMemName = aRead.GetValue(1).ToString();
lsMaster.Ref_Price_SRC = lsMemName;
ldoPriceStart = Convert.ToDouble(aRead.GetValue(12));
lsSQL = Convert.ToString(aRead.GetValue(12));
decimal cc = Convert.ToDecimal(aRead.GetValue(12));
ldoPriceStart = (Convert.ToDouble(aRead.GetValue(12)) * Convert.ToDouble(lsMaster.UStoBaht));
//ldoPriceStart = decimal.Round(ldoPriceStart, 2);
//decimal bbb = Convert.ToDecimal(ldoPriceStart);
decimal aa = decimal.Round(Convert.ToDecimal(ldoPriceStart / lsMaster.ReVat), 2); //lsMaster.Request_Inc_Vat = Convert.ToString(decimal.Round(Convert.ToDecimal(ldoPriceStart), 2));
lsMaster.Request_Inc_Vat = ldoPriceStart.ToString("0.00");
lsMaster.Request_Exc_Vat = Convert.ToString(aa);
//lsMaster.Request_Inc_Vat = lsMaster.Request_Inc_Vat;
lsMaster.Ref_Price = lsMaster.Request_Exc_Vat;
if (lsMemID == lsMem)
{
j++;
}
else
{
lsMem = lsMemID;
j = 1;
}
ldoPriceEnd = aPriceBaht;
decimal bb = decimal.Round(Convert.ToDecimal(ldoPriceEnd / lsMaster.ReVat), 2);
//lsMaster.Request_Inc_Vat = Convert.ToString(decimal.Round(Convert.ToDecimal(ldoPriceEnd), 2));
lsMaster.Request_Inc_Vat = ldoPriceEnd.ToString("0.00");
lsMaster.Request_Exc_Vat = Convert.ToString(bb);
//lsMaster.Request_Inc_Vat = lsMaster.Request_Inc_Vat;
lsMaster.Ref_Price = lsMaster.Request_Exc_Vat;
lsData1_10 = lsMaster.ShopCode + "|" + lsMaster.Std_Cate_Code + "|" + lsMemID + j.ToString("00000") + "|" + lsMemName + "|" + lsMaster.ShpBnd_Code + "|" + lsMaster.BarCode + "|" + lsMaster.Trans_Type + "|" + lsMaster.Vat_Type + "|" + lsMaster.VatRate + "|" + lsMaster.Unit_Code;
lsData11_23 = lsMaster.ReQuest_Date + "|" + lsMaster.Request_Exc_Vat + "|" + lsMaster.Request_Inc_Vat + "|" + lsMaster.RequestEFF_SDate + "|" + lsMaster.RequestEFF_EDate + "|" + lsMaster.Ref_Price + "|" + lsMaster.Ref_Price_SRC + "|" + lsMaster.Ref_Price_Date + "|" + lsMaster.Ref_Code_1 + "|" + lsMaster.Ref_Code_2 + "|" + lsMaster.Ref_Code_3 + "|" + lsMaster.Ref_Code_4 + "|" + lsMaster.Ref_Code_5;
lsData[i] = lsData1_10 + "|" + lsData11_23;
//lsSW.WriteLine(lsData);
//lsSW.WriteLine(lsData);
}
}
return(lsData);
}