public DataTable M_TankaCD_SelectAll(M_TankaCD_Entity mbe)
{
string sp = "M_TankaCD_SelectAll";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@DisplayKbn", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = mbe.DisplayKbn
} },
{ "@ChangeDate", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mbe.ChangeDate
} },
{ "@TankaCDFrom", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mbe.TankaCDFrom
} },
{ "@TankaCDTo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mbe.TankaCDTo
} },
{ "@TankaName", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mbe.TankaName
} },
};
return(SelectData(dic, sp));
}
private bool BindGrid()
{
mke = GetEntity();
DataTable dt = mbl.M_TankaCD_SelectAll(mke);
if (dt.Rows.Count == 0)
{
return(false);
}
dgvDetail.DataSource = dt;
return(true);
}
public DataTable M_TankaCD_Select(M_TankaCD_Entity mte)
{
string sp = "M_TankaCD_Select";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@TankaCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mte.TankaCD
} },
{ "@ChangeDate", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mte.ChangeDate
} }
};
return(SelectData(dic, sp));
}
private M_TankaCD_Entity GetEntity()
{
mke = new M_TankaCD_Entity();
mke.DisplayKbn = radioButton1.Checked ? "0" : "1";
mke.ChangeDate = lblChangeDate.Text;
mke.TankaCDFrom = detailControls[(int)EIndex.TankaSetteiFrom].Text;
if (detailControls[(int)EIndex.TankaSetteiTo].Text == "")
{
mke.TankaCDTo = new string('Z', ((CKM_Controls.CKM_TextBox)detailControls[(int)EIndex.TankaSetteiTo]).MaxLength);
}
else
{
mke.TankaCDTo = detailControls[(int)EIndex.TankaSetteiTo].Text;
}
mke.TankaName = detailControls[(int)EIndex.TankaSetteiName].Text;
return(mke);
}
public DataTable M_TankaCD_SelectAll(M_TankaCD_Entity mse)
{
return(mmdl.M_TankaCD_SelectAll(mse));
}
public DataTable M_TankaCD_Select(M_TankaCD_Entity mke)
{
return(mmdl.M_TankaCD_Select(mke));
}
