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