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