Exemplo n.º 1
0
 protected override void OnSetSqlParameters(GtidParameterCollection sqlParams)
 {
     if (cboNgayDuDau.SelectedValue != null)
     {
         sqlParams.AddWithValue("@ThoiGian", cboNgayDuDau.SelectedValue).Direction = ParameterDirection.Input;
     }
     if (cboTrungTam.SelectedValue != null && int.Parse(cboTrungTam.SelectedValue.ToString()) != 0)
     {
         sqlParams.AddWithValue("@IdTrungTam", cboTrungTam.SelectedValue).Direction = ParameterDirection.Input;
     }
     if (cboKho.SelectedValue != null && int.Parse(cboKho.SelectedValue.ToString()) != 0)
     {
         sqlParams.AddWithValue("@IdKho", cboKho.SelectedValue).Direction = ParameterDirection.Input;
     }
     if (ut.isStringNotEmpty(txtTenSanPham.Text))
     {
         sqlParams.AddWithValue("@SanPham", txtTenSanPham.Text).Direction = ParameterDirection.Input;
     }
 }
Exemplo n.º 2
0
 protected override void OnSetSqlParameters(GtidParameterCollection sqlParams)
 {
     sqlParams.Clear();
     sqlParams.AddWithValue("@FromDate", dtTuNgay.Value.Date);
     sqlParams.AddWithValue("@ToDate", dtDenNgay.Value.Date.AddHours(24));
     sqlParams.AddWithValue("@IdTrungTam", cboTrungTam.SelectedValue);
     sqlParams.AddWithValue("@IdKho", cboKho.SelectedValue);
     sqlParams.AddWithValue("@IdSanPham", cboSanPham.SelectedValue);
     if (ut.isStringNotEmpty(txtTenSanPham.Text))
     {
         sqlParams.AddWithValue("@SanPham", txtTenSanPham.Text);
     }
 }