public NewBXRatio()
{
InitializeComponent();
tbBXRatio.KeyPress += new KeyPressEventHandler(AllowNumber);
tbMin.KeyPress += new KeyPressEventHandler(AllowNumber);
tbMax.KeyPress += new KeyPressEventHandler(AllowNumber);
ratioRule = new MRS.Model.BXRatio();
}
protected Model.BXRatio Parse(System.Data.SqlClient.SqlDataReader reader)
{
Model.BXRatio ratio = new Model.BXRatio();
DBTable.BXRatio table = new SQLServerDAL.DBTable.BXRatio();
ratio.Id = Convert.ToInt32(reader[table.Id.Text]);
ratio.OrderNumber = Convert.ToInt32(reader[table.OrderNumber.Text]);
ratio.MinKBJE = Convert.ToDecimal(reader[table.MinKBJE.Text]);
ratio.MaxKBJE = Convert.ToDecimal(reader[table.MaxKBJE.Text]);
ratio.HspType = reader[table.HspType.Text].ToString().Trim();
ratio.Ratio = Convert.ToDecimal(reader[table.Ratio.Text]);
return(ratio);
}
public IList <MRS.Model.BXRatio> Select()
{
IList <MRS.Model.BXRatio> ratioes = new List <MRS.Model.BXRatio>();
DBProcedure.Select_BXRatio_All prdCmdText = new SQLServerDAL.DBProcedure.Select_BXRatio_All();
SQLProcedure prdHelper = new SQLProcedure(DS.ConnectionString.ConnectionStringMRS, prdCmdText.Text);
using (SqlDataReader reader = prdHelper.ExecuteReader())
{
while (reader.Read())
{
Model.BXRatio ratio = Parse(reader);
ratioes.Add(ratio);
}
}
prdHelper.Dispose();
return(ratioes);
}
