/// <summary>
/// 获取用户信息
/// </summary>
/// <param name="ID"></param>
/// <returns>Users</returns>
public Entity.User.Users GetUsers(String cName)
{
Entity.User.Users entity = null;
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
try
{
IDbDataParameter[] prams =
{
dbFactory.MakeInParam("@cName", DBTypeConverter.ConvertCsTypeToOriginDBType(cName.GetType().ToString()), cName, 50)
};
IDataReader dataReader = db.ExecuteReader(Config.constr, CommandType.Text, "select UserID from t_R_UserInfo where Name='" + cName + "'", prams);
while (dataReader.Read())
{
entity = new Entity.User.Users();
entity.UserID = dataReader["UserID"].ToString();
break;
}
}
catch (Exception ex)
{
Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal);
}
finally
{
db.Conn.Close();
}
return(entity);
}
/// <summary>
///保存用户AB角
/// </summary>
/// <param name="users"></param>
/// <returns></returns>
public int DeleteAB(Entity.User.Users users, string role, string typeID)
{
int iReturn = 0;
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
SqlTransactionHelper thelper = new SqlTransactionHelper(Config.constr);
IDbTransaction trans = thelper.StartTransaction();
try
{
IDbDataParameter[] prams =
{
};
//iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_UserInfo_Update", prams);
//iReturn = int.Parse(prams[7].Value.ToString());
string strinsert = "Delete from t_MoniterUser where userid='" + users.UserID + "' and role='" + role + "' and typeid='" + typeID + "'";
db.ExecuteNonQueryTrans(trans, CommandType.Text, strinsert, prams);
thelper.CommitTransaction(trans);
iReturn = 1;
}
catch (Exception ex)
{
iReturn = 0;
thelper.RollTransaction(trans);
Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal);
}
finally
{
db.Conn.Close();
}
return(iReturn);
}
/// <summary>
/// 查询用户
/// </summary>
/// <returns></returns>
public List <Entity.User.Users> QueryUsers(string cName, int bStop, string cDepCode, int iRole, int level)
{
List <Entity.User.Users> list = new List <Entity.User.Users>();
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
try
{
IDbDataParameter[] prams =
{
dbFactory.MakeInParam("@cName", DBTypeConverter.ConvertCsTypeToOriginDBType(cName.GetType().ToString()), cName, 50),
dbFactory.MakeInParam("@cDepCode", DBTypeConverter.ConvertCsTypeToOriginDBType(cDepCode.GetType().ToString()), cDepCode, 50),
dbFactory.MakeInParam("@bStop", DBTypeConverter.ConvertCsTypeToOriginDBType(bStop.GetType().ToString()), bStop, 50),
dbFactory.MakeInParam("@level", DBTypeConverter.ConvertCsTypeToOriginDBType(level.GetType().ToString()), level, 0),
dbFactory.MakeInParam("@iRole", DBTypeConverter.ConvertCsTypeToOriginDBType(iRole.GetType().ToString()), iRole, 0)
};
IDataReader dataReader = db.ExecuteReader(Config.constr, CommandType.StoredProcedure, "proc_User_QueryCondition", prams);
while (dataReader.Read())
{
Entity.User.Users entity = new Entity.User.Users();
entity.ID = int.Parse(dataReader["ID"].ToString());
entity.CName = dataReader["cName"].ToString();
entity.CMemo = dataReader["cMemo"].ToString();
entity.Guid = System.Guid.NewGuid().ToString();
entity.BStop = bool.Parse(dataReader["bStop"].ToString());
entity.BStopName = dataReader["BStopName"].ToString();
entity.BAdmin = bool.Parse(dataReader["BAdmin"].ToString());
entity.BAdminName = dataReader["BAdminName"].ToString();
entity.CRole = GetName(dataReader["IRoleType"].ToString());
entity.IRoleType = DataHelper.ParseToInt(dataReader["IRoleType"].ToString());
entity.CDepCode = dataReader["CDepCode"].ToString();
//entity.CDepCodeName = GetName(entity.CDepCode, entity.IRoleType);
entity.CPhone = dataReader["CPhone"].ToString();
entity.DActivityLastTime = DateTime.Parse(dataReader["dActivityLastTime"].ToString());
entity.CActivityIP = dataReader["cActivityIP"].ToString();
entity.DCreateDate = DateTime.Parse(dataReader["dCreateDate"].ToString());
entity.CCreateUser = dataReader["cCreateUser"].ToString();
entity.DUpdateDate = DateTime.Parse(dataReader["dUpdateDate"].ToString());
list.Add(entity);
}
}
catch (Exception ex)
{
Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal);
}
finally
{
db.Conn.Close();
}
return(list);
}
/// <summary>
/// 获取用户信息
/// </summary>
/// <param name="ID"></param>
/// <returns>Users</returns>
public Entity.User.Users GetUsersByID(int UserID)
{
Entity.User.Users entity = null;
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
try
{
IDbDataParameter[] prams =
{
dbFactory.MakeInParam("@UserID", DBTypeConverter.ConvertCsTypeToOriginDBType(UserID.GetType().ToString()), UserID, 0)
};
IDataReader dataReader = db.ExecuteReader(Config.constr, CommandType.StoredProcedure, "proc_User_GetByID", prams);
while (dataReader.Read())
{
entity = new Entity.User.Users();
entity.ID = int.Parse(dataReader["ID"].ToString());
entity.CName = dataReader["cName"].ToString();
entity.CMemo = dataReader["cMemo"].ToString();
entity.Guid = System.Guid.NewGuid().ToString();
entity.CPW = dataReader["cPW"].ToString();
//entity.BStop = bool.Parse(dataReader["bStop"].ToString());
//entity.BStopName = dataReader["BStopName"].ToString();
entity.CRole = GetName(dataReader["IRoleType"].ToString());
entity.IRoleType = DataHelper.ParseToInt(dataReader["IRoleType"].ToString());
entity.BAdmin = bool.Parse(dataReader["BAdmin"].ToString());
//entity.BAdminName = dataReader["BAdminName"].ToString();
entity.ILevel = DataHelper.ParseToInt(dataReader["ILevel"].ToString());
//entity.CDepCode = dataReader["CDepCode"].ToString();
entity.CPhone = dataReader["CPhone"].ToString();
entity.DActivityLastTime = DateTime.Parse(dataReader["dActivityLastTime"].ToString());
entity.CActivityIP = dataReader["cActivityIP"].ToString();
entity.DCreateDate = DateTime.Parse(dataReader["dCreateDate"].ToString());
entity.CCreateUser = dataReader["cCreateUser"].ToString();
entity.DUpdateDate = DateTime.Parse(dataReader["dUpdateDate"].ToString());
}
}
catch (Exception ex)
{
Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal);
}
finally
{
db.Conn.Close();
}
return(entity);
}
/// <summary>
/// 增加用户
/// </summary>
/// <param name="users"></param>
/// <returns></returns>
public int AddUsers(Entity.User.Users users)
{
int iReturn = 0;
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
SqlTransactionHelper thelper = new SqlTransactionHelper(Config.constr);
IDbTransaction trans = thelper.StartTransaction();
try
{
IDbDataParameter[] prams =
{
dbFactory.MakeInParam("@cName", DBTypeConverter.ConvertCsTypeToOriginDBType(users.CName.GetType().ToString()), users.CName, 50),
dbFactory.MakeInParam("@cPW", DBTypeConverter.ConvertCsTypeToOriginDBType(users.CPW.GetType().ToString()), users.CPW, 50),
dbFactory.MakeInParam("@cMemo", DBTypeConverter.ConvertCsTypeToOriginDBType(users.CMemo.GetType().ToString()), users.CMemo, 500),
dbFactory.MakeInParam("@bStop", DBTypeConverter.ConvertCsTypeToOriginDBType(users.BStop.GetType().ToString()), users.BStop, 1),
dbFactory.MakeInParam("@bAdmin", DBTypeConverter.ConvertCsTypeToOriginDBType(users.BAdmin.GetType().ToString()), users.BAdmin, 1),
dbFactory.MakeInParam("@iRoleType", DBTypeConverter.ConvertCsTypeToOriginDBType(users.IRoleType.GetType().ToString()), users.IRoleType, 0),
dbFactory.MakeInParam("@cRole", DBTypeConverter.ConvertCsTypeToOriginDBType(users.CRole.GetType().ToString()), users.CRole, 4000),
dbFactory.MakeInParam("@cPhone", DBTypeConverter.ConvertCsTypeToOriginDBType(users.CPhone.GetType().ToString()), users.CPhone, 50),
dbFactory.MakeInParam("@dActivityLastTime", DBTypeConverter.ConvertCsTypeToOriginDBType(users.DActivityLastTime.GetType().ToString()), users.DActivityLastTime, 0),
dbFactory.MakeInParam("@cActivityIP", DBTypeConverter.ConvertCsTypeToOriginDBType(users.CActivityIP.GetType().ToString()), users.CActivityIP, 50),
dbFactory.MakeInParam("@dCreateDate", DBTypeConverter.ConvertCsTypeToOriginDBType(users.DCreateDate.GetType().ToString()), users.DCreateDate, 0),
dbFactory.MakeInParam("@cCreateUser", DBTypeConverter.ConvertCsTypeToOriginDBType(users.CCreateUser.GetType().ToString()), users.CCreateUser, 50),
dbFactory.MakeInParam("@dUpdateDate", DBTypeConverter.ConvertCsTypeToOriginDBType(users.DUpdateDate.GetType().ToString()), users.DUpdateDate, 0),
dbFactory.MakeInParam("@cUpdateUser", DBTypeConverter.ConvertCsTypeToOriginDBType(users.CUpdateUser.GetType().ToString()), users.CUpdateUser, 50),
dbFactory.MakeOutReturnParam()
};
iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_User_Add", prams);
iReturn = int.Parse(prams[14].Value.ToString());
string[] areaList = users.CAreaCode.Split(',');
foreach (string str in areaList)
{
string strinsert = "insert into t_R_UserArea(UserID,AreaID,cGradeBaseType) values('" + iReturn + "','" + str + "','01')";
db.ExecuteNonQueryTrans(trans, CommandType.Text, strinsert, prams);
}
thelper.CommitTransaction(trans);
}
catch (Exception ex)
{
iReturn = 0;
thelper.RollTransaction(trans);
Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal);
}
finally
{
db.Conn.Close();
}
return(iReturn);
}
/// <summary>
///更改用户信息
/// </summary>
/// <param name="users"></param>
/// <returns></returns>
public int EditUsers(Entity.User.Users users)
{
int iReturn = 0;
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
SqlTransactionHelper thelper = new SqlTransactionHelper(Config.constr);
IDbTransaction trans = thelper.StartTransaction();
try
{
IDbDataParameter[] prams =
{
dbFactory.MakeInParam("@ID", DBTypeConverter.ConvertCsTypeToOriginDBType(users.ID.GetType().ToString()), users.ID, 50),
dbFactory.MakeInParam("@UserID", DBTypeConverter.ConvertCsTypeToOriginDBType(users.UserID.GetType().ToString()), users.UserID, 50),
dbFactory.MakeInParam("@PWD", DBTypeConverter.ConvertCsTypeToOriginDBType(users.PWD.GetType().ToString()), users.PWD, 50),
dbFactory.MakeInParam("@DepartID", DBTypeConverter.ConvertCsTypeToOriginDBType(users.DepartID.GetType().ToString()), users.DepartID, 50),
dbFactory.MakeInParam("@RoleID", DBTypeConverter.ConvertCsTypeToOriginDBType(users.RoleID.GetType().ToString()), users.RoleID, 50),
dbFactory.MakeInParam("@PWDModifyTime", DBTypeConverter.ConvertCsTypeToOriginDBType(users.PWDModifyTime.GetType().ToString()), users.PWDModifyTime, 50),
dbFactory.MakeInParam("@UserName", DBTypeConverter.ConvertCsTypeToOriginDBType(users.Name.GetType().ToString()), users.Name, 50),
dbFactory.MakeInParam("@grouptype", DBTypeConverter.ConvertCsTypeToOriginDBType(users.grouptype.GetType().ToString()), users.grouptype, 50),
dbFactory.MakeOutReturnParam()
};
string strSql = @"update t_R_UserInfo
set UserID='" + users.UserID +
"',DepartID='" + users.DepartID +
"',RoleID='" + users.RoleID +
"',PWD='" + users.PWD +
"',Name='" + users.Name +
"' where id='" + users.ID + "'";
iReturn = db.ExecuteNonQuery(Config.constr, CommandType.Text, strSql, prams);
}
catch (Exception ex)
{
iReturn = 0;
Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal);
}
finally
{
db.Conn.Close();
}
return(iReturn);
}
/// <summary>
/// 获取用户信息
/// </summary>
/// <param name="ID"></param>
/// <returns>Users</returns>
public int CheckUsers(String cName, int userid)
{
int i = 0;
Entity.User.Users entity = null;
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
try
{
IDbDataParameter[] prams =
{
};
string strSql = "SELECT * FROM [Users] where cName='" + cName + "'";;
if (userid != 0)
{
strSql = "SELECT * FROM [Users] where cName='" + cName + "' and ID!=" + userid + "";;
}
IDataReader dataReader = db.ExecuteReader(Config.constr, CommandType.Text, strSql, prams);
while (dataReader.Read())
{
i = 1;
}
}
catch (Exception ex)
{
i = 0;
Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal);
}
finally
{
db.Conn.Close();
}
return(i);
}
/// <summary>
/// 增加用户
/// </summary>
/// <param name="users"></param>
/// <returns></returns>
public int AddUsers(Entity.User.Users users)
{
int iReturn = 0;
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
SqlTransactionHelper thelper = new SqlTransactionHelper(Config.constr);
IDbTransaction trans = thelper.StartTransaction();
try
{
IDbDataParameter[] prams =
{
dbFactory.MakeInParam("@UserID", DBTypeConverter.ConvertCsTypeToOriginDBType(users.UserID.GetType().ToString()), users.UserID, 50),
dbFactory.MakeInParam("@PWD", DBTypeConverter.ConvertCsTypeToOriginDBType(users.PWD.GetType().ToString()), users.PWD, 50),
dbFactory.MakeInParam("@DepartID", DBTypeConverter.ConvertCsTypeToOriginDBType(users.DepartID.GetType().ToString()), users.DepartID, 50),
dbFactory.MakeInParam("@RoleID", DBTypeConverter.ConvertCsTypeToOriginDBType(users.RoleID.GetType().ToString()), users.RoleID, 50),
dbFactory.MakeInParam("@PWDModifyTime", DBTypeConverter.ConvertCsTypeToOriginDBType(users.PWDModifyTime.GetType().ToString()), users.PWDModifyTime, 50),
dbFactory.MakeInParam("@UserName", DBTypeConverter.ConvertCsTypeToOriginDBType(users.Name.GetType().ToString()), users.Name, 50),
dbFactory.MakeInParam("@grouptype", DBTypeConverter.ConvertCsTypeToOriginDBType(users.grouptype.GetType().ToString()), users.grouptype, 50),
dbFactory.MakeOutReturnParam()
};
iReturn = db.ExecuteNonQuery(Config.constr, CommandType.StoredProcedure, "proc_UserInfo_Add", prams);
iReturn = int.Parse(prams[7].Value.ToString());
}
catch (Exception ex)
{
iReturn = 0;
Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal);
}
finally
{
db.Conn.Close();
}
return(iReturn);
}
