/// <summary>
/// 得到一个对象实体
/// </summary>
public UserPassportInfo GetUserPassportInfoModel(int UserID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 UserID,Erp_Name,Erp_Pwd,g_Name,g_PWD from tbUserPassportInfo ");
strSql.Append(" where UserID=@UserID ");
SqlParameter[] parameters =
{
new SqlParameter("@UserID", SqlDbType.Int, 4)
};
parameters[0].Value = UserID;
UserPassportInfo model = new UserPassportInfo();
DataSet ds = DbHelper.ExecuteDataset(CommandType.Text, strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["UserID"].ToString() != "")
{
model.UserID = int.Parse(ds.Tables[0].Rows[0]["UserID"].ToString());
}
model.Erp_Name = ds.Tables[0].Rows[0]["Erp_Name"].ToString();
model.Erp_Pwd = ds.Tables[0].Rows[0]["Erp_Pwd"].ToString();
model.g_Name = ds.Tables[0].Rows[0]["g_Name"].ToString();
model.g_PWD = ds.Tables[0].Rows[0]["g_PWD"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void UpdateUserPassportInfo(UserPassportInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tbUserPassportInfo set ");
strSql.Append("UserID=@UserID,");
strSql.Append("Erp_Name=@Erp_Name,");
strSql.Append("Erp_Pwd=@Erp_Pwd,");
strSql.Append("g_Name=@g_Name,");
strSql.Append("g_PWD=@g_PWD");
strSql.Append(" where UserID=@UserID and Erp_Name=@Erp_Name and Erp_Pwd=@Erp_Pwd and g_Name=@g_Name and g_PWD=@g_PWD ");
SqlParameter[] parameters =
{
new SqlParameter("@UserID", SqlDbType.Int, 4),
new SqlParameter("@Erp_Name", SqlDbType.VarChar, 50),
new SqlParameter("@Erp_Pwd", SqlDbType.VarChar, 50),
new SqlParameter("@g_Name", SqlDbType.VarChar, 50),
new SqlParameter("@g_PWD", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.UserID;
parameters[1].Value = model.Erp_Name;
parameters[2].Value = model.Erp_Pwd;
parameters[3].Value = model.g_Name;
parameters[4].Value = model.g_PWD;
DbHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int AddUserPassportInfo(UserPassportInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tbUserPassportInfo(");
strSql.Append("UserID,Erp_Name,Erp_Pwd,g_Name,g_PWD)");
strSql.Append(" values (");
strSql.Append("@UserID,@Erp_Name,@Erp_Pwd,@g_Name,@g_PWD)");
SqlParameter[] parameters =
{
new SqlParameter("@UserID", SqlDbType.Int, 4),
new SqlParameter("@Erp_Name", SqlDbType.VarChar, 50),
new SqlParameter("@Erp_Pwd", SqlDbType.VarChar, 50),
new SqlParameter("@g_Name", SqlDbType.VarChar, 50),
new SqlParameter("@g_PWD", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.UserID;
parameters[1].Value = model.Erp_Name;
parameters[2].Value = model.Erp_Pwd;
parameters[3].Value = model.g_Name;
parameters[4].Value = model.g_PWD;
object obj = DbHelper.ExecuteScalar(CommandType.Text, strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
//public Weather weathers = new Weather();
protected virtual void Page_Load(object sender, EventArgs e)
{
//weathers = Caches.GetWeather("福州");
if (this.userid != -1)
{
if (this.username != "")
{
pagetitle = " 您好 [" + this.username + "]";
Order = Orders.GetOrderStateList().Tables[0];
ProductAlarm = Orders.GetProductAlarm();
UserPassportInfo pi = new UserPassportInfo();
try
{
pi = tbUserInfo.GetUserPassportInfoModel(this.userid);
if (pi != null)
{
Erp_Name = pi.Erp_Name;
Erp_Pwd = pi.Erp_Pwd;
}
}
finally
{
pi = null;
}
}
else
{
pagetitle = " 请先登录!";
}
}
else
{
AddErrLine("请先登录!");
SetBackLink("login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
SetMetaRefresh(1, "login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public static void UpdateUserPassportInfo(UserPassportInfo model)
{
DatabaseProvider.GetInstance().UpdateUserPassportInfo(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public static int AddUserPassportInfo(UserPassportInfo model)
{
return(DatabaseProvider.GetInstance().AddUserPassportInfo(model));
}
protected virtual void Page_Load(object sender, EventArgs e)
{
if (this.userid > 0)
{
if (CheckUserPopedoms("X"))
{
UserTypeList = Caches.GetUserTypeList();
Act = HTTPRequest.GetString("Act");
uName = Utils.ChkSQL(HTTPRequest.GetString("uName"));
uPWD = Utils.ChkSQL(HTTPRequest.GetString("uPWD"));
uPWD_Old = Utils.ChkSQL(HTTPRequest.GetString("uPWD_Old"));
uPermissions = Utils.ChkSQL(HTTPRequest.GetString("uPermissions"));
uEstate = Utils.ChkSQL(HTTPRequest.GetString("uEstate"));
Erp_Name = Utils.ChkSQL(HTTPRequest.GetString("Erp_Name"));
Erp_Pwd = Utils.ChkSQL(HTTPRequest.GetString("Erp_Pwd"));
g_Name = Utils.ChkSQL(HTTPRequest.GetString("g_Name"));
g_PWD = Utils.ChkSQL(HTTPRequest.GetString("g_PWD"));
uType = HTTPRequest.GetInt("uType", 0);
StaffID = HTTPRequest.GetInt("StaffID", 0);
StorageIDStr = Utils.ChkSQL(HTTPRequest.GetString("StorageIDStr"));
StorageIDStr = StorageIDStr.IndexOf("x") > -1 ? "x" : "," + StorageIDStr + ",";
pi.Erp_Name = "";
pi.Erp_Pwd = "";
pi.g_Name = "";
pi.g_PWD = "";
if (Act == "Edit")
{
UserID = Utils.StrToInt(HTTPRequest.GetString("uid"), 0);
ui = tbUserInfo.GetUserInfoModel(UserID);
pi = tbUserInfo.GetUserPassportInfoModel(UserID);
if (pi == null)
{
pi = new UserPassportInfo();
pi.Erp_Name = "";
pi.Erp_Pwd = "";
pi.g_Name = "";
pi.g_PWD = "";
}
UserPopedomJson = UsersUtils.GetUserPopedomToJsonStr();// UsersUtils.GetUserPopedomToJsonStr(ui.uPermissions);
}
if (ispost)
{
if (ui.uPermissions != "X")
{
ui.uPermissions = uPermissions;
}
ui.uEstate = uEstate == "0" ? 0 : 1;
ui.uType = uType;
ui.StaffID = StaffID;
ui.StorageIDStr = StorageIDStr;
if (Act == "Add")
{
if (!tbUserInfo.ExistsUserInfo(uName))
{
ui.uName = uName;
ui.uPWD = Utils.MD5(uPWD);
ui.uCode = Utils.CutString(Utils.GetRanDomCode(), 16);
ui.uLastIP = HTTPRequest.GetIP();
ui.uAppendTime = DateTime.Now;
ui.uUpAppendTime = DateTime.Now;
pi.UserID = tbUserInfo.AddUserInfo(ui);
Logs.AddEventLog(this.userid, "新增用户:" + ui.uName);
if (pi.UserID > 0)
{
pi.Erp_Name = Erp_Name;
pi.Erp_Pwd = Erp_Pwd;
pi.g_Name = g_Name;
pi.g_PWD = g_PWD;
if (tbUserInfo.AddUserPassportInfo(pi) > 0)
{
AddMsgLine("创建成功!");
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
else
{
AddErrLine("账户创建成功,但通行证绑定失败!");
AddScript("history.back(1);");
}
}
else
{
AddErrLine("创建失败!");
AddScript("history.back(1);");
}
}
else
{
AddErrLine("用户名:" + uName + ",已存在,请更换!");
AddScript("history.back(1);");
}
}
if (Act == "Edit")
{
if (UserID > 0)
{
ui.UserID = UserID;
if (uPWD.Trim() != "")
{
ui.uPWD = Utils.MD5(uPWD);
}
else
{
ui.uPWD = uPWD_Old;
}
//超级管理员无需修改权限与状态
if (ui.uPermissions == "X")
{
ui.uPermissions = "X";
ui.uEstate = 0;
}
try
{
pi.UserID = UserID;
pi.Erp_Name = Erp_Name;
pi.Erp_Pwd = Erp_Pwd;
pi.g_Name = g_Name;
pi.g_PWD = g_PWD;
if (tbUserInfo.UserPassportInfoExists(UserID))
{
tbUserInfo.UpdateUserPassportInfo(pi);
}
else
{
tbUserInfo.AddUserPassportInfo(pi);
}
tbUserInfo.UpdateUserInfo(ui);
Logs.AddEventLog(this.userid, "修改用户:" + ui.uName);
AddMsgLine("修改成功!");
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
catch (Exception ex)
{
AddErrLine("修改失败!<br/>" + ex);
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
}
else
{
AddErrLine("参数错误,修改失败!");
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
}
}
else
{
StorageList = tbStorageInfo.GetStorageInfoList(" sState = 0").Tables [0];
if (Act == "Add")
{
ui.UserID = 0;
ui.uName = "";
ui.uPWD = "";
ui.uCode = "";
ui.uEstate = 0;
ui.uPermissions = "";
ui.StorageIDStr = "x";
UserPopedomJson = UsersUtils.GetUserPopedomToJsonStr();
}
if (Act == "Del")
{
try
{
tbUserInfo.DeleteUserInfo(HTTPRequest.GetString("uid"));
Logs.AddEventLog(this.userid, "删除用户:uid=>" + HTTPRequest.GetString("uid"));
AddMsgLine("删除成功!");
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
catch (Exception ex)
{
AddErrLine("删除失败!<br/>" + ex);
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
}
}
}
else
{
AddErrLine("权限不足!");
AddScript("window.parent.HidBox();");
}
}
else
{
AddErrLine("请先登录!");
SetBackLink("login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
SetMetaRefresh(1, "login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
}
}
