public static List <MODEL_Insur_thai.Loan_Model.bank_pathfile> cLoadFilePath(MODEL_Insur_thai.Loan_Model.bank_pathfile data) { SqlCommand cmd = new SqlCommand(); cmd.Parameters.AddWithValue("@loan_Id", data.loan_Id); string sql = @" select * from bank_pathfile where loan_Id = @loan_Id "; var item = cSourceData.GetData(sql, cmd).Tables[0]; List <MODEL_Insur_thai.Loan_Model.bank_pathfile> obj = new List <MODEL_Insur_thai.Loan_Model.bank_pathfile>(); if (item.Rows.Count > 0) { for (var i = 0; i < item.Rows.Count; i++) { obj.Add( new MODEL_Insur_thai.Loan_Model.bank_pathfile { file_desc = item.Rows[i]["file_desc"].ToString(), file_name = item.Rows[i]["file_name"].ToString(), file_path = item.Rows[i]["file_path"].ToString() }); } } return(obj); }
public static List <MODEL_Insur_thai.Loan_Model.bank_pathfile> cLoadFilePath(MODEL_Insur_thai.Loan_Model.bank_pathfile data) { return(DAL_Insur_thai.Loan_DAL.cLoadFilePath(data)); }