/// <summary>
/// 从行中读取数据映射到实体类的属性中
/// </summary>
/// <remarks></remarks>
private static Entity.AgencyInformation_Entity GetEntity(DataRow row)
{
Entity.AgencyInformation_Entity _obj = new Entity.AgencyInformation_Entity();
if (!row["ID"].Equals(DBNull.Value))
{
_obj.ID = Convert.ToInt32(row["ID"]);
}
if (!row["AgencyNo"].Equals(DBNull.Value))
{
_obj.AgencyNo = Convert.ToString(row["AgencyNo"]);
}
if (!row["account_bank"].Equals(DBNull.Value))
{
_obj.account_bank = Convert.ToString(row["account_bank"]);
}
if (!row["account_bank_code"].Equals(DBNull.Value))
{
_obj.account_bank_code = Convert.ToString(row["account_bank_code"]);
}
if (!row["banktype_code"].Equals(DBNull.Value))
{
_obj.banktype_code = Convert.ToString(row["banktype_code"]);
}
if (!row["banktype_name"].Equals(DBNull.Value))
{
_obj.banktype_name = Convert.ToString(row["banktype_name"]);
}
return(_obj);
}
/// <summary>
/// 更新机构信息
/// </summary>
/// <param name="ai">用户实体</param>
/// <returns>影响行数</returns>
public static int UpdateAgencyInfo(Entity.AgencyInformation_Entity ai)
{
string sequel = "DR_UpdateAgencyinformation";
SqlParameter[] paras = (SqlParameter[])ValueParas(ai);
int result = SqlHelper.ExecuteNonQuery(CommandType.StoredProcedure, sequel, paras);
return(result);
}
/// <summary>
/// 该数据访问对象的属性值装载到数据库更新参数数组Insert用
/// </summary>
/// <remarks></remarks>
private static IDbDataParameter[] ValueParas(Entity.AgencyInformation_Entity _obj)
{
SqlParameter[] paras = new SqlParameter[6];
paras[0] = new SqlParameter("@ID", _obj.ID);
paras[1] = new SqlParameter("@AgencyNo", _obj.AgencyNo);
paras[2] = new SqlParameter("@account_bank", _obj.account_bank);
paras[3] = new SqlParameter("@account_bank_code", _obj.account_bank_code);
paras[4] = new SqlParameter("@banktype_code", _obj.banktype_code);
paras[5] = new SqlParameter("@banktype_name", _obj.banktype_name);
paras[0].DbType = DbType.Int32;
paras[1].DbType = DbType.String;
paras[2].DbType = DbType.String;
paras[3].DbType = DbType.String;
paras[4].DbType = DbType.String;
paras[5].DbType = DbType.String;
return(paras);
}
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));
}
}
public static int CreateAgencyInfo(Entity.AgencyInformation_Entity ai)
{
return(DAL.AgencyInformation_DAL.CreateAgencyInfo(ai));
}
