private UserListEntity GetUserListFromDataRow(DataRow dr) { UserListEntity dt = new UserListEntity(); if (dr["UserSerialID"].ToString() != "" || dr["UserSerialID"] != null) dt.UserSerialID = Int32.Parse(dr["UserSerialID"].ToString()); dt.UserID = dr["UserID"].ToString(); dt.PassWord = dr["PassWord"].ToString(); dt.UserName = dr["UserName"].ToString(); dt.UserType = dr["UserType"].ToString(); dt.UserTypeN = dr["UserTypeN"].ToString(); dt.UserEmail = dr["UserEmail"].ToString(); dt.UserCode = dr["UserCode"].ToString(); dt.DeptName = dr["DeptName"].ToString(); dt.UseFlag = dr["UseFlag"].ToString(); dt.CreateUser = dr["CreateUser"].ToString(); dt.CreateDate = Convert.ToDateTime(dr["CreateDate"]); dt.LastModifier = dr["LastModifier"].ToString(); dt.LastModifyDate = Convert.ToDateTime(dr["LastModifyDate"]); return dt; }
/// <summary> /// 修改信息 /// </summary> /// <param name="_UserListEntity"></param> /// <returns>返回string "-1"表示该已经存在,否则成功 </returns> public string UpdateUserList(UserListEntity _UserListEntity) { DbParameter[] pramsUpdate = { MakeInParam("@UserSerialID",(DbType)SqlDbType.Int,4,_UserListEntity.UserSerialID ), MakeInParam("@UserID",(DbType)SqlDbType.VarChar,50,_UserListEntity.UserID ), MakeInParam("@PassWord",(DbType)SqlDbType.VarChar,50,_UserListEntity.PassWord ), MakeInParam("@UserName",(DbType)SqlDbType.VarChar,50,_UserListEntity.UserName ), MakeInParam("@UserType",(DbType)SqlDbType.VarChar,50,_UserListEntity.UserType ), MakeInParam("@UserEmail",(DbType)SqlDbType.VarChar,50,_UserListEntity.UserEmail ), MakeInParam("@UserCode",(DbType)SqlDbType.VarChar,50,_UserListEntity.UserCode ), MakeInParam("@UseFlag",(DbType)SqlDbType.VarChar,1,_UserListEntity.UseFlag ), MakeInParam("@LastModifier",(DbType)SqlDbType.VarChar,50,_UserListEntity.LastModifier ), MakeInParam("@LastModifyDate",(DbType)SqlDbType.DateTime,16,_UserListEntity.LastModifyDate ), }; StringBuilder sb = new StringBuilder(); sb.Append("Update [dbo].[UserList]"); sb.Append(" set "); sb.Append(" [UserID]=@UserID,"); sb.Append(" [PassWord]=@PassWord,"); sb.Append(" [UserName]=@UserName,"); sb.Append(" [UserType]=@UserType,"); sb.Append(" [UserEmail]=@UserEmail,"); sb.Append(" [UserCode]=@UserCode,"); sb.Append(" [UseFlag]=@UseFlag,"); sb.Append(" [LastModifier]=@LastModifier,"); sb.Append(" [LastModifyDate]=@LastModifyDate "); sb.Append(" where [UserSerialID]=@UserSerialID "); return ExecuteNonQuery(CommandType.Text, sb.ToString(), pramsUpdate).ToString(); }
/// <summary> /// 新增信息 /// </summary> /// <param name="_UserListEntity"></param> /// <returns>返回string "-1"表示该已经存在,否则成功 </returns> public string AddUserList(UserListEntity _UserListEntity) { //判断该记录是否已经存在 DbParameter[] prams = { MakeInParam("@UserID",(DbType)SqlDbType.VarChar,50,_UserListEntity.UserID ), MakeInParam("@UserCode",(DbType)SqlDbType.VarChar,50,_UserListEntity.UserCode ), MakeInParam("@UserType",(DbType)SqlDbType.VarChar,50,_UserListEntity.UserType ), }; string sql = "select * from UserList where (len(@UserID)>0 and UserID=@UserID) or (@UserType='0' and UserCode=@UserCode) "; if (ExecuteDataset(CommandType.Text, sql, prams).Tables[0].Rows.Count > 0) { return "-2";//该记录已经存在 } else { DbParameter[] pramsInsert = { MakeInParam("@UserID",(DbType)SqlDbType.VarChar,50,_UserListEntity.UserID ), MakeInParam("@PassWord",(DbType)SqlDbType.VarChar,50,_UserListEntity.PassWord ), MakeInParam("@UserName",(DbType)SqlDbType.VarChar,50,_UserListEntity.UserName ), MakeInParam("@UserType",(DbType)SqlDbType.VarChar,50,_UserListEntity.UserType ), MakeInParam("@UserEmail",(DbType)SqlDbType.VarChar,50,_UserListEntity.UserEmail ), MakeInParam("@UserCode",(DbType)SqlDbType.VarChar,50,_UserListEntity.UserCode ), MakeInParam("@UseFlag",(DbType)SqlDbType.VarChar,1,_UserListEntity.UseFlag ), MakeInParam("@CreateUser",(DbType)SqlDbType.VarChar,50,_UserListEntity.CreateUser ), MakeInParam("@CreateDate",(DbType)SqlDbType.DateTime,16,_UserListEntity.CreateDate ), MakeInParam("@LastModifier",(DbType)SqlDbType.VarChar,50,_UserListEntity.LastModifier ), MakeInParam("@LastModifyDate",(DbType)SqlDbType.DateTime,16,_UserListEntity.LastModifyDate ), }; StringBuilder sb = new StringBuilder(); sb.Append("INSERT INTO [dbo].[UserList]"); sb.Append("("); sb.Append(" [UserID]"); sb.Append(",[PassWord]"); sb.Append(",[UserName]"); sb.Append(",[UserType]"); sb.Append(",[UserEmail]"); sb.Append(",[UserCode]"); sb.Append(",[UseFlag]"); sb.Append(",[CreateUser]"); sb.Append(",[CreateDate]"); sb.Append(",[LastModifier]"); sb.Append(",[LastModifyDate]"); sb.Append(") "); sb.Append(" VALUES ("); sb.Append("@UserID,"); sb.Append("@PassWord,"); sb.Append("@UserName,"); sb.Append("@UserType,"); sb.Append("@UserEmail,"); sb.Append("@UserCode,"); sb.Append("@UseFlag,"); sb.Append("@CreateUser,"); sb.Append("@CreateDate,"); sb.Append("@LastModifier,"); sb.Append("@LastModifyDate )"); sb.Append("select @@identity;"); return ExecuteScalar(CommandType.Text, sb.ToString(), pramsInsert).ToString(); } }
protected void Share_Button(object sender, EventArgs e) { string szAllName; szAllName = txtSendTo.Text; int iCount = 0; string[] szOneAllName = szAllName.Split(';'); int CalendarID=0, PermissionUserID=0; foreach (string szOneName in szOneAllName) { if (szOneName != "") { string[] szName = szOneName.Split('('); CalendarPermission _CalendarPermission = new CalendarPermission(); foreach (string szUserName in szName) { iCount++; if (iCount == 1) { _CalendarPermission = new CalendarPermission(); UserListEntity _UserListEntity = new UserListEntity(); _UserListEntity = DbHelper.GetInstance().GetUserListEntityByUserID(szUserName); if (_UserListEntity != null) { _CalendarPermission.CalendarPermissionUserID = _UserListEntity.UserSerialID; //共享人员ID PermissionUserID = _UserListEntity.UserSerialID; } else _CalendarPermission.CalendarID = 0; _CalendarPermission.CalendarID = Int32.Parse(Context.Session["UserID"].ToString()); CalendarID = Int32.Parse(Context.Session["UserID"].ToString()); } else { string[] szPermission = szUserName.Split(')'); int iPerCount = 0; foreach (string szPermissionName in szPermission) { iPerCount++; if (iPerCount == 1) { _CalendarPermission.CalendarPer = szPermissionName; //权限 CalendarPermission _Calendar = DbHelper.GetInstance().GetCalendarPermissionEntityByID(CalendarID, PermissionUserID); if (_Calendar == null) { string szIndex = DbHelper.GetInstance().AddNewsCalenderPermission(_CalendarPermission); //添加 } else { string szIndex = DbHelper.GetInstance().UpDateCalendarPermission(_CalendarPermission); //更新 } } else iPerCount = 0; } iCount = 0; } } } } }
private string SaveData() { UserListEntity _UserListEntity = new UserListEntity(); _UserListEntity.UserSerialID = Convert.ToInt32(txtUserSerialID.Value != string.Empty ? txtUserSerialID.Value : "0"); _UserListEntity.UserID = txtUserID.Text; _UserListEntity.UserName = txtUserName.Text; _UserListEntity.UserType = ddlUserType.SelectedValue; _UserListEntity.UserEmail = txtUserEmail.Text; _UserListEntity.UserCode = txtUserCode.Text; _UserListEntity.UseFlag = chkUseFlag.Checked ? "1" : "0"; _UserListEntity.CreateUser = userEntity.UserID; _UserListEntity.CreateDate = DateTime.Now; _UserListEntity.LastModifier = userEntity.UserID; _UserListEntity.LastModifyDate = DateTime.Now; string sResult = "-1"; if (strOperationState == "Add") sResult = DbHelper.GetInstance().AddUserList(_UserListEntity); else if (strOperationState == "Update") sResult = DbHelper.GetInstance().UpdateUserList(_UserListEntity); return sResult; }
/// <summary> /// BasePage类构造函数 /// </summary> public BasePage() { strButtonHideScript = "<script type=\"text/javascript\" lanuage=\"javascript\"> \r\n" + "buttonHidesuccess(); \r\n" + "</script> \r\n"; config = GeneralConfigs.GetConfig(); //先看是否正常登陆 userid=WebUtils.GetCookieUser(); password = WebUtils.GetCookiePassword(config.Passwordkey); if (userid == "" || password == "") { Context.Response.Redirect("/login.aspx",true); return; } if (!Page.IsPostBack) { this.RegisterAdminPageClientScriptBlock(); } if (userEntity == null) { userEntity = DbHelper.GetInstance().GetUserListEntityByUserID(userid); } if (config.Closed == 1 && pagename != "login.aspx" && pagename != "logout.aspx" && pagename != "register.aspx" ) { ShowMessage(1); return; } nowdate = Utils.GetDate(); nowtime = Utils.GetTime(); nowdatetime = Utils.GetDateTime(); link = ""; script = ""; isseccode = Utils.InArray(pagename, config.Seccodestatus); if ((isseccode)) { if (DNTRequest.GetString("vcode") == "") { if (pagename == "showforum.aspx") { } else if (pagename.EndsWith("ajax.aspx")) { if (DNTRequest.GetString("t") == "quickreply") { ResponseAjaxVcodeError(); } } else { AddErrLine("验证码错误"); } } else { } } m_starttickDateTime = DateTime.Now; ShowPage(); m_processtime = DateTime.Now.Subtract(m_starttickDateTime).TotalMilliseconds / 1000; }