private void frm_SysUsers_Load(object sender, EventArgs e)
{
SysUserCollection sysUserCollection = new Select().From(SysUser.Schema).ExecuteAsCollection <SysUserCollection>();
// grdSysUser.DataSource = sysUserCollection.ToDataTable();
Utility.SetDataSourceForDataGridEx(grdSysUser, sysUserCollection.ToDataTable(), true, true, "", "");
SqlQuery sqlQuery = new Select().From(SysTrinhky.Schema)
.Where(SysTrinhky.Columns.ReportName).IsEqualTo(TenBaoCao)
.And(SysTrinhky.Columns.ObjectName).IsEqualTo(globalVariables.UserName);
SysTrinhky objSysTrinhky = sqlQuery.ExecuteSingle <SysTrinhky>();
if (objSysTrinhky != null)
{
NoiDung = Utility.sDbnull(objSysTrinhky.Trinhky);
}
}
private void cmdUpdateAllUser_Click(object sender, EventArgs e)
{
if (grdSysUser.GetCheckedRows().Length <= 0)
{
Utility.ShowMsg("Bạn phải chọn thông tin trên lưới thực hiện ", "Thông báo");
return;
}
try
{
if (chkOverUser.Checked)
{
foreach (Janus.Windows.GridEX.GridEXRow gridExRow in grdSysUser.GetCheckedRows())
{
new Delete().From(SysTrinhky.Schema)
.Where(SysTrinhky.Columns.ReportName).IsEqualTo(TenBaoCao)
.And(SysTrinhky.Columns.ObjectName).IsEqualTo(
Utility.sDbnull(gridExRow.Cells[SysUser.Columns.PkSuid].Value, "")).Execute();
}
}
foreach (Janus.Windows.GridEX.GridEXRow gridExRow in grdSysUser.GetCheckedRows())
{
SqlQuery sqlQuery = new Select().From(SysTrinhky.Schema)
.Where(SysTrinhky.Columns.ReportName).IsEqualTo(TenBaoCao)
.And(SysTrinhky.Columns.ObjectName).IsEqualTo(
Utility.sDbnull(gridExRow.Cells[SysUser.Columns.PkSuid].Value, ""));
if (sqlQuery.GetRecordCount() <= 0)
{
SysTrinhky.Insert(TenBaoCao, Utility.sDbnull(gridExRow.Cells[SysUser.Columns.PkSuid].Value, ""), NoiDung);
}
}
Utility.ShowMsg("Bạn thực hiện thành công", "Thông báo thành công");
}
catch (Exception)
{
throw;
}
}
public void Update(string ReportName,string ObjectName,string Trinhky)
{
SysTrinhky item = new SysTrinhky();
item.MarkOld();
item.IsLoaded = true;
item.ReportName = ReportName;
item.ObjectName = ObjectName;
item.Trinhky = Trinhky;
item.Save(UserName);
}
public void Insert(string ReportName,string ObjectName,string Trinhky)
{
SysTrinhky item = new SysTrinhky();
item.ReportName = ReportName;
item.ObjectName = ObjectName;
item.Trinhky = Trinhky;
item.Save(UserName);
}
private SysTrinhky CreateTrinhKy()
{
SysTrinhky objTrinhky=new SysTrinhky();
objTrinhky.FontName = mv_FONT_CHU;
objTrinhky.FontSize = mv_CO_CHU;
objTrinhky.FontStype = mv_KIEU_CHU;
objTrinhky.ObjectContent = mv_NOI_DUNG;
objTrinhky.FontName = mv_FONT_CHU;
objTrinhky.ReportName = mv_TEN_BIEUBC;
objTrinhky.TitleReport = mv_TIEUDE;
objTrinhky.ObjectName = globalVariables.UserName;
return objTrinhky;
}
public void Update(string ReportName,string ObjectName,string FontName,int? FontSize,string FontStype,string ObjectContent,string Trinhky)
{
SysTrinhky item = new SysTrinhky();
item.MarkOld();
item.IsLoaded = true;
item.ReportName = ReportName;
item.ObjectName = ObjectName;
item.FontName = FontName;
item.FontSize = FontSize;
item.FontStype = FontStype;
item.ObjectContent = ObjectContent;
item.Trinhky = Trinhky;
item.Save(UserName);
}
public void Insert(string ReportName,string ObjectName,string FontName,int? FontSize,string FontStype,string ObjectContent,string Trinhky)
{
SysTrinhky item = new SysTrinhky();
item.ReportName = ReportName;
item.ObjectName = ObjectName;
item.FontName = FontName;
item.FontSize = FontSize;
item.FontStype = FontStype;
item.ObjectContent = ObjectContent;
item.Trinhky = Trinhky;
item.Save(UserName);
}
