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