/// <summary>
/// 获取银行卡
/// </summary>
/// <returns></returns>
public static List <UserBanks> GetBanks(string type, string userid, int pageSize, int pageIndex, ref int totalCount, ref int pageCount, string keyword = "")
{
string tablename = "UserBanks a join M_Users b on a.userid=b.userid ";
string sqlwhere = " 1=1 ";
if (!string.IsNullOrEmpty(type))
{
sqlwhere += " and a.Type in(" + type + ")";
}
if (!string.IsNullOrEmpty(userid))
{
sqlwhere += " and a.userid='" + userid + "' ";
}
if (!string.IsNullOrEmpty(keyword))
{
sqlwhere += " and b.LoginName='" + keyword + "' ";
}
DataTable dt = CommonBusiness.GetPagerData(tablename, "a.*,b.LoginName ", sqlwhere, "a.AutoID ", pageSize, pageIndex, out totalCount, out pageCount);
List <UserBanks> list = new List <UserBanks>();
foreach (DataRow dr in dt.Rows)
{
UserBanks model = new UserBanks();
model.FillData(dr);
list.Add(model);
}
return(list);
}
public static UserBanks GetBankDetail(int autoid)
{
DataTable dt = UserBanksDAL.BaseProvider.GetBankDetail(autoid);
UserBanks model = new UserBanks();
foreach (DataRow dr in dt.Rows)
{
model.FillData(dr);
}
return(model);
}
/// <summary>
/// Efetua a conversão de um tipo UserBankModel para um tipo UserBank (DTO)
/// </summary>
/// <returns>UserBank com os dados da model</returns>
public static UserBanks UserBankModelToDTO(UserBankModel bankModel)
{
UserBanks dao = new UserBanks
{
Account = bankModel.Account,
Agency = bankModel.Agency,
BankID = bankModel.BankID,
ID = bankModel.ID
};
return(dao);
}
public static UserBankModel UserBankToModel(UserBanks dto)
{
UserBankModel model = new UserBankModel
{
Account = dto.Account,
Agency = dto.Agency,
BankID = dto.BankID,
ID = dto.ID
};
return(model);
}
public JsonResult SaveBanks(string entity)
{
JavaScriptSerializer serializer = new JavaScriptSerializer();
UserBanks model = serializer.Deserialize <UserBanks>(entity);
model.UserID = CurrentUser.UserID;
string errmsg = "";
var result = UserBanksBusiness.InsertBanks(model, ref errmsg);
JsonDictionary.Add("result", result);
if (!result)
{
JsonDictionary.Add("ErrMsg", errmsg);
}
return(new JsonResult
{
Data = JsonDictionary,
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public static bool UpdateBanks(UserBanks model, ref string errmsg)
{
return(UserBanksDAL.BaseProvider.UpdateModel(model.AutoID, model.CardCode, model.BankName, model.BankChild,
model.TrueName, model.BankPre, model.BankCity, model.Type, model.IDCard, ref errmsg));
}
public static bool InsertBanks(UserBanks model, ref string errmsg)
{
return(UserBanksDAL.BaseProvider.Create(model.UserID, model.CardCode, model.BankName, model.BankChild,
model.TrueName, model.BankPre, model.BankCity, model.Type, model.IDCard, ref errmsg));
}
