public void UpdateSYS_Right(SYS_Right sys_right)
{
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
try
{
List <DbParameter> para = new List <DbParameter>();
para.Add(_DbHelper.CreateParameter(FIELD_ID, sys_right.ID, false));
para.Add(_DbHelper.CreateParameter(FIELD_FUNCNAME, sys_right.FuncName, false));
para.Add(_DbHelper.CreateParameter(FIELD_TAG, sys_right.Tag, false));
para.Add(_DbHelper.CreateParameter(FIELD_MODULEID, sys_right.ModuleID, false));
//para.Add(_DbHelper.CreateParameter(FIELD_MODULEID, sys_right.ModuleID, false));
para.Add(_DbHelper.CreateParameter(FIELD_FuncID, sys_right.FuncId, false));
_DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Right_Update]", para.ToArray());
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_RightDataAccess.Update: {0}", ex.Message));
}
finally
{
conn.Close();
}
}
protected void grvSys_Right_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
SYS_Right sysRight = new SYS_Right();
try {
//if (CheckName(e.NewValues["FuncName"].ToString()) && CheckID(e.NewValues["FuncId"].ToString()))
if (CheckName(e.NewValues["FuncName"].ToString()))
{
int lstRight = sys_right.SelectMaxFuncID();
int i = lstRight + 1;
sysRight.FuncName = e.NewValues["FuncName"].ToString();
sysRight.FuncId = i.ToString();
sysRight.Tag = i.ToString();
sysRight.ModuleID = (int)e.NewValues["ModuleID"];
sys_right.InsertSYS_Right(sysRight);
_DataBind();
e.Cancel = true;
grvSys_Right.CancelEdit();
}
else
{
throw new Exception("Trùng tên ! Vui lòng nhập lại");
}
}
catch (Exception ex)
{
throw new Exception(string.Format("Trùng tên! Vui lòng nhập lại"));
}
}
protected void btnThemQuyen_Click(object sender, EventArgs e)
{
SYS_RightOfUser rightOfUser = null;
List <SYS_RightOfUser> sysRightOfUsers = new List <SYS_RightOfUser>();
if (grvChonChucNang.Selection.Count == 0)
{
pcChonChucNang.ShowOnPageLoad = false;
return;
}
List <Object> keyvalues = grvChonChucNang.GetSelectedFieldValues("ID");
int UserID = (int)GridUser.GetRowValues(GridUser.FocusedRowIndex, "ID");
foreach (int key in keyvalues)
{
rightOfUser = new SYS_RightOfUser();
rightOfUser.Approve = true;
rightOfUser.Create = true;
rightOfUser.Delete = true;
rightOfUser.Update = true;
rightOfUser.RightId = key;
rightOfUser.UserId = UserID;
sysRightOfUsers.Add(rightOfUser);
}
_ISYS_RightUserService.InsertSYS_RightOfUser(sysRightOfUsers);
GridUser_CustomCallback(null, null);
grvChonChucNang.Selection.UnselectAll();
pcChonChucNang.ShowOnPageLoad = false;
}
protected void Grd_HtmlCommandCellPrepared(object sender, DevExpress.Web.ASPxGridViewTableCommandCellEventArgs e)
{
if (e.CommandCellType == GridViewTableCommandCellType.Data)
{
SYS_Right right = (SYS_Right)Session["Right"];
if (right == null)
{
return;
}
for (int i = 0; i < e.Cell.Controls.Count; i++)
{
if (!right.IsCreate)
{
btnThem.Visible = false;
//e.Cell.Controls[1].Visible = false;
}
if (!right.IsUpdate)
{
e.Cell.Controls[0].Visible = false;
}
if (!right.IsDelete)
{
e.Cell.Controls[1].Visible = false;
}
}
}
}
protected void grvSys_Right_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
SYS_Right sysRight = new SYS_Right();
try {
sysRight.ID = (int)e.Keys["ID"];
sysRight.FuncName = e.NewValues["FuncName"].ToString();
SYS_Right right = sys_right.SelectSYS_Right(sysRight.ID);
sysRight.FuncId = right.FuncId;
sysRight.ModuleID = (int)e.NewValues["ModuleID"];
if (e.NewValues["FuncName"].ToString().ToLower() != e.OldValues["FuncName"].ToString().ToLower())
{
if (!CheckName(e.NewValues["FuncName"].ToString()))
{
throw new Exception("Trùng tên ! Vui lòng nhập lại");
}
}
//if (e.NewValues["FuncId"].ToString().ToLower() != e.OldValues["FuncId"].ToString().ToLower())
//{
// if (!CheckID(e.NewValues["FuncId"].ToString()))
// {
// throw new Exception("Trùng mã ! Vui lòng nhập lại");
// }
//}
sys_right.UpdateSYS_Right(sysRight);
_DataBind();
e.Cancel = true;
grvSys_Right.CancelEdit();
}
catch (Exception ex)
{
throw new Exception(string.Format("Trùng tên vui lòng nhập lại."));
}
}
protected void Page_Load(object sender, EventArgs e)
{
SYS_Session session = (SYS_Session)Session["SYS_Session"];
if (session == null || session.User.USERNAME == "Guest")
{
session.CurrentPage = Request.AppRelativeCurrentExecutionFilePath;
Response.Redirect("~\\Login.aspx");
}
else
{
List <SYS_Right> right = session.User.Rights;
foreach (SYS_Right sysRight in right)
{
if (sysRight.FuncId == funcid)
{
rightOfUser = sysRight;
Session["Right"] = sysRight;
Session["UserId"] = session.User.IDUSER;
Session["FunctionId"] = sysRight.FuncId;
break;
}
}
if (rightOfUser == null)
{
Session["Status"] = "0";
Response.Redirect("~\\HeThong\\Default.aspx");
}
}
Session["SYS_Session"] = session;
_DataBind();
}
public SYS_Right SelectSYS_Right(int ID)
{
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
SYS_Right sys_right = new SYS_Right();
DbDataReader reader = null;
try
{
List <DbParameter> para = new List <DbParameter>();
para.Add(_DbHelper.CreateParameter(FIELD_ID, ID, false));
reader = _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Right_GetByID]", para.ToArray());
if (reader.HasRows && reader.Read())
{
SYS_RightDataAccess.SetSYS_RightInfo(reader, ref sys_right);
}
return(sys_right);
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_RightDataAccess.SelectById: {0}", ex.Message));
}
finally
{
if (reader != null)
{
reader.Close();
}
conn.Close();
}
}
public int InsertSYS_Right(SYS_Right sys_right)
{
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
try
{
List <DbParameter> para = new List <DbParameter>();
DbParameter ouput = _DbHelper.CreateParameter(FIELD_ID, DbType.Int32, true);
para.Add(_DbHelper.CreateParameter(FIELD_FUNCNAME, sys_right.FuncName, false));
para.Add(_DbHelper.CreateParameter(FIELD_TAG, sys_right.Tag, false));
para.Add(_DbHelper.CreateParameter(FIELD_MODULEID, sys_right.ModuleID, false));
para.Add(_DbHelper.CreateParameter(FIELD_FuncID, sys_right.FuncId, false));
para.Add(ouput);
_DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Right_Insert]", para.ToArray());
return((int)ouput.Value);
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_RightDataAccess.Insert: {0}", ex.Message));
}
finally
{
conn.Close();
}
}
private static void SetSYS_RightInfo(DbDataReader reader, ref SYS_Right sys_right)
{
sys_right.ID = int.Parse("0" + reader[FIELD_ID]);
sys_right.FuncName = "" + reader[FIELD_FUNCNAME];
sys_right.Tag = "" + reader[FIELD_TAG];
sys_right.ModuleID = int.Parse("0" + reader[FIELD_MODULEID]);
sys_right.FuncId = "" + reader[FIELD_FuncID];
}
protected void Page_Load(object sender, EventArgs e)
{
SYS_Session session = (SYS_Session)Session["SYS_Session"];
session.FuncID = funcid;
if (!IsPostBack)
{
if (session == null || session.User.USERNAME == "Guest")
{
session.CurrentPage = Request.AppRelativeCurrentExecutionFilePath;
Response.Redirect("~\\Login.aspx");
}
else
{
if (Request.Cookies["IDUSER"].Value != "1")
{
List <SYS_Right> right = session.User.Rights;
foreach (SYS_Right sysRight in right)
{
if (sysRight.FuncId == funcid)
{
rightOfUser = sysRight;
if (!rightOfUser.IsCreate)
{
btnAdd.Enabled = false;
}
if (!rightOfUser.IsDelete)
{
btnRemove.Enabled = false;
}
if (!rightOfUser.IsUpdate)
{
btnSubmit.Enabled = false;
}
Session["UserId"] = session.User.IDUSER;
Session["FunctionId"] = sysRight.FuncId;
break;
}
}
if (rightOfUser == null)
{
Session["Status"] = "0";
Response.Redirect("~\\HeThong\\Default.aspx");
}
session.CurrentPage = Request.AppRelativeCurrentExecutionFilePath;
}
}
Session["SYS_Session"] = session;
_DataBind();
}
else
{
grdRightOfRoles.DataSource = Session["ListRight"];
grdRightNotRoles.DataSource = Session["ListLeft"];
}
}
private static void SetListSYS_RightInfo(ref DbDataReader reader, ref List <SYS_Right> sys_rights)
{
SYS_Right sys_right = null;
while (reader.Read())
{
sys_right = new SYS_Right();
SYS_RightDataAccess.SetSYS_RightInfo(reader, ref sys_right);
sys_rights.Add(sys_right);
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
_lstRight = (List <SYS_Right>)Session["ListLeft"];
_lstRight1 = (List <SYS_Right>)Session["ListRight"];
if (grdRightNotRoles.Selection.Count == 0)
{
return;
}
List <Object> keyvalues = grdRightNotRoles.GetSelectedFieldValues("ID");
SYS_Right Right;
foreach (object key in keyvalues)
{
Right = new SYS_Right();
// fix
Right.ModuleID = 1;
Right.SysModun = _lstRight[0].SysModun;
Right.FuncId = grdRightNotRoles.GetRowValuesByKeyValue(key, "FuncId").ToString();
Right.FuncName = grdRightNotRoles.GetRowValuesByKeyValue(key, "FuncName").ToString();
Right.ID = int.Parse(key.ToString());
Right.Tag = key.ToString();
Right.ModuleName = grdRightNotRoles.GetRowValuesByKeyValue(key, "ModuleName").ToString();
//_lstRight.Remove(Right);
for (int i = 0; i < _lstRight.Count; i++)
{
if (_lstRight[i].ID == Right.ID)
{
_lstRight.RemoveAt(i);
}
}
Right.IsApprove = true;
Right.IsCreate = true;
Right.IsDelete = true;
Right.IsUpdate = true;
_lstRight1.Add(Right);
//WriteLog("Insert " + Right.FuncName,Action.Create);
}
Session["ListLeft"] = _lstRight;
grdRightNotRoles.DataSource = _lstRight;
grdRightNotRoles.DataBind();
Session["ListRight"] = _lstRight1;
grdRightOfRoles.DataSource = _lstRight1;
grdRightOfRoles.DataBind();
grdRightOfRoles.Selection.UnselectAll();
grdRightNotRoles.Selection.UnselectAll();
}
public List <SYS_Right> GetRightsByRole(SYS_Roles roles)
{
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
List <SYS_Right> result = new List <SYS_Right>();
DbDataReader reader = null;
try
{
List <DbParameter> para = new List <DbParameter>();
para.Add(_DbHelper.CreateParameter("RoleID", roles.ID, false));
reader = _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Role_GetRightsByRole]", para.ToArray());
if (reader.HasRows)
{
SYS_ModunDataAccess modunDataAccess = new SYS_ModunDataAccess();
while (reader.Read())
{
SYS_Right temp = new SYS_Right();
SetSYS_RightInfo(reader, ref temp);
temp.IsApprove = Boolean.Parse(reader[FIELD_APPROVE].ToString());
temp.IsDelete = Boolean.Parse(reader[FIELD_DELETE].ToString());
temp.IsCreate = Boolean.Parse(reader[FIELD_CREATE].ToString());
temp.IsUpdate = Boolean.Parse(reader[FIELD_UPDATE].ToString());
temp.SysModun = modunDataAccess.SelectSYS_ModunTest(temp.ModuleID);
if (temp.SysModun != null)
{
temp.ModuleName = temp.SysModun.Name;
}
result.Add(temp);
}
}
return(result);
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_RightDataAccess.GetRightsByRole: {0}", ex.Message));
}
finally
{
if (reader != null)
{
reader.Close();
}
conn.Close();
}
}
private static void SetListSYS_RightInfoModulName(ref DbDataReader reader, ref List <SYS_Right> sys_rights)
{
SYS_Right sys_right = null;
SYS_ModunDataAccess isysModunDataAccess = new SYS_ModunDataAccess();
SYS_Modun sysModun = new SYS_Modun();
while (reader.Read())
{
sys_right = new SYS_Right();
SYS_RightDataAccess.SetSYS_RightInfo(reader, ref sys_right);
sysModun = isysModunDataAccess.SelectSYS_Modun(sys_right.ModuleID);
sys_right.ModuleName = sysModun.Name;
sys_rights.Add(sys_right);
}
}
public List <SYS_Right> GetRightsByNotUser(SYS_User user)
{
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
List <SYS_Right> result = new List <SYS_Right>();
DbDataReader reader = null;
try
{
List <DbParameter> para = new List <DbParameter>();
para.Add(_DbHelper.CreateParameter("UserID", user.ID, false));
reader = _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Right_GetByNotUser]", para.ToArray());
if (reader.HasRows)
{
SYS_ModunDataAccess modunDataAccess = new SYS_ModunDataAccess();
while (reader.Read())
{
SYS_Right temp = new SYS_Right();
SetSYS_RightInfo(reader, ref temp);
temp.IsApprove = false;
temp.IsDelete = false;
temp.IsCreate = false;
temp.IsUpdate = false;
temp.SysModun = modunDataAccess.SelectSYS_Modun(temp.ModuleID, conn);
temp.ModuleName = temp.SysModun.Name;
result.Add(temp);
}
}
return(result);
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_RightDataAccess.GetRightsByNotUser: {0}", ex.Message));
}
finally
{
if (reader != null)
{
reader.Close();
}
conn.Close();
}
}
public void UpdateSYS_Right(DbTransaction transaction, SYS_Right sys_right)
{
try
{
List <DbParameter> para = new List <DbParameter>();
para.Add(_DbHelper.CreateParameter(FIELD_ID, sys_right.ID, false));
para.Add(_DbHelper.CreateParameter(FIELD_FUNCNAME, sys_right.FuncName, false));
para.Add(_DbHelper.CreateParameter(FIELD_TAG, sys_right.Tag, false));
para.Add(_DbHelper.CreateParameter(FIELD_MODULEID, sys_right.ModuleID, false));
_DbHelper.ExecuteNonQuery(transaction, Common.DatabaseSchema + "[SYS_Right_Update]", para.ToArray());
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_RightDataAccess.Update: {0}", ex.Message));
}
}
protected void grvSys_Right_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e)
{
SYS_Right objSys_right = new SYS_Right {
ID = (int)e.Keys["ID"]
};
try
{
sys_right.DeleteSYS_Right(objSys_right);
_DataBind();
e.Cancel = true;
}
catch (Exception ex)
{
throw new Exception(string.Format("grvSys_Right_RowDeleting DeleteSYS_Right:"));
}
}
public List <SYS_Right> GetAllRightsByUser(SYS_User user, string connect)
{
List <SYS_Right> result = new List <SYS_Right>();
DbDataReader reader = null;
SYS_ConfigConnectionDataAccess connectionDataAccess = new SYS_ConfigConnectionDataAccess();
connect = connectionDataAccess.DecryptSYS_ConfigConnection(connect);
DbConnection dbConnection = Common.CreateConnection(connect);
dbConnection.Open();
try
{
List <DbParameter> para = new List <DbParameter>();
para.Add(_DbHelper.CreateParameter("UserName", user.UserName, false));
reader = _DbHelper.ExecuteReader(dbConnection, Common.DatabaseSchema + "[SYS_ALLRight_GetByUser]", para.ToArray());
if (reader.HasRows)
{
while (reader.Read())
{
SYS_Right temp = new SYS_Right();
SetSYS_RightInfo(reader, ref temp);
temp.IsApprove = Boolean.Parse(reader[FIELD_APPROVE].ToString());
temp.IsDelete = Boolean.Parse(reader[FIELD_DELETE].ToString());
temp.IsCreate = Boolean.Parse(reader[FIELD_CREATE].ToString());
temp.IsUpdate = Boolean.Parse(reader[FIELD_UPDATE].ToString());
temp.ModuleID = int.Parse(reader[FIELD_MODULEID] + "");
result.Add(temp);
}
}
return(result);
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_RightDataAccess.GetRightsByUser: {0}", ex.Message));
}
finally
{
if (reader != null)
{
reader.Close();
}
dbConnection.Close();
}
}
protected void Page_Load(object sender, EventArgs e)
{
#region PhanQuyen
MTCSYT.SYS_Session session = (MTCSYT.SYS_Session)Session["SYS_Session"];
if (session == null || session.User.USERNAME == "Guest")
{
Response.Redirect("~\\Login.aspx");
}
else
{
if (Request.Cookies["IDUSER"].Value != "1")
{
List <SYS_Right> right = session.User.Rights;
foreach (SYS_Right sysRight in right)
{
if (sysRight.FuncId == funcid)
{
rightOfUser = sysRight;
Session["Right"] = sysRight;
Session["UserId"] = session.User.IDUSER;
Session["FunctionId"] = sysRight.FuncId;
break;
}
}
if (rightOfUser == null)
{
Session["Status"] = "0";
Response.Redirect("~\\HeThong\\Default.aspx");
}
}
}
Session["SYS_Session"] = session;
#endregion
if (!IsPostBack)
{
cmbThang.Value = DateTime.Now.Month;
cmbNam.Value = DateTime.Now.Year;
}
loadDanhMuc();
//if (!IsCallback)
// _DataBind();
}
protected void btnDelete_Click(object sender, EventArgs e)
{
List <SYS_RightOfUser> lst = new List <SYS_RightOfUser>();
SYS_RightOfUser rightOfUser = null;
List <Object> keyvalues = grdRightOfRoles.GetSelectedFieldValues("ID");
int UserID = (int)GridUser.GetRowValues(GridUser.FocusedRowIndex, "ID");
foreach (Object key in keyvalues)
{
rightOfUser = new SYS_RightOfUser();
rightOfUser.RightId = (int)key;
rightOfUser.UserId = UserID;
lst.Add(rightOfUser);
}
_ISYS_RightUserService.DeleteSYS_RightOfUser_ByUser(lst);
//_DataBind();
GridUser_CustomCallback(null, null);
grdRightOfRoles.Selection.UnselectAll();
}
protected void GrdLog_HtmlCommandCellPrepared(object sender, DevExpress.Web.ASPxGridViewTableCommandCellEventArgs e)
{
if (e.CommandCellType == DevExpress.Web.GridViewTableCommandCellType.Data)
{
SYS_Right right = (SYS_Right)Session["Right"];
if (right != null)
{
for (int i = 0; i < e.Cell.Controls.Count; i++)
{
if (!right.IsDelete && i == 0)
{
btnDeleteLog.Visible = false;
e.Cell.Controls[0].Visible = false;
}
}
// Edit =0; New = 1;Delete =2
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
//#region [Phân quyền]
SYS_Session session = (SYS_Session)Session["SYS_Session"];
if (session == null || session.User.USERNAME == "Guest")
{
session.CurrentPage = Request.AppRelativeCurrentExecutionFilePath;
Response.Redirect("~\\Login.aspx");
}
else
{
List <SYS_Right> right = session.User.Rights;
foreach (SYS_Right sysRight in right)
{
if (sysRight.FuncId == funcid)
{
rightOfUser = sysRight;
Session["Right"] = sysRight;
Session["UserId"] = session.User.IDUSER;
Session["FunctionId"] = sysRight.FuncId;
break;
}
}
if (rightOfUser == null)
{
Session["Status"] = "0";
Response.Redirect("~\\HeThong\\Default.aspx");
}
}
Session["SYS_Session"] = session;
//#endregion
_BindGrdRegion();
grdRegionOrganization_CustomCallback(null, null);
if (IsCallback)
{
BinhGrdProvince();
}
}
public void DeleteSYS_Right(SYS_Right sys_right)
{
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
try
{
List <DbParameter> para = new List <DbParameter>();
para.Add(_DbHelper.CreateParameter(FIELD_ID, sys_right.ID, false));
_DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Right_Delete]", para.ToArray());
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
}
}
public int InsertSYS_Right(DbTransaction transaction, SYS_Right sys_right)
{
try
{
List <DbParameter> para = new List <DbParameter>();
DbParameter ouput = _DbHelper.CreateParameter(FIELD_ID, DbType.Int32, true);
para.Add(_DbHelper.CreateParameter(FIELD_FUNCNAME, sys_right.FuncName, false));
para.Add(_DbHelper.CreateParameter(FIELD_TAG, sys_right.Tag, false));
para.Add(_DbHelper.CreateParameter(FIELD_MODULEID, sys_right.ModuleID, false));
para.Add(ouput);
_DbHelper.ExecuteNonQuery(transaction, Common.DatabaseSchema + "[SYS_Right_Insert]", para.ToArray());
return((int)ouput.Value);
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_RightDataAccess.Insert: {0}", ex.Message));
}
}
protected void Page_Load(object sender, EventArgs e)
{
ScriptManager ScriptMan = ScriptManager.GetCurrent(this);
//ScriptManager1.RegisterPostBackControl(btnOk);
if (ScriptMan != null)
{
ScriptMan.RegisterPostBackControl(btnDownload);
}
var session = (SYS_Session)Session["SYS_Session"];
session.FuncID = funcid;
if (session == null || session.User.USERNAME == "Guest")
{
session.CurrentPage = Request.AppRelativeCurrentExecutionFilePath;
Response.Redirect("~\\Login.aspx");
}
else
{
List <SYS_Right> right = session.User.Rights;
foreach (SYS_Right sysRight in right)
{
if (sysRight.FuncId == funcid)
{
rightOfUser = sysRight;
Session["Right"] = sysRight;
Session["UserId"] = session.User.IDUSER;
Session["FunctionId"] = sysRight.FuncId;
break;
}
}
if (rightOfUser == null)
{
Session["Status"] = "0";
Response.Redirect("~\\HeThong\\Default.aspx");
}
}
Session["SYS_Session"] = session;
}
private static void SetSYS_LogInfo(DbDataReader reader, ref SYS_Log sys_log)
{
sys_log.ID = int.Parse("0" + reader[FIELD_ID]);
sys_log.UserId = int.Parse("0" + reader[FIELD_USERID]);
sys_log.FunctionId = int.Parse("0" + reader[FIELD_FUNCTIONID]);
sys_log.Action = int.Parse("0" + reader[FIELD_ACTION]);
sys_log.Description = "" + reader[FIELD_DESCRIPTION];
DateTime Time = (DateTime)reader[FIELD_TIME];
sys_log.Time = Time != null ? (DateTime)Time : DateTime.Now;
sys_log.IDBC = int.Parse("0" + reader[FIELD_IDBC]);
sys_log.PhanLoai = int.Parse("0" + reader[FIELD_PHANLOAI]);
SYS_UserDataAccess sysUserDataAccess = new SYS_UserDataAccess();
SYS_User sysUser = sysUserDataAccess.SelectSYS_User(sys_log.UserId);
sys_log.Username = sysUser.Name;
SYS_RightDataAccess sysRightDataAccess = new SYS_RightDataAccess();
SYS_Right sysRight = sysRightDataAccess.SelectSYS_Right(sys_log.FunctionId);
sys_log.FuncName = sysRight.FuncName;
}
public int InsertSYS_Right(SYS_Right sys_right)
{
return(_sys_rightDataAccess.InsertSYS_Right(sys_right));
}
public void UpdateSYS_Right(SYS_Right sys_right)
{
_sys_rightDataAccess.UpdateSYS_Right(sys_right);
}
public void DeleteSYS_Right(SYS_Right sys_rights)
{
_sys_rightDataAccess.DeleteSYS_Right(sys_rights);
}
