public Tz888.Model.LoanscontactsTab GetLoanscontactsTabByLoansInfoId(int LoansInfoId) { string sql = "select * from loanscontactsTab where loansInfoID=@loansinfoid"; DataSet set = DbHelperSQL.Query(sql, new SqlParameter("@LoansInfoId", LoansInfoId)); LoanscontactsTab loansinfo = null; try { foreach (DataRow row in set.Tables[0].Rows) { Tz888.SQLServerDAL.loansInfoTab loantabl = new loansInfoTab(); loansinfo = new LoanscontactsTab(); loansinfo.ContactsID = Convert.ToInt32(row["ContactsID"]); loansinfo.LoansInfoID = loantabl.GetLoansInfoTabByLoansInfoId(Convert.ToInt32(row["LoansInfoID"])); loansinfo.EnterpriseName = row["EnterpriseName"].ToString(); loansinfo.ContactsName = row["ContactsName"].ToString(); loansinfo.Telephone = row["Telephone"].ToString(); loansinfo.Moblie = row["Moblie"].ToString(); loansinfo.Mail = row["Mail"].ToString(); loansinfo.Address = row["Address"].ToString(); loansinfo.Loginname = row["Loginname"].ToString(); } } catch (Exception) { throw; } return(loansinfo); }
public Tz888.Model.LoansInfo GetLoansInfoByLoansInfoId(int LoansInfoId) { string sql = "select * from loansInfo where loansInfoID=@LoansInfoId"; DataSet set = DbHelperSQL.Query(sql, new SqlParameter("LoansInfoId", LoansInfoId)); LoansInfo loansinfo = null; try { foreach (DataRow row in set.Tables[0].Rows) { Tz888.SQLServerDAL.loansInfoTab loantabl = new loansInfoTab(); loansinfo = new LoansInfo(); loansinfo.LoanID = Convert.ToInt32(row["LoanID"]); loansinfo.LoansInfoID = loantabl.GetLoansInfoTabByLoansInfoId(Convert.ToInt32(row["LoansInfoID"])); loansinfo.ValidityID = Convert.ToInt32(row["ValidityID"].ToString()); loansinfo.CountryID = row["CountryID"].ToString(); loansinfo.ProvinceID = row["ProvinceID"].ToString(); loansinfo.CityID = row["CityID"].ToString(); loansinfo.CountyID = row["CountyID"].ToString(); loansinfo.Amount = Convert.ToInt32(row["Amount"]); loansinfo.Deadline = Convert.ToInt32(row["Deadline"]); loansinfo.Reimbursement = Convert.ToInt32(row["Reimbursement"]); loansinfo.Guarantee = Convert.ToInt32(row["Guarantee"]); loansinfo.BorrowingUse = row["BorrowingUse"].ToString(); loansinfo.Title = row["Title"].ToString(); loansinfo.Keywords = row["Keywords"].ToString(); loansinfo.Description = row["Description"].ToString(); loansinfo.Reason = row["Reason"].ToString(); } } catch (Exception) { } return(loansinfo); }