//public static Nfmb WhereMemberCodeIs(string memberCode) //{ // var sqlBuilder = new StringBuilder(); // sqlBuilder.Append("SELECT * FROM nfmb WHERE MEM_CODE = ?MEM_CODE LIMIT 1"); // var param = new SqlParameter("?MEM_CODE", memberCode); // var dataTable = DatabaseController.ExecuteSelectQuery(sqlBuilder.ToString(), param); // var member = new Nfmb(); // foreach (DataRow dataRow in dataTable.Rows) // { // member.SetPropertiesFromDataRow(dataRow); // } // return member; //} //public static Nfmb WhereMemberNameIs(string memberName) //{ // var sqlBuilder = new StringBuilder(); // sqlBuilder.Append("SELECT * FROM nfmb WHERE MEM_NAME = ?MEM_NAME LIMIT 1"); // var param = new SqlParameter("?MEM_NAME", memberName); // var dataTable = DatabaseController.ExecuteSelectQuery(sqlBuilder.ToString(), param); // var member = new Nfmb(); // foreach (DataRow dataRow in dataTable.Rows) // { // member.SetPropertiesFromDataRow(dataRow); // } // return member; //} public static List <Nfmb> GetList() { const string sqlSelect = "SELECT ID, MEM_CODE, MEM_NAME FROM nfmb ORDER BY MEM_CODE"; DataTable dataTable = DatabaseController.ExecuteSelectQuery(sqlSelect); var list = new List <Nfmb>(); foreach (DataRow dataRow in dataTable.Rows) { var member = new Nfmb(); member.ID = DataConverter.ToInteger(dataRow["ID"]); member.MemberCode = DataConverter.ToString(dataRow["MEM_CODE"]); member.MemberName = DataConverter.ToString(dataRow["MEM_NAME"]); list.Add(member); } return(list); }
public static Nfmb FindByName(string name) { var member = new Nfmb(); member.ResetProperties(); var key = new SqlParameter("?MEM_NAME", name); string sql = DatabaseController.GenerateSelectStatement(TABLE_NAME, key); DataTable dataTable = DatabaseController.ExecuteSelectQuery(sql, key); foreach (DataRow dataRow in dataTable.Rows) { member.SetPropertiesFromDataRow(dataRow); } return(member); }
public virtual void SetMember(Nfmb member) { MemberCode = member.MemberCode; MemberName = member.MemberName; }