public SpecialPricing() { getGui = new get_GUI(); BulkInfoList = new ArrayList(); OnSaleInfoList = new ArrayList(); PricesList = new ArrayList(); }
private void FrmSetupInvoiceNotes_Load(object sender, EventArgs e) { Services.get_GUI get_GUI = new get_GUI(); DataTable a = get_GUI.GetSetupByStore(StaticClass.storeId); for (var i = 1; i < 10; i++) { this.tabControl1.TabPages[1].Controls["cretextbox" + i].Text = a.Rows[0][24 + i].ToString(); } textBox1.Text = a.Rows[0][34].ToString(); try { byte[] barrImg = (byte[])a.Rows[0]["Logo"]; string strfn = Convert.ToString(DateTime.Now.ToFileTime()); FileStream fs = new FileStream(strfn, FileMode.CreateNew, FileAccess.Write); fs.Write(barrImg, 0, barrImg.Length); fs.Flush(); fs.Close(); pictureBox1.Image = Image.FromFile(strfn); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button1_Click(object sender, EventArgs e) { Services.get_GUI get_GUI = new get_GUI(); get_GUI.UpdateInvoiceNotes(StaticClass.storeId, creTextBox1.Text, creTextBox2.Text, creTextBox3.Text, creTextBox4.Text, creTextBox5.Text, creTextBox6.Text, creTextBox7.Text, creTextBox8.Text, creTextBox9.Text, textBox1.Text); get_GUI.UpdateLogo(m_barrImg, StaticClass.storeId); this.Dispose(); }
private void FrmSetupTax_Load(object sender, EventArgs e) { Services.get_GUI a = new get_GUI(); DataTable taxRate = a.GetTaxRate(StaticClass.storeId); creTextBox1.Text = String.Format("{0:0.##}", (Convert.ToDecimal(taxRate.Rows[0]["Tax1_Rate"]) * 100)); creTextBox2.Text = String.Format("{0:0.##}", (Convert.ToDecimal(taxRate.Rows[0]["Tax2_Rate"]) * 100)); creTextBox3.Text = String.Format("{0:0.##}", (Convert.ToDecimal(taxRate.Rows[0]["Tax3_Rate"]) * 100)); }
private void button2_Click(object sender, EventArgs e) { decimal t1 = Convert.ToDecimal(creTextBox1.Text) / 100; decimal t2 = Convert.ToDecimal(creTextBox2.Text) / 100; decimal t3 = Convert.ToDecimal(creTextBox3.Text) / 100; Services.get_GUI get_GUI = new get_GUI(); get_GUI.UpdateTax(StaticClass.storeId, t1, t2, t3); this.Dispose(); }
private void button3_Click(object sender, EventArgs e) { if (Alert.ShowAdminPassRequest()) { FrmKeyBoard frmKeyBoard = new FrmKeyBoard(true); if (frmKeyBoard.ShowDialog() == DialogResult.OK) { Services.get_GUI get_GUI = new get_GUI(); get_GUI.UpdateAdminSwipe(StaticClass.storeId, frmKeyBoard.value); } } }
private void button2_Click(object sender, EventArgs e) { if (serviceGet.checkAdminPass(creTextBox1.Text, StaticClass.storeId)) { if (creTextBox2.Text == creTextBox3.Text) { Services.get_GUI get_GUI = new get_GUI(); get_GUI.UpdateAdminPass(StaticClass.storeId, creTextBox2.Text); } } this.Dispose(); }
public static bool CheckGrant(string storeId, string cashierId, int grantNum) { get_GUI getGui = new get_GUI(); DataTable emp = getGui.GetEmpById(cashierId); Service.ServiceGet service = new ServiceGet(); switch (grantNum) { case XEM_BAN_KHAC: if (emp.Rows[0][XEM_BAN_KHAC].ToString() == "P") { return(true); } else if (emp.Rows[0][XEM_BAN_KHAC].ToString() == "Y") { FrmAdminPass frm = new FrmAdminPass(); if (frm.ShowDialog() == DialogResult.OK) { if (!service.checkAdminPass(frm.text, storeId)) { MessageBox.Show("Password không đúng !"); return(false); } else { return(true); } } else { return(false); } } else { return(false); } break; default: return(false); } }
private static bool check(string storeId, string cashierId, string columnName) { get_GUI getGui = new get_GUI(); DataTable emp = getGui.GetEmployeeByID(storeId, cashierId); Service.ServiceGet service = new ServiceGet(); if (emp.Rows[0][columnName].ToString() == "Y") { return(true); } else if (emp.Rows[0][columnName].ToString() == "P") { FrmAdminPass frm = new FrmAdminPass(); if (frm.ShowDialog() == DialogResult.OK) { if (!service.checkAdminPass(frm.text, storeId)) { Alert.Show("Password không đúng !", Color.Red); return(false); } else { return(true); } } else { return(false); } } else if (emp.Rows[0][columnName].ToString() == "N") { Alert.Show("Bạn không có quyền để\n thực hiện chức năng này", Color.Red); return(false); } return(false); }
public SpecialPricing(string itemNum) { ItemNum = itemNum; getGui = new get_GUI(); BulkInfoList = new ArrayList(); OnSaleInfoList = new ArrayList(); PricesList = new ArrayList(); DataTable sale = getGui.GetBulkInfo(StaticClass.storeId, itemNum); if (sale != null) { for (int i = 0; i < sale.Rows.Count; i++) { BulkInfo bulkInfo = new BulkInfo(Convert.ToSingle(sale.Rows[i]["Bulk_Quan"]), Convert.ToDecimal(sale.Rows[i]["Bulk_Price"])); BulkInfoList.Add(bulkInfo); } } sale = getGui.GetOnsaleInfo(StaticClass.storeId, itemNum); if (sale != null) { for (int i = 0; i < sale.Rows.Count; i++) { OnSalesInfo onSalesInfo = new OnSalesInfo(Convert.ToDateTime(sale.Rows[i]["Sale_Start"]), Convert.ToDateTime(sale.Rows[i]["Sale_End"]), Convert.ToSingle(sale.Rows[i]["Percent"])); OnSaleInfoList.Add(onSalesInfo); } } sale = getGui.GetPrices(StaticClass.storeId, itemNum); if (sale != null) { for (int i = 0; i < sale.Rows.Count; i++) { Prices prices = new Prices(Convert.ToDecimal(sale.Rows[i]["Price"]), Convert.ToDateTime(sale.Rows[i]["Criteria1"]), Convert.ToDateTime(sale.Rows[i]["Criteria2"]), Convert.ToString(sale.Rows[i]["Criteria3"]), Convert.ToBoolean(sale.Rows[i]["Enabled"]), Convert.ToInt32(sale.Rows[i]["PriceType"])); PricesList.Add(prices); } } }
public FrmEditLayout() { pageIndex = 1; selectedSection = 1; InitializeComponent(); getGui = new get_GUI(); sections = new ArrayList(); buttonKhu = new ArrayList(); buttonKhu.Add(button10); buttonKhu.Add(button11); buttonKhu.Add(button22); buttonKhu.Add(button23); but_AddSec.changeColor(Color.White, Color.Green); button17.changeColor(Color.White, Color.LightSkyBlue); button13.changeColor(Color.White, Color.Orange); button14.changeColor(Color.White, Color.Orange); button15.changeColor(Color.White, Color.Orange); button16.changeColor(Color.White, Color.Red); button21.changeColor(Color.White, Color.Red); but_Done.changeColor(Color.White, Color.DimGray); but_Cancel.changeColor(Color.White, Color.DimGray); }
public static bool CheckGrant(string storeId, string cashierId, int grantNum) { if (!StaticClass.isAdmin) { get_GUI getGui = new get_GUI(); DataTable emp = getGui.GetEmpById(cashierId); Service.ServiceGet service = new ServiceGet(); switch (grantNum) { case XEM_BAN_KHAC: return(check(storeId, cashierId, "CFA_Other_Tables")); case CFA_INVOICE_DELETE_ITEMS: return(check(storeId, cashierId, "CFA_Invoice_DeleteItems")); case CFA_INVOICE_DISCOUNT: return(check(storeId, cashierId, "CFA_Invoice_Discount")); case CFA_INVOICE_PRICE_CHANGE: return(check(storeId, cashierId, "CFA_Invoice_PriceChange")); case CFA_INVOICE_VOID: return(check(storeId, cashierId, "CFA_Invoice_Void")); case CFA_TRANSFER_TABLE: return(check(storeId, cashierId, "CFA_Transfer_Tables")); case CFA_INVOICE_QUAN_CHANGE: return(check(storeId, cashierId, "CFA_ENDTRANS_CASH")); case CFA_INVOICE_RETURN: return(check(storeId, cashierId, "CFA_Refund_Item")); case CFA_SETUP_TAX: return(check(storeId, cashierId, "CFA_Setup_Tax")); case CFA_SETUP_PRINTER: return(check(storeId, cashierId, "CFA_Setup_DefPrinter")); case CFA_SETUP_RECEIPT_NOTES: return(check(storeId, cashierId, "CFA_SETUP_RECEIPT_NOTES")); case CFA_SETUP_DEPTS_EDIT: return(check(storeId, cashierId, "CFA_Depts_Edit")); case CFA_SETUP_INVENT_EDIT: return(check(storeId, cashierId, "CFA_Inven_Edit")); case CFA_SETUP_EDIT_EMP: return(check(storeId, cashierId, "CFA_SETUP_EDIT_EMPLOYEES")); case CFA_REPORT_DISPLAY: return(check(storeId, cashierId, "CFA_Reports_Display")); case CFA_TS_CONFIG: return(check(storeId, cashierId, "CFA_TS_CONFIG")); case CFA_Open_Cash_Drawer: return(check(storeId, cashierId, "CFA_Open_Cash_Drawer")); case CFA_Cust_Edit: return(check(storeId, cashierId, "CFA_Cust_Edit")); case CFA_PRINT_HOLD: return(check(storeId, cashierId, "CFA_PRINT_HOLD")); case CFA_ENDTRANS_ACCOUNT: return(check(storeId, cashierId, "CFA_ENDTRANS_ACCOUNT")); case CFA_AUCTION_SHIP: return(check(storeId, cashierId, "CFA_AUCTION_SHIP")); case CFA_PULLBACK_INVOICE: return(check(storeId, cashierId, "CFA_PULLBACK_INVOICE")); default: return(false); } } else { return(true); } }
public ServiceGet() { getGui = new get_GUI(); }
public void FrmLogin_Load(object sender, EventArgs e) { //OleDbConnection m_cnADONetConnection = new OleDbConnection(); //OleDbDataAdapter m_daDataAdapter; //OleDbCommandBuilder m_cbCommandBuilder; //DataTable m_dtDict = new DataTable(); //m_cnADONetConnection.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + System.Windows.Forms.Application.StartupPath + @"\ConfigDatabase.mdb"; //m_cnADONetConnection.Open(); //m_daDataAdapter = new OleDbDataAdapter("Select * From DatabaseInfo", m_cnADONetConnection); //m_cbCommandBuilder = new OleDbCommandBuilder(m_daDataAdapter); //m_daDataAdapter.Fill(m_dtDict); //if (m_dtDict.Rows.Count != 0) //{ // StaticClass.mode = m_dtDict.Rows[0]["Mode"].ToString(); // if (m_dtDict.Rows[0]["InstanceName"].ToString() == "" ) // { // StaticClass.serverName = m_dtDict.Rows[0]["ServerName"].ToString(); // } // else // { // StaticClass.serverName = m_dtDict.Rows[0]["ServerName"].ToString() + "\\" + m_dtDict.Rows[0]["InstanceName"].ToString(); // } // StaticClass.databaseName = m_dtDict.Rows[0]["DatabaseName"].ToString(); // Services.get_GUI.serverName = StaticClass.serverName; // Services.get_GUI.databaseName = StaticClass.databaseName; //} serviceGet = new ServiceGet(); getGui = new get_GUI(); button45.changeColor(Color.White, Color.Red); button46.changeColor(Color.White, Color.FromArgb(0, 150, 0)); button9.changeColor(Color.White, Color.Red); button7.changeColor(Color.White, Color.FromArgb(0, 150, 0)); button13.changeColor(Color.White, Color.Gray); button24.changeColor(Color.White, Color.Yellow); button25.changeColor(Color.White, Color.Yellow); button26.changeColor(Color.White, Color.Yellow); button27.changeColor(Color.White, Color.Yellow); button28.changeColor(Color.White, Color.Yellow); button29.changeColor(Color.White, Color.Yellow); button30.changeColor(Color.White, Color.Yellow); button31.changeColor(Color.White, Color.Yellow); button32.changeColor(Color.White, Color.Yellow); button33.changeColor(Color.White, Color.Yellow); button34.changeColor(Color.White, Color.Yellow); button35.changeColor(Color.White, Color.Yellow); button36.changeColor(Color.White, Color.Yellow); button37.changeColor(Color.White, Color.Yellow); button38.changeColor(Color.White, Color.Yellow); button39.changeColor(Color.White, Color.Yellow); button40.changeColor(Color.White, Color.Yellow); button41.changeColor(Color.White, Color.Yellow); button42.changeColor(Color.White, Color.Yellow); button43.changeColor(Color.White, Color.Yellow); button44.changeColor(Color.White, Color.Yellow); button48.changeColor(Color.White, Color.Yellow); button49.changeColor(Color.White, Color.Yellow); button50.changeColor(Color.White, Color.Yellow); button51.changeColor(Color.White, Color.Yellow); button52.changeColor(Color.White, Color.Yellow); button53.changeColor(Color.White, Color.Orange); button54.changeColor(Color.White, Color.Yellow); button55.changeColor(Color.White, Color.OrangeRed); panel2.Visible = false; panel1.Visible = true; textBox1.Clear(); textBox2.Clear(); bool focus = textBox1.Focus(); bool f = textBox1.Focused; this.Refresh(); DataTable setup = getGui.GetSetupByStore(StaticClass.storeId); string path = setup.Rows[0]["Company_Info_5"].ToString(); FileInfo fi = new FileInfo(path); if (path != "" && fi.Exists) { pictureBox1.Image = Image.FromFile(path); } label3.Text = setup.Rows[0]["Invoice_Notes_10"].ToString(); }
public FrmBanHang() { InitializeComponent(); serviceGet = new ServiceGet(); getGui = new get_GUI(); //for (int i = 1; i < 8;i++ ) //{ // button tmp = (button)panel1.Controls["button" + i.ToString()]; // tmp.changeColor(Color.White,Color.Orange); //} //for (int i = 15; i < 43; i++) //{ // button tmp = (button)panel2.Controls["button" + i.ToString()]; // tmp.changeColor(Color.White, Color.Gray); //} button45.changeColor(Color.White, Color.OrangeRed); button46.changeColor(Color.White, Color.OrangeRed); button47.changeColor(Color.White, Color.Orange); button48.changeColor(Color.White, Color.Yellow); button49.changeColor(Color.White, Color.OrangeRed); button50.changeColor(Color.White, Color.Gray); button52.changeColor(Color.White, Color.Gray); button53.changeColor(Color.White, Color.Orange); button54.changeColor(Color.White, Color.Green); //listNhomHang = new ArrayList(); //for (int i = 1; i < 18; i++) //{ // listNhomHang.Add(i.ToString()); //} //for (int i = 1; i < 70; i++) //{ // listMatHang.Add(i.ToString()); //} listMatHang = new ArrayList(); listIdNhomHang = new ArrayList(); listNhomHang = new ArrayList(); listIdMatHang = new ArrayList(); DataTable tblnhomhang = serviceGet.GetDepartments("1001"); for (int i = 0; i < tblnhomhang.Rows.Count; i++) { listNhomHang.Add(tblnhomhang.Rows[i][2].ToString()); listIdNhomHang.Add(tblnhomhang.Rows[i][24].ToString()); } DataTable tblMathang = getGui.GetInventoryByDept("0", listIdNhomHang[0].ToString(), "1001"); for (int i = 0; i < tblMathang.Rows.Count; i++) { listMatHang.Add(tblMathang.Rows[i][3].ToString()); listIdMatHang.Add(tblMathang.Rows[i][7].ToString()); } if (listNhomHang.Count % 7 == 0) { numOfPageNhom = listNhomHang.Count / 7; } else { numOfPageNhom = listNhomHang.Count / 7 + 1; } if (listMatHang.Count % 28 == 0) { numOfPageMatHang = listMatHang.Count / 28; } else { numOfPageMatHang = listMatHang.Count / 28 + 1; } pageIndexNhom = 1; selectIndexNhom = 1; pageIndexMatHang = 1; LoadNhomHang(); LoadMatHang(); }
static void Main() { Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); GetDatabaseInfo getDatabaseInfo = new GetDatabaseInfo(); if (!getDatabaseInfo.isconfiged) { FrmDelete requestconn = new FrmDelete(); requestconn.label1.Text = "Chưa có kết nối database.\n Bạn có muốn chọn database không?"; if (requestconn.ShowDialog() == DialogResult.OK) { FrmConfigDatabase frmConfigDatabase = new FrmConfigDatabase(); frmConfigDatabase.ShowDialog(); } } else { if (DAO.DataProvider.TestConnection(getDatabaseInfo.mode, getDatabaseInfo.serverName, getDatabaseInfo.databaseName, getDatabaseInfo.user, getDatabaseInfo.pass)) { Services.get_GUI.serverName = getDatabaseInfo.serverName; Services.get_GUI.databaseName = getDatabaseInfo.databaseName; Services.get_GUI.Mode = getDatabaseInfo.mode; Services.get_GUI.UserName = getDatabaseInfo.user; Services.get_GUI.Password = getDatabaseInfo.pass; Services.get_GUI getGUI = new get_GUI(); if (getGUI.GetSetupByStore(StaticClass.storeId) == null) { FrmDelete requestconn = new FrmDelete(); requestconn.label1.Text = "Kết nối không thành công.\n Bạn có muốn chọn database không?"; if (requestconn.ShowDialog() == DialogResult.OK) { FrmConfigDatabase frmConfigDatabase = new FrmConfigDatabase(); frmConfigDatabase.ShowDialog(); return; } } Lc.Check(); if (StaticClass.version == Lc.Version.Demo) { FrmRegisterInfo frmRegisterInfo; int num = getGUI.GetNumOfInvoice(); if (num > 50) { frmRegisterInfo = new FrmRegisterInfo("Quá 100 hóa đơn.", false); //frmRegisterInfo.ShowDialog(); Application.Run(frmRegisterInfo); //if (MessBox2Choice.ShowBox("Quá 100 hóa đơn.\n Bạn có muốn đăng kí không?", Color.Red) == DialogResult.Yes) //{ // Application.Run(new FrmRegister()); //} } else { frmRegisterInfo = new FrmRegisterInfo("Bạn còn " + (100 - num).ToString() + " hóa đơn để thử\n với phiên bản Demo", true); //frmRegisterInfo.ShowDialog(); frmRegisterInfo.ShowDialog(); //Alert.Show("Bạn còn " + (100 - num).ToString()+" hóa đơn để thử\n với phiên bản Demo"); Application.Run(new FrmLogin()); } } else { Application.Run(new FrmLogin()); //Application.Run(new FrmGeneralSetup()); } } else { FrmDelete requestconn = new FrmDelete(); requestconn.label1.Text = "Kết nối không thành công.\n Bạn có muốn chọn database không?"; if (requestconn.ShowDialog() == DialogResult.OK) { FrmConfigDatabase frmConfigDatabase = new FrmConfigDatabase(); frmConfigDatabase.ShowDialog(); } } } //Application.Run(new FrmCustomer()); }