/// <summary> /// 更新一条数据 /// </summary> public void Update(ManagementCenter.Model.UM_UserInfo model, DbTransaction tran, Database db) { StringBuilder strSql = new StringBuilder(); strSql.Append("update UM_UserInfo set "); strSql.Append("UserName=@UserName,"); strSql.Append("LoginName=@LoginName,"); strSql.Append("Password=@Password,"); strSql.Append("CertificateStyle=@CertificateStyle,"); strSql.Append("Postalcode=@Postalcode,"); strSql.Append("RoleID=@RoleID,"); strSql.Append("CertificateNo=@CertificateNo,"); strSql.Append("Telephone=@Telephone,"); strSql.Append("Address=@Address,"); strSql.Append("Email=@Email,"); strSql.Append("QuestionID=@QuestionID,"); strSql.Append("Answer=@Answer,"); strSql.Append("CouterID=@CouterID,"); strSql.Append("Remark=@Remark,"); strSql.Append("AddType=@AddType,"); strSql.Append("AddTime=@AddTime"); strSql.Append(" where UserID=@UserID "); if (db == null) { db = DatabaseFactory.CreateDatabase(); } DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "UserName", DbType.String, model.UserName); db.AddInParameter(dbCommand, "LoginName", DbType.String, model.LoginName); db.AddInParameter(dbCommand, "Password", DbType.String, model.Password); db.AddInParameter(dbCommand, "UserID", DbType.Int32, model.UserID); db.AddInParameter(dbCommand, "CertificateStyle", DbType.Int32, model.CertificateStyle); db.AddInParameter(dbCommand, "Postalcode", DbType.String, model.Postalcode); db.AddInParameter(dbCommand, "RoleID", DbType.Int32, model.RoleID); db.AddInParameter(dbCommand, "CertificateNo", DbType.String, model.CertificateNo); db.AddInParameter(dbCommand, "Telephone", DbType.String, model.Telephone); db.AddInParameter(dbCommand, "Address", DbType.String, model.Address); db.AddInParameter(dbCommand, "Email", DbType.String, model.Email); db.AddInParameter(dbCommand, "QuestionID", DbType.Int32, model.QuestionID); db.AddInParameter(dbCommand, "Answer", DbType.String, model.Answer); db.AddInParameter(dbCommand, "CouterID", DbType.Int32, model.CouterID); db.AddInParameter(dbCommand, "Remark", DbType.String, model.Remark); db.AddInParameter(dbCommand, "AddType", DbType.Int32, model.AddType); db.AddInParameter(dbCommand, "AddTime", DbType.DateTime, model.AddTime); if (tran == null) { db.ExecuteNonQuery(dbCommand); } else { db.ExecuteNonQuery(dbCommand, tran); } }
/// <summary> /// 对象实体绑定数据 /// </summary> public ManagementCenter.Model.UM_UserInfo ReaderBind(IDataReader dataReader) { ManagementCenter.Model.UM_UserInfo model = new ManagementCenter.Model.UM_UserInfo(); object ojb; model.UserName = dataReader["UserName"].ToString(); model.LoginName = dataReader["LoginName"].ToString(); model.Password = dataReader["Password"].ToString(); ojb = dataReader["UserID"]; if (ojb != null && ojb != DBNull.Value) { model.UserID = (int)ojb; } ojb = dataReader["CertificateStyle"]; if (ojb != null && ojb != DBNull.Value) { model.CertificateStyle = (int)ojb; } model.Postalcode = dataReader["Postalcode"].ToString(); ojb = dataReader["RoleID"]; if (ojb != null && ojb != DBNull.Value) { model.RoleID = (int)ojb; } model.CertificateNo = dataReader["CertificateNo"].ToString(); model.Telephone = dataReader["Telephone"].ToString(); model.Address = dataReader["Address"].ToString(); model.Email = dataReader["Email"].ToString(); ojb = dataReader["QuestionID"]; if (ojb != null && ojb != DBNull.Value) { model.QuestionID = (int)ojb; } model.Answer = dataReader["Answer"].ToString(); ojb = dataReader["CouterID"]; if (ojb != null && ojb != DBNull.Value) { model.CouterID = (int)ojb; } ojb = dataReader["AddTime"]; if (ojb != null && ojb != DBNull.Value) { model.AddTime = (DateTime)ojb; } ojb = dataReader["AddType"]; if (ojb != null && ojb != DBNull.Value) { model.AddType = (int)ojb; } model.Remark = dataReader["Remark"].ToString(); return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ManagementCenter.Model.UM_UserInfo model, DbTransaction tran, Database db) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into UM_UserInfo("); strSql.Append("UserName,LoginName,Password,CertificateStyle,Postalcode,RoleID,CertificateNo,Telephone,Address,Email,QuestionID,Answer,CouterID,Remark,AddType,AddTime)"); strSql.Append(" values ("); strSql.Append("@UserName,@LoginName,@Password,@CertificateStyle,@Postalcode,@RoleID,@CertificateNo,@Telephone,@Address,@Email,@QuestionID,@Answer,@CouterID,@Remark,@AddType,@AddTime)"); strSql.Append(";select @@IDENTITY"); if (db == null) { db = DatabaseFactory.CreateDatabase(); } DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "UserName", DbType.String, model.UserName); db.AddInParameter(dbCommand, "LoginName", DbType.String, model.LoginName); db.AddInParameter(dbCommand, "Password", DbType.String, UtilityClass.DesEncrypt(model.Password, string.Empty)); db.AddInParameter(dbCommand, "CertificateStyle", DbType.Int32, model.CertificateStyle); db.AddInParameter(dbCommand, "Postalcode", DbType.String, model.Postalcode); db.AddInParameter(dbCommand, "RoleID", DbType.Int32, model.RoleID); db.AddInParameter(dbCommand, "CertificateNo", DbType.String, model.CertificateNo); db.AddInParameter(dbCommand, "Telephone", DbType.String, model.Telephone); db.AddInParameter(dbCommand, "Address", DbType.String, model.Address); db.AddInParameter(dbCommand, "Email", DbType.String, model.Email); db.AddInParameter(dbCommand, "QuestionID", DbType.Int32, model.QuestionID); db.AddInParameter(dbCommand, "Answer", DbType.String, model.Answer); db.AddInParameter(dbCommand, "CouterID", DbType.Int32, model.CouterID); db.AddInParameter(dbCommand, "Remark", DbType.String, model.Remark); db.AddInParameter(dbCommand, "AddType", DbType.Int32, model.AddType); db.AddInParameter(dbCommand, "AddTime", DbType.DateTime, System.DateTime.Now); int result; object obj; if (tran == null) { obj = db.ExecuteScalar(dbCommand); } else { obj = db.ExecuteScalar(dbCommand, tran); } if (!int.TryParse(obj.ToString(), out result)) { return(0); } return(result); }
/// <summary> /// 获得数据列表 /// </summary> //public DataSet GetList(int PageSize,int PageIndex,string strWhere) //{ //return dal.GetList(PageSize,PageIndex,strWhere); //} #endregion //===========================================管理员=============================================== #region 添加管理员 /// <summary> /// 添加管理员 /// </summary> /// <param name="model"></param> /// <param name="RightGroupID"></param> /// <returns></returns> public bool ManagerAdd(ManagementCenter.Model.UM_UserInfo model, int RightGroupID) { ManagementCenter.DAL.UM_UserInfoDAL UserInfoDAL = new UM_UserInfoDAL(); ManagementCenter.DAL.UM_ManagerBeloneToGroupDAL ManagerBeloneToGroupDAL = new UM_ManagerBeloneToGroupDAL(); Database db = DatabaseFactory.CreateDatabase(); DbConnection Conn = db.CreateConnection(); if (Conn.State != ConnectionState.Open) { Conn.Open(); } DbTransaction Tran = Conn.BeginTransaction(); try { int UserID = UserInfoDAL.Add(model, Tran, db); if (UserID != 0) { UM_ManagerBeloneToGroup ManagerBeloneToGroup = new UM_ManagerBeloneToGroup(); ManagerBeloneToGroup.UserID = UserID; ManagerBeloneToGroup.ManagerGroupID = RightGroupID; ManagerBeloneToGroupDAL.Add(ManagerBeloneToGroup, Tran, db); Tran.Commit(); } } catch (Exception ex) { Tran.Rollback(); string errCode = "GL-1100"; string errMsg = "添加管理员失败!"; VTException vte = new VTException(errCode, errMsg, ex); LogHelper.WriteError(vte.ToString(), vte.InnerException); return(false); } finally { if (Conn.State == ConnectionState.Open) { Conn.Close(); } } return(true); }
/// <summary> /// 登陆验证 /// </summary> public ManagementCenter.Model.UM_UserInfo TranLogin(int UserID, string Password) { string SQL_SELECT_Login = @"select * FROM UM_UserInfo where UserID=@UserID AND Password=@Password AND RoleID=@RoleID "; Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(SQL_SELECT_Login); db.AddInParameter(dbCommand, "UserID", DbType.Int32, UserID); db.AddInParameter(dbCommand, "Password", DbType.String, Password); db.AddInParameter(dbCommand, "RoleID", DbType.Int32, (int)Types.RoleTypeEnum.Transaction); ManagementCenter.Model.UM_UserInfo model = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public ManagementCenter.Model.UM_UserInfo GetModel(int UserID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select UserName,LoginName,Password,UserID,CertificateStyle,Postalcode,RoleID,CertificateNo,Telephone,Address,Email,QuestionID,Answer,CouterID,Remark,AddType,AddTime from UM_UserInfo "); strSql.Append(" where UserID=@UserID "); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "UserID", DbType.Int32, UserID); ManagementCenter.Model.UM_UserInfo model = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } return(model); }
/// <summary> /// 对管理员用户名和密码进行验证 /// </summary> /// <param name="LoginName">管理员用户名</param> /// <param name="PassWord">密码</param> /// <returns>查询出的数据</returns> public ManagementCenter.Model.UM_UserInfo AdminLogin(string LoginName, string PassWord) { string SQL_SELECT_Login = @"SELECT [UserName],[LoginName],[Password],[UserID],[CertificateStyle],[Postalcode],[RoleID], [CertificateNo],[Telephone],[Address],[Email],[QuestionID],[Answer],[CouterID],[Remark],[AddType],[AddTime] FROM UM_UserInfo where LoginName=@LoginName AND Password=@Password AND (RoleID=1 or RoleID=2)"; Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(SQL_SELECT_Login); db.AddInParameter(dbCommand, "LoginName", DbType.String, LoginName); db.AddInParameter(dbCommand, "Password", DbType.String, PassWord); ManagementCenter.Model.UM_UserInfo model = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } return(model); }
/// <summary> /// 更新交易员 /// </summary> /// <param name="userInfo">交易员实体</param> /// <param name="MLoginName">管理员登陆名称</param> /// <param name="ManagerPWd">管理员密码</param> /// <param name="message">返回的信息</param> /// <returns></returns> public bool UpdateTransactionAll(Entity.UM_UserInfo userInfo, string MLoginName, string ManagerPWd, out string message) { message = string.Empty; return(false); }
/// <summary> /// 更新用户信息 /// </summary> /// <param name="model">用户信息实体</param> public void Update(ManagementCenter.Model.UM_UserInfo model) { Update(model, null, null); }
/// <summary> /// 添加用户信息 /// </summary> /// <param name="model">用户信息实体</param> /// <returns></returns> public int Add(ManagementCenter.Model.UM_UserInfo model) { return(Add(model, null, null)); }