/// <summary>
/// 更新用户信息
/// </summary>
/// <param name="ui">用户实体</param>
/// <returns>影响行数</returns>
public static int UpdateUserInfo(Entity.UserInformation_Entity ui)
{
string sequel = "DR_UpdateUserinformation";
SqlParameter[] paras = (SqlParameter[])ValueParas(ui);
int result = SqlHelper.ExecuteNonQuery(CommandType.StoredProcedure, sequel, paras);
return(result);
}
/// <summary>
/// 该数据访问对象的属性值装载到数据库更新参数数组Insert用
/// </summary>
/// <remarks></remarks>
private static IDbDataParameter[] ValueParas(Entity.UserInformation_Entity _obj)
{
SqlParameter[] paras = new SqlParameter[4];
paras[0] = new SqlParameter("@ID", _obj.ID);
paras[1] = new SqlParameter("@UserName", _obj.UserName);
paras[2] = new SqlParameter("@UserPassword", _obj.UserPassword);
paras[3] = new SqlParameter("@AgencyNo", _obj.AgencyNo);
paras[0].DbType = DbType.Int32;
paras[1].DbType = DbType.String;
paras[2].DbType = DbType.String;
paras[3].DbType = DbType.String;
return(paras);
}
/// <summary>
/// 从行中读取数据映射到实体类的属性中
/// </summary>
/// <remarks></remarks>
private static Entity.UserInformation_Entity GetEntity(DataRow row)
{
Entity.UserInformation_Entity _obj = new Entity.UserInformation_Entity();
if (!row["ID"].Equals(DBNull.Value))
{
_obj.ID = Convert.ToInt32(row["ID"]);
}
if (!row["UserName"].Equals(DBNull.Value))
{
_obj.UserName = Convert.ToString(row["UserName"]);
}
if (!row["UserPassword"].Equals(DBNull.Value))
{
_obj.UserPassword = Convert.ToString(row["UserPassword"]);
}
if (!row["AgencyNo"].Equals(DBNull.Value))
{
_obj.AgencyNo = Convert.ToString(row["AgencyNo"]);
}
return(_obj);
}
public ActionResult Login()
{
string username = Request["username"];
string password = Request["password"];
if (BLL.UserInformation_BLL.UserLogin(username, password))
{
Entity.UserInformation_Entity UI = BLL.UserInformation_BLL.GetUserInfoByName(username);
Entity.AgencyInformation_Entity AI = BLL.AgencyInformation_BLL.GetAgencyInfoByAgencyNo1(UI.AgencyNo);
ViewBag.ID = UI.ID;
ViewBag.Name = UI.UserName;
ViewBag.AgencyName = AI.account_bank;
ViewBag.AgencyNo = AI.AgencyNo;
Session["UserName"] = UI.UserName;
Session["AgencyName"] = AI.account_bank;
Session["AgencyNo"] = AI.AgencyNo;
var token = new { access_token = "c262e61cd13ad99fc650e6908c7e5e65b63d2f32185ecfed6b801ee3fbdd5c0a" };
var json = new
{
code = 0,
msg = "登陆成功！",
data = token
};
return(Json(json, JsonRequestBehavior.AllowGet));
}
else
{
var json = new
{
code = 1001,
msg = "用户名或密码错误！",
data = ""
};
return(Json(json, JsonRequestBehavior.AllowGet));
}
}
/// <summary>
/// 更新用户信息
/// </summary>
/// <param name="ui">用户实体</param>
/// <returns>影响行数</returns>
public static int UpdateUserInfo(Entity.UserInformation_Entity ui)
{
ui.UserPassword = Entity.MD5.EnctryByMD51(ui.UserPassword);
return(DAL.UserInformation_DAL.UpdateUserInfo(ui));
}
