private void setParameter(iSqlParameter[] parms, UserrightInfo info)
{
try
{
int i = -1;
parms[++i].Value = info.R_new;
parms[++i].Value = info.R_upt;
parms[++i].Value = info.R_del;
parms[++i].Value = info.R_sys;
parms[++i].Value = info.Id;
return;
}
catch (Exception ex)
{
throw ex;
}
}
private UserrightInfo getDataReader(iSqlDataReader dar)
{
try
{
int i = -1;
UserrightInfo info = new UserrightInfo();
info.R_new = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.R_upt = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.R_del = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.R_sys = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Id = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i);
return info;
}
catch (Exception ex)
{
throw ex;
}
}
public bool Save(UserrightInfo info)
{
try
{
using (iSqlConnection iConn = HELPER.getConnect(HELPER.SQL_SYSTEM))
{
using (iSqlTransaction trans = iConn.BeginTransaction())
{
try
{
this.Saveitem(trans, info);
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw ex;
}
}
iConn.Close();
}
return true;
}
catch (Exception ex)
{
throw ex;
}
}
public bool Saveitem(iSqlTransaction trans, UserrightInfo info)
{
try
{
if (trans == null || info == null) return false;
string SQL = string.Empty;
if (info.Id == 0)
{
SQL = SQL_INSERT;
info.Id = (int)HELPER.getNewID(trans, TABLENAME);
iSqlParameter[] parms = this.getParameter(SQL);
this.setParameter(parms, info);
HELPER.executeNonQuery(trans, iCommandType.Text, SQL, parms);
}
else if (HELPER.isExist(trans, TABLENAME, info.Id))
{
SQL = SQL_UPDATE;
iSqlParameter[] parms = this.getParameter(SQL);
this.setParameter(parms, info);
HELPER.executeNonQuery(trans, iCommandType.Text, SQL, parms);
}
else
{
SQL = SQL_INSERT;
info.Id = (int)HELPER.getNewID(trans, TABLENAME);
iSqlParameter[] parms = this.getParameter(SQL);
this.setParameter(parms, info);
HELPER.executeNonQuery(trans, iCommandType.Text, SQL, parms);
}
return true;
}
catch (Exception ex)
{
throw ex;
}
}
private UserInfo Take()
{
try
{
int iid = 0;
int.TryParse(txtId.Value, out iid);
UserInfo info = (new CUser()).Wcmm_Getinfo(iid);
if (info == null)
info = new UserInfo();
info.Id = iid;
info.Name = txtName.Text.Trim();
if (iid == 0)
info.Username = CFunctions.remove_blank(info.Name);
info.Password = CFunctions.MBEncrypt("DFTY$FDSSDYE$#%");
info.Email = info.Username + "@dangdong.vn";
info.Pis = info.Pis == 0 ? 1 : info.Pis;
if (PARENT != null)
{
info.Pid = PARENT.Id;
info.Depth = PARENT.Depth + 1;
}
else
{
info.Depth = info.Pid != 0 ? info.Depth : 1;
}
info.Status = CCommon.GetStatus_upt();
info.Timeupdate = DateTime.Now;
UserrightInfo rinfo = new UserrightInfo();
rinfo.Id = info.Id;
string RPages = "";
if (dtlListRPages.Items.Count > 0)
{
foreach (DataListItem row in dtlListRPages.Items)
{
string Navigateurl = dtlListRPages.DataKeys[row.ItemIndex].ToString();
CheckBox RPages_typeof = (CheckBox)row.FindControl("RPages_typeof");
ListBox RPages_cid = (ListBox)row.FindControl("RPages_cid");
if (RPages_typeof.Checked)
{
string page = Navigateurl.Replace("l.aspx", "");
RPages += page + "#";
foreach (ListItem item in RPages_cid.Items)
{
if (item.Selected)
RPages += page + item.Value + "#";
}
}
}
}
rinfo.R_new = rinfo.R_upt = rinfo.R_del = "#" + RPages;
rinfo.R_sys = "";
info.iRight = rinfo;
return info;
}
catch
{
return null;
}
}
