public CUSTOMRP.Model.USER GetModel(int UserID, string UID, int DATABASEID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,UID,GID,DATABASEID,PASSWORD,VIEWLEVEL,REPORTGROUPLIST,USERGROUPLEVEL,SETUPUSER,REPORTRIGHT,AUTODATE,EMAIL,USERGROUP,NAME,SENSITIVITYLEVEL from [USER] ");
strSql.Append(" where UID=@UID and DATABASEID=@DATABASEID ");
SqlParameter[] parameters =
{
new SqlParameter("@UID", SqlDbType.NVarChar, 200),
new SqlParameter("@DATABASEID", SqlDbType.Int, 4)
};
parameters[0].Value = UID;
parameters[1].Value = DATABASEID;
CUSTOMRP.Model.USER model = new CUSTOMRP.Model.USER();
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 save_Click(object sender, EventArgs e)
{
foreach (RepeaterItem ri in this.Repeater3.Items)
{
if (ri.ItemType == ListItemType.Item || ri.ItemType == ListItemType.AlternatingItem)
{
Literal uid = ri.FindControl("uid") as Literal;
DropDownList viewLevel = ri.FindControl("DDLQUERYLEVEL") as DropDownList;
DropDownList USERGROUP = ri.FindControl("DDLUSERGROUP") as DropDownList;
CheckBoxList REPORTGROUP = ri.FindControl("CBLREPORTGROUP") as CheckBoxList;
CheckBoxList ReportRight = ri.FindControl("CBLReportRight") as CheckBoxList;
string struid = uid.Text;
int gid = Int32.Parse(USERGROUP.SelectedValue);
decimal vlevel = Decimal.Parse(viewLevel.SelectedValue);
string strreportGroup = Common.IncWeb.CheckBoxList_GetString(REPORTGROUP);
IList <int> strReportRight = Common.IncWeb.CheckBoxList_ToList(ReportRight);
long intReportRight = Common.Utils.getSum2N(strReportRight.ToArray());
CUSTOMRP.Model.USER myuser = QueryReport.Code.WebHelper.bllUSER.GetModel(me.ID, struid, me.DatabaseID);
myuser.SENSITIVITYLEVEL = vlevel;
myuser.REPORTGROUPLIST = strreportGroup;
myuser.REPORTRIGHT = (int)intReportRight;
myuser.GID = gid;
QueryReport.Code.WebHelper.bllUSER.Update(myuser);
}
}
//Server.Transfer("quicksetup.aspx", false);
Common.JScript.AlertAndRedirect(QueryReport.Code.AppNum.ErrorMsg.success, "UserList.aspx");
Response.End();
//this.lblJavascript.Text = String.Format("<script type=\"text/javascript\">alert({0});</script>", QueryReport.Code.AppNum.success);
}
private void Page_Init(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(Request.QueryString["id"]))
{
if (me.checkUserGroupRight(CUSTOMRP.Model.APPModuleID.usergroupright_user, "Add", me.LoginID) == false)
{
Common.JScript.AlertAndRedirect(AppNum.ErrorMsg.accesserror, "userlist.aspx");
Response.End();
}
isexist = false;
id = 0;
myUser = null;
this.Button2.Visible = false;
}
else
{
if (me.checkUserGroupRight(CUSTOMRP.Model.APPModuleID.usergroupright_user, "Modify", me.LoginID) == false)
{
Common.JScript.AlertAndRedirect(AppNum.ErrorMsg.accesserror, "userlist.aspx");
Response.End();
}
isexist = true;
id = Int32.Parse(Request.QueryString["id"]);
myUser = BllUser.GetModel(me.ID, id);
if (myUser == null)
{
Common.JScript.AlertAndRedirect(AppNum.ErrorMsg.parameter_error, "viewlevel.aspx");
Response.End();
}
}
}
public CUSTOMRP.Model.USER GetModelForUser(int UserID, string LoginID, int DatabaseID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,UID,GID,DATABASEID,PASSWORD,VIEWLEVEL,REPORTGROUPLIST,USERGROUPLEVEL,SETUPUSER,REPORTRIGHT,AUTODATE,EMAIL,USERGROUP,NAME,SENSITIVITYLEVEL from [USER]");
strSql.Append(" where UID = @UID AND DATABASEID = @DATABASEID");
CUSTOMRP.Model.USER model = new CUSTOMRP.Model.USER();
DataSet ds = DbHelperSQL.Query(UserID, strSql.ToString(), new SqlParameter("@UID", LoginID), new SqlParameter("@DATABASEID", DatabaseID));
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(CUSTOMRP.Model.USER model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [USER](");
strSql.Append("UID,GID,DATABASEID,PASSWORD,VIEWLEVEL,REPORTGROUPLIST,USERGROUPLEVEL,SETUPUSER,REPORTRIGHT,AUTODATE,EMAIL,USERGROUP,NAME,SENSITIVITYLEVEL)");
strSql.Append(" values (");
strSql.Append("@UID,@GID,@DATABASEID,@PASSWORD,@VIEWLEVEL,@REPORTGROUPLIST,@USERGROUPLEVEL,@SETUPUSER,@REPORTRIGHT,@AUTODATE,@EMAIL,@USERGROUP,@NAME,@SENSITIVITYLEVEL)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@UID", SqlDbType.NVarChar, 200),
new SqlParameter("@GID", SqlDbType.Int, 4),
new SqlParameter("@DATABASEID", SqlDbType.Int, 4),
new SqlParameter("@PASSWORD", SqlDbType.NVarChar, 50),
new SqlParameter("@VIEWLEVEL", SqlDbType.NVarChar, 2000),
new SqlParameter("@REPORTGROUPLIST", SqlDbType.NVarChar, 2000),
new SqlParameter("@USERGROUPLEVEL", SqlDbType.NVarChar, 2000),
new SqlParameter("@SETUPUSER", SqlDbType.Int, 4),
new SqlParameter("@REPORTRIGHT", SqlDbType.Int, 4),
new SqlParameter("@AUTODATE", SqlDbType.DateTime),
new SqlParameter("@EMAIL", SqlDbType.NVarChar, 2000),
new SqlParameter("@USERGROUP", SqlDbType.NVarChar, 100),
new SqlParameter("@NAME", SqlDbType.NVarChar, 50),
new SqlParameter("@SENSITIVITYLEVEL", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.UID;
parameters[1].Value = model.GID;
parameters[2].Value = model.DATABASEID;
parameters[3].Value = model.PASSWORD;
parameters[4].Value = model.VIEWLEVEL;
parameters[5].Value = model.REPORTGROUPLIST;
parameters[6].Value = model.USERGROUPLEVEL;
parameters[7].Value = model.SETUPUSER;
parameters[8].Value = model.REPORTRIGHT;
parameters[9].Value = model.AUTODATE;
parameters[10].Value = model.EMAIL;
parameters[11].Value = model.USERGROUP;
parameters[12].Value = model.NAME;
parameters[13].Value = model.SENSITIVITYLEVEL;
object obj = DbHelperSQL.GetSingle(model.SETUPUSER, strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
model.ID = Convert.ToInt32(obj);
Model.AUDITLOG auditobj = model.GetAuditLogObject(null);
auditobj.UserID = model.SETUPUSER;
auditobj.CreateDate = DateTime.Now;
auditobj.MessageType = Model.AUDITLOG.Severity.Audit;
auditobj.ModuleName = "DAL.USER.Add";
auditobj.Message = String.Format(AppNum.AuditMessage.UserInsertSuccess, model.ID);
AUDITLOG.Add(auditobj);
return(model.ID);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public CUSTOMRP.Model.USER DataRowToModel(DataRow row)
{
CUSTOMRP.Model.USER model = new CUSTOMRP.Model.USER();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = Int32.Parse(row["ID"].ToString());
}
if (row["UID"] != null)
{
model.UID = row["UID"].ToString();
}
if (row["GID"] != null && row["GID"].ToString() != "")
{
model.GID = Int32.Parse(row["GID"].ToString());
}
if (row["DATABASEID"] != null && row["DATABASEID"].ToString() != "")
{
model.DATABASEID = Int32.Parse(row["DATABASEID"].ToString());
}
if (row["PASSWORD"] != null)
{
model.PASSWORD = row["PASSWORD"].ToString();
}
if (row["VIEWLEVEL"] != null)
{
model.VIEWLEVEL = row["VIEWLEVEL"].ToString();
}
if (row["REPORTGROUPLIST"] != null)
{
model.REPORTGROUPLIST = row["REPORTGROUPLIST"].ToString();
}
if (row["USERGROUPLEVEL"] != null)
{
model.USERGROUPLEVEL = row["USERGROUPLEVEL"].ToString();
}
if (row["SETUPUSER"] != null && row["SETUPUSER"].ToString() != "")
{
model.SETUPUSER = Int32.Parse(row["SETUPUSER"].ToString());
}
if (row["REPORTRIGHT"] != null && row["REPORTRIGHT"].ToString() != "")
{
model.REPORTRIGHT = Int32.Parse(row["REPORTRIGHT"].ToString());
}
if (row["AUTODATE"] != null && row["AUTODATE"].ToString() != "")
{
model.AUTODATE = DateTime.Parse(row["AUTODATE"].ToString());
}
if (row["EMAIL"] != null)
{
model.EMAIL = row["EMAIL"].ToString();
}
if (row["USERGROUP"] != null)
{
model.USERGROUP = row["USERGROUP"].ToString();
}
if (row["NAME"] != null)
{
model.NAME = row["NAME"].ToString();
}
if (row["SENSITIVITYLEVEL"] != null && row["SENSITIVITYLEVEL"].ToString() != "")
{
model.SENSITIVITYLEVEL = Decimal.Parse(row["SENSITIVITYLEVEL"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(CUSTOMRP.Model.USER model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update [USER] set ");
strSql.Append("DATABASEID=@DATABASEID,");
strSql.Append("PASSWORD=@PASSWORD,");
strSql.Append("VIEWLEVEL=@VIEWLEVEL,");
strSql.Append("REPORTGROUPLIST=@REPORTGROUPLIST,");
strSql.Append("USERGROUPLEVEL=@USERGROUPLEVEL,");
strSql.Append("SETUPUSER=@SETUPUSER,");
strSql.Append("REPORTRIGHT=@REPORTRIGHT,");
strSql.Append("AUTODATE=@AUTODATE,");
strSql.Append("EMAIL=@EMAIL,");
strSql.Append("USERGROUP=@USERGROUP,");
strSql.Append("NAME=@NAME,");
strSql.Append("SENSITIVITYLEVEL=@SENSITIVITYLEVEL,");
strSql.Append("GID=@GID");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@DATABASEID", SqlDbType.Int, 4),
new SqlParameter("@PASSWORD", SqlDbType.NVarChar, 50),
new SqlParameter("@VIEWLEVEL", SqlDbType.NVarChar, 2000),
new SqlParameter("@REPORTGROUPLIST", SqlDbType.NVarChar, 2000),
new SqlParameter("@USERGROUPLEVEL", SqlDbType.NVarChar, 2000),
new SqlParameter("@SETUPUSER", SqlDbType.Int, 4),
new SqlParameter("@REPORTRIGHT", SqlDbType.Int, 4),
new SqlParameter("@AUTODATE", SqlDbType.DateTime),
new SqlParameter("@EMAIL", SqlDbType.NVarChar, 2000),
new SqlParameter("@USERGROUP", SqlDbType.NVarChar, 100),
new SqlParameter("@NAME", SqlDbType.NVarChar, 50),
new SqlParameter("@SENSITIVITYLEVEL", SqlDbType.Decimal, 9),
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@UID", SqlDbType.NVarChar, 200),
new SqlParameter("@GID", SqlDbType.Int, 4)
};
parameters[0].Value = model.DATABASEID;
parameters[1].Value = model.PASSWORD;
parameters[2].Value = model.VIEWLEVEL;
parameters[3].Value = model.REPORTGROUPLIST;
parameters[4].Value = model.USERGROUPLEVEL;
parameters[5].Value = model.SETUPUSER;
parameters[6].Value = model.REPORTRIGHT;
parameters[7].Value = model.AUTODATE;
parameters[8].Value = model.EMAIL;
parameters[9].Value = model.USERGROUP;
parameters[10].Value = model.NAME;
parameters[11].Value = model.SENSITIVITYLEVEL;
parameters[12].Value = model.ID;
parameters[13].Value = model.UID;
parameters[14].Value = model.GID;
int rows = DbHelperSQL.ExecuteSql(model.SETUPUSER, strSql.ToString(), parameters);
if (rows > 0)
{
Model.AUDITLOG auditobj = model.GetAuditLogObject(null);
auditobj.UserID = model.SETUPUSER;
auditobj.CreateDate = DateTime.Now;
auditobj.MessageType = Model.AUDITLOG.Severity.Audit;
auditobj.ModuleName = "DAL.USER.Update";
auditobj.Message = String.Format(AppNum.AuditMessage.UserUpdateSuccess, model.ID);
AUDITLOG.Add(auditobj);
return(true);
}
else
{
return(false);
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (isexist == false)
{
string uid = this.txtuid.Text.Trim();
string password = Common.Utils.MD5NET(this.txtp1.Text.Trim());
string email = this.txtemail.Text.Trim();
string name = this.txtusername.Text.Trim();
decimal sensitivitylevel = Decimal.Parse(this.ddlsensitivitylevel.SelectedValue);
int usergroup = Int32.Parse(this.DDLUSERGROUP.SelectedValue);
if (BllUser.GetList(me.ID, "UID='" + uid + "' AND DATABASEID = '" + me.DatabaseID + "'").Tables[0].Rows.Count > 0)
{
//Common.JScript.Alert(AppNum.Commonexits);
//Common.JScript.GoHistory(-1);
Common.JScript.AlertAndRedirect(AppNum.ErrorMsg.Commonexits, "UserList.aspx");
Response.End();
}
CUSTOMRP.Model.USER myUser = new CUSTOMRP.Model.USER();
myUser.SETUPUSER = 0;
myUser.DATABASEID = me.DatabaseID;
myUser.UID = uid;
myUser.PASSWORD = password;
myUser.EMAIL = email;
myUser.NAME = name;
myUser.SENSITIVITYLEVEL = sensitivitylevel;
myUser.GID = usergroup;
int[] arrayrpr = Common.IncWeb.CheckBoxList_ToList(this.CBLReportRight).ToArray();
myUser.REPORTRIGHT = (int)Common.Utils.getSum2N(arrayrpr);
myUser.REPORTGROUPLIST = Common.IncWeb.CheckBoxList_GetString(this.CBLReportGroup);
myUser.VIEWLEVEL = "";
BllUser.Add(myUser);
}
else
{
string password = Common.Utils.MD5NET(this.txtp1.Text.Trim());
string email = this.txtemail.Text.Trim();
string name = this.txtusername.Text.Trim();
decimal sensitivitylevel = Decimal.Parse(this.ddlsensitivitylevel.SelectedValue);
int usergroup = Int32.Parse(DDLUSERGROUP.SelectedValue);
myUser.DATABASEID = me.DatabaseID;
if (this.txtp1.Text.Trim() != "")
{
myUser.PASSWORD = password;
}
myUser.EMAIL = email;
myUser.NAME = name;
myUser.SENSITIVITYLEVEL = sensitivitylevel;
myUser.GID = usergroup;
int[] arrayrpr = Common.IncWeb.CheckBoxList_ToList(this.CBLReportRight).ToArray();
myUser.REPORTRIGHT = (int)Common.Utils.getSum2N(arrayrpr);
myUser.REPORTGROUPLIST = Common.IncWeb.CheckBoxList_GetString(this.CBLReportGroup);
BllUser.Update(myUser);
}
Common.JScript.AlertAndRedirect(AppNum.ErrorMsg.success, "UserList.aspx");
Response.End();
}
