public static int Save(LogonUserInfo user)
{
int id;
if (user.ID <= 0) {
id = LogonUserDao.Add(user);
}
else {
id = LogonUserDao.Update(user) ? user.ID : 0;
}
return id;
}
private LogonUserInfo BuildEntity()
{
LogonUserInfo user = new LogonUserInfo();
user.ID = GetFormInteger("id");
user.Code = Request.Form["code"];
user.Password = Request.Form["password"];
user.RoleType = GetFormInteger("role");
user.DeptID = GetFormInteger("dept");
user.Active = Request.Form["active"] == "true";
return user;
}
public static int Add(LogonUserInfo user)
{
SqlParameter[] parameters = new SqlParameter[5];
parameters[0] = new SqlParameter("@Code", SqlDbType.VarChar, 20);
parameters[0].Value = user.Code;
parameters[1] = new SqlParameter("@Password", SqlDbType.VarChar, 20);
parameters[1].Value = user.Password;
parameters[2] = new SqlParameter("@RoleType", SqlDbType.Int);
parameters[2].Value = user.RoleType;
parameters[3] = new SqlParameter("@DeptID", SqlDbType.Int);
parameters[3].Value = user.DeptID>=0 ? (object) user.DeptID : DBNull.Value;
parameters[4] = new SqlParameter("@Flag", SqlDbType.Int);
parameters[4].Value = user.Active ? 1 : 0;
StringBuilder sql = new StringBuilder();
sql.AppendLine("DECLARE @ID int");
sql.AppendLine("INSERT INTO LogonUser (logonUser, passwd, roleType, flag, depId)");
sql.AppendLine("VALUES (@Code, @Password, @RoleType, @Flag, @DeptID)");
sql.AppendLine("SET @ID = SCOPE_IDENTITY()");
sql.AppendLine("SELECT @ID");
int newID = (int) helper.ExecuteScalar(sql.ToString(), parameters);
return newID;
}
public static bool Update(LogonUserInfo user)
{
SqlParameter[] parameters = new SqlParameter[6];
parameters[0] = new SqlParameter("@Code", SqlDbType.VarChar, 20);
parameters[0].Value = user.Code;
parameters[1] = new SqlParameter("@Password", SqlDbType.VarChar, 20);
parameters[1].Value = user.Password;
parameters[2] = new SqlParameter("@RoleType", SqlDbType.Int);
parameters[2].Value = user.RoleType;
parameters[3] = new SqlParameter("@DeptID", SqlDbType.Int);
parameters[3].Value = user.DeptID >= 0 ? (object)user.DeptID : DBNull.Value;
parameters[4] = new SqlParameter("@Flag", SqlDbType.Int);
parameters[4].Value = user.Active ? 1 : 0;
parameters[5] = new SqlParameter("@ID", SqlDbType.Int);
parameters[5].Value = user.ID;
StringBuilder sql = new StringBuilder();
sql.AppendLine("UPDATE LogonUser SET logonUser = @Code, passwd = @Password, roleType = @RoleType, depId = @DeptID, flag = @Flag");
sql.AppendLine("WHERE ID = @ID");
return helper.ExecuteNonQuery(sql.ToString(), parameters.ToArray()) > 0;
}
