public LottoSale selectByPk(String lThoId)
{
LottoSale item = new LottoSale();
String sql = "";
DataTable dt = new DataTable();
sql = "Select * From " + lSale.table + " Where " + lSale.pkField + "='" + lThoId + "'";
dt = conn.selectData(sql);
if (dt.Rows.Count > 0)
{
item = setData(item, dt);
}
return(item);
}
private LottoSale setData(LottoSale item, DataTable dt)
{
item.Active = dt.Rows[0][lSale.Active].ToString();
item.Amount = dt.Rows[0][lSale.Amount].ToString();
item.AmountPer = dt.Rows[0][lSale.AmountPer].ToString();
item.Id = dt.Rows[0][lSale.Id].ToString();
item.monthId = dt.Rows[0][lSale.monthId].ToString();
item.periodId = dt.Rows[0][lSale.periodId].ToString();
item.rowNumber = dt.Rows[0][lSale.rowNumber].ToString();
item.saleId = dt.Rows[0][lSale.saleId].ToString();
item.saleName = dt.Rows[0][lSale.saleName].ToString();
item.yearId = dt.Rows[0][lSale.yearId].ToString();
return(item);
}
private void initConfig()
{
lSale = new LottoSale();
lSale.Active = "lot_sale_active";
lSale.Amount = "amount";
lSale.AmountPer = "amount_per";
lSale.Id = "lot_sale_id";
lSale.monthId = "month_id";
lSale.periodId = "period1";
lSale.rowNumber = "row_number";
lSale.saleId = "sale_id";
lSale.saleName = "sale_name";
lSale.yearId = "year_id";
lSale.table = "t_lottory_sale";
lSale.pkField = "lot_sale_id";
}
