private void PrintLog(string recid, string plarform, string msg)
{
string ip = GameRequest.GetUserIP();
string serpath = Server.MapPath("TaskLog");
string content = string.Format("{2} 任务ID:{0} 目标IP:{1} {4}\r\n msg:{3}\r\n", recid, ip, DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"), msg, plarform);
PrintTxt.RecordLog(serpath, content);
}
private void CercarBtn_Click(object sender, EventArgs e)
{
ERROR.Visible = false;
PrintTxt.Clear();
ClientTxt.Clear();
VoucherAmountTxt.Clear();
StateVoucherTxt.Clear();
ExpirationTxt.Clear();
TiquetPreviewTxt.Clear();
Cursor.Current = Cursors.WaitCursor;
if (VoucherSerchedTxt.Text != "")
{
try
{
string Texto = "";
DataTable dataTable = new DataTable();
DataRow rowTable;
dataTable.Columns.Add("Data", typeof(DateTime));
dataTable.Columns.Add("Botiga");
dataTable.Columns.Add("Caixa");
dataTable.Columns.Add("Tiquet");
dataTable.Columns.Add("Import", typeof(decimal));
dataTable.Columns.Add("Observacion");
MySqlConnection connection = new MySqlConnection(Connection());
StringBuilder Command = new StringBuilder();
Command.Append("select tienda, nterm, nreb, typlin, fecha, numero, total, cliente, plu from datacap where fecha >= date('" + VOUCHER_Dates.Value.ToString("yyyyMMdd") + "') and numero = @numvoucher order by fecha, tienda, nterm, nreb, nlinea");
MySqlCommand CMD = new MySqlCommand(Command.ToString(), connection);
CMD.Parameters.AddWithValue("@numvoucher", VoucherSerchedTxt.Text.Trim());
connection.Close();
connection.Open();
MySqlDataReader VOUCHER = CMD.ExecuteReader();
int BN = 0;
int TPVN = 0;
int TIKN = 0;
while (VOUCHER.Read())
{
rowTable = dataTable.NewRow();
rowTable[0] = Convert.ToDateTime(VOUCHER[4]).ToString("dd/MM/yyyy");
rowTable[1] = Get_NameCenter(Convert.ToInt32(VOUCHER[0]));
rowTable[2] = VOUCHER[1].ToString().Trim();
rowTable[3] = VOUCHER[2].ToString().Trim();
rowTable[4] = Convert.ToDecimal(VOUCHER[6]);
rowTable[5] = Get_Type(VOUCHER[3].ToString().Trim());
string PLU = VOUCHER[8].ToString().Trim();
dataTable.Rows.Add(rowTable);
if (VOUCHER[3].ToString().Trim() == "CUP")
{
PrintTxt.Text = Convert.ToDateTime(VOUCHER[4]).ToString("dd/MM/yyyy");
ClientTxt.Text = VOUCHER[7].ToString().Trim();
VoucherAmountTxt.Text = VOUCHER[6].ToString().Trim() + " €";
StateVoucherTxt.Text = "Pendent d'utilització";
StateVoucherTxt.ForeColor = Color.DarkOrange;
BN = Convert.ToInt32(VOUCHER[0].ToString().Trim());
TPVN = Convert.ToInt32(VOUCHER[1].ToString().Trim());
TIKN = Convert.ToInt32(VOUCHER[2].ToString().Trim());
string GN = "G" + new string('0', 2 - Convert.ToInt32(VOUCHER[0]).ToString().Length) + Convert.ToInt32(VOUCHER[0]);
string FileVoucher = @"\\192.168.192.101\GEINSA\GnxServer\" + GN + @"\cupones.txt";
if (File.Exists(Directory.GetCurrentDirectory() + @"\cupones-copy.txt"))
{
File.Delete(Directory.GetCurrentDirectory() + @"\cupones-copy.txt");
}
File.Copy(FileVoucher, Directory.GetCurrentDirectory() + @"\cupones-copy.txt");
using (StreamReader sr = new StreamReader(Directory.GetCurrentDirectory() + @"\cupones-copy.txt", Encoding.Default))
{
string line;
while ((line = sr.ReadLine()) != null)
{
if (line.Substring(0, 5).Trim() == PLU)
{
ExpirationTxt.Text = line.Substring(49, 10);
if (Convert.ToDateTime(ExpirationTxt.Text) <= DateTime.Now)
{
StateVoucherTxt.ForeColor = Color.DarkRed;
ExpirationTxt.ForeColor = Color.DarkRed;
StateVoucherTxt.Text = "Cupó Caducat!";
}
else
{
StateVoucherTxt.ForeColor = Color.Black;
ExpirationTxt.ForeColor = Color.Black;
}
break;
}
}
}
}
else if (VOUCHER[3].ToString().Trim() == "CUR")
{
StateVoucherTxt.Text = "Cupó utilitzat";
StateVoucherTxt.ForeColor = Color.ForestGreen;
}
else if (VOUCHER[3].ToString().Trim() == "SUP")
{
StateVoucherTxt.Text = "Cupó Cancel·lat";
StateVoucherTxt.ForeColor = Color.DarkRed;
}
}
VOUCHER.Close();
connection.Close();
Voucher_Table.DataSource = dataTable;
Voucher_Table.ForeColor = Color.Black;
Voucher_Table.Font = new Font("Century Gothic", 10F);
Voucher_Table.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
Voucher_Table.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
Voucher_Table.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
Voucher_Table.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
Voucher_Table.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
Voucher_Table.Columns[5].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
MySqlConnection connectionIP = new MySqlConnection(ConnectionIP());
StringBuilder CommandIP = new StringBuilder();
CommandIP.Append("SELECT LOC FROM `departaments-cca`.cca where DPT = @BN and TPV = @TPVN;");
MySqlCommand CMDIP = new MySqlCommand(CommandIP.ToString(), connectionIP);
CMDIP.Parameters.AddWithValue("@BN", BN);
CMDIP.Parameters.AddWithValue("@TPVN", TPVN);
connectionIP.Close();
connectionIP.Open();
MySqlDataReader IP = CMDIP.ExecuteReader();
string FileIP = "";
while (IP.Read())
{
Ping CHK = new Ping();
PingReply reply = CHK.Send(IP[0].ToString().Trim(), 1000);
if (reply.Status == IPStatus.Success)
{
FileIP = @"\\" + IP[0].ToString().Trim() + @"\geinsa\GnxPOS\Bckup\";
if (VOUCHER_Dates.Value.ToShortDateString() == DateTime.Today.ToShortDateString())
{
FileIP = @"\\" + IP[0].ToString().Trim() + @"\geinsa\GnxPOS\Data\";
}
}
}
DirectoryInfo dir = new DirectoryInfo(FileIP);
foreach (var file in dir.GetFiles())
{
if (file.CreationTime.Date.ToString().Substring(0, 10) == PrintTxt.Text.ToString().Substring(0, 10) && file.Name.Contains("journal"))
{
if (File.Exists(Directory.GetCurrentDirectory() + @"\journal-copy.txt"))
{
File.Delete(Directory.GetCurrentDirectory() + @"\journal-copy.txt");
}
File.Copy(FileIP + file.Name, Directory.GetCurrentDirectory() + @"\journal-copy.txt");
string line = "";
using (StreamReader sr = new StreamReader(Directory.GetCurrentDirectory() + @"\journal-copy.txt", Encoding.Default))
{
string Bot = new string('0', 4 - Convert.ToString(BN).Length) + Convert.ToString(BN);
string Tpv = new string('0', 4 - Convert.ToString(TPVN).Length) + Convert.ToString(TPVN);
string Tik = new string('0', 4 - Convert.ToString(TIKN).Length) + Convert.ToString(TIKN);
string FindText = Bot + "\t" + Tpv + "\t" + Tik;
TiquetPreviewTxt.Text = "";
while ((line = sr.ReadLine()) != null)
{
if (line.Substring(0, 14) == FindText)
{
Texto += line.Substring(31, line.Length - 31) + Environment.NewLine;
}
}
}
}
}
TiquetPreviewTxt.Text = Texto;
Cursor.Current = Cursors.Default;
}
catch (Exception)
{
ERROR.Visible = true;
Cursor.Current = Cursors.Default;
}
}
else
{
}
}
