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