public void LoadData()
{
data_set = new DataSet2();
set_1();
set_3();
set_7();
set_10();
set_11();
set_11A();
set_11B();
set_12();
set_13();
set_13A();
set_13B();
set_15();
set_16();
set_17();
set_18();
set_18A();
set_18B();
set_18C();
set_18D();
set_20();
set_21();
}
public override global::System.Data.DataSet Clone()
{
DataSet2 cln = ((DataSet2)(base.Clone()));
cln.InitVars();
cln.SchemaSerializationMode = this.SchemaSerializationMode;
return(cln);
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs)
{
DataSet2 ds = new DataSet2();
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny();
any.Namespace = ds.Namespace;
sequence.Items.Add(any);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace))
{
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try
{
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();)
{
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length))
{
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length) &&
(s1.ReadByte() == s2.ReadByte()));)
{
;
}
if ((s1.Position == s1.Length))
{
return(type);
}
}
}
}
finally
{
if ((s1 != null))
{
s1.Close();
}
if ((s2 != null))
{
s2.Close();
}
}
}
xs.Add(dsSchema);
return(type);
}
private void MemberListForm_Load(object sender, EventArgs e)
{
DataSet2 ds = new DataSet2();
DataSet2TableAdapters.MembersTableAdapter ma = new DataSet2TableAdapters.MembersTableAdapter();
ma.Fill(ds.Members);
memberreport cr = new memberreport();
cr.SetDataSource(ds);
crystalReportViewer1.ReportSource = cr;
}
private void frmInvoiceReport_Load(object sender, EventArgs e)
{
DataSet2 ds = new DataSet2();
DataSet2TableAdapters.bookinginvoicereportTableAdapter da = new DataSet2TableAdapters.bookinginvoicereportTableAdapter();
da.Fill(ds.bookinginvoicereport);
BookingInvoice cr = new BookingInvoice();
cr.SetDataSource(ds);
cr.SetParameterValue("TransactionID", frmBookingDetail.rptTransactionid);
crInvoice.ReportSource = cr;
}
private void Button_Click(object sender, RoutedEventArgs e)
{
departmentsTableAdapter dadeps = new departmentsTableAdapter();
ds = new DataSet2();
dadeps.Fill(ds.departments);
dgdept.ItemsSource = ds.departments.DefaultView;
employeeTableAdapter daemps = new employeeTableAdapter();
daemps.Fill(ds.employee);
dgData.ItemsSource = ds.employee.DefaultView;
}
private void bntReport_Click(object sender, EventArgs e)
{
OracleConnection orc = new OracleConnection(@"DATA SOURCE=localhost:1521/XE;PERSIST SECURITY INFO=True;USER ID=ZHANEL; Password = 123 ");
orc.Open();
string query = "Select * from \"SEARCH\"";
OracleDataAdapter da = new OracleDataAdapter(query, orc);
DataSet2 ds = new DataSet2();
da.Fill(ds, "SEARCH");
ReportDocument rDoc = new ReportDocument();
rDoc.Load("CrystalReport4.rpt");
rDoc.SetDataSource(ds);
crystalReportViewer1.ReportSource = rDoc;
}
public DataSet2 LoadData(string s)
{
data_set = new DataSet2();
Thana_name = s;
set_1();
SET_1A();
set_2();
set_3();
set_4();
set_5();
set_6();
set_7();
set_8();
set_9();
set_10();
set_11();
set_11A();
set_11B();
set_12();
set_13();
set_13A();
set_13B();
set_14();
set_14B();
set_14C();
set_15();
set_16();
set_17();
set_18();
set_18A();
set_18B();
set_18C();
set_18D();
set_19();
set_20();
set_21();
set_22();
return data_set;
}
private void Used_View_report_return_sale_checks_Load(object sender, EventArgs e)
{
var x = mob_sys.Used_get_return_sale_check_by_id(Class1.Return_id).ToList();
DataSet2 ds = new DataSet2();
int i = 1;
foreach (var item in x)
{
ds.Used_Return_check.Rows.Add(item.ID, item.Return_Date, item.Return_from, item.UserName, item.Total, item.paid_mount,
item.return_details_notes, item.count, i, item.Name, item.item_notes, item.Price, item.remaining);
i++;
}
return_byid2 cr = new return_byid2();
cr.SetDataSource(ds.Tables["Used_Return_check"]);
crystalReportViewer1.ReportSource = cr;
crystalReportViewer1.Refresh();
}
private void Used_View_report_store_items_Load(object sender, EventArgs e)
{
var Username = Class1.TheValue;
var x = mob_sys.USed_get_store_items().ToList();
DataSet2 ds = new DataSet2();
//int i = 1;
foreach (var item in x)
{
ds.Used_Store_Items.Rows.Add(item.ID, item.Items_Names, item.quantity, item.Recieve_Price, item.Sale_Price, Username);
// i++;
}
get_store_items cr = new get_store_items();
cr.SetDataSource(ds.Tables["Used_Store_Items"]);
crystalReportViewer1.ReportSource = cr;
crystalReportViewer1.Refresh();
}
protected void Application_Start(object sender, EventArgs e)
{
var dataSet1 = new DataSet1();
using (var categoriesAdapter = new CategoriesTableAdapter()) {
categoriesAdapter.Fill(dataSet1.Categories);
var categoriesProvider = new ObjectDataProvider(dataSet1);
DataProviderRepository.Current.Register("Categories", "Categories", categoriesProvider);
}
var dataSet2 = new DataSet2();
using (var customersAdapter = new CustomersTableAdapter()) {
customersAdapter.Fill(dataSet2.Customers);
var customersProvider = new ObjectDataProvider(dataSet2);
DataProviderRepository.Current.Register("Customers", "Customers", customersProvider);
}
}
/// <summary>
/// метод для заполнения содержимого Комбобоксов сразу при открытии формы
/// </summary>
public SboyOborudovania()
{
InitializeComponent();
obnova();
ОборудованиеTableAdapter = new ОборудованиеTableAdapter();
DataSet2 = new DataSet2();
new ОборудованиеTableAdapter().Fill(DataSet2.Оборудование);
MarkirovkaComboB.ItemsSource = DataSet2.Оборудование;
MarkirovkaComboB.DisplayMemberPath = "Маркировка";
MarkirovkaComboB.SelectedValuePath = "Маркировка";
///
ТипОборудованиеTableAdapter = new ТипОборудованиеTableAdapter();
DataSet2 = new DataSet2();
new ТипОборудованиеTableAdapter().Fill(DataSet2.ТипОборудование);
TypeOborudComboB.ItemsSource = DataSet2.ТипОборудование;
TypeOborudComboB.DisplayMemberPath = "Тип_Оборуования";
TypeOborudComboB.SelectedValuePath = "Тип_Оборуования";
}
private void generate_bill_Load(object sender, EventArgs e)
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
con.Open();
DataSet2 ds = new DataSet2();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select * from order_user where id=" + j + "";
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds.DataTable2);
SqlCommand cmd2 = con.CreateCommand();
cmd2.CommandType = CommandType.Text;
cmd2.CommandText = "select * from order_item where order_id=" + j + "";
cmd2.ExecuteNonQuery();
DataTable dt2 = new DataTable();
SqlDataAdapter da2 = new SqlDataAdapter(cmd2);
da2.Fill(ds.DataTable1);
da2.Fill(dt2);
tot = 0;
foreach (DataRow dr2 in dt2.Rows)
{
tot = tot + Convert.ToInt32(dr2["total"].ToString());
}
CrystalReport2 myreport = new CrystalReport2();
myreport.SetDataSource(ds);
myreport.SetParameterValue("total", tot.ToString());
crystalReportViewer1.ReportSource = myreport;
}
private void View_report_sale_check_Load(object sender, EventArgs e)
{
var x = mob_sys.get_sale_check_by_id2(Class1.Sale_id).ToList();
DataSet2 ds = new DataSet2();
int i = 1;
foreach (var item in x)
{
ds.Sale_check.Rows.Add(item.ID, item.sale_Date, item.Sale_To, item.UserName, item.TotalPrice, item.difference_col,
item.Discount_val, item.Addition_val, item.remaining, item.sale_details_notes, item.count, i, item.Name, item.item_notes,
item.Price);
i++;
}
Sale_byid cr = new Sale_byid();
cr.SetDataSource(ds.Tables["Sale_check"]);
crystalReportViewer1.ReportSource = cr;
crystalReportViewer1.Refresh();
}
private void PrintAllOrdersForm_Load(object sender, EventArgs e)
{
DataSet2 ds = new DataSet2();
PrintAllOrdersReport cr = new PrintAllOrdersReport();
SqlConnection cn = connection.getConnection();
String query1 = "select o.id_order,o.signe_order,o.date_order,o.commissaire_judiciaire,o.ville,o.tribunal,c.nom as 'id_client_order',a.nom as 'id_adversaire_order',o.decision,o.type from orderr o,adv_order a,client_order c where o.id_adversaire_order=a.id_adv_order and o.id_client_order=c.id_client_order";
SqlDataAdapter da = new SqlDataAdapter(query1, cn);
da.Fill(ds, "orderr");
string query2 = "select nom_avocat,adresse,autorite from avocat";
SqlDataAdapter da2 = new SqlDataAdapter(query2, cn);
da2.Fill(ds, "avocat");
cr.SetDataSource(ds);
crystalReportViewer1.ReportSource = cr;
crystalReportViewer1.Refresh();
}
public void LoadNewRpt()
{
FuelreportCR crystalReport = new FuelreportCR();
try
{
DataSet2 dsCustomers = db.GetData(_fromDate, _toDate);
crystalReport.SetDataSource(dsCustomers);
this.crystalReportViewer1.ReportSource = crystalReport;
TextObject yr = (TextObject)crystalReport.ReportDefinition.Sections["Section5"].ReportObjects["TxtObjLogUser"];
yr.Text = "[ Copyright \u00A9 " + DateTime.Now.Year.ToString() + " Delmo IT " + " PD : "
+ DateTime.Now.ToString("dd/MM/yyyy") + " PT : " + DateTime.Now.ToString("hh:mm:ss tt")
+ " Com : " + System.Environment.MachineName.ToString() + " UN : "
+ Properties.Settings.Default.LastUser + " ]";
}
catch { MessageBox.Show("Error loading with the report...", "Report Error", MessageBoxButtons.OK, MessageBoxIcon.Error); }
try
{
DataTable table = db.FillReportHeader();
DataRow row = table.Rows[0];
TextObject heder = (TextObject)crystalReport.ReportDefinition.Sections["Section1"].ReportObjects["TxtCRName"];
heder.Text = row[0].ToString();
TextObject heder2 = (TextObject)crystalReport.ReportDefinition.Sections["Section1"].ReportObjects["TxtCrAddr"];
heder2.Text = row[1].ToString();
TextObject heder3 = (TextObject)crystalReport.ReportDefinition.Sections["Section1"].ReportObjects["TxtCRTPNo"];
heder3.Text = "Tel : " + row[2].ToString() + " / Fax : " + row[3].ToString();
TextObject heder4 = (TextObject)crystalReport.ReportDefinition.Sections["Section1"].ReportObjects["TxtCREmailWeb"];
heder4.Text = "E-Mail : " + row[4].ToString() + " / Web Address : " + row[5].ToString();
TextObject heder5 = (TextObject)crystalReport.ReportDefinition.Sections["Section1"].ReportObjects["TxtHoLine"];
heder5.Text = "Hot Line : 0774410500 / " + row[2].ToString();
TextObject fromD = (TextObject)crystalReport.ReportDefinition.Sections["Section1"].ReportObjects["CrFromDatTxt"];
fromD.Text = _fromDate;
TextObject toDay = (TextObject)crystalReport.ReportDefinition.Sections["Section1"].ReportObjects["CrToDatTxt"];
toDay.Text = _toDate;
}
catch
{
MessageBox.Show("Error loading with the report header...", "Report Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
this.crystalReportViewer1.RefreshReport();
}
private void Used_View_purch_report_byID_Load(object sender, EventArgs e)
{
var x = mob_sys.Used_get_purch_check_id(Class1.Purch_id).ToList();
DataSet2 ds = new DataSet2();
int i = 1;
foreach (var item in x)
{
ds.Used_purch_check.Rows.Add(item.ID, item.Recieve_Date, item.Supplier_Name, item.UserName, item.Company, item.Total, item.diff,
item.difference_col, item.Discount_val, item.Addition_val, item.purch_details_notes, item.count, i, item.Name, item.item_details,
item.Price);
i++;
}
purch_byid cr = new purch_byid();
cr.SetDataSource(ds.Tables["Used_purch_check"]);
crystalReportViewer1.ReportSource = cr;
crystalReportViewer1.Refresh();
}
public void LoadData()
{
data_set = new DataSet2();
Thana_name = comboBox_Thana.Text.ToString();
set_1();
set_3();
set_4();
set_6();
set_7();
set_8();
set_9();
set_10();
set_11();
set_11A();
set_11B();
set_12();
set_13();
set_13A();
set_13B();
set_14();
set_14B();
set_14C();
set_15();
set_16();
set_17();
set_18();
set_18A();
set_18B();
set_18C();
set_18D();
set_19();
set_20();
set_21();
}
/// <summary>
/// метод для заполнения комбо-бокса данными из
/// таблицы изделия
/// и заполнением датагрид таблицей Спецификация изделий
/// </summary>
public SpecifickaciaIzdeliy()
{
InitializeComponent();
string s = @"Data Source = DESKTOP-P6DOUN2\MSSQLSERVER02;Integrated Security = true;Initial Catalog=Cake";
SqlConnection connection = new SqlConnection(s);
connection.Open();
SqlDataAdapter adapter = new SqlDataAdapter("select * from СпецификацияИзделий", connection);
System.Data.DataTable dataTable = new System.Data.DataTable("СпецификацияИзделий");
adapter.Fill(dataTable);
dataGrid.ItemsSource = dataTable.DefaultView;
connection.Close();
ИзделиеTableAdapter = new ИзделиеTableAdapter();
DataSet2 = new DataSet2();
new ИзделиеTableAdapter().Fill(DataSet2.Изделие);
IzdeliaComboB.ItemsSource = DataSet2.Изделие;
IzdeliaComboB.DisplayMemberPath = "Изделие";
IzdeliaComboB.SelectedValuePath = "Изделие";
}
private void button8_Click(object sender, EventArgs e)
{
//penalty
MySqlConnection sqlcon = new MySqlConnection("DATA SOURCE= 127.0.0.1; INITIAL CATALOG=it_2d; UID=root");
MySqlCommand sqlcom = new MySqlCommand("SELECT b_no,u_un,d_borrowed,fine FROM tbl_penalty where b_no != 'PENALTY' && fine != '0'", sqlcon);
MySqlDataAdapter sqlDA = new MySqlDataAdapter();
DataSet2 ds = new DataSet2();
sqlcon.Open();
sqlcom.CommandType = CommandType.Text;
sqlDA.SelectCommand = sqlcom;
sqlDA.Fill(ds, "penaltys");
// dataGridView1.DataSource = ds;
// dataGridView1.DataMember = "tbl_penalty";
penaltys cry = new penaltys();
cry.SetDataSource(ds);
crystalReportViewer1.ReportSource = cry;
sqlcon.Close();
}
private void button3_Click_1(object sender, EventArgs e)
{
//useraccts
MySqlConnection sqlcon = new MySqlConnection("DATA SOURCE= 127.0.0.1; INITIAL CATALOG=it_2d; UID=root");
MySqlCommand sqlcom = new MySqlCommand("SELECT * FROM tbl_user", sqlcon);
MySqlDataAdapter sqlDA = new MySqlDataAdapter();
DataSet2 ds = new DataSet2();
sqlcon.Open();
sqlcom.CommandType = CommandType.Text;
sqlDA.SelectCommand = sqlcom;
sqlDA.Fill(ds, "useracc");
// dataGridView1.DataSource = ds;
// dataGridView1.DataMember = "tbl_penalty";
useracc cry = new useracc();
cry.SetDataSource(ds);
crystalReportViewer1.ReportSource = cry;
sqlcon.Close();
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["connectme"].ConnectionString);
SqlCommand cmd = new SqlCommand("SELECT dbo.GLedger.Date, dbo.GLedger.Naration, ISNULL(dbo.GLedger.Debit, 0) AS Debit, ISNULL(dbo.GLedger.Credit, 0) AS Credit, dbo.GLedger.Balance, dbo.GLedger.[user] FROM dbo.credit_sales LEFT OUTER JOIN dbo.Credit_Customers ON dbo.credit_sales.credit_customerID = dbo.Credit_Customers.credit_customerID LEFT OUTER JOIN dbo.GLedger ON dbo.Credit_Customers.credit_customerID = dbo.GLedger.credit_customerID LEFT OUTER JOIN dbo.creditPayment ON dbo.GLedger.credit_customerID = dbo.creditPayment.credit_customerID WHERE (dbo.Credit_Customers.BussinessName = '" + cmbCreditorsName.Text + "') AND (dbo.GLedger.Date BETWEEN '" + dateTimePicker1.Value + "' AND '" + dateTimePicker2.Value + "') GROUP BY ISNULL(dbo.GLedger.Debit, 0), ISNULL(dbo.GLedger.Credit, 0), dbo.GLedger.Balance, dbo.GLedger.credit_customerID, dbo.Credit_Customers.BussinessName, dbo.GLedger.Naration, dbo.GLedger.Date, dbo.GLedger.[user]", conn);
SqlDataAdapter dscmd = new SqlDataAdapter(cmd);
DataSet2 ds = new DataSet2();
dscmd.Fill(ds, "GLedger");
ds.Tables[0].TableName = "GLedger";
CrystalReportcreditor objRpt = new CrystalReportcreditor();
objRpt.SetDataSource(ds);
objRpt.SetParameterValue("Name", cmbCreditorsName.Text);
objRpt.SetParameterValue("Telephone", tel);
objRpt.SetParameterValue("Address", Add);
//objRpt.SetDataSource(ds.GLedger.Select(c => new
//{
// Date = c.Date,
// Naration = c.Naration,
// Debit = c.Debit,
// Credit = c.Credit,
// Balance = c.Balance,
// user = c.user
//}));
//this.CrystalReportcreditor1.reo
crystalReportViewer1.ReportSource = objRpt;
crystalReportViewer1.Refresh();
////}
}
}//Access the Report Header
#region populate DataSet with data from Query For Fuel General Report
public DataSet2 GetData(string fromDate, string toDate)
{
DataSet2 dsCustomers = new DataSet2();
try
{
using (SqlCommand cmd = new SqlCommand(@"select l.LOC_LOC_NAME as Location,
substring(FIN_DOC_DATE,4,3) + substring(FIN_DOC_DATE,1,3)+substring(FIN_DOC_DATE,7,4) as [Date],
FIN_DOC_TIME as [Time], FIN_REFARANCE as [Bill : No :], v.VHC_MST_NO as [Vehicle No:],e1.Name1 as [Security Person], e.Name1 as [ISSUE Person],
FIN_MILEAGE as [Vehicle M:R:], FIN_QTY as [Diesel Qty], FIN_ST_METER as [Fuel Pump OPE:M:R:], FIN_ED_METER as [Fuel Pump CLO:M:R:]
FROM FUEL_TMP_ISSUE_HEADER_SUB as main Inner Join LOCATION AS l ON main.FIN_LOC_LOC_CODE = l.LOC_LOC_CODE INNER JOIN
ITEM_MASTER as i on main.FIN_ITEM_CODE=i.IT_MST_CODE inner join VEHICLE_MASTER as v on main.FIN_VEHICLE_CODE=v.VHC_MST_CODE inner join
EMPLOYEE_MASTER as e on main.FIN_ISSUE_PERSON_NAME=e.EMP_CODE inner join EMPLOYEE_MASTER as e1 on main.FIN_SECURITY=e1.EMP_CODE inner join
EMPLOYEE_MASTER as e2 on main.FIN_AUTORIZED=e2.EMP_CODE inner join SECURITY_HEADER as s on main.USER_CODE=s.SEC_HDR_CODE
where Cast(FIN_DOC_DATE as datetime) >= '" + Convert.ToDateTime(fromDate).ToString("MM/dd/yyyy") + "' and Cast(FIN_DOC_DATE as datetime) <= '" + Convert.ToDateTime(toDate).ToString("MM/dd/yyyy") + "' ORDER BY FIN_DOC_INDEX DESC"))
{
using (SqlDataAdapter sda = new SqlDataAdapter())
{ cmd.Connection = conn; sda.SelectCommand = cmd; sda.Fill(dsCustomers, "DataTable1"); }
}
}
catch (Exception ex) { MessageBox.Show("ReportAccess class \n" + ex.Message.ToString(), "GetData", MessageBoxButtons.OK, MessageBoxIcon.Hand); }
return(dsCustomers);
}
public virtual int Update(DataSet2 dataSet) {
return this.Adapter.Update(dataSet, "停车场收费统计");
}
public virtual int Update(DataSet2.停车场收费统计DataTable dataTable) {
return this.Adapter.Update(dataTable);
}
public virtual int Fill(DataSet2.停车场收费统计DataTable dataTable) {
this.Adapter.SelectCommand = this.CommandCollection[0];
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
public Form2(DataSet2 ds)
{
data_set = ds;
InitializeComponent();
}
public Form3(DataSet2 ds)
{
data_set = ds;
InitializeComponent();
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.dtFrom = new System.Windows.Forms.DateTimePicker();
this.label3 = new System.Windows.Forms.Label();
this.label4 = new System.Windows.Forms.Label();
this.label6 = new System.Windows.Forms.Label();
this.dtTo = new System.Windows.Forms.DateTimePicker();
this.label7 = new System.Windows.Forms.Label();
this.tbFh = new System.Windows.Forms.MaskedTextBox();
this.label8 = new System.Windows.Forms.Label();
this.tbFs = new System.Windows.Forms.MaskedTextBox();
this.tbTm = new System.Windows.Forms.MaskedTextBox();
this.tbSoThe = new System.Windows.Forms.MaskedTextBox();
this.tbFm = new System.Windows.Forms.MaskedTextBox();
this.tbTs = new System.Windows.Forms.MaskedTextBox();
this.label10 = new System.Windows.Forms.Label();
this.tbTh = new System.Windows.Forms.MaskedTextBox();
this.label9 = new System.Windows.Forms.Label();
this.button1 = new System.Windows.Forms.Button();
this.label5 = new System.Windows.Forms.Label();
this.tbSoTrace = new System.Windows.Forms.TextBox();
this.rbPayment = new System.Windows.Forms.RadioButton();
this.label2 = new System.Windows.Forms.Label();
this.rbATM_POS = new System.Windows.Forms.RadioButton();
this.groupBox2 = new System.Windows.Forms.GroupBox();
this.dataGridView1 = new System.Windows.Forms.DataGridView();
this.groupBox1 = new System.Windows.Forms.GroupBox();
this.label1 = new System.Windows.Forms.Label();
this.groupBox3 = new System.Windows.Forms.GroupBox();
this.rbBNK_ISS = new System.Windows.Forms.RadioButton();
this.rbBNK_ACQ = new System.Windows.Forms.RadioButton();
this.dataSet21 = new BanknetDomestic.DataSet2();
this.label11 = new System.Windows.Forms.Label();
this.label12 = new System.Windows.Forms.Label();
this.groupBox2.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).BeginInit();
this.groupBox1.SuspendLayout();
this.groupBox3.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dataSet21)).BeginInit();
this.SuspendLayout();
//
// dtFrom
//
this.dtFrom.Format = System.Windows.Forms.DateTimePickerFormat.Short;
this.dtFrom.Location = new System.Drawing.Point(100, 20);
this.dtFrom.Name = "dtFrom";
this.dtFrom.Size = new System.Drawing.Size(89, 20);
this.dtFrom.TabIndex = 7;
//
// label3
//
this.label3.AutoSize = true;
this.label3.Location = new System.Drawing.Point(32, 22);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(54, 13);
this.label3.TabIndex = 4;
this.label3.Text = "From date";
//
// label4
//
this.label4.AutoSize = true;
this.label4.Location = new System.Drawing.Point(32, 48);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(44, 13);
this.label4.TabIndex = 5;
this.label4.Text = "To date";
//
// label6
//
this.label6.AutoSize = true;
this.label6.Location = new System.Drawing.Point(308, 48);
this.label6.Name = "label6";
this.label6.Size = new System.Drawing.Size(17, 13);
this.label6.TabIndex = 51;
this.label6.Text = "ss";
//
// dtTo
//
this.dtTo.Format = System.Windows.Forms.DateTimePickerFormat.Short;
this.dtTo.Location = new System.Drawing.Point(100, 44);
this.dtTo.Name = "dtTo";
this.dtTo.Size = new System.Drawing.Size(89, 20);
this.dtTo.TabIndex = 8;
//
// label7
//
this.label7.AutoSize = true;
this.label7.Location = new System.Drawing.Point(256, 48);
this.label7.Name = "label7";
this.label7.Size = new System.Drawing.Size(17, 13);
this.label7.TabIndex = 50;
this.label7.Text = "mi";
//
// tbFh
//
this.tbFh.Location = new System.Drawing.Point(222, 21);
this.tbFh.Mask = "00";
this.tbFh.Name = "tbFh";
this.tbFh.Size = new System.Drawing.Size(33, 20);
this.tbFh.TabIndex = 40;
this.tbFh.Text = "23";
//
// label8
//
this.label8.AutoSize = true;
this.label8.Location = new System.Drawing.Point(189, 48);
this.label8.Name = "label8";
this.label8.Size = new System.Drawing.Size(31, 13);
this.label8.TabIndex = 49;
this.label8.Text = "hh24";
//
// tbFs
//
this.tbFs.Location = new System.Drawing.Point(326, 21);
this.tbFs.Mask = "00";
this.tbFs.Name = "tbFs";
this.tbFs.Size = new System.Drawing.Size(33, 20);
this.tbFs.TabIndex = 42;
this.tbFs.Text = "00";
//
// tbTm
//
this.tbTm.Location = new System.Drawing.Point(275, 45);
this.tbTm.Mask = "00";
this.tbTm.Name = "tbTm";
this.tbTm.Size = new System.Drawing.Size(33, 20);
this.tbTm.TabIndex = 46;
this.tbTm.Text = "59";
//
// tbSoThe
//
this.tbSoThe.Culture = new System.Globalization.CultureInfo("vi-VN");
this.tbSoThe.Location = new System.Drawing.Point(90, 12);
this.tbSoThe.Margin = new System.Windows.Forms.Padding(2);
this.tbSoThe.Mask = "0000 0000 0000 0000";
this.tbSoThe.Name = "tbSoThe";
this.tbSoThe.Size = new System.Drawing.Size(117, 20);
this.tbSoThe.TabIndex = 138;
//
// tbFm
//
this.tbFm.Location = new System.Drawing.Point(275, 21);
this.tbFm.Mask = "00";
this.tbFm.Name = "tbFm";
this.tbFm.Size = new System.Drawing.Size(33, 20);
this.tbFm.TabIndex = 41;
this.tbFm.Text = "00";
//
// tbTs
//
this.tbTs.Location = new System.Drawing.Point(326, 45);
this.tbTs.Mask = "00";
this.tbTs.Name = "tbTs";
this.tbTs.Size = new System.Drawing.Size(33, 20);
this.tbTs.TabIndex = 47;
this.tbTs.Text = "59";
//
// label10
//
this.label10.AutoSize = true;
this.label10.Location = new System.Drawing.Point(189, 24);
this.label10.Name = "label10";
this.label10.Size = new System.Drawing.Size(31, 13);
this.label10.TabIndex = 44;
this.label10.Text = "hh24";
//
// tbTh
//
this.tbTh.Location = new System.Drawing.Point(222, 45);
this.tbTh.Mask = "00";
this.tbTh.Name = "tbTh";
this.tbTh.Size = new System.Drawing.Size(33, 20);
this.tbTh.TabIndex = 43;
this.tbTh.Text = "22";
//
// label9
//
this.label9.AutoSize = true;
this.label9.Location = new System.Drawing.Point(256, 24);
this.label9.Name = "label9";
this.label9.Size = new System.Drawing.Size(17, 13);
this.label9.TabIndex = 45;
this.label9.Text = "mi";
//
// button1
//
this.button1.Location = new System.Drawing.Point(22, 188);
this.button1.Name = "button1";
this.button1.Size = new System.Drawing.Size(75, 23);
this.button1.TabIndex = 142;
this.button1.Text = "View";
this.button1.UseVisualStyleBackColor = true;
this.button1.Click += new System.EventHandler(this.button1_Click);
//
// label5
//
this.label5.AutoSize = true;
this.label5.Location = new System.Drawing.Point(308, 24);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(17, 13);
this.label5.TabIndex = 48;
this.label5.Text = "ss";
//
// tbSoTrace
//
this.tbSoTrace.Location = new System.Drawing.Point(315, 12);
this.tbSoTrace.MaxLength = 6;
this.tbSoTrace.Name = "tbSoTrace";
this.tbSoTrace.Size = new System.Drawing.Size(110, 20);
this.tbSoTrace.TabIndex = 141;
//
// rbPayment
//
this.rbPayment.AutoSize = true;
this.rbPayment.Checked = true;
this.rbPayment.Location = new System.Drawing.Point(49, 19);
this.rbPayment.Name = "rbPayment";
this.rbPayment.Size = new System.Drawing.Size(66, 17);
this.rbPayment.TabIndex = 8;
this.rbPayment.TabStop = true;
this.rbPayment.Text = "Payment";
this.rbPayment.UseVisualStyleBackColor = true;
//
// label2
//
this.label2.AutoSize = true;
this.label2.Location = new System.Drawing.Point(233, 15);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(51, 13);
this.label2.TabIndex = 140;
this.label2.Text = "Số Trace";
//
// rbATM_POS
//
this.rbATM_POS.AutoSize = true;
this.rbATM_POS.Location = new System.Drawing.Point(49, 42);
this.rbATM_POS.Name = "rbATM_POS";
this.rbATM_POS.Size = new System.Drawing.Size(75, 17);
this.rbATM_POS.TabIndex = 9;
this.rbATM_POS.Text = "ATM/POS";
this.rbATM_POS.UseVisualStyleBackColor = true;
this.rbATM_POS.CheckedChanged += new System.EventHandler(this.rbATM_POS_CheckedChanged);
//
// groupBox2
//
this.groupBox2.Controls.Add(this.label12);
this.groupBox2.Controls.Add(this.label11);
this.groupBox2.Controls.Add(this.dtFrom);
this.groupBox2.Controls.Add(this.label3);
this.groupBox2.Controls.Add(this.label4);
this.groupBox2.Controls.Add(this.label6);
this.groupBox2.Controls.Add(this.dtTo);
this.groupBox2.Controls.Add(this.label7);
this.groupBox2.Controls.Add(this.tbFh);
this.groupBox2.Controls.Add(this.label8);
this.groupBox2.Controls.Add(this.tbFs);
this.groupBox2.Controls.Add(this.tbTm);
this.groupBox2.Controls.Add(this.tbFm);
this.groupBox2.Controls.Add(this.tbTs);
this.groupBox2.Controls.Add(this.label10);
this.groupBox2.Controls.Add(this.tbTh);
this.groupBox2.Controls.Add(this.label9);
this.groupBox2.Controls.Add(this.label5);
this.groupBox2.Location = new System.Drawing.Point(11, 114);
this.groupBox2.Name = "groupBox2";
this.groupBox2.Size = new System.Drawing.Size(531, 72);
this.groupBox2.TabIndex = 145;
this.groupBox2.TabStop = false;
this.groupBox2.Text = "Thời gian";
//
// dataGridView1
//
this.dataGridView1.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom)
| System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.dataGridView1.BackgroundColor = System.Drawing.SystemColors.Control;
this.dataGridView1.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;
this.dataGridView1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this.dataGridView1.Location = new System.Drawing.Point(4, 219);
this.dataGridView1.Margin = new System.Windows.Forms.Padding(2);
this.dataGridView1.Name = "dataGridView1";
this.dataGridView1.ReadOnly = true;
this.dataGridView1.RowTemplate.Height = 24;
this.dataGridView1.Size = new System.Drawing.Size(807, 255);
this.dataGridView1.TabIndex = 144;
//
// groupBox1
//
this.groupBox1.Controls.Add(this.rbPayment);
this.groupBox1.Controls.Add(this.rbATM_POS);
this.groupBox1.Location = new System.Drawing.Point(35, 37);
this.groupBox1.Name = "groupBox1";
this.groupBox1.Size = new System.Drawing.Size(196, 73);
this.groupBox1.TabIndex = 143;
this.groupBox1.TabStop = false;
this.groupBox1.Text = "Option";
//
// label1
//
this.label1.AutoSize = true;
this.label1.Location = new System.Drawing.Point(24, 15);
this.label1.Margin = new System.Windows.Forms.Padding(2, 0, 2, 0);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(38, 13);
this.label1.TabIndex = 139;
this.label1.Text = "Số thẻ";
//
// groupBox3
//
this.groupBox3.Controls.Add(this.rbBNK_ISS);
this.groupBox3.Controls.Add(this.rbBNK_ACQ);
this.groupBox3.Location = new System.Drawing.Point(260, 38);
this.groupBox3.Name = "groupBox3";
this.groupBox3.Size = new System.Drawing.Size(165, 72);
this.groupBox3.TabIndex = 146;
this.groupBox3.TabStop = false;
this.groupBox3.Text = "ATM/POS";
this.groupBox3.Visible = false;
//
// rbBNK_ISS
//
this.rbBNK_ISS.AutoSize = true;
this.rbBNK_ISS.Checked = true;
this.rbBNK_ISS.Location = new System.Drawing.Point(45, 16);
this.rbBNK_ISS.Name = "rbBNK_ISS";
this.rbBNK_ISS.Size = new System.Drawing.Size(53, 17);
this.rbBNK_ISS.TabIndex = 10;
this.rbBNK_ISS.TabStop = true;
this.rbBNK_ISS.Text = "Issuer";
this.rbBNK_ISS.UseVisualStyleBackColor = true;
//
// rbBNK_ACQ
//
this.rbBNK_ACQ.AutoSize = true;
this.rbBNK_ACQ.Location = new System.Drawing.Point(45, 41);
this.rbBNK_ACQ.Name = "rbBNK_ACQ";
this.rbBNK_ACQ.Size = new System.Drawing.Size(64, 17);
this.rbBNK_ACQ.TabIndex = 11;
this.rbBNK_ACQ.Text = "Acquirer";
this.rbBNK_ACQ.UseVisualStyleBackColor = true;
//
// dataSet21
//
this.dataSet21.DataSetName = "DataSet2";
this.dataSet21.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// label11
//
this.label11.AutoSize = true;
this.label11.Location = new System.Drawing.Point(388, 26);
this.label11.Name = "label11";
this.label11.Size = new System.Drawing.Size(124, 13);
this.label11.TabIndex = 52;
this.label11.Text = "(dd/mm/yyyy hh24:mi:ss)";
//
// label12
//
this.label12.AutoSize = true;
this.label12.Location = new System.Drawing.Point(388, 48);
this.label12.Name = "label12";
this.label12.Size = new System.Drawing.Size(124, 13);
this.label12.TabIndex = 52;
this.label12.Text = "(dd/mm/yyyy hh24:mi:ss)";
//
// Frm_Check_Banknet_Transaction
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(822, 485);
this.Controls.Add(this.groupBox3);
this.Controls.Add(this.tbSoThe);
this.Controls.Add(this.button1);
this.Controls.Add(this.tbSoTrace);
this.Controls.Add(this.label2);
this.Controls.Add(this.groupBox2);
this.Controls.Add(this.dataGridView1);
this.Controls.Add(this.groupBox1);
this.Controls.Add(this.label1);
this.Name = "Frm_Check_Banknet_Transaction";
this.Text = "Frm_Check_Banknet_Transaction";
this.Load += new System.EventHandler(this.Frm_Check_Banknet_Transaction_Load);
this.groupBox2.ResumeLayout(false);
this.groupBox2.PerformLayout();
((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).EndInit();
this.groupBox1.ResumeLayout(false);
this.groupBox1.PerformLayout();
this.groupBox3.ResumeLayout(false);
this.groupBox3.PerformLayout();
((System.ComponentModel.ISupportInitialize)(this.dataSet21)).EndInit();
this.ResumeLayout(false);
this.PerformLayout();
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.components = new System.ComponentModel.Container();
System.Windows.Forms.Label t_idLabel;
System.Windows.Forms.Label t_dateLabel;
System.Windows.Forms.Label t_amountLabel;
System.Windows.Forms.Label name_address_1Label;
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle1 = new System.Windows.Forms.DataGridViewCellStyle();
this.t_idTextBox = new System.Windows.Forms.TextBox();
this.customer_transBindingSource = new System.Windows.Forms.BindingSource(this.components);
this.dataSet2 = new Vectra.DataSet2();
this.t_dateDateTimePicker = new System.Windows.Forms.DateTimePicker();
this.t_amountTextBox = new System.Windows.Forms.TextBox();
this.name_address_1TextBox = new System.Windows.Forms.TextBox();
this.customerBindingSource = new System.Windows.Forms.BindingSource(this.components);
this.cust_idTextBox = new System.Windows.Forms.TextBox();
this.btnDelete = new System.Windows.Forms.Button();
this.sqLiteConnection1 = new Devart.Data.SQLite.SQLiteConnection();
this.iNVOICE_RECIEPTSDataGridView = new System.Windows.Forms.DataGridView();
this.dataGridViewTextBoxColumn9 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn12 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn11 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn10 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.invoice_key = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.iNVOICE_RECIEPTSBindingSource = new System.Windows.Forms.BindingSource(this.components);
this.iNVOICE_HEADERBindingSource = new System.Windows.Forms.BindingSource(this.components);
this.customer_transTableAdapter = new Vectra.DataSet2TableAdapters.customer_transTableAdapter();
this.tableAdapterManager = new Vectra.DataSet2TableAdapters.TableAdapterManager();
this.customerTableAdapter = new Vectra.DataSet2TableAdapters.customerTableAdapter();
this.iNVOICE_HEADERTableAdapter = new Vectra.DataSet2TableAdapters.INVOICE_HEADERTableAdapter();
this.iNVOICE_RECIEPTSTableAdapter = new Vectra.DataSet2TableAdapters.INVOICE_RECIEPTSTableAdapter();
t_idLabel = new System.Windows.Forms.Label();
t_dateLabel = new System.Windows.Forms.Label();
t_amountLabel = new System.Windows.Forms.Label();
name_address_1Label = new System.Windows.Forms.Label();
((System.ComponentModel.ISupportInitialize)(this.customer_transBindingSource)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dataSet2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.customerBindingSource)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.iNVOICE_RECIEPTSDataGridView)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.iNVOICE_RECIEPTSBindingSource)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.iNVOICE_HEADERBindingSource)).BeginInit();
this.SuspendLayout();
//
// t_idLabel
//
t_idLabel.AutoSize = true;
t_idLabel.Location = new System.Drawing.Point(12, 45);
t_idLabel.Name = "t_idLabel";
t_idLabel.Size = new System.Drawing.Size(80, 13);
t_idLabel.TabIndex = 2;
t_idLabel.Text = "Transaction ID:";
//
// t_dateLabel
//
t_dateLabel.AutoSize = true;
t_dateLabel.Location = new System.Drawing.Point(233, 45);
t_dateLabel.Name = "t_dateLabel";
t_dateLabel.Size = new System.Drawing.Size(73, 13);
t_dateLabel.TabIndex = 10;
t_dateLabel.Text = "Receipt Date:";
//
// t_amountLabel
//
t_amountLabel.AutoSize = true;
t_amountLabel.Location = new System.Drawing.Point(473, 45);
t_amountLabel.Name = "t_amountLabel";
t_amountLabel.Size = new System.Drawing.Size(46, 13);
t_amountLabel.TabIndex = 16;
t_amountLabel.Text = "Amount:";
//
// name_address_1Label
//
name_address_1Label.AutoSize = true;
name_address_1Label.Location = new System.Drawing.Point(41, 12);
name_address_1Label.Name = "name_address_1Label";
name_address_1Label.Size = new System.Drawing.Size(51, 13);
name_address_1Label.TabIndex = 20;
name_address_1Label.Text = "Customer";
//
// t_idTextBox
//
this.t_idTextBox.BackColor = System.Drawing.SystemColors.ActiveCaptionText;
this.t_idTextBox.BorderStyle = System.Windows.Forms.BorderStyle.None;
this.t_idTextBox.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.customer_transBindingSource, "t_id", true));
this.t_idTextBox.Location = new System.Drawing.Point(98, 45);
this.t_idTextBox.Name = "t_idTextBox";
this.t_idTextBox.ReadOnly = true;
this.t_idTextBox.Size = new System.Drawing.Size(112, 13);
this.t_idTextBox.TabIndex = 0;
this.t_idTextBox.TabStop = false;
//
// customer_transBindingSource
//
this.customer_transBindingSource.DataMember = "customer_trans";
this.customer_transBindingSource.DataSource = this.dataSet2;
//
// dataSet2
//
this.dataSet2.DataSetName = "DataSet2";
this.dataSet2.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// t_dateDateTimePicker
//
this.t_dateDateTimePicker.DataBindings.Add(new System.Windows.Forms.Binding("Value", this.customer_transBindingSource, "t_date", true));
this.t_dateDateTimePicker.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.customer_transBindingSource, "t_date", true));
this.t_dateDateTimePicker.Format = System.Windows.Forms.DateTimePickerFormat.Short;
this.t_dateDateTimePicker.Location = new System.Drawing.Point(312, 41);
this.t_dateDateTimePicker.Name = "t_dateDateTimePicker";
this.t_dateDateTimePicker.Size = new System.Drawing.Size(121, 20);
this.t_dateDateTimePicker.TabIndex = 1;
//
// t_amountTextBox
//
this.t_amountTextBox.BorderStyle = System.Windows.Forms.BorderStyle.None;
this.t_amountTextBox.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.customer_transBindingSource, "t_amount", true));
this.t_amountTextBox.Location = new System.Drawing.Point(525, 45);
this.t_amountTextBox.Name = "t_amountTextBox";
this.t_amountTextBox.Size = new System.Drawing.Size(139, 13);
this.t_amountTextBox.TabIndex = 2;
//
// name_address_1TextBox
//
this.name_address_1TextBox.BackColor = System.Drawing.SystemColors.ActiveCaptionText;
this.name_address_1TextBox.BorderStyle = System.Windows.Forms.BorderStyle.None;
this.name_address_1TextBox.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.customerBindingSource, "name_address_1", true));
this.name_address_1TextBox.ForeColor = System.Drawing.SystemColors.WindowText;
this.name_address_1TextBox.Location = new System.Drawing.Point(236, 12);
this.name_address_1TextBox.Name = "name_address_1TextBox";
this.name_address_1TextBox.ReadOnly = true;
this.name_address_1TextBox.Size = new System.Drawing.Size(526, 13);
this.name_address_1TextBox.TabIndex = 21;
this.name_address_1TextBox.TabStop = false;
//
// customerBindingSource
//
this.customerBindingSource.DataMember = "customer";
this.customerBindingSource.DataSource = this.dataSet2;
//
// cust_idTextBox
//
this.cust_idTextBox.BackColor = System.Drawing.SystemColors.ActiveCaptionText;
this.cust_idTextBox.BorderStyle = System.Windows.Forms.BorderStyle.None;
this.cust_idTextBox.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.customerBindingSource, "cust_id", true));
this.cust_idTextBox.Location = new System.Drawing.Point(98, 12);
this.cust_idTextBox.Name = "cust_idTextBox";
this.cust_idTextBox.ReadOnly = true;
this.cust_idTextBox.Size = new System.Drawing.Size(112, 13);
this.cust_idTextBox.TabIndex = 23;
this.cust_idTextBox.TabStop = false;
//
// btnDelete
//
this.btnDelete.Location = new System.Drawing.Point(550, 99);
this.btnDelete.Name = "btnDelete";
this.btnDelete.Size = new System.Drawing.Size(87, 34);
this.btnDelete.TabIndex = 3;
this.btnDelete.Text = "Delete";
this.btnDelete.UseVisualStyleBackColor = true;
this.btnDelete.Click += new System.EventHandler(this.btnDelete_Click);
//
// sqLiteConnection1
//
this.sqLiteConnection1.ConnectionString = "Data Source=\"C:\\Documents and Settings\\All Users\\Application Data\\Vectra\\Data\\PRO" +
"D.db3\";";
this.sqLiteConnection1.Name = "sqLiteConnection1";
this.sqLiteConnection1.Owner = this;
//
// iNVOICE_RECIEPTSDataGridView
//
this.iNVOICE_RECIEPTSDataGridView.AllowUserToAddRows = false;
dataGridViewCellStyle1.BackColor = System.Drawing.Color.Silver;
this.iNVOICE_RECIEPTSDataGridView.AlternatingRowsDefaultCellStyle = dataGridViewCellStyle1;
this.iNVOICE_RECIEPTSDataGridView.AutoGenerateColumns = false;
this.iNVOICE_RECIEPTSDataGridView.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this.iNVOICE_RECIEPTSDataGridView.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {
this.dataGridViewTextBoxColumn9,
this.dataGridViewTextBoxColumn12,
this.dataGridViewTextBoxColumn11,
this.dataGridViewTextBoxColumn10,
this.invoice_key});
this.iNVOICE_RECIEPTSDataGridView.DataSource = this.iNVOICE_RECIEPTSBindingSource;
this.iNVOICE_RECIEPTSDataGridView.Location = new System.Drawing.Point(15, 99);
this.iNVOICE_RECIEPTSDataGridView.Name = "iNVOICE_RECIEPTSDataGridView";
this.iNVOICE_RECIEPTSDataGridView.RowHeadersVisible = false;
this.iNVOICE_RECIEPTSDataGridView.Size = new System.Drawing.Size(465, 151);
this.iNVOICE_RECIEPTSDataGridView.TabIndex = 28;
//
// dataGridViewTextBoxColumn9
//
this.dataGridViewTextBoxColumn9.DataPropertyName = "recpt_number";
this.dataGridViewTextBoxColumn9.HeaderText = "Receipt No";
this.dataGridViewTextBoxColumn9.Name = "dataGridViewTextBoxColumn9";
//
// dataGridViewTextBoxColumn12
//
this.dataGridViewTextBoxColumn12.DataPropertyName = "invoice_number";
this.dataGridViewTextBoxColumn12.HeaderText = "Invoice No.";
this.dataGridViewTextBoxColumn12.Name = "dataGridViewTextBoxColumn12";
//
// dataGridViewTextBoxColumn11
//
this.dataGridViewTextBoxColumn11.DataPropertyName = "recpt_date";
this.dataGridViewTextBoxColumn11.HeaderText = "Date";
this.dataGridViewTextBoxColumn11.Name = "dataGridViewTextBoxColumn11";
//
// dataGridViewTextBoxColumn10
//
this.dataGridViewTextBoxColumn10.DataPropertyName = "amount";
this.dataGridViewTextBoxColumn10.HeaderText = "Amount";
this.dataGridViewTextBoxColumn10.Name = "dataGridViewTextBoxColumn10";
//
// invoice_key
//
this.invoice_key.DataPropertyName = "invoice_key";
this.invoice_key.HeaderText = "invoice_key";
this.invoice_key.Name = "invoice_key";
this.invoice_key.Visible = false;
//
// iNVOICE_RECIEPTSBindingSource
//
this.iNVOICE_RECIEPTSBindingSource.DataMember = "INVOICE_RECIEPTS";
this.iNVOICE_RECIEPTSBindingSource.DataSource = this.dataSet2;
//
// iNVOICE_HEADERBindingSource
//
this.iNVOICE_HEADERBindingSource.DataMember = "INVOICE_HEADER";
this.iNVOICE_HEADERBindingSource.DataSource = this.dataSet2;
//
// customer_transTableAdapter
//
this.customer_transTableAdapter.ClearBeforeFill = true;
//
// tableAdapterManager
//
this.tableAdapterManager.BackupDataSetBeforeUpdate = false;
this.tableAdapterManager.configurationTableAdapter = null;
this.tableAdapterManager.customer_transTableAdapter = this.customer_transTableAdapter;
this.tableAdapterManager.customerTableAdapter = this.customerTableAdapter;
this.tableAdapterManager.debtors_summaryTableAdapter = null;
this.tableAdapterManager.debtorsTableAdapter = null;
this.tableAdapterManager.gl_categoryTableAdapter = null;
this.tableAdapterManager.gl_txnsTableAdapter = null;
this.tableAdapterManager.glTableAdapter = null;
this.tableAdapterManager.INVOICE_HEADERTableAdapter = this.iNVOICE_HEADERTableAdapter;
this.tableAdapterManager.invoice_itemsTableAdapter = null;
this.tableAdapterManager.INVOICE_RECIEPTSTableAdapter = this.iNVOICE_RECIEPTSTableAdapter;
this.tableAdapterManager.payment_typeTableAdapter = null;
this.tableAdapterManager.PaymentAdjustRptTableAdapter = null;
this.tableAdapterManager.product_typeTableAdapter = null;
this.tableAdapterManager.ProductSalesReportTableAdapter = null;
this.tableAdapterManager.ProductSalesSummaryTableAdapter = null;
this.tableAdapterManager.productsTableAdapter = null;
this.tableAdapterManager.SalesSummary1TableAdapter = null;
this.tableAdapterManager.sqlite_sequenceTableAdapter = null;
this.tableAdapterManager.UpdateOrder = Vectra.DataSet2TableAdapters.TableAdapterManager.UpdateOrderOption.InsertUpdateDelete;
//
// customerTableAdapter
//
this.customerTableAdapter.ClearBeforeFill = true;
//
// iNVOICE_HEADERTableAdapter
//
this.iNVOICE_HEADERTableAdapter.ClearBeforeFill = true;
//
// iNVOICE_RECIEPTSTableAdapter
//
this.iNVOICE_RECIEPTSTableAdapter.ClearBeforeFill = true;
//
// ReceiptEdit
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.BackColor = System.Drawing.SystemColors.Control;
this.ClientSize = new System.Drawing.Size(766, 263);
this.Controls.Add(this.iNVOICE_RECIEPTSDataGridView);
this.Controls.Add(this.btnDelete);
this.Controls.Add(this.cust_idTextBox);
this.Controls.Add(name_address_1Label);
this.Controls.Add(this.name_address_1TextBox);
this.Controls.Add(t_idLabel);
this.Controls.Add(this.t_idTextBox);
this.Controls.Add(t_dateLabel);
this.Controls.Add(this.t_dateDateTimePicker);
this.Controls.Add(t_amountLabel);
this.Controls.Add(this.t_amountTextBox);
this.ForeColor = System.Drawing.SystemColors.WindowText;
this.Name = "ReceiptEdit";
this.Text = "Receipts";
this.Load += new System.EventHandler(this.Receipts_Load);
((System.ComponentModel.ISupportInitialize)(this.customer_transBindingSource)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dataSet2)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.customerBindingSource)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.iNVOICE_RECIEPTSDataGridView)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.iNVOICE_RECIEPTSBindingSource)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.iNVOICE_HEADERBindingSource)).EndInit();
this.ResumeLayout(false);
this.PerformLayout();
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.groupBox3 = new System.Windows.Forms.GroupBox();
this.tbH4 = new System.Windows.Forms.TextBox();
this.tbH2 = new System.Windows.Forms.TextBox();
this.tbY2 = new System.Windows.Forms.TextBox();
this.tbB2 = new System.Windows.Forms.TextBox();
this.label14 = new System.Windows.Forms.Label();
this.label13 = new System.Windows.Forms.Label();
this.label12 = new System.Windows.Forms.Label();
this.label11 = new System.Windows.Forms.Label();
this.groupBox1 = new System.Windows.Forms.GroupBox();
this.dtFrom = new System.Windows.Forms.DateTimePicker();
this.label2 = new System.Windows.Forms.Label();
this.label3 = new System.Windows.Forms.Label();
this.label6 = new System.Windows.Forms.Label();
this.dtTo = new System.Windows.Forms.DateTimePicker();
this.label7 = new System.Windows.Forms.Label();
this.tbFh = new System.Windows.Forms.MaskedTextBox();
this.label8 = new System.Windows.Forms.Label();
this.tbFs = new System.Windows.Forms.MaskedTextBox();
this.tbTm = new System.Windows.Forms.MaskedTextBox();
this.tbFm = new System.Windows.Forms.MaskedTextBox();
this.tbTs = new System.Windows.Forms.MaskedTextBox();
this.label10 = new System.Windows.Forms.Label();
this.tbTh = new System.Windows.Forms.MaskedTextBox();
this.label9 = new System.Windows.Forms.Label();
this.label5 = new System.Windows.Forms.Label();
this.button2 = new System.Windows.Forms.Button();
this.btCancel = new System.Windows.Forms.Button();
this.dataSet21 = new BanknetDomestic.DataSet2();
this.dataSet22 = new BanknetDomestic.DataSet2();
this.groupBox3.SuspendLayout();
this.groupBox1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dataSet21)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dataSet22)).BeginInit();
this.SuspendLayout();
//
// groupBox3
//
this.groupBox3.Controls.Add(this.tbH4);
this.groupBox3.Controls.Add(this.tbH2);
this.groupBox3.Controls.Add(this.tbY2);
this.groupBox3.Controls.Add(this.tbB2);
this.groupBox3.Controls.Add(this.label14);
this.groupBox3.Controls.Add(this.label13);
this.groupBox3.Controls.Add(this.label12);
this.groupBox3.Controls.Add(this.label11);
this.groupBox3.Location = new System.Drawing.Point(1, 2);
this.groupBox3.Name = "groupBox3";
this.groupBox3.Size = new System.Drawing.Size(413, 114);
this.groupBox3.TabIndex = 61;
this.groupBox3.TabStop = false;
this.groupBox3.Text = "Payment";
//
// tbH4
//
this.tbH4.Location = new System.Drawing.Point(177, 89);
this.tbH4.Name = "tbH4";
this.tbH4.Size = new System.Drawing.Size(206, 20);
this.tbH4.TabIndex = 61;
//
// tbH2
//
this.tbH2.Location = new System.Drawing.Point(178, 63);
this.tbH2.Name = "tbH2";
this.tbH2.Size = new System.Drawing.Size(206, 20);
this.tbH2.TabIndex = 61;
//
// tbY2
//
this.tbY2.Location = new System.Drawing.Point(99, 37);
this.tbY2.Name = "tbY2";
this.tbY2.Size = new System.Drawing.Size(285, 20);
this.tbY2.TabIndex = 60;
//
// tbB2
//
this.tbB2.Location = new System.Drawing.Point(100, 13);
this.tbB2.Name = "tbB2";
this.tbB2.Size = new System.Drawing.Size(284, 20);
this.tbB2.TabIndex = 59;
//
// label14
//
this.label14.AutoSize = true;
this.label14.Location = new System.Drawing.Point(20, 92);
this.label14.Name = "label14";
this.label14.Size = new System.Drawing.Size(82, 13);
this.label14.TabIndex = 7;
this.label14.Text = "Acquier Tn (H4)";
//
// label13
//
this.label13.AutoSize = true;
this.label13.Location = new System.Drawing.Point(20, 67);
this.label13.Name = "label13";
this.label13.Size = new System.Drawing.Size(152, 13);
this.label13.TabIndex = 7;
this.label13.Text = "Chênh lệch có E-không B (H2)";
//
// label12
//
this.label12.AutoSize = true;
this.label12.Location = new System.Drawing.Point(20, 43);
this.label12.Name = "label12";
this.label12.Size = new System.Drawing.Size(73, 13);
this.label12.TabIndex = 6;
this.label12.Text = "Phát sinh (Y2)";
//
// label11
//
this.label11.AutoSize = true;
this.label11.Location = new System.Drawing.Point(20, 20);
this.label11.Name = "label11";
this.label11.Size = new System.Drawing.Size(63, 13);
this.label11.TabIndex = 5;
this.label11.Text = "Đầu kỳ (B2)";
//
// groupBox1
//
this.groupBox1.Controls.Add(this.dtFrom);
this.groupBox1.Controls.Add(this.label2);
this.groupBox1.Controls.Add(this.label3);
this.groupBox1.Controls.Add(this.label6);
this.groupBox1.Controls.Add(this.dtTo);
this.groupBox1.Controls.Add(this.label7);
this.groupBox1.Controls.Add(this.tbFh);
this.groupBox1.Controls.Add(this.label8);
this.groupBox1.Controls.Add(this.tbFs);
this.groupBox1.Controls.Add(this.tbTm);
this.groupBox1.Controls.Add(this.tbFm);
this.groupBox1.Controls.Add(this.tbTs);
this.groupBox1.Controls.Add(this.label10);
this.groupBox1.Controls.Add(this.tbTh);
this.groupBox1.Controls.Add(this.label9);
this.groupBox1.Controls.Add(this.label5);
this.groupBox1.Location = new System.Drawing.Point(1, 117);
this.groupBox1.Name = "groupBox1";
this.groupBox1.Size = new System.Drawing.Size(413, 93);
this.groupBox1.TabIndex = 62;
this.groupBox1.TabStop = false;
this.groupBox1.Text = "Option";
//
// dtFrom
//
this.dtFrom.Format = System.Windows.Forms.DateTimePickerFormat.Short;
this.dtFrom.Location = new System.Drawing.Point(95, 28);
this.dtFrom.Name = "dtFrom";
this.dtFrom.Size = new System.Drawing.Size(89, 20);
this.dtFrom.TabIndex = 7;
//
// label2
//
this.label2.AutoSize = true;
this.label2.Location = new System.Drawing.Point(27, 30);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(54, 13);
this.label2.TabIndex = 4;
this.label2.Text = "From date";
//
// label3
//
this.label3.AutoSize = true;
this.label3.Location = new System.Drawing.Point(27, 54);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(44, 13);
this.label3.TabIndex = 5;
this.label3.Text = "To date";
//
// label6
//
this.label6.AutoSize = true;
this.label6.Location = new System.Drawing.Point(303, 54);
this.label6.Name = "label6";
this.label6.Size = new System.Drawing.Size(17, 13);
this.label6.TabIndex = 51;
this.label6.Text = "ss";
//
// dtTo
//
this.dtTo.Format = System.Windows.Forms.DateTimePickerFormat.Short;
this.dtTo.Location = new System.Drawing.Point(95, 50);
this.dtTo.Name = "dtTo";
this.dtTo.Size = new System.Drawing.Size(89, 20);
this.dtTo.TabIndex = 8;
//
// label7
//
this.label7.AutoSize = true;
this.label7.Location = new System.Drawing.Point(251, 54);
this.label7.Name = "label7";
this.label7.Size = new System.Drawing.Size(17, 13);
this.label7.TabIndex = 50;
this.label7.Text = "mi";
//
// tbFh
//
this.tbFh.Location = new System.Drawing.Point(217, 29);
this.tbFh.Mask = "00";
this.tbFh.Name = "tbFh";
this.tbFh.Size = new System.Drawing.Size(33, 20);
this.tbFh.TabIndex = 40;
this.tbFh.Text = "23";
//
// label8
//
this.label8.AutoSize = true;
this.label8.Location = new System.Drawing.Point(184, 54);
this.label8.Name = "label8";
this.label8.Size = new System.Drawing.Size(31, 13);
this.label8.TabIndex = 49;
this.label8.Text = "hh24";
//
// tbFs
//
this.tbFs.Location = new System.Drawing.Point(321, 29);
this.tbFs.Mask = "00";
this.tbFs.Name = "tbFs";
this.tbFs.Size = new System.Drawing.Size(33, 20);
this.tbFs.TabIndex = 42;
this.tbFs.Text = "00";
//
// tbTm
//
this.tbTm.Location = new System.Drawing.Point(270, 51);
this.tbTm.Mask = "00";
this.tbTm.Name = "tbTm";
this.tbTm.Size = new System.Drawing.Size(33, 20);
this.tbTm.TabIndex = 46;
this.tbTm.Text = "59";
//
// tbFm
//
this.tbFm.Location = new System.Drawing.Point(270, 29);
this.tbFm.Mask = "00";
this.tbFm.Name = "tbFm";
this.tbFm.Size = new System.Drawing.Size(33, 20);
this.tbFm.TabIndex = 41;
this.tbFm.Text = "00";
//
// tbTs
//
this.tbTs.Location = new System.Drawing.Point(321, 51);
this.tbTs.Mask = "00";
this.tbTs.Name = "tbTs";
this.tbTs.Size = new System.Drawing.Size(33, 20);
this.tbTs.TabIndex = 47;
this.tbTs.Text = "59";
//
// label10
//
this.label10.AutoSize = true;
this.label10.Location = new System.Drawing.Point(184, 32);
this.label10.Name = "label10";
this.label10.Size = new System.Drawing.Size(31, 13);
this.label10.TabIndex = 44;
this.label10.Text = "hh24";
//
// tbTh
//
this.tbTh.Location = new System.Drawing.Point(217, 51);
this.tbTh.Mask = "00";
this.tbTh.Name = "tbTh";
this.tbTh.Size = new System.Drawing.Size(33, 20);
this.tbTh.TabIndex = 43;
this.tbTh.Text = "22";
//
// label9
//
this.label9.AutoSize = true;
this.label9.Location = new System.Drawing.Point(251, 32);
this.label9.Name = "label9";
this.label9.Size = new System.Drawing.Size(17, 13);
this.label9.TabIndex = 45;
this.label9.Text = "mi";
//
// label5
//
this.label5.AutoSize = true;
this.label5.Location = new System.Drawing.Point(303, 32);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(17, 13);
this.label5.TabIndex = 48;
this.label5.Text = "ss";
//
// button2
//
this.button2.Location = new System.Drawing.Point(19, 225);
this.button2.Name = "button2";
this.button2.Size = new System.Drawing.Size(75, 23);
this.button2.TabIndex = 63;
this.button2.Text = "Export";
this.button2.UseVisualStyleBackColor = true;
this.button2.Click += new System.EventHandler(this.button2_Click);
//
// btCancel
//
this.btCancel.Location = new System.Drawing.Point(322, 225);
this.btCancel.Name = "btCancel";
this.btCancel.Size = new System.Drawing.Size(75, 23);
this.btCancel.TabIndex = 64;
this.btCancel.Text = "Cancel";
this.btCancel.UseVisualStyleBackColor = true;
this.btCancel.Click += new System.EventHandler(this.btCancel_Click);
//
// dataSet21
//
this.dataSet21.DataSetName = "DataSet2";
this.dataSet21.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// dataSet22
//
this.dataSet22.DataSetName = "DataSet2";
this.dataSet22.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// Frm_Check_Accounting
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(432, 261);
this.Controls.Add(this.btCancel);
this.Controls.Add(this.button2);
this.Controls.Add(this.groupBox1);
this.Controls.Add(this.groupBox3);
this.Name = "Frm_Check_Accounting";
this.Text = "38. Check Accounting";
this.Load += new System.EventHandler(this.Frm_Check_Accounting_Load);
this.groupBox3.ResumeLayout(false);
this.groupBox3.PerformLayout();
this.groupBox1.ResumeLayout(false);
this.groupBox1.PerformLayout();
((System.ComponentModel.ISupportInitialize)(this.dataSet21)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dataSet22)).EndInit();
this.ResumeLayout(false);
}
public void ImportFromTextFile(string filePath)
{
DataSet2 test = new DataSet2();
StreamReader s = new StreamReader(filePath);
Guid guid = Guid.NewGuid();
test.Tests.AddTestsRow("Test from typed file(by parser v11)", true, "unknown", 3, 3, guid.ToString(), 1, 0);
test.QuestionSets.AddQuestionSetsRow("Set from typed file", "unknown", 0, int.MaxValue, 3, 3, 0, 0, 0);
//Todo Updete Number of question
int correctQiestionNamber = 0;
int curentQuestionNumber = -1;
int numberZone1 = 0;
int numberZone2 = 0;
int numberZone3 = 0;
byte curentAnswerNumber = 0;
DataTable questionSubtypesTable = propv1.GetQuestionSubtypesTable();
while (!s.EndOfStream)
{
string line = s.ReadLine();
while (line == "")
{
line = s.ReadLine();
}
if (line == null)
{
break;
}
if (line[0] == '#')
{
string question = "";
string ts = (line[line.Length - 3].ToString() + line[line.Length - 2].ToString());
int questDifficutly = Convert.ToInt32(ts);
int questionSubType = 0;
switch (questDifficutly)
{
case 25:
questDifficutly = 1;
++numberZone1;
break;
case 50:
questDifficutly = 2;
++numberZone2;
break;
case 75:
questDifficutly = 3;
++numberZone3;
break;
}
//parse questionSubtype
string[] splitedStrs = line.Split(',');
string questionSubtype = splitedStrs[1];
DataRow[] rows = questionSubtypesTable.Select(string.Format("name like '%{0}%'", questionSubtype.Trim()));
if (rows.Length > 0)
{
questionSubType = (int)rows[0]["id"];
}
else
{
if (questionSubtype.Trim() == "WP")
{
questionSubType = (int)BuisinessObjects.Subtype.WordProblems;
}
}
while ((line == "") || (line[1] < 'A') || (line[1] > 'Z'))
{
line = s.ReadLine();
question += line;
}
test.Questions.AddQuestionsRow(1, questionSubType, questDifficutly, question, null);
curentQuestionNumber++;
}
if (line[0] == '(')
{
string answer = "";
while ((line == "") || (line[0] == '('))
{
answer = line;
line = s.ReadLine();
if (answer != "")
{
test.Answers.AddAnswersRow(curentQuestionNumber, answer, false, curentAnswerNumber);
}
curentAnswerNumber++;
}
}
if (line[0] == '{')
{
correctQiestionNamber = (int)(line[1] - 64);
int temp = 0;
for (int i = 0; i < test.Answers.Count; ++i)
{
if (test.Answers[i].QuestionId == curentQuestionNumber)
{
temp++;
}
if (temp == correctQiestionNamber)
{
test.Answers[i].IsCorrect = true;
break;
}
}
string explanation = string.Empty;
while (line != null && line != string.Empty)
{
explanation += line;
line = s.ReadLine();
}
if (!string.IsNullOrEmpty(explanation))
{
test.explanations.AddexplanationsRow(curentQuestionNumber, explanation);
}
}
}
test.QuestionSets[0].NumberOfQuestionsToPick = test.Questions.Count;
test.QuestionSets[0].NumberOfQuestionsInZone1 = numberZone1;
test.QuestionSets[0].NumberOfQuestionsInZone2 = numberZone2;
test.QuestionSets[0].NumberOfQuestionsInZone3 = numberZone3;
//test.QuestionSets[0].QuestionSubtypeId = questionSubType;
test.TestContents.AddTestContentsRow(0, 0, 0);
for (byte i = 0; i < test.Questions.Count; ++i)
{
test.SetsToQuestions.AddSetsToQuestionsRow(0, i, 1, i);
}
provider.SetTest(test);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.components = new System.ComponentModel.Container();
System.Windows.Forms.Label t_idLabel;
System.Windows.Forms.Label t_typeLabel;
System.Windows.Forms.Label t_cust_idLabel;
System.Windows.Forms.Label t_ref_idLabel;
System.Windows.Forms.Label t_dateLabel;
System.Windows.Forms.Label t_noteLabel;
System.Windows.Forms.Label t_amountLabel;
System.Windows.Forms.Label t_src_idLabel;
System.Windows.Forms.Label name_address_1Label;
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle5 = new System.Windows.Forms.DataGridViewCellStyle();
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle6 = new System.Windows.Forms.DataGridViewCellStyle();
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle7 = new System.Windows.Forms.DataGridViewCellStyle();
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle8 = new System.Windows.Forms.DataGridViewCellStyle();
this.t_idTextBox = new System.Windows.Forms.TextBox();
this.customer_transBindingSource = new System.Windows.Forms.BindingSource(this.components);
this.dataSet2 = new Vectra.DataSet2();
this.t_typeTextBox = new System.Windows.Forms.TextBox();
this.t_cust_idTextBox = new System.Windows.Forms.TextBox();
this.t_ref_idTextBox = new System.Windows.Forms.TextBox();
this.t_dateDateTimePicker = new System.Windows.Forms.DateTimePicker();
this.t_noteTextBox = new System.Windows.Forms.TextBox();
this.t_amountTextBox = new System.Windows.Forms.TextBox();
this.t_src_idTextBox = new System.Windows.Forms.TextBox();
this.name_address_1TextBox = new System.Windows.Forms.TextBox();
this.customerBindingSource = new System.Windows.Forms.BindingSource(this.components);
this.cust_idTextBox = new System.Windows.Forms.TextBox();
this.iNVOICE_HEADERDataGridView = new System.Windows.Forms.DataGridView();
this.dataGridViewTextBoxColumn1 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn2 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn3 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn4 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn5 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn6 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn7 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.unpaid = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.recent_payment = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.iNVOICE_HEADERBindingSource = new System.Windows.Forms.BindingSource(this.components);
this.iNVOICE_RECIEPTSBindingSource = new System.Windows.Forms.BindingSource(this.components);
this.btnApply = new System.Windows.Forms.Button();
this.customer_transTableAdapter = new Vectra.DataSet2TableAdapters.customer_transTableAdapter();
this.tableAdapterManager = new Vectra.DataSet2TableAdapters.TableAdapterManager();
this.customerTableAdapter = new Vectra.DataSet2TableAdapters.customerTableAdapter();
this.iNVOICE_HEADERTableAdapter = new Vectra.DataSet2TableAdapters.INVOICE_HEADERTableAdapter();
this.iNVOICE_RECIEPTSTableAdapter = new Vectra.DataSet2TableAdapters.INVOICE_RECIEPTSTableAdapter();
this.sqLiteConnection1 = new Devart.Data.SQLite.SQLiteConnection();
this.ApplyReciepts = new System.Windows.Forms.Button();
this.UnAllocatedAmount = new System.Windows.Forms.TextBox();
this.label1 = new System.Windows.Forms.Label();
this.btnReset = new System.Windows.Forms.Button();
this.btnSubTotal = new System.Windows.Forms.Button();
t_idLabel = new System.Windows.Forms.Label();
t_typeLabel = new System.Windows.Forms.Label();
t_cust_idLabel = new System.Windows.Forms.Label();
t_ref_idLabel = new System.Windows.Forms.Label();
t_dateLabel = new System.Windows.Forms.Label();
t_noteLabel = new System.Windows.Forms.Label();
t_amountLabel = new System.Windows.Forms.Label();
t_src_idLabel = new System.Windows.Forms.Label();
name_address_1Label = new System.Windows.Forms.Label();
((System.ComponentModel.ISupportInitialize)(this.customer_transBindingSource)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dataSet2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.customerBindingSource)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.iNVOICE_HEADERDataGridView)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.iNVOICE_HEADERBindingSource)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.iNVOICE_RECIEPTSBindingSource)).BeginInit();
this.SuspendLayout();
//
// t_idLabel
//
t_idLabel.AutoSize = true;
t_idLabel.Location = new System.Drawing.Point(12, 45);
t_idLabel.Name = "t_idLabel";
t_idLabel.Size = new System.Drawing.Size(80, 13);
t_idLabel.TabIndex = 2;
t_idLabel.Text = "Transaction ID:";
//
// t_typeLabel
//
t_typeLabel.AutoSize = true;
t_typeLabel.Location = new System.Drawing.Point(11, 328);
t_typeLabel.Name = "t_typeLabel";
t_typeLabel.Size = new System.Drawing.Size(93, 13);
t_typeLabel.TabIndex = 4;
t_typeLabel.Text = "Transaction Type:";
//
// t_cust_idLabel
//
t_cust_idLabel.AutoSize = true;
t_cust_idLabel.Location = new System.Drawing.Point(50, 354);
t_cust_idLabel.Name = "t_cust_idLabel";
t_cust_idLabel.Size = new System.Drawing.Size(54, 13);
t_cust_idLabel.TabIndex = 6;
t_cust_idLabel.Text = "Customer:";
//
// t_ref_idLabel
//
t_ref_idLabel.AutoSize = true;
t_ref_idLabel.Location = new System.Drawing.Point(44, 380);
t_ref_idLabel.Name = "t_ref_idLabel";
t_ref_idLabel.Size = new System.Drawing.Size(60, 13);
t_ref_idLabel.TabIndex = 8;
t_ref_idLabel.Text = "Reference:";
//
// t_dateLabel
//
t_dateLabel.AutoSize = true;
t_dateLabel.Location = new System.Drawing.Point(233, 45);
t_dateLabel.Name = "t_dateLabel";
t_dateLabel.Size = new System.Drawing.Size(73, 13);
t_dateLabel.TabIndex = 10;
t_dateLabel.Text = "Receipt Date:";
//
// t_noteLabel
//
t_noteLabel.AutoSize = true;
t_noteLabel.Location = new System.Drawing.Point(328, 328);
t_noteLabel.Name = "t_noteLabel";
t_noteLabel.Size = new System.Drawing.Size(33, 13);
t_noteLabel.TabIndex = 12;
t_noteLabel.Text = "Note:";
//
// t_amountLabel
//
t_amountLabel.AutoSize = true;
t_amountLabel.Location = new System.Drawing.Point(473, 45);
t_amountLabel.Name = "t_amountLabel";
t_amountLabel.Size = new System.Drawing.Size(46, 13);
t_amountLabel.TabIndex = 16;
t_amountLabel.Text = "Amount:";
//
// t_src_idLabel
//
t_src_idLabel.AutoSize = true;
t_src_idLabel.Location = new System.Drawing.Point(212, 496);
t_src_idLabel.Name = "t_src_idLabel";
t_src_idLabel.Size = new System.Drawing.Size(41, 13);
t_src_idLabel.TabIndex = 18;
t_src_idLabel.Text = "t src id:";
//
// name_address_1Label
//
name_address_1Label.AutoSize = true;
name_address_1Label.Location = new System.Drawing.Point(41, 12);
name_address_1Label.Name = "name_address_1Label";
name_address_1Label.Size = new System.Drawing.Size(51, 13);
name_address_1Label.TabIndex = 20;
name_address_1Label.Text = "Customer";
//
// t_idTextBox
//
this.t_idTextBox.BackColor = System.Drawing.SystemColors.ActiveCaptionText;
this.t_idTextBox.BorderStyle = System.Windows.Forms.BorderStyle.None;
this.t_idTextBox.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.customer_transBindingSource, "t_id", true));
this.t_idTextBox.Location = new System.Drawing.Point(98, 45);
this.t_idTextBox.Name = "t_idTextBox";
this.t_idTextBox.ReadOnly = true;
this.t_idTextBox.Size = new System.Drawing.Size(112, 13);
this.t_idTextBox.TabIndex = 0;
this.t_idTextBox.TabStop = false;
this.t_idTextBox.Leave += new System.EventHandler(this.t_idTextBox_Leave);
//
// customer_transBindingSource
//
this.customer_transBindingSource.DataMember = "customer_trans";
this.customer_transBindingSource.DataSource = this.dataSet2;
//
// dataSet2
//
this.dataSet2.DataSetName = "DataSet2";
this.dataSet2.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// t_typeTextBox
//
this.t_typeTextBox.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.customer_transBindingSource, "t_type", true));
this.t_typeTextBox.Location = new System.Drawing.Point(110, 324);
this.t_typeTextBox.Name = "t_typeTextBox";
this.t_typeTextBox.Size = new System.Drawing.Size(200, 20);
this.t_typeTextBox.TabIndex = 5;
//
// t_cust_idTextBox
//
this.t_cust_idTextBox.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.customer_transBindingSource, "t_cust_id", true));
this.t_cust_idTextBox.Location = new System.Drawing.Point(110, 351);
this.t_cust_idTextBox.Name = "t_cust_idTextBox";
this.t_cust_idTextBox.Size = new System.Drawing.Size(200, 20);
this.t_cust_idTextBox.TabIndex = 6;
//
// t_ref_idTextBox
//
this.t_ref_idTextBox.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.customer_transBindingSource, "t_ref_id", true));
this.t_ref_idTextBox.Location = new System.Drawing.Point(110, 377);
this.t_ref_idTextBox.Name = "t_ref_idTextBox";
this.t_ref_idTextBox.Size = new System.Drawing.Size(200, 20);
this.t_ref_idTextBox.TabIndex = 7;
//
// t_dateDateTimePicker
//
this.t_dateDateTimePicker.DataBindings.Add(new System.Windows.Forms.Binding("Value", this.customer_transBindingSource, "t_date", true));
this.t_dateDateTimePicker.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.customer_transBindingSource, "t_date", true));
this.t_dateDateTimePicker.Format = System.Windows.Forms.DateTimePickerFormat.Short;
this.t_dateDateTimePicker.Location = new System.Drawing.Point(312, 41);
this.t_dateDateTimePicker.Name = "t_dateDateTimePicker";
this.t_dateDateTimePicker.Size = new System.Drawing.Size(121, 20);
this.t_dateDateTimePicker.TabIndex = 1;
//
// t_noteTextBox
//
this.t_noteTextBox.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.customer_transBindingSource, "t_note", true));
this.t_noteTextBox.Location = new System.Drawing.Point(397, 324);
this.t_noteTextBox.Multiline = true;
this.t_noteTextBox.Name = "t_noteTextBox";
this.t_noteTextBox.Size = new System.Drawing.Size(200, 73);
this.t_noteTextBox.TabIndex = 8;
this.t_noteTextBox.Leave += new System.EventHandler(this.t_noteTextBox_Leave);
//
// t_amountTextBox
//
this.t_amountTextBox.BorderStyle = System.Windows.Forms.BorderStyle.None;
this.t_amountTextBox.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.customer_transBindingSource, "t_amount", true));
this.t_amountTextBox.Location = new System.Drawing.Point(525, 45);
this.t_amountTextBox.Name = "t_amountTextBox";
this.t_amountTextBox.Size = new System.Drawing.Size(139, 13);
this.t_amountTextBox.TabIndex = 2;
this.t_amountTextBox.Leave += new System.EventHandler(this.t_amountTextBox_Leave);
//
// t_src_idTextBox
//
this.t_src_idTextBox.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.customer_transBindingSource, "t_src_id", true));
this.t_src_idTextBox.Location = new System.Drawing.Point(281, 493);
this.t_src_idTextBox.Name = "t_src_idTextBox";
this.t_src_idTextBox.Size = new System.Drawing.Size(200, 20);
this.t_src_idTextBox.TabIndex = 19;
//
// name_address_1TextBox
//
this.name_address_1TextBox.BackColor = System.Drawing.SystemColors.ActiveCaptionText;
this.name_address_1TextBox.BorderStyle = System.Windows.Forms.BorderStyle.None;
this.name_address_1TextBox.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.customerBindingSource, "name_address_1", true));
this.name_address_1TextBox.ForeColor = System.Drawing.SystemColors.WindowText;
this.name_address_1TextBox.Location = new System.Drawing.Point(236, 12);
this.name_address_1TextBox.Name = "name_address_1TextBox";
this.name_address_1TextBox.ReadOnly = true;
this.name_address_1TextBox.Size = new System.Drawing.Size(526, 13);
this.name_address_1TextBox.TabIndex = 21;
this.name_address_1TextBox.TabStop = false;
//
// customerBindingSource
//
this.customerBindingSource.DataMember = "customer";
this.customerBindingSource.DataSource = this.dataSet2;
//
// cust_idTextBox
//
this.cust_idTextBox.BackColor = System.Drawing.SystemColors.ActiveCaptionText;
this.cust_idTextBox.BorderStyle = System.Windows.Forms.BorderStyle.None;
this.cust_idTextBox.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.customerBindingSource, "cust_id", true));
this.cust_idTextBox.Location = new System.Drawing.Point(98, 12);
this.cust_idTextBox.Name = "cust_idTextBox";
this.cust_idTextBox.ReadOnly = true;
this.cust_idTextBox.Size = new System.Drawing.Size(112, 13);
this.cust_idTextBox.TabIndex = 23;
this.cust_idTextBox.TabStop = false;
//
// iNVOICE_HEADERDataGridView
//
this.iNVOICE_HEADERDataGridView.AutoGenerateColumns = false;
this.iNVOICE_HEADERDataGridView.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this.iNVOICE_HEADERDataGridView.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {
this.dataGridViewTextBoxColumn1,
this.dataGridViewTextBoxColumn2,
this.dataGridViewTextBoxColumn3,
this.dataGridViewTextBoxColumn4,
this.dataGridViewTextBoxColumn5,
this.dataGridViewTextBoxColumn6,
this.dataGridViewTextBoxColumn7,
this.unpaid,
this.recent_payment});
this.iNVOICE_HEADERDataGridView.DataSource = this.iNVOICE_HEADERBindingSource;
this.iNVOICE_HEADERDataGridView.Location = new System.Drawing.Point(9, 79);
this.iNVOICE_HEADERDataGridView.Name = "iNVOICE_HEADERDataGridView";
this.iNVOICE_HEADERDataGridView.RowHeadersVisible = false;
this.iNVOICE_HEADERDataGridView.SelectionMode = System.Windows.Forms.DataGridViewSelectionMode.CellSelect;
this.iNVOICE_HEADERDataGridView.Size = new System.Drawing.Size(906, 220);
this.iNVOICE_HEADERDataGridView.TabIndex = 4;
this.iNVOICE_HEADERDataGridView.TabStop = false;
this.iNVOICE_HEADERDataGridView.CellClick += new System.Windows.Forms.DataGridViewCellEventHandler(this.iNVOICE_HEADERDataGridView_CellClick);
this.iNVOICE_HEADERDataGridView.CellFormatting += new System.Windows.Forms.DataGridViewCellFormattingEventHandler(this.iNVOICE_HEADERDataGridView_CellFormatting);
//
// dataGridViewTextBoxColumn1
//
this.dataGridViewTextBoxColumn1.DataPropertyName = "invoice_number";
dataGridViewCellStyle5.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight;
dataGridViewCellStyle5.NullValue = null;
this.dataGridViewTextBoxColumn1.DefaultCellStyle = dataGridViewCellStyle5;
this.dataGridViewTextBoxColumn1.HeaderText = "Invoice Number";
this.dataGridViewTextBoxColumn1.Name = "dataGridViewTextBoxColumn1";
this.dataGridViewTextBoxColumn1.ReadOnly = true;
//
// dataGridViewTextBoxColumn2
//
this.dataGridViewTextBoxColumn2.DataPropertyName = "invoice_date";
dataGridViewCellStyle6.Format = "d";
dataGridViewCellStyle6.NullValue = null;
this.dataGridViewTextBoxColumn2.DefaultCellStyle = dataGridViewCellStyle6;
this.dataGridViewTextBoxColumn2.HeaderText = "Invoice Date";
this.dataGridViewTextBoxColumn2.Name = "dataGridViewTextBoxColumn2";
this.dataGridViewTextBoxColumn2.ReadOnly = true;
//
// dataGridViewTextBoxColumn3
//
this.dataGridViewTextBoxColumn3.DataPropertyName = "cust_id";
this.dataGridViewTextBoxColumn3.HeaderText = "Customer";
this.dataGridViewTextBoxColumn3.Name = "dataGridViewTextBoxColumn3";
this.dataGridViewTextBoxColumn3.ReadOnly = true;
//
// dataGridViewTextBoxColumn4
//
this.dataGridViewTextBoxColumn4.DataPropertyName = "docket_number";
this.dataGridViewTextBoxColumn4.HeaderText = "Docket Number";
this.dataGridViewTextBoxColumn4.Name = "dataGridViewTextBoxColumn4";
this.dataGridViewTextBoxColumn4.ReadOnly = true;
//
// dataGridViewTextBoxColumn5
//
this.dataGridViewTextBoxColumn5.DataPropertyName = "notes";
this.dataGridViewTextBoxColumn5.HeaderText = "Notes";
this.dataGridViewTextBoxColumn5.Name = "dataGridViewTextBoxColumn5";
this.dataGridViewTextBoxColumn5.ReadOnly = true;
//
// dataGridViewTextBoxColumn6
//
this.dataGridViewTextBoxColumn6.DataPropertyName = "text_fully_paid";
this.dataGridViewTextBoxColumn6.HeaderText = "Fully Paid";
this.dataGridViewTextBoxColumn6.Name = "dataGridViewTextBoxColumn6";
this.dataGridViewTextBoxColumn6.ReadOnly = true;
//
// dataGridViewTextBoxColumn7
//
this.dataGridViewTextBoxColumn7.DataPropertyName = "invoice_amount";
dataGridViewCellStyle7.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight;
dataGridViewCellStyle7.Format = "C2";
dataGridViewCellStyle7.NullValue = null;
this.dataGridViewTextBoxColumn7.DefaultCellStyle = dataGridViewCellStyle7;
this.dataGridViewTextBoxColumn7.HeaderText = "Invoice Amount";
this.dataGridViewTextBoxColumn7.Name = "dataGridViewTextBoxColumn7";
this.dataGridViewTextBoxColumn7.ReadOnly = true;
//
// unpaid
//
this.unpaid.DataPropertyName = "invoice_unpaid";
dataGridViewCellStyle8.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight;
dataGridViewCellStyle8.Format = "C2";
dataGridViewCellStyle8.NullValue = null;
this.unpaid.DefaultCellStyle = dataGridViewCellStyle8;
this.unpaid.HeaderText = "Invoice Unpaid";
this.unpaid.Name = "unpaid";
this.unpaid.ReadOnly = true;
//
// recent_payment
//
this.recent_payment.DataPropertyName = "recent_payment";
this.recent_payment.HeaderText = "Allocation";
this.recent_payment.Name = "recent_payment";
//
// iNVOICE_HEADERBindingSource
//
this.iNVOICE_HEADERBindingSource.DataMember = "INVOICE_HEADER";
this.iNVOICE_HEADERBindingSource.DataSource = this.dataSet2;
//
// iNVOICE_RECIEPTSBindingSource
//
this.iNVOICE_RECIEPTSBindingSource.DataMember = "INVOICE_RECIEPTS";
this.iNVOICE_RECIEPTSBindingSource.DataSource = this.dataSet2;
//
// btnApply
//
this.btnApply.Location = new System.Drawing.Point(687, 40);
this.btnApply.Name = "btnApply";
this.btnApply.Size = new System.Drawing.Size(75, 23);
this.btnApply.TabIndex = 3;
this.btnApply.Text = "Auto Apply";
this.btnApply.UseVisualStyleBackColor = true;
this.btnApply.Click += new System.EventHandler(this.btnApply_Click);
//
// customer_transTableAdapter
//
this.customer_transTableAdapter.ClearBeforeFill = true;
//
// tableAdapterManager
//
this.tableAdapterManager.BackupDataSetBeforeUpdate = false;
this.tableAdapterManager.configurationTableAdapter = null;
this.tableAdapterManager.customer_transTableAdapter = this.customer_transTableAdapter;
this.tableAdapterManager.customerTableAdapter = this.customerTableAdapter;
this.tableAdapterManager.debtors_summaryTableAdapter = null;
this.tableAdapterManager.debtorsTableAdapter = null;
this.tableAdapterManager.gl_categoryTableAdapter = null;
this.tableAdapterManager.gl_txnsTableAdapter = null;
this.tableAdapterManager.glTableAdapter = null;
this.tableAdapterManager.INVOICE_HEADERTableAdapter = this.iNVOICE_HEADERTableAdapter;
this.tableAdapterManager.invoice_itemsTableAdapter = null;
this.tableAdapterManager.INVOICE_RECIEPTSTableAdapter = this.iNVOICE_RECIEPTSTableAdapter;
this.tableAdapterManager.payment_typeTableAdapter = null;
this.tableAdapterManager.PaymentAdjustRptTableAdapter = null;
this.tableAdapterManager.product_typeTableAdapter = null;
this.tableAdapterManager.ProductSalesReportTableAdapter = null;
this.tableAdapterManager.ProductSalesSummaryTableAdapter = null;
this.tableAdapterManager.productsTableAdapter = null;
this.tableAdapterManager.SalesSummary1TableAdapter = null;
this.tableAdapterManager.sqlite_sequenceTableAdapter = null;
this.tableAdapterManager.UpdateOrder = Vectra.DataSet2TableAdapters.TableAdapterManager.UpdateOrderOption.InsertUpdateDelete;
//
// customerTableAdapter
//
this.customerTableAdapter.ClearBeforeFill = true;
//
// iNVOICE_HEADERTableAdapter
//
this.iNVOICE_HEADERTableAdapter.ClearBeforeFill = true;
//
// iNVOICE_RECIEPTSTableAdapter
//
this.iNVOICE_RECIEPTSTableAdapter.ClearBeforeFill = true;
//
// sqLiteConnection1
//
this.sqLiteConnection1.ConnectionString = "Data Source=\"C:\\Documents and Settings\\All Users\\Application Data\\Vectra\\Data\\PRO" +
"D.db3\";";
this.sqLiteConnection1.Name = "sqLiteConnection1";
this.sqLiteConnection1.Owner = this;
//
// ApplyReciepts
//
this.ApplyReciepts.Location = new System.Drawing.Point(840, 41);
this.ApplyReciepts.Name = "ApplyReciepts";
this.ApplyReciepts.Size = new System.Drawing.Size(75, 23);
this.ApplyReciepts.TabIndex = 24;
this.ApplyReciepts.Text = "Apply";
this.ApplyReciepts.UseVisualStyleBackColor = true;
this.ApplyReciepts.Click += new System.EventHandler(this.button1_Click);
//
// UnAllocatedAmount
//
this.UnAllocatedAmount.BorderStyle = System.Windows.Forms.BorderStyle.None;
this.UnAllocatedAmount.ForeColor = System.Drawing.Color.Red;
this.UnAllocatedAmount.Location = new System.Drawing.Point(815, 357);
this.UnAllocatedAmount.Name = "UnAllocatedAmount";
this.UnAllocatedAmount.Size = new System.Drawing.Size(100, 13);
this.UnAllocatedAmount.TabIndex = 25;
this.UnAllocatedAmount.TextAlign = System.Windows.Forms.HorizontalAlignment.Right;
//
// label1
//
this.label1.AutoSize = true;
this.label1.Location = new System.Drawing.Point(692, 357);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(123, 13);
this.label1.TabIndex = 26;
this.label1.Text = "Remaining Unallocated: ";
//
// btnReset
//
this.btnReset.Location = new System.Drawing.Point(815, 380);
this.btnReset.Name = "btnReset";
this.btnReset.Size = new System.Drawing.Size(100, 23);
this.btnReset.TabIndex = 27;
this.btnReset.Text = "Reset Allocation";
this.btnReset.UseVisualStyleBackColor = true;
this.btnReset.Click += new System.EventHandler(this.btnReset_Click);
//
// btnSubTotal
//
this.btnSubTotal.Location = new System.Drawing.Point(840, 318);
this.btnSubTotal.Name = "btnSubTotal";
this.btnSubTotal.Size = new System.Drawing.Size(75, 23);
this.btnSubTotal.TabIndex = 28;
this.btnSubTotal.Text = "Sub Total";
this.btnSubTotal.UseVisualStyleBackColor = true;
this.btnSubTotal.Click += new System.EventHandler(this.btnSubTotal_Click);
//
// Receipts
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.BackColor = System.Drawing.SystemColors.Control;
this.ClientSize = new System.Drawing.Size(920, 424);
this.Controls.Add(this.btnSubTotal);
this.Controls.Add(this.btnReset);
this.Controls.Add(this.label1);
this.Controls.Add(this.UnAllocatedAmount);
this.Controls.Add(this.ApplyReciepts);
this.Controls.Add(this.btnApply);
this.Controls.Add(this.iNVOICE_HEADERDataGridView);
this.Controls.Add(this.cust_idTextBox);
this.Controls.Add(name_address_1Label);
this.Controls.Add(this.name_address_1TextBox);
this.Controls.Add(t_idLabel);
this.Controls.Add(this.t_idTextBox);
this.Controls.Add(t_typeLabel);
this.Controls.Add(this.t_typeTextBox);
this.Controls.Add(t_cust_idLabel);
this.Controls.Add(this.t_cust_idTextBox);
this.Controls.Add(t_ref_idLabel);
this.Controls.Add(this.t_ref_idTextBox);
this.Controls.Add(t_dateLabel);
this.Controls.Add(this.t_dateDateTimePicker);
this.Controls.Add(t_noteLabel);
this.Controls.Add(this.t_noteTextBox);
this.Controls.Add(t_amountLabel);
this.Controls.Add(this.t_amountTextBox);
this.Controls.Add(t_src_idLabel);
this.Controls.Add(this.t_src_idTextBox);
this.ForeColor = System.Drawing.SystemColors.WindowText;
this.Name = "Receipts";
this.Text = "Receipts";
this.Load += new System.EventHandler(this.Receipts_Load);
((System.ComponentModel.ISupportInitialize)(this.customer_transBindingSource)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dataSet2)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.customerBindingSource)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.iNVOICE_HEADERDataGridView)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.iNVOICE_HEADERBindingSource)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.iNVOICE_RECIEPTSBindingSource)).EndInit();
this.ResumeLayout(false);
this.PerformLayout();
}
private void button_Show_Click(object sender, EventArgs e)
{
if (comboBox_report.Text.ToString().Length != 0)
{
if (previous.Length == 0)
{
previous = comboBox_Thana.Text.ToString();
reportgenerat report_show = new reportgenerat();
data_set = report_show.LoadData(comboBox_Thana.Text.ToString());
}
else if (previous != comboBox_Thana.Text.ToString())
{
reportgenerat report_show = new reportgenerat();
data_set = report_show.LoadData(comboBox_Thana.Text.ToString());
previous = comboBox_Thana.Text.ToString();
}
string report = comboBox_report.Text.ToString();
#region show report
if (report == "Report 1")
{
view_1();
}
else if (report == "Report 1A")
{
view_1A();
}
else if (report == "Report 2")
{
view_2();
}
else if (report == "Report 3")
{
view_3();
}
else if (report == "Report 4")
{
view_4();
}
else if (report == "Report 5")
{
view_5();
}
else if (report == "Report 6")
{
view_6();
}
else if (report == "Report 7")
{
view_7();
}
else if (report == "Report 8")
{
view_8();
}
else if (report == "Report 9")
{
view_9();
}
else if (report == "Report 10")
{
view_10();
}
else if (report == "Report 11")
{
view_11();
}
else if (report == "Report 11A")
{
view_11A();
}
else if (report == "Report 11B")
{
view_11B();
}
else if (report == "Report 12")
{
view_12();
}
else if (report == "Report 13")
{
view_13();
}
else if (report == "Report 13A")
{
view_13A();
}
else if (report == "Report 13B")
{
view_13B();
}
else if (report == "Report 14")
{
view_14();
}
else if (report == "Report 14B")
{
view_14B();
}
else if (report == "Report 14C")
{
view_14C();
}
else if (report == "Report 15")
{
view_15();
}
else if (report == "Report 16")
{
view_16();
}
else if (report == "Report 17")
{
view_17();
}
else if (report == "Report 18")
{
view_18();
}
else if (report == "Report 18A")
{
view_18A();
}
else if (report == "Report 18B")
{
view_18B();
}
else if (report == "Report 18C")
{
view_18C();
}
else if (report == "Report 18D")
{
view_18D();
}
else if (report == "Report 19")
{
view_19();
}
else if (report == "Report 20")
{
view_20();
}
else if (report == "Report 21")
{
view_21();
}
else if (report == "Report 22")
{
view_22();
}
#endregion
}
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.groupBox1 = new System.Windows.Forms.GroupBox();
this.label4 = new System.Windows.Forms.Label();
this.dtFrom = new System.Windows.Forms.DateTimePicker();
this.label2 = new System.Windows.Forms.Label();
this.label3 = new System.Windows.Forms.Label();
this.label6 = new System.Windows.Forms.Label();
this.dtTo = new System.Windows.Forms.DateTimePicker();
this.label7 = new System.Windows.Forms.Label();
this.tbFh = new System.Windows.Forms.MaskedTextBox();
this.label8 = new System.Windows.Forms.Label();
this.tbFs = new System.Windows.Forms.MaskedTextBox();
this.tbTm = new System.Windows.Forms.MaskedTextBox();
this.tbFm = new System.Windows.Forms.MaskedTextBox();
this.tbTs = new System.Windows.Forms.MaskedTextBox();
this.label10 = new System.Windows.Forms.Label();
this.tbTh = new System.Windows.Forms.MaskedTextBox();
this.label9 = new System.Windows.Forms.Label();
this.label5 = new System.Windows.Forms.Label();
this.button2 = new System.Windows.Forms.Button();
this.comboBox1 = new System.Windows.Forms.ComboBox();
this.button1 = new System.Windows.Forms.Button();
this.label1 = new System.Windows.Forms.Label();
this.dataSet21 = new WAY4FORM.DataSet2();
this.groupBox1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dataSet21)).BeginInit();
this.SuspendLayout();
//
// groupBox1
//
this.groupBox1.Controls.Add(this.label4);
this.groupBox1.Controls.Add(this.dtFrom);
this.groupBox1.Controls.Add(this.label2);
this.groupBox1.Controls.Add(this.label3);
this.groupBox1.Controls.Add(this.label6);
this.groupBox1.Controls.Add(this.dtTo);
this.groupBox1.Controls.Add(this.label7);
this.groupBox1.Controls.Add(this.tbFh);
this.groupBox1.Controls.Add(this.label8);
this.groupBox1.Controls.Add(this.tbFs);
this.groupBox1.Controls.Add(this.tbTm);
this.groupBox1.Controls.Add(this.tbFm);
this.groupBox1.Controls.Add(this.tbTs);
this.groupBox1.Controls.Add(this.label10);
this.groupBox1.Controls.Add(this.tbTh);
this.groupBox1.Controls.Add(this.label9);
this.groupBox1.Controls.Add(this.label5);
this.groupBox1.Location = new System.Drawing.Point(20, 64);
this.groupBox1.Margin = new System.Windows.Forms.Padding(4);
this.groupBox1.Name = "groupBox1";
this.groupBox1.Padding = new System.Windows.Forms.Padding(4);
this.groupBox1.Size = new System.Drawing.Size(551, 114);
this.groupBox1.TabIndex = 64;
this.groupBox1.TabStop = false;
this.groupBox1.Text = "Option";
//
// label4
//
this.label4.AutoSize = true;
this.label4.Location = new System.Drawing.Point(127, 91);
this.label4.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(164, 17);
this.label4.TabIndex = 52;
this.label4.Text = "(dd/mm/yyyy hh24:mi:ss)";
//
// dtFrom
//
this.dtFrom.Format = System.Windows.Forms.DateTimePickerFormat.Short;
this.dtFrom.Location = new System.Drawing.Point(127, 34);
this.dtFrom.Margin = new System.Windows.Forms.Padding(4);
this.dtFrom.Name = "dtFrom";
this.dtFrom.Size = new System.Drawing.Size(117, 22);
this.dtFrom.TabIndex = 7;
//
// label2
//
this.label2.AutoSize = true;
this.label2.Location = new System.Drawing.Point(36, 37);
this.label2.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(72, 17);
this.label2.TabIndex = 4;
this.label2.Text = "From date";
//
// label3
//
this.label3.AutoSize = true;
this.label3.Location = new System.Drawing.Point(36, 66);
this.label3.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(57, 17);
this.label3.TabIndex = 5;
this.label3.Text = "To date";
//
// label6
//
this.label6.AutoSize = true;
this.label6.Location = new System.Drawing.Point(404, 66);
this.label6.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0);
this.label6.Name = "label6";
this.label6.Size = new System.Drawing.Size(22, 17);
this.label6.TabIndex = 51;
this.label6.Text = "ss";
//
// dtTo
//
this.dtTo.Format = System.Windows.Forms.DateTimePickerFormat.Short;
this.dtTo.Location = new System.Drawing.Point(127, 62);
this.dtTo.Margin = new System.Windows.Forms.Padding(4);
this.dtTo.Name = "dtTo";
this.dtTo.Size = new System.Drawing.Size(117, 22);
this.dtTo.TabIndex = 8;
//
// label7
//
this.label7.AutoSize = true;
this.label7.Location = new System.Drawing.Point(335, 66);
this.label7.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0);
this.label7.Name = "label7";
this.label7.Size = new System.Drawing.Size(22, 17);
this.label7.TabIndex = 50;
this.label7.Text = "mi";
//
// tbFh
//
this.tbFh.Location = new System.Drawing.Point(289, 36);
this.tbFh.Margin = new System.Windows.Forms.Padding(4);
this.tbFh.Mask = "00";
this.tbFh.Name = "tbFh";
this.tbFh.Size = new System.Drawing.Size(43, 22);
this.tbFh.TabIndex = 40;
this.tbFh.Text = "23";
//
// label8
//
this.label8.AutoSize = true;
this.label8.Location = new System.Drawing.Point(245, 66);
this.label8.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0);
this.label8.Name = "label8";
this.label8.Size = new System.Drawing.Size(40, 17);
this.label8.TabIndex = 49;
this.label8.Text = "hh24";
//
// tbFs
//
this.tbFs.Location = new System.Drawing.Point(428, 36);
this.tbFs.Margin = new System.Windows.Forms.Padding(4);
this.tbFs.Mask = "00";
this.tbFs.Name = "tbFs";
this.tbFs.Size = new System.Drawing.Size(43, 22);
this.tbFs.TabIndex = 42;
this.tbFs.Text = "00";
//
// tbTm
//
this.tbTm.Location = new System.Drawing.Point(360, 63);
this.tbTm.Margin = new System.Windows.Forms.Padding(4);
this.tbTm.Mask = "00";
this.tbTm.Name = "tbTm";
this.tbTm.Size = new System.Drawing.Size(43, 22);
this.tbTm.TabIndex = 46;
this.tbTm.Text = "59";
//
// tbFm
//
this.tbFm.Location = new System.Drawing.Point(360, 36);
this.tbFm.Margin = new System.Windows.Forms.Padding(4);
this.tbFm.Mask = "00";
this.tbFm.Name = "tbFm";
this.tbFm.Size = new System.Drawing.Size(43, 22);
this.tbFm.TabIndex = 41;
this.tbFm.Text = "00";
//
// tbTs
//
this.tbTs.Location = new System.Drawing.Point(428, 63);
this.tbTs.Margin = new System.Windows.Forms.Padding(4);
this.tbTs.Mask = "00";
this.tbTs.Name = "tbTs";
this.tbTs.Size = new System.Drawing.Size(43, 22);
this.tbTs.TabIndex = 47;
this.tbTs.Text = "59";
//
// label10
//
this.label10.AutoSize = true;
this.label10.Location = new System.Drawing.Point(245, 39);
this.label10.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0);
this.label10.Name = "label10";
this.label10.Size = new System.Drawing.Size(40, 17);
this.label10.TabIndex = 44;
this.label10.Text = "hh24";
//
// tbTh
//
this.tbTh.Location = new System.Drawing.Point(289, 63);
this.tbTh.Margin = new System.Windows.Forms.Padding(4);
this.tbTh.Mask = "00";
this.tbTh.Name = "tbTh";
this.tbTh.Size = new System.Drawing.Size(43, 22);
this.tbTh.TabIndex = 43;
this.tbTh.Text = "22";
//
// label9
//
this.label9.AutoSize = true;
this.label9.Location = new System.Drawing.Point(335, 39);
this.label9.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0);
this.label9.Name = "label9";
this.label9.Size = new System.Drawing.Size(22, 17);
this.label9.TabIndex = 45;
this.label9.Text = "mi";
//
// label5
//
this.label5.AutoSize = true;
this.label5.Location = new System.Drawing.Point(404, 39);
this.label5.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(22, 17);
this.label5.TabIndex = 48;
this.label5.Text = "ss";
//
// button2
//
this.button2.Location = new System.Drawing.Point(128, 193);
this.button2.Margin = new System.Windows.Forms.Padding(4);
this.button2.Name = "button2";
this.button2.Size = new System.Drawing.Size(100, 28);
this.button2.TabIndex = 63;
this.button2.Text = "Export";
this.button2.UseVisualStyleBackColor = true;
this.button2.Visible = false;
//
// comboBox1
//
this.comboBox1.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
this.comboBox1.FormattingEnabled = true;
this.comboBox1.Items.AddRange(new object[] {
"1.",
"2.",
"3.",
"4.",
"5.",
"6.",
"7.",
"8.",
"9.",
"10. Báo cáo chi tiết giao dịch sai lệch (Có Electra - Không có Napas)",
"11. Báo cáo chi tiết giao dịch sai lệch (Có Napas - Không có Electra)",
"12. Báo cáo đối chiếu (Có Napas - Có Electra)"});
this.comboBox1.Location = new System.Drawing.Point(107, 22);
this.comboBox1.Margin = new System.Windows.Forms.Padding(4);
this.comboBox1.Name = "comboBox1";
this.comboBox1.Size = new System.Drawing.Size(604, 24);
this.comboBox1.TabIndex = 62;
this.comboBox1.SelectedIndexChanged += new System.EventHandler(this.comboBox1_SelectedIndexChanged);
//
// button1
//
this.button1.Location = new System.Drawing.Point(20, 193);
this.button1.Margin = new System.Windows.Forms.Padding(4);
this.button1.Name = "button1";
this.button1.Size = new System.Drawing.Size(100, 28);
this.button1.TabIndex = 61;
this.button1.Text = "View";
this.button1.UseVisualStyleBackColor = true;
this.button1.Click += new System.EventHandler(this.button1_Click_1);
//
// label1
//
this.label1.AutoSize = true;
this.label1.Location = new System.Drawing.Point(16, 26);
this.label1.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(82, 17);
this.label1.TabIndex = 60;
this.label1.Text = "Report type";
//
// dataSet21
//
this.dataSet21.DataSetName = "DataSet2";
this.dataSet21.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// frmReportAcquirer
//
this.AutoScaleDimensions = new System.Drawing.SizeF(8F, 16F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(735, 250);
this.Controls.Add(this.groupBox1);
this.Controls.Add(this.button2);
this.Controls.Add(this.comboBox1);
this.Controls.Add(this.button1);
this.Controls.Add(this.label1);
this.Margin = new System.Windows.Forms.Padding(4);
this.Name = "frmReportAcquirer";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
this.Text = "ReportAcquirer";
this.Load += new System.EventHandler(this.frmReportAcquirer_Load);
this.groupBox1.ResumeLayout(false);
this.groupBox1.PerformLayout();
((System.ComponentModel.ISupportInitialize)(this.dataSet21)).EndInit();
this.ResumeLayout(false);
this.PerformLayout();
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
DataSet2 ds = new DataSet2();
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny();
any.Namespace = ds.Namespace;
sequence.Items.Add(any);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace)) {
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length)) {
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length)
&& (s1.ReadByte() == s2.ReadByte())); ) {
;
}
if ((s1.Position == s1.Length)) {
return type;
}
}
}
}
finally {
if ((s1 != null)) {
s1.Close();
}
if ((s2 != null)) {
s2.Close();
}
}
}
xs.Add(dsSchema);
return type;
}
public Form1()
{
InitializeComponent();
data_set = new DataSet2();
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
DataSet2 ds = new DataSet2();
global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny();
any1.Namespace = "http://www.w3.org/2001/XMLSchema";
any1.MinOccurs = new decimal(0);
any1.MaxOccurs = decimal.MaxValue;
any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any1);
global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny();
any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
any2.MinOccurs = new decimal(1);
any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any2);
global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute();
attribute1.Name = "namespace";
attribute1.FixedValue = ds.Namespace;
type.Attributes.Add(attribute1);
global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute();
attribute2.Name = "tableTypeName";
attribute2.FixedValue = "停车场收费统计DataTable";
type.Attributes.Add(attribute2);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace)) {
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length)) {
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length)
&& (s1.ReadByte() == s2.ReadByte())); ) {
;
}
if ((s1.Position == s1.Length)) {
return type;
}
}
}
}
finally {
if ((s1 != null)) {
s1.Close();
}
if ((s2 != null)) {
s2.Close();
}
}
}
xs.Add(dsSchema);
return type;
}
private void btnPrintReport_Click(object sender, EventArgs e)
{
ECustoms.HandoverStatisticReport report = new HandoverStatisticReport();
// Cuc hai quan
((TextObject)report.Section1.ReportObjects["SuperiorCompany"]).Text = GetUserConfig().ToUpper();
// Chi cuc hai quan
((TextObject)report.Section1.ReportObjects["CompanyName"]).Text = GlobalInfo.CompanyName.ToUpper();
//StringBuilder buffer = new StringBuilder();
//buffer.Append(" SELECT * FROM ViewAllDeclarationTNTX ");
//buffer.Append(" WHERE DeclarationID != 0 AND DeclarationID != 1 ");
//var connection = new SqlConnection(Common.Decrypt(System.Configuration.ConfigurationSettings.AppSettings["connectionString"], true));
//var adpater = new SqlDataAdapter(buffer.ToString(), connection);
//var dt = new DataTable();
//adpater.Fill(dt);
//report.SetDataSource(dt);
DataSet2 dataSet2 = new DataSet2();
DataTable table1 = dataSet2.ViewAllDeclarationTNTX;
foreach (ViewAllDeclaration obj in _listDeclarationinfo)
{
table1.Rows.Add(
obj.DeclarationID,
obj.Number,
null,
null,
null,
obj.Unit,
null,
null,
null,
null,
null,
null,
obj.Type,
null,
obj.RegisterDate,
null,
null,
null,
obj.RegisterPlace,
null,
obj.NumberHandover,
obj.DateHandover,
null,
null,
null,
null,
null,
null,
obj.Seal,
1,
null,
null,
null,
null,
null,
null,
null);
}
report.SetDataSource(dataSet2);
//preview report
var reportForm = new FrmCrystalReport(report, _userInfo);
reportForm.MaximizeBox = true;
reportForm.Show(this);
}
private void button_Show_Click(object sender, EventArgs e)
{
if (comboBox_report.Text.ToString().Length != 0)
{
if (previous.Length == 0)
{
previous = comboBox_Thana.Text.ToString();
reportgenerat report_show = new reportgenerat();
data_set = report_show.LoadData(comboBox_Thana.Text.ToString());
}
else if (previous != comboBox_Thana.Text.ToString())
{
reportgenerat report_show = new reportgenerat();
data_set = report_show.LoadData(comboBox_Thana.Text.ToString());
previous = comboBox_Thana.Text.ToString();
}
string report = comboBox_report.Text.ToString();
#region show report
if (report == "Report 1")
{
view_1();
}
else if (report == "Report 1A")
{
view_1A();
}
else if (report == "Report 2")
{
view_2();
}
else if (report == "Report 3")
{
view_3();
}
else if (report == "Report 4")
{
view_4();
}
else if (report == "Report 5")
{
view_5();
}
else if (report == "Report 6")
{
view_6();
}
else if (report == "Report 7")
{
view_7();
}
else if (report == "Report 8")
{
view_8();
}
else if (report == "Report 9")
{
view_9();
}
else if (report == "Report 10")
{
view_10();
}
else if (report == "Report 11")
{
view_11();
}
else if (report == "Report 11A")
{
view_11A();
}
else if (report == "Report 11B")
{
view_11B();
}
else if (report == "Report 12")
{
view_12();
}
else if (report == "Report 13")
{
view_13();
}
else if (report == "Report 13A")
{
view_13A();
}
else if (report == "Report 13B")
{
view_13B();
}
else if (report == "Report 14")
{
view_14();
}
else if (report == "Report 14B")
{
view_14B();
}
else if (report == "Report 14C")
{
view_14C();
}
else if (report == "Report 15")
{
view_15();
}
else if (report == "Report 16")
{
view_16();
}
else if (report == "Report 17")
{
view_17();
}
else if (report == "Report 18")
{
view_18();
}
else if (report == "Report 18A")
{
view_18A();
}
else if (report == "Report 18B")
{
view_18B();
}
else if (report == "Report 18C")
{
view_18C();
}
else if (report == "Report 18D")
{
view_18D();
}
else if (report == "Report 19")
{
view_19();
}
else if (report == "Report 20")
{
view_20();
}
else if (report == "Report 21")
{
view_21();
}
else if (report == "Report 22")
{
view_22();
}
#endregion
}
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.groupBox1 = new System.Windows.Forms.GroupBox();
this.btn_Search = new System.Windows.Forms.Button();
this.rd_All = new System.Windows.Forms.RadioButton();
this.rd_Processed = new System.Windows.Forms.RadioButton();
this.rd_Waiting = new System.Windows.Forms.RadioButton();
this.dgv_BankNet_Issuer_Trans = new System.Windows.Forms.DataGridView();
this.dataSet21 = new BanknetDomestic.DataSet2();
this.label1 = new System.Windows.Forms.Label();
this.label2 = new System.Windows.Forms.Label();
this.label3 = new System.Windows.Forms.Label();
this.label4 = new System.Windows.Forms.Label();
this.tb_CardNo = new System.Windows.Forms.TextBox();
this.tb_Trace_Auth_No = new System.Windows.Forms.TextBox();
this.tb_Auth_No = new System.Windows.Forms.TextBox();
this.tb_Trans_Date = new System.Windows.Forms.TextBox();
this.groupBox1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dgv_BankNet_Issuer_Trans)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dataSet21)).BeginInit();
this.SuspendLayout();
//
// groupBox1
//
this.groupBox1.Controls.Add(this.tb_Auth_No);
this.groupBox1.Controls.Add(this.tb_Trans_Date);
this.groupBox1.Controls.Add(this.tb_Trace_Auth_No);
this.groupBox1.Controls.Add(this.tb_CardNo);
this.groupBox1.Controls.Add(this.label4);
this.groupBox1.Controls.Add(this.label3);
this.groupBox1.Controls.Add(this.label2);
this.groupBox1.Controls.Add(this.label1);
this.groupBox1.Controls.Add(this.btn_Search);
this.groupBox1.Controls.Add(this.rd_All);
this.groupBox1.Controls.Add(this.rd_Processed);
this.groupBox1.Controls.Add(this.rd_Waiting);
this.groupBox1.Location = new System.Drawing.Point(13, 13);
this.groupBox1.Name = "groupBox1";
this.groupBox1.Size = new System.Drawing.Size(900, 123);
this.groupBox1.TabIndex = 0;
this.groupBox1.TabStop = false;
this.groupBox1.Text = "Status";
//
// btn_Search
//
this.btn_Search.Location = new System.Drawing.Point(12, 89);
this.btn_Search.Name = "btn_Search";
this.btn_Search.Size = new System.Drawing.Size(75, 23);
this.btn_Search.TabIndex = 2;
this.btn_Search.Text = "Search";
this.btn_Search.UseVisualStyleBackColor = true;
this.btn_Search.Click += new System.EventHandler(this.btn_Search_Click);
//
// rd_All
//
this.rd_All.AutoSize = true;
this.rd_All.Location = new System.Drawing.Point(12, 66);
this.rd_All.Name = "rd_All";
this.rd_All.Size = new System.Drawing.Size(36, 17);
this.rd_All.TabIndex = 1;
this.rd_All.Text = "All";
this.rd_All.UseVisualStyleBackColor = true;
//
// rd_Processed
//
this.rd_Processed.AutoSize = true;
this.rd_Processed.Location = new System.Drawing.Point(12, 43);
this.rd_Processed.Name = "rd_Processed";
this.rd_Processed.Size = new System.Drawing.Size(75, 17);
this.rd_Processed.TabIndex = 1;
this.rd_Processed.Text = "Processed";
this.rd_Processed.UseVisualStyleBackColor = true;
//
// rd_Waiting
//
this.rd_Waiting.AutoSize = true;
this.rd_Waiting.Checked = true;
this.rd_Waiting.Location = new System.Drawing.Point(12, 19);
this.rd_Waiting.Name = "rd_Waiting";
this.rd_Waiting.Size = new System.Drawing.Size(61, 17);
this.rd_Waiting.TabIndex = 0;
this.rd_Waiting.TabStop = true;
this.rd_Waiting.Text = "Waiting";
this.rd_Waiting.UseVisualStyleBackColor = true;
//
// dgv_BankNet_Issuer_Trans
//
this.dgv_BankNet_Issuer_Trans.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this.dgv_BankNet_Issuer_Trans.Location = new System.Drawing.Point(13, 142);
this.dgv_BankNet_Issuer_Trans.Name = "dgv_BankNet_Issuer_Trans";
this.dgv_BankNet_Issuer_Trans.Size = new System.Drawing.Size(900, 192);
this.dgv_BankNet_Issuer_Trans.TabIndex = 1;
this.dgv_BankNet_Issuer_Trans.CellDoubleClick += new System.Windows.Forms.DataGridViewCellEventHandler(this.dgv_BankNet_Issuer_Trans_CellDoubleClick);
//
// dataSet21
//
this.dataSet21.DataSetName = "DataSet2";
this.dataSet21.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// label1
//
this.label1.AutoSize = true;
this.label1.Location = new System.Drawing.Point(168, 23);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(46, 13);
this.label1.TabIndex = 3;
this.label1.Text = "Card No";
//
// label2
//
this.label2.AutoSize = true;
this.label2.Location = new System.Drawing.Point(166, 48);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(79, 13);
this.label2.TabIndex = 4;
this.label2.Text = "Trace Audit No";
//
// label3
//
this.label3.AutoSize = true;
this.label3.Location = new System.Drawing.Point(404, 23);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(89, 13);
this.label3.TabIndex = 5;
this.label3.Text = "Transaction Date";
//
// label4
//
this.label4.AutoSize = true;
this.label4.Location = new System.Drawing.Point(404, 48);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(68, 13);
this.label4.TabIndex = 6;
this.label4.Text = "Authorize No";
//
// tb_CardNo
//
this.tb_CardNo.Location = new System.Drawing.Point(251, 19);
this.tb_CardNo.Name = "tb_CardNo";
this.tb_CardNo.Size = new System.Drawing.Size(126, 20);
this.tb_CardNo.TabIndex = 7;
//
// tb_Trace_Auth_No
//
this.tb_Trace_Auth_No.Location = new System.Drawing.Point(251, 45);
this.tb_Trace_Auth_No.Name = "tb_Trace_Auth_No";
this.tb_Trace_Auth_No.Size = new System.Drawing.Size(126, 20);
this.tb_Trace_Auth_No.TabIndex = 8;
//
// tb_Auth_No
//
this.tb_Auth_No.Location = new System.Drawing.Point(499, 44);
this.tb_Auth_No.Name = "tb_Auth_No";
this.tb_Auth_No.Size = new System.Drawing.Size(126, 20);
this.tb_Auth_No.TabIndex = 10;
//
// tb_Trans_Date
//
this.tb_Trans_Date.Location = new System.Drawing.Point(499, 18);
this.tb_Trans_Date.Name = "tb_Trans_Date";
this.tb_Trans_Date.Size = new System.Drawing.Size(126, 20);
this.tb_Trans_Date.TabIndex = 9;
//
// Frm_Update_ChargeBack_Flag
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(925, 346);
this.Controls.Add(this.dgv_BankNet_Issuer_Trans);
this.Controls.Add(this.groupBox1);
this.Name = "Frm_Update_ChargeBack_Flag";
this.Text = "Frm_Update_ChargeBack_Flag";
this.groupBox1.ResumeLayout(false);
this.groupBox1.PerformLayout();
((System.ComponentModel.ISupportInitialize)(this.dgv_BankNet_Issuer_Trans)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dataSet21)).EndInit();
this.ResumeLayout(false);
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs)
{
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
DataSet2 ds = new DataSet2();
global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny();
any1.Namespace = "http://www.w3.org/2001/XMLSchema";
any1.MinOccurs = new decimal(0);
any1.MaxOccurs = decimal.MaxValue;
any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any1);
global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny();
any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
any2.MinOccurs = new decimal(1);
any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any2);
global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute();
attribute1.Name = "namespace";
attribute1.FixedValue = ds.Namespace;
type.Attributes.Add(attribute1);
global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute();
attribute2.Name = "tableTypeName";
attribute2.FixedValue = "DataTable1DataTable";
type.Attributes.Add(attribute2);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace))
{
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();)
{
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length))
{
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length) &&
(s1.ReadByte() == s2.ReadByte()));)
{
;
}
if ((s1.Position == s1.Length))
{
return(type);
}
}
}
}
finally {
if ((s1 != null))
{
s1.Close();
}
if ((s2 != null))
{
s2.Close();
}
}
}
xs.Add(dsSchema);
return(type);
}
private void report_Load(object sender, EventArgs e)
{
if (NumDeci != "0" && NumDeciF == "0")
{
if (NumR != 0)
{
try
{
MySqlConnection con = new MySqlConnection(Database.ConnectionString());
DecisionReporting cr1 = new DecisionReporting();
// Clipboard.SetText("select payement.NumPayement,NumA,DateDLR,NumDeci,DateDeci,MontantCNL,Nom,Prenom,client.DateNaissance,LieuNaissance,PrenomPere,NomMere,PrenomMere,Adress,programme.NomProgramme,FraisAdm,Site,CoutFoncierTTC,NbrPiece,biens.NumIlot,biens.NumBloc,biens.Niveau,biens.Numlot,biens.SurH,PrixTTC,Notaire,AdresseNotaire,sum(MontantAV) AS Apport,NumR,DateR,IP,MAC,UserName,IdUser from ov,edd,biens,programme,client,cnl,attribution,payement,decisionr,users where CodeDec='" + NumR + "' AND decisionr.RefP = payement.NumPayement AND payement.NumAttribution = attribution.NumA AND payement.NumPayement = cnl.NumPayement AND attribution.NumClient = client.NumClient AND attribution.NumProgramme = programme.RefProgramme AND attribution.IdBien = biens.Id AND programme.RefProgramme = edd.RefProgramme AND payement.NumPayement = ov.NumPayement and ov.Etat='Terminé' and IdUser='******'");
string query = @"select payement.NumPayement,NumA,DateDLR,NumDeci,DateDeci,MontantCNL,Nom,Prenom,client.DateNaissance,LieuNaissance,PrenomPere,NomMere,PrenomMere,Adress,programme.NomProgramme,FraisAdm,Site,CoutFoncierTTC,NbrPiece,biens.NumIlot,biens.NumBloc,biens.Niveau,biens.Numlot,biens.SurH,PrixTTC,Notaire,AdresseNotaire,sum(MontantAV) AS Apport,NumR,DateR,IP,MAC,UserName,IdUser from ov,edd,biens,programme,client,cnl,attribution,payement,decisionr,users where CodeDec='" + NumR + "' AND decisionr.RefP = payement.NumPayement AND payement.NumAttribution = attribution.NumA AND payement.NumPayement = cnl.NumPayement AND attribution.NumClient = client.NumClient AND attribution.NumProgramme = programme.RefProgramme AND attribution.IdBien = biens.Id AND programme.RefProgramme = edd.RefProgramme AND payement.NumPayement = ov.NumPayement and ov.Etat='Terminé' and IdUser='******'";
MySqlDataAdapter dab = new MySqlDataAdapter(query, con);
DataSet2 DSP = new DataSet2();
dab.Fill(DSP.DataTable1);
cr1.SetDataSource((DataTable)DSP.DataTable1);
string query3 = @"select NumR,DateR from decisionr where CodeDec='" + NumR + "' ORDER BY CodeDec DESC LIMIT 1,1";
MySqlDataAdapter dab3 = new MySqlDataAdapter(query3, con);
DataSet4 ds3 = new DataSet4();
dab3.Fill(ds3.DataTable1);
cr1.OpenSubreport("PreviousDec.rpt").SetDataSource((DataTable)ds3.DataTable1);
crystalReportViewer1.ReportSource = cr1;
crystalReportViewer1.Refresh();
con.Close();
}
catch (Exception ex)
{
MessageBox.Show("Veuillez selectionner une décison \n" + ex.Message + "\n");
}
}
}
else if (NumDeci != "0" && NumDeciF != "0")
{
if (NumR != 0)
{
try
{
MySqlConnection con = new MySqlConnection(Database.ConnectionString());
DecisionReporting cr1 = new DecisionReporting();
string query = @"select payement.NumPayement,NumA,DateDLR,NumDeci,DateDeci,NumDeciF,DateDeciF,MontantCNL,MontantFNPOS,Nom,Prenom,client.DateNaissance,LieuNaissance,PrenomPere,NomMere,PrenomMere,Adress,programme.NomProgramme,Site,CoutFoncierTTC,NbrPiece,biens.NumIlot,biens.NumBloc,biens.Niveau,biens.Numlot,biens.SurH,PrixTTC,Notaire,AdresseNotaire,sum(MontantAV) AS Apport,NumR,DateR,FraisAdm,IP,MAC,UserName,IdUser from fnpos,ov,edd,biens,programme,client,cnl,attribution,payement,decisionr,users where CodeDec='1' AND decisionr.RefP = payement.NumPayement AND payement.NumAttribution = attribution.NumA AND payement.NumPayement = cnl.NumPayement AND payement.NumPayement = fnpos.NumPayement AND attribution.NumClient = client.NumClient AND attribution.NumProgramme = programme.RefProgramme AND attribution.IdBien = biens.Id AND programme.RefProgramme = edd.RefProgramme AND payement.NumPayement = ov.NumPayement and ov.Etat='Terminé' and IdUser='******'";
MySqlDataAdapter dab = new MySqlDataAdapter(query, con);
DataSet2 DSP = new DataSet2();
dab.Fill(DSP.DataTable1);
cr1.SetDataSource((DataTable)DSP.DataTable1);
string query3 = @"select NumR,DateR from decisionr where CodeDec='" + NumR + "' ORDER BY CodeDec DESC LIMIT 1,1";
MySqlDataAdapter dab3 = new MySqlDataAdapter(query3, con);
DataSet4 ds3 = new DataSet4();
dab3.Fill(ds3.DataTable1);
cr1.OpenSubreport("PreviousDec.rpt").SetDataSource((DataTable)ds3.DataTable1);
crystalReportViewer1.ReportSource = cr1;
crystalReportViewer1.Refresh();
con.Close();
}
catch (Exception ex)
{
MessageBox.Show("Veuillez selectionner une décison \n" + ex.Message + "\n");
}
}
}
else
{
MessageBox.Show("Veuillez d'abord remplir les informations du CNL et/ou fnpos ");
}
}
