private void ViewVasData_Load(object sender, EventArgs e)
{
homeVas.Hide();
listBox1.Items.Clear();
listBox1.Hide();
Cursor.Current = Cursors.WaitCursor;
settingView = new dgvSettings();
changeFormat = new ChangeFormat();
reserv = new ReserveID();
this.dataGridView1.AllowUserToAddRows = false;
List <string> lstHeader = new List <string>();
lstHeader.Add("VasCode");
lstHeader.Add("Channel");
lstHeader.Add("MktCode");
lstHeader.Add("OrderType");
lstHeader.Add("Product");
lstHeader.Add("Speed");
lstHeader.Add("Province");
lstHeader.Add("Effective");
lstHeader.Add("Expire");
ToVasProduct();
settingView.setDgv(dataGridView1, filename, "VAS New Sale(SMART UI)$B3:J", lstHeader);
validate = new Validation(dataGridView1, ConnectionProd, ConnectionTemp, outputPath);
listBox1.Items.Clear();
ListBox ls = validate.verify("VAS");
foreach (string v in ls.Items)
{
listBox1.Items.Add(v);
}
if (listBox1.Items.Count > 0)
{
indexListbox = validate.indexDgv;
listBox1.Show();
}
else
{
listBox1.Hide();
}
toolStripStatusLabel1.Text = "Rows : " + dataGridView1.RowCount.ToString();
Cursor.Current = Cursors.Default;
}
/// <summary>
/// When this form loading
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void MainDiscount_Load(object sender, EventArgs e)
{
home.Hide();
listBox1.Items.Clear();
listBox1.Hide();
Cursor.Current = Cursors.Default;
toolStripStatusLabel1.Text = filename;
this.dataGridView1.AllowUserToAddRows = false;
btnOK.Enabled = true;
settingView = new dgvSettings();
changeFormat = new ChangeFormat();
reserv = new ReserveID();
if (FLAG_NEW == true && FLAG_EXISTING == false)
{
labelPg.Text = "Page1/1";
ViewNewDC();
}
else if (FLAG_NEW == false && FLAG_EXISTING == true)
{
labelPg.Text = "Page1/1";
ViewExistingDC();
}
else
{
labelPg.Text = "Page1/2";
btnOK.Text = "Next";
ViewNewDC();
}
Cursor.Current = Cursors.Default;
}
private void ViewResult_Load(object sender, EventArgs e)
{
Cursor.Current = Cursors.WaitCursor;
main.Hide();
int screenW = SystemInformation.VirtualScreen.Width;
int screenH = SystemInformation.VirtualScreen.Height;
if (screenW - size.Width <= 250 || screenH - size.Height <= 50)
{
this.WindowState = FormWindowState.Maximized;
}
else
{
this.Size = size;
}
connString71 = "Data Source=(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.19.193.20)(PORT = 1560))" +
"(CONNECT_DATA = (SID = TEST03)));User Id= TRUREF71; Password= TRUREF71;";
btnInsert.Enabled = true;
reserve = new ReserveID();
//lstTableResult[0] = New
//lstTableResult[1] = Existing
//Both
if (lstTableResult[0] != null && lstTableResult[1] != null)
{
isBoth = true;
DataTable dtTableNew = lstTableResult[0];
DataTable dtTableEx = lstTableResult[1];
DataTable AllTable = new DataTable();
AllTable = dtTableNew.Copy();
AllTable.Merge(dtTableEx, true, MissingSchemaAction.Ignore);
dataGridViewResult.DataSource = AllTable;
toolStripStatusLabel1.Text = "Sum : " + dataGridViewResult.RowCount.ToString() + " rows";
}
else
{
if (lstTableResult[0] != null)
{
//NewDC
DataTable dtTableNew = lstTableResult[0];
dataGridViewResult.DataSource = dtTableNew;
toolStripStatusLabel1.Text = "Sum : " + dataGridViewResult.RowCount.ToString() + " rows";
}
else
{
//Existing
DataTable dtTableEx = lstTableResult[1];
btnExport.Enabled = false;
isExisting = true;
dataGridViewResult.DataSource = dtTableEx;
toolStripStatusLabel1.Text = "Sum : " + dataGridViewResult.RowCount.ToString() + " rows";
}
}
HilightRows();
Cursor.Current = Cursors.Default;
}
