/// <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)); }