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(); }