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