private void fCRManage_Load(object sender, EventArgs e)
{
this.grMain.DataSource = bs;
string sql = "select * from dmlydo";
tblydo = _db.GetDataTable(sql);
this.riLydo.DataSource = tblydo;
gvMain.CustomDrawCell += new DevExpress.XtraGrid.Views.Base.RowCellCustomDrawEventHandler(gvMain_CustomDrawCell);
}
private void GetLoad()
{
tbCr = db.GetDataTable("select Tk,MaWC,MaSP,Inload from plwc where 1=0");
for (int i = minTk; i <= maxTk; i++)
{
foreach (DataRow dr in MasterTb.Rows)
{
if (dr["Tk" + i.ToString()] != DBNull.Value && double.Parse(dr["Tk" + i.ToString()].ToString()) > 0)
{
DataRow _r = tbCr.NewRow();
_r["Tk"] = i.ToString();
_r["MaWC"] = dr["MaWC"];
_r["MaSP"] = dr["MaSP"];
_r["Inload"] = double.Parse(dr["Tk" + i.ToString()].ToString());
tbCr.Rows.Add(_r);
}
}
}
}
private void fSelectTask4Copy_Load(object sender, EventArgs e)
{
string sql = "select a.ID, a.TaskLabel, b.WFName, c.TableName, c.DienGiai from systask a " +
" inner join sysWF b on a.WFID = b.ID " +
" inner join systable c on b.systableid = c.systableid";
tbTask = dbStruct.GetDataTable(sql);
bs.DataSource = tbTask;
gridControl2.DataSource = bs;
bs.CurrentItemChanged += Bs_CurrentItemChanged;
}
private void Filter_Load(object sender, EventArgs e)
{
string sql = "select * from dmnhomgt";
DataTable tb = dt.GetDataTable(sql);
//MessageBox.Show(tb.Rows.Count.ToString());
gridLookUpEdit1.Properties.DataSource = tb;
gridLookUpEdit1.Properties.ValueMember = "MaNhom";
gridLookUpEdit1.Properties.DisplayMember = "TenNhom";
if (tb.Rows.Count > 0)
{
gridLookUpEdit1.Select(0, 1);
}
}
private void Filter_Load(object sender, EventArgs e)
{
string sql = "select * from dmnhomgt";
DataTable tb = dt.GetDataTable(sql);
gridLookUpEdit1.Properties.DataSource = tb;
gridLookUpEdit1.Properties.ValueMember = "MaNhom";
gridLookUpEdit1.Properties.DisplayMember = "TenNhom";
gridLookUpEdit1.EditValue = manhom;
gridLookUpEdit1.Properties.ReadOnly = true;
spinEdit1.EditValue = Config.GetValue("KyKeToan") == null ? DateTime.Today.Month : Int32.Parse(Config.GetValue("KyKeToan").ToString());
spinEdit2.EditValue = Config.GetValue("KyKeToan") == null ? DateTime.Today.Month : Int32.Parse(Config.GetValue("KyKeToan").ToString());
if (Config.GetValue("Language").ToString() == "1")
{
FormFactory.DevLocalizer.Translate(this);
}
}
private void getSohieu()
{
string sql = "select * from dmImation";
gridLookUpEdit1.Properties.DataSource = db.GetDataTable(sql);
}
