private void KhoiTaoKhuVuc()
{
_dbPosArea = new DataSingle("dmPOSArea", Config.GetValue("sysPackageID").ToString());
// string sql = "select * from dmPOSArea where macn='" + Config.GetValue("MaCN").ToString() + "'";
_dbPosArea.GetData();
if (_dbPosArea == null)
{
return;
}
tbA = _dbPosArea.DsData.Tables[0];
int x = 0;
foreach (DataRow drA in tbA.Rows)
{
SimpleButton bt = new SimpleButton();
bt.Text = drA["TenPOSArea"].ToString();
bt.Tag = drA["MaPOSArea"].ToString();
panelControl1.Controls.Add(bt);
bt.Left = x;
bt.Top = 45;
bt.Size = new Size(150, 100);
bt.Visible = true;
x += 151;
bt.Click += new EventHandler(bt_Click);
KhoiTaoBan(bt.Tag.ToString());
}
}
private void getdata()
{
string sql = "select * from dmvt";
dmvt = db.GetDataTable(sql);
gridLookUpEdit1.Properties.DataSource = dmvt;
repositoryItemGridLookUpEdit1.DataSource = dmvt;
sql = "select * from dmdvt";
dmdvt = db.GetDataTable(sql);
if (_data != null && _data.DsStruct.Tables.Count > 1)
{
DataRow[] lstDr = _data.DsStruct.Tables[1].Select("FieldName='MaKho'");
if (lstDr.Length > 0)
{
_dataKho = new DataSingle("DMKho", "7");
_dataKho.GetData();
DataFactory.publicCDTData.AddCDTData(_dataKho);
dmkhoGrid = _frmDesign.GenGridLookupEdit(lstDr[0], true);
dmkhoGrid.EditValueChanged += DmkhoGrid_EditValueChanged;
LayoutControlItem iKho = new LayoutControlItem(layoutControl1, dmkhoGrid);
iKho.Text = "Chọn kho:";
if (_dataKho.DsData != null && _dataKho.DsData.Tables[0].Rows.Count > 0)
{
MaKho = _dataKho.DsData.Tables[0].Rows[0]["MaKho"].ToString();
dmkhoGrid.EditValue = MaKho;
}
}
}
}
public fChonCN()
{
InitializeComponent();
_dbCN = new DataSingle("dmChinhanh", Config.GetValue("sysPackageID").ToString());
_dbCN.GetData();
gridLookUpEdit1.Properties.DataSource = _dbCN.DsData.Tables[0];
}
private void fKHManage_Load(object sender, EventArgs e)
{
vDateEdit2.EditValue = DateTime.Parse(DateTime.Now.ToShortDateString());
vDateEdit1.EditValue = DateTime.Parse(DateTime.Now.ToShortDateString()).AddYears(-1);
ckCAuto.Checked = false;
dmKH = new DataSingle("dmKH", "7");
dmKH.GetData();
bsDMKH.DataSource = dmKH.DsData.Tables[0];
bsDMKH.CurrentItemChanged += BsDMKH_CurrentItemChanged;
FormDesigner designer = new FormDesigner(dmKH);
GridControl gc = designer.GenGridControl(dmKH.DsStruct.Tables[0], false, DockStyle.Fill);
panelControl9.Controls.Add(gc);
gc.DataSource = bsDMKH;
TabControl.SelectedPageChanged += TabControl_SelectedPageChanged;
}
private void Init_History()
{
dtGDHistory = new DataSingle("dtGDHistory", "7");
dtGDHistory.Condition = "1=0";
dtGDHistory.GetData();
designer_history = new FormDesigner(dtGDHistory);
gcHistory = designer_history.GenGridControl(dtGDHistory.DsStruct.Tables[0], false, DockStyle.Fill);
designer_history.bindingSource = bsGDHistory;
foreach (CDTRepGridLookup glc in designer_history.rlist)
{
if (glc.Data != null)
{
glc.Data.GetData();
}
}
tbHistory.Controls.Add(gcHistory);
setRight_History();
}
public fChonCa()
{
InitializeComponent();
_dbCa = new DataSingle("dmCa", Config.GetValue("sysPackageID").ToString());
_dbCa.GetData();
gridLookUpEdit2.Properties.DataSource = _dbCa.DsData.Tables[0];
if (bool.Parse(Config.GetValue("TheoCa").ToString()) && _dbCa.DsData.Tables[0].Rows.Count == 1)
{
gridLookUpEdit2.EditValue = _dbCa.DsData.Tables[0].Rows[0]["MaCa"].ToString();
}
else if (_dbCa.DsData.Tables[0].Rows.Count == 0)
{
gridLookUpEdit2.EditValue = null;
}
if (!bool.Parse(Config.GetValue("TheoCa").ToString()))
{
gridLookUpEdit2.Visible = false;
}
}
private void simpleButton1_Click(object sender, EventArgs e)
{
CDTData data = new DataSingle("dtCCDC", Config.GetValue("sysPackageID").ToString());
data.Condition = "soky=0";
data.GetData();
BindingSource bs = new BindingSource();
bs.DataSource = data.DsData.Tables[0];
if (data.DsData.Tables[0].Rows.Count > 0)
{
FrmSingle fs = new FrmSingle(data);
fs.ShowDialog();
}
if (spinEdit1.Value > spinEdit2.Value)
{
return;
}
CalPB cal;
for (int i = int.Parse(spinEdit1.Value.ToString()); i <= spinEdit2.Value; i++)
{
try
{
cal = new CalPB(i, namLv);
cal.calculate();
fbangPB f = new fbangPB(cal);
f.Text = this.Text;
f.ShowDialog();
}
catch
{
}
}
}
private void Khoitao()
{
dmkh = DataFactory.publicCDTData.findCDTData("DMKH", "", "");
if (dmkh == null)
{
dmkh = DataFactory.DataFactory.Create(CDTControl.DataType.Single, "DMKH", Config.GetValue("sysPackageID").ToString()) as DataSingle;
DataFactory.publicCDTData.AddCDTData(dmkh);
dmkh.GetData();
}
this.grdmkh.Properties.DataSource = dmkh.DsData.Tables[0];
// grdmkh.EditValue = _cban.MaKH;
string sql = "select mamon, tenmon, giaban, hinh, maloaimon from dmmon where mamon in (select mamon from dmmon4area where MaPOSArea='" + MaPOSArea + "')";
tbMon = db.GetDataTable(sql);
sql = "select maloaimon from dmmon where mamon in (select mamon from dmmon4area where MaPOSArea='" + MaPOSArea + "')";
sql = "select maloaimon, tenloaimon from dmloaimon where maloaimon in (" + sql + ")";
tbLoaiMon = db.GetDataTable(sql);
repositoryItemGridLookUpEdit1.DataSource = tbMon;
pcLoaiMon.Visible = true;
panelControl1.Controls.Add(pcLoaiMon);
pcLoaiMon.Width = 10;
pcLoaiMon.Height = panelControl1.Height;
int x = 0;
pcLoaiMon.Left = sLeft.Width;
foreach (DataRow drLM in tbLoaiMon.Rows)
{
SimpleButton sp = new SimpleButton();
sp.Text = drLM["tenloaimon"].ToString();
sp.Tag = drLM["maloaimon"].ToString();
sp.Width = 100;
sp.Height = pcLoaiMon.Height;
sp.Font = new Font("Times New Roman", 10, FontStyle.Bold);
sp.ForeColor = Color.Firebrick;
sp.Left = x;
sp.Top = 0;
x += sp.Width;
pcLoaiMon.Controls.Add(sp);
pcLoaiMon.Width += sp.Width;
sp.Click += new EventHandler(sp_Click);
//Khởi tạo món
DataRow[] ldrMon = tbMon.Select("maloaimon='" + sp.Tag.ToString() + "'");
PanelControl pc = new PanelControl();
pc.Text = sp.Tag.ToString();
pc.Visible = true;
this.Controls.Add(pc);
pc.BringToFront();
pc.Dock = DockStyle.Fill;
lpc.Add(pc);
PanelControl pc1 = new PanelControl();
DevExpress.XtraEditors.VScrollBar VSsr = new DevExpress.XtraEditors.VScrollBar();
VSsr.Minimum = 0;
VSsr.Maximum = 1;
VSsr.LargeChange = 1;
VSsr.Scroll += VSsr_Scroll;
pc.Controls.Add(VSsr);
VSsr.Dock = DockStyle.Right;
pc.Resize += Pc_Resize;
pc1.Width = pc.Width - VSsr.Width;
pc1.Top = 0;
pc1.Left = 0;
VSsr.Tag = pc1;
pc1.Height = 100;
pc.Controls.Add(pc1);
int xt = 0;
int yt = 0;
foreach (DataRow drMon in ldrMon)
{
cMon sb = new cMon(drMon);
pc1.Controls.Add(sb);
pc1.Resize += Pc1_Resize;
sb.Chonmon += new EventHandler(sb_Click);
}
}
}
public fShowHistorySgle(DataSingle _data)
{
_Data = _data;
InitializeComponent();
Getdata();
}
