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