public LoginUser(int ID, string LoginID, int APPLICATIONID, int DatabaseID, string DatabaseNAME, decimal ViewLevel, string ReportGroup, int REPORTRIGHT, CUSTOMRP.Model.GROUPRIGHT gr)
{
this.ID = ID;
this.LoginID = LoginID;
this.APPLICATIONID = APPLICATIONID;
this.DatabaseID = DatabaseID;
this.DatabaseNAME = DatabaseNAME;
this.ViewLevel = ViewLevel;
this.ReportGroup = ReportGroup;
this.gr = gr;
//v1.1.0 - Cheong - 2016/06/03 - Simplify report right assignment
_ReportRight = (ReportRight)REPORTRIGHT;
//List<int> reportRight = Function.Utils.getList2N(REPORTRIGHT);
//if (reportRight.Contains(3))
//{
// rp_view = true; // = 8
//}
//if (reportRight.Contains(2))
//{
// rp_delete = true; // = 4
//}
//if (reportRight.Contains(1))
//{
// rp_modify = true; // = 2
//}
//if (reportRight.Contains(0))
//{
// rp_add = true; // = 1
//}
}
protected void load(CUSTOMRP.Model.GROUPRIGHT _gright)
{
this.companyadd.Checked = WebHelper.checkRight(_gright.COMPANY, "Add");
this.companydel.Checked = WebHelper.checkRight(_gright.COMPANY, "Delete");
this.companymodify.Checked = WebHelper.checkRight(_gright.COMPANY, "Modify");
this.companyview.Checked = WebHelper.checkRight(_gright.COMPANY, "View");
this.rgadd.Checked = WebHelper.checkRight(_gright.REPORTGROUP, "Add");
this.rgdel.Checked = WebHelper.checkRight(_gright.REPORTGROUP, "Delete");
this.rgmodify.Checked = WebHelper.checkRight(_gright.REPORTGROUP, "Modify");
this.rgview.Checked = WebHelper.checkRight(_gright.REPORTGROUP, "View");
this.categoryadd.Checked = WebHelper.checkRight(_gright.CATEGARY, "Add");
this.categorydel.Checked = WebHelper.checkRight(_gright.CATEGARY, "Delete");
this.categorymodify.Checked = WebHelper.checkRight(_gright.CATEGARY, "Modify");
this.categoryview.Checked = WebHelper.checkRight(_gright.CATEGARY, "View");
this.sladd.Checked = WebHelper.checkRight(_gright.SECURITY, "Add");
this.sldel.Checked = WebHelper.checkRight(_gright.SECURITY, "Delete");
this.slmodify.Checked = WebHelper.checkRight(_gright.SECURITY, "Modify");
this.slview.Checked = WebHelper.checkRight(_gright.SECURITY, "View");
this.queryadd.Checked = WebHelper.checkRight(_gright.QUERY, "Add");
this.querydel.Checked = WebHelper.checkRight(_gright.QUERY, "Delete");
this.querymodify.Checked = WebHelper.checkRight(_gright.QUERY, "Modify");
this.queryview.Checked = WebHelper.checkRight(_gright.QUERY, "View");
this.usergroupadd.Checked = WebHelper.checkRight(_gright.USERGROUP, "Add");
this.usergroupdel.Checked = WebHelper.checkRight(_gright.USERGROUP, "Delete");
this.usergroupmodify.Checked = WebHelper.checkRight(_gright.USERGROUP, "Modify");
this.usergroupview.Checked = WebHelper.checkRight(_gright.USERGROUP, "View");
this.useradd.Checked = WebHelper.checkRight(_gright.USERSETUP, "Add");
this.userdel.Checked = WebHelper.checkRight(_gright.USERSETUP, "Delete");
this.usermodify.Checked = WebHelper.checkRight(_gright.USERSETUP, "Modify");
this.userview.Checked = WebHelper.checkRight(_gright.USERSETUP, "View");
this.ugradd.Checked = WebHelper.checkRight(_gright.USERGROUPRIGHT, "Add");
this.ugrdel.Checked = WebHelper.checkRight(_gright.USERGROUPRIGHT, "Delete");
this.ugrmodify.Checked = WebHelper.checkRight(_gright.USERGROUPRIGHT, "Modify");
this.ugrview.Checked = WebHelper.checkRight(_gright.USERGROUPRIGHT, "View");
this.Wordadd.Checked = WebHelper.checkRight(_gright.EXTEND1, "Add");
this.Worddel.Checked = WebHelper.checkRight(_gright.EXTEND1, "Delete");
this.Wordmodify.Checked = WebHelper.checkRight(_gright.EXTEND1, "Modify");
this.Wordview.Checked = WebHelper.checkRight(_gright.EXTEND1, "View");
this.Copyadd.Checked = WebHelper.checkRight(_gright.EXTEND2, "Add");
this.Copydel.Checked = WebHelper.checkRight(_gright.EXTEND2, "Delete");
this.Copymodify.Checked = WebHelper.checkRight(_gright.EXTEND2, "Modify");
this.Copyview.Checked = WebHelper.checkRight(_gright.EXTEND2, "View");
}
protected void changeGID(object Sender, EventArgs e)
{
if (string.IsNullOrEmpty(this.DDLUSERGROUP.SelectedValue) == false)
{
string STRGID = this.DDLUSERGROUP.SelectedValue;
GID = Int32.Parse(STRGID);
myGRight = WebHelper.bllGroupRight.GetModel(me.ID, GID);
if (myGRight != null)
{
load(myGRight);
}
else
{
load(new CUSTOMRP.Model.GROUPRIGHT());
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
System.Data.DataTable MYDT = WebHelper.bllUserGroup.GetList(me.ID, " DATABASEID='" + me.DatabaseID + "'").Tables[0];
this.DDLUSERGROUP.DataSource = MYDT;
this.DDLUSERGROUP.DataTextField = "NAME";
this.DDLUSERGROUP.DataValueField = "ID";
this.DDLUSERGROUP.DataBind();
if (string.IsNullOrEmpty(this.DDLUSERGROUP.SelectedValue) == false)
{
string STRGID = this.DDLUSERGROUP.SelectedValue;
GID = Int32.Parse(STRGID);
myGRight = WebHelper.bllGroupRight.GetModel(me.ID, GID);
if (myGRight != null)
{
load(myGRight);
}
}
}
}
/// <summary>
/// 批量删除数据
/// </summary>
//public bool DeleteList(int UserID, string IDlist)
//{
// StringBuilder strSql=new StringBuilder();
// strSql.Append("delete from GROUPRIGHT ");
// strSql.Append(" where ID in ("+IDlist + ") ");
// int rows=DbHelperSQL.ExecuteSql(UserID, strSql.ToString());
// if (rows > 0)
// {
// return true;
// }
// else
// {
// return false;
// }
//}
/// <summary>
/// 得到一个对象实体
/// </summary>
public CUSTOMRP.Model.GROUPRIGHT GetModel(int UserID, int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,GID,COMPANY,REPORTGROUP,CATEGARY,SECURITY,QUERY,USERGROUP,USERGROUPRIGHT,USERSETUP,AUDODATE,EXTEND1,EXTEND2,EXTEND3 from GROUPRIGHT ");
strSql.Append(" where GID=@GID");
SqlParameter[] parameters =
{
new SqlParameter("@GID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
CUSTOMRP.Model.GROUPRIGHT model = new CUSTOMRP.Model.GROUPRIGHT();
DataSet ds = DbHelperSQL.Query(UserID, strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
protected void Button1_Click(object sender, EventArgs e)
{
//Add check for save
if (me.checkUserGroupRight(CUSTOMRP.Model.APPModuleID.usergroupright_groupright, "Modify", me.LoginID) == false)
{
Common.JScript.Alert(AppNum.ErrorMsg.accesserror);
Common.JScript.GoHistory(-1);
Response.End();
}
//save date.
//reload date
string company = (this.companyadd.Checked == true ? "Add," : "") + (this.companydel.Checked == true ? "Delete," : "") + (this.companymodify.Checked == true ? "Modify," : "") + (this.companyview.Checked == true ? "View," : "");
string rg = (this.rgadd.Checked == true ? "Add," : "") + (this.rgdel.Checked == true ? "Delete," : "") + (this.rgmodify.Checked == true ? "Modify," : "") + (this.rgview.Checked == true ? "View," : "");
string category = (this.categoryadd.Checked == true ? "Add," : "") + (this.categorydel.Checked == true ? "Delete," : "") + (this.categorymodify.Checked == true ? "Modify," : "") + (this.categoryview.Checked == true ? "View," : "");
string sl = (this.sladd.Checked == true ? "Add," : "") + (this.sldel.Checked == true ? "Delete," : "") + (this.slmodify.Checked == true ? "Modify," : "") + (this.slview.Checked == true ? "View," : "");
string query = (this.queryadd.Checked == true ? "Add," : "") + (this.querydel.Checked == true ? "Delete," : "") + (this.querymodify.Checked == true ? "Modify," : "") + (this.queryview.Checked == true ? "View," : "");
string usergroup = (this.usergroupadd.Checked == true ? "Add," : "") + (this.usergroupdel.Checked == true ? "Delete," : "") + (this.usergroupmodify.Checked == true ? "Modify," : "") + (this.usergroupview.Checked == true ? "View," : "");
string usergroupright = (this.ugradd.Checked == true ? "Add," : "") + (this.ugrdel.Checked == true ? "Delete," : "") + (this.ugrmodify.Checked == true ? "Modify," : "") + (this.ugrview.Checked == true ? "View," : "");
string user = (this.useradd.Checked == true ? "Add," : "") + (this.userdel.Checked == true ? "Delete," : "") + (this.usermodify.Checked == true ? "Modify," : "") + (this.userview.Checked == true ? "View," : "");
string word = (this.Wordadd.Checked == true ? "Add," : "") + (this.Worddel.Checked == true ? "Delete," : "") + (this.Wordmodify.Checked == true ? "Modify," : "") + (this.Wordview.Checked == true ? "View," : "");
string copy = (this.Copyadd.Checked == true ? "Add," : "") + (this.Copydel.Checked == true ? "Delete," : "") + (this.Copymodify.Checked == true ? "Modify," : "") + (this.Copyview.Checked == true ? "View," : "");
company = company == "" ? "" : company.Substring(0, company.Length - 1);
rg = rg == "" ? "" : rg.Substring(0, rg.Length - 1);
category = category == "" ? "" : category.Substring(0, category.Length - 1);
sl = sl == "" ? "" : sl.Substring(0, sl.Length - 1);
query = query == "" ? "" : query.Substring(0, query.Length - 1);
usergroup = usergroup == "" ? "" : usergroup.Substring(0, usergroup.Length - 1);
usergroupright = usergroupright == "" ? "" : usergroupright.Substring(0, usergroupright.Length - 1);
user = user == "" ? "" : user.Substring(0, user.Length - 1);
word = word == "" ? "" : word.Substring(0, word.Length - 1);
copy = copy == "" ? "" : copy.Substring(0, copy.Length - 1);
string STRGID = this.DDLUSERGROUP.SelectedValue;
GID = Int32.Parse(STRGID);
myGRight = WebHelper.bllGroupRight.GetModel(me.ID, GID);
if (GID != 0)
{
if (myGRight == null)
{
//add
myGRight = new CUSTOMRP.Model.GROUPRIGHT();
myGRight.GID = GID;
myGRight.QUERY = query;
myGRight.REPORTGROUP = rg;
myGRight.SECURITY = sl;
myGRight.USERSETUP = user;
myGRight.COMPANY = company;
myGRight.CATEGARY = category;
myGRight.USERGROUP = usergroup;
myGRight.USERGROUPRIGHT = usergroupright;
myGRight.EXTEND1 = word;
myGRight.EXTEND2 = copy;
WebHelper.bllGroupRight.Add(me.ID, myGRight);
}
else
{
//update
myGRight.GID = GID;
myGRight.QUERY = query;
myGRight.REPORTGROUP = rg;
myGRight.SECURITY = sl;
myGRight.USERSETUP = user;
myGRight.COMPANY = company;
myGRight.CATEGARY = category;
myGRight.USERGROUP = usergroup;
myGRight.USERGROUPRIGHT = usergroupright;
myGRight.EXTEND1 = word;
myGRight.EXTEND2 = copy;
WebHelper.bllGroupRight.Update(me.ID, myGRight);
}
}
changeGID(this.Button1, new EventArgs());
//Response.Redirect("GROUPRIGHT.ASPX");
Common.JScript.Alert(AppNum.ErrorMsg.success);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(int UserID, CUSTOMRP.Model.GROUPRIGHT model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into GROUPRIGHT(");
strSql.Append("GID,COMPANY,REPORTGROUP,CATEGARY,SECURITY,QUERY,USERGROUP,USERGROUPRIGHT,USERSETUP,AUDODATE,EXTEND1,EXTEND2,EXTEND3)");
strSql.Append(" values (");
strSql.Append("@GID,@COMPANY,@REPORTGROUP,@CATEGARY,@SECURITY,@QUERY,@USERGROUP,@USERGROUPRIGHT,@USERSETUP,@AUDODATE,@EXTEND1,@EXTEND2,@EXTEND3)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@GID", SqlDbType.Int, 4),
new SqlParameter("@COMPANY", SqlDbType.NVarChar, 50),
new SqlParameter("@REPORTGROUP", SqlDbType.NVarChar, 50),
new SqlParameter("@CATEGARY", SqlDbType.NVarChar, 50),
new SqlParameter("@SECURITY", SqlDbType.NVarChar, 50),
new SqlParameter("@QUERY", SqlDbType.NVarChar, 50),
new SqlParameter("@USERGROUP", SqlDbType.NVarChar, 50),
new SqlParameter("@USERGROUPRIGHT", SqlDbType.NVarChar, 50),
new SqlParameter("@USERSETUP", SqlDbType.NVarChar, 50),
new SqlParameter("@AUDODATE", SqlDbType.DateTime),
new SqlParameter("@EXTEND1", SqlDbType.NVarChar, 50),
new SqlParameter("@EXTEND2", SqlDbType.NVarChar, 50),
new SqlParameter("@EXTEND3", SqlDbType.NVarChar, -1)
};
parameters[0].Value = model.GID;
parameters[1].Value = model.COMPANY;
parameters[2].Value = model.REPORTGROUP;
parameters[3].Value = model.CATEGARY;
parameters[4].Value = model.SECURITY;
parameters[5].Value = model.QUERY;
parameters[6].Value = model.USERGROUP;
parameters[7].Value = model.USERGROUPRIGHT;
parameters[8].Value = model.USERSETUP;
parameters[9].Value = model.AUDODATE;
parameters[10].Value = model.EXTEND1;
parameters[11].Value = model.EXTEND2;
parameters[12].Value = model.EXTEND3;
object obj = DbHelperSQL.GetSingle(UserID, strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
model.ID = Convert.ToInt32(obj);
Model.AUDITLOG auditobj = model.GetAuditLogObject(null);
auditobj.UserID = UserID;
auditobj.CreateDate = DateTime.Now;
auditobj.MessageType = Model.AUDITLOG.Severity.Audit;
auditobj.ModuleName = "DAL.GROUPRIGHT.Add";
auditobj.Message = String.Format(AppNum.AuditMessage.GroupRightInsertSuccess, model.ID);
AUDITLOG.Add(auditobj);
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public CUSTOMRP.Model.GROUPRIGHT DataRowToModel(DataRow row)
{
CUSTOMRP.Model.GROUPRIGHT model = new CUSTOMRP.Model.GROUPRIGHT();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = Int32.Parse(row["ID"].ToString());
}
if (row["GID"] != null && row["GID"].ToString() != "")
{
model.GID = Int32.Parse(row["GID"].ToString());
}
if (row["COMPANY"] != null)
{
model.COMPANY = row["COMPANY"].ToString();
}
if (row["REPORTGROUP"] != null)
{
model.REPORTGROUP = row["REPORTGROUP"].ToString();
}
if (row["CATEGARY"] != null)
{
model.CATEGARY = row["CATEGARY"].ToString();
}
if (row["SECURITY"] != null)
{
model.SECURITY = row["SECURITY"].ToString();
}
if (row["QUERY"] != null)
{
model.QUERY = row["QUERY"].ToString();
}
if (row["USERGROUP"] != null)
{
model.USERGROUP = row["USERGROUP"].ToString();
}
if (row["USERGROUPRIGHT"] != null)
{
model.USERGROUPRIGHT = row["USERGROUPRIGHT"].ToString();
}
if (row["USERSETUP"] != null)
{
model.USERSETUP = row["USERSETUP"].ToString();
}
if (row["AUDODATE"] != null && row["AUDODATE"].ToString() != "")
{
model.AUDODATE = DateTime.Parse(row["AUDODATE"].ToString());
}
if (row["EXTEND1"] != null)
{
model.EXTEND1 = row["EXTEND1"].ToString();
}
if (row["EXTEND2"] != null)
{
model.EXTEND2 = row["EXTEND2"].ToString();
}
if (row["EXTEND3"] != null)
{
model.EXTEND3 = row["EXTEND3"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(int UserID, CUSTOMRP.Model.GROUPRIGHT model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update GROUPRIGHT set ");
strSql.Append("COMPANY=@COMPANY,");
strSql.Append("REPORTGROUP=@REPORTGROUP,");
strSql.Append("CATEGARY=@CATEGARY,");
strSql.Append("SECURITY=@SECURITY,");
strSql.Append("QUERY=@QUERY,");
strSql.Append("USERGROUP=@USERGROUP,");
strSql.Append("USERGROUPRIGHT=@USERGROUPRIGHT,");
strSql.Append("USERSETUP=@USERSETUP,");
strSql.Append("AUDODATE=@AUDODATE,");
strSql.Append("EXTEND1=@EXTEND1,");
strSql.Append("EXTEND2=@EXTEND2,");
strSql.Append("EXTEND3=@EXTEND3");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@COMPANY", SqlDbType.NVarChar, 50),
new SqlParameter("@REPORTGROUP", SqlDbType.NVarChar, 50),
new SqlParameter("@CATEGARY", SqlDbType.NVarChar, 50),
new SqlParameter("@SECURITY", SqlDbType.NVarChar, 50),
new SqlParameter("@QUERY", SqlDbType.NVarChar, 50),
new SqlParameter("@USERGROUP", SqlDbType.NVarChar, 50),
new SqlParameter("@USERGROUPRIGHT", SqlDbType.NVarChar, 50),
new SqlParameter("@USERSETUP", SqlDbType.NVarChar, 50),
new SqlParameter("@AUDODATE", SqlDbType.DateTime),
new SqlParameter("@EXTEND1", SqlDbType.NVarChar, 50),
new SqlParameter("@EXTEND2", SqlDbType.NVarChar, 50),
new SqlParameter("@EXTEND3", SqlDbType.NVarChar, -1),
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@GID", SqlDbType.Int, 4)
};
parameters[0].Value = model.COMPANY;
parameters[1].Value = model.REPORTGROUP;
parameters[2].Value = model.CATEGARY;
parameters[3].Value = model.SECURITY;
parameters[4].Value = model.QUERY;
parameters[5].Value = model.USERGROUP;
parameters[6].Value = model.USERGROUPRIGHT;
parameters[7].Value = model.USERSETUP;
parameters[8].Value = model.AUDODATE;
parameters[9].Value = model.EXTEND1;
parameters[10].Value = model.EXTEND2;
parameters[11].Value = model.EXTEND3;
parameters[12].Value = model.ID;
parameters[13].Value = model.GID;
int rows = DbHelperSQL.ExecuteSql(UserID, strSql.ToString(), parameters);
if (rows > 0)
{
Model.AUDITLOG auditobj = model.GetAuditLogObject(null);
auditobj.UserID = UserID;
auditobj.CreateDate = DateTime.Now;
auditobj.MessageType = Model.AUDITLOG.Severity.Audit;
auditobj.ModuleName = "DAL.GROUPRIGHT.Update";
auditobj.Message = String.Format(AppNum.AuditMessage.GroupRightUpdateSuccess, model.ID);
AUDITLOG.Add(auditobj);
return(true);
}
else
{
return(false);
}
}
