public US_V_GD_DON_DAT_HANG(decimal i_dbID)
{
pm_objDS = new DS_V_GD_DON_DAT_HANG();
pm_strTableName = c_TableName;
IMakeSelectCmd v_objMkCmd = new CMakeAndSelectCmd(pm_objDS, c_TableName);
v_objMkCmd.AddCondition("ID", i_dbID, eKieuDuLieu.KieuNumber, eKieuSoSanh.Bang);
SqlCommand v_cmdSQL;
v_cmdSQL = v_objMkCmd.getSelectCmd();
this.FillDatasetByCommand(pm_objDS, v_cmdSQL);
pm_objDR = getRowClone(pm_objDS.Tables[pm_strTableName].Rows[0]);
}
private void load_data_2_grid()
{
m_ds = new DS_V_GD_DON_DAT_HANG();
DateTime v_dt_tu_ngay;
DateTime v_dt_den_ngay;
decimal v_id_phong_ban = CIPConvert.ToDecimal(m_cbo_phong_ban.SelectedValue);
if (!m_dt_chon_thang.Checked)
{
v_dt_tu_ngay = new DateTime(1900, 1, 1);
v_dt_den_ngay = new DateTime(2789, 1, 1);
}
else
{
v_dt_tu_ngay = m_dt_chon_thang.Value.AddDays(-m_dt_chon_thang.Value.Date.Day + 1);
v_dt_den_ngay = m_dt_chon_thang.Value.AddMonths(1).AddDays(-m_dt_chon_thang.Value.Day);
}
if (m_cbo_loc.SelectedIndex == 0)
{
m_us.Nhap_ma_hoa_don_NCC(m_ds, v_dt_tu_ngay, v_dt_den_ngay, CONST_ID_TRANG_THAI_DON_HANG.DA_DUYET, v_id_phong_ban);
}
if (m_cbo_loc.SelectedIndex == 1)
{
m_us.Loc_HD_chua_co_ma_hoa_don_NCC(m_ds, v_dt_tu_ngay, v_dt_den_ngay, CONST_ID_TRANG_THAI_DON_HANG.DA_DUYET, v_id_phong_ban);
}
if (m_cbo_loc.SelectedIndex == 2)
{
m_us.Loc_HD_da_co_ma_hoa_don_NCC(m_ds, v_dt_tu_ngay, v_dt_den_ngay, CONST_ID_TRANG_THAI_DON_HANG.DA_DUYET, v_id_phong_ban);
}
m_fg_don_dat_hang.Redraw = false;
CGridUtils.Dataset2C1Grid(m_ds, m_fg_don_dat_hang, m_obj_trans);
m_fg_don_dat_hang.Redraw = true;
kiem_tra_du_lieu_don_dat_hang();
}
v_us.FillDataset(v_ds);
m_cbo_phap_nhan.DataSource = v_ds.DM_PHAP_NHAN;
m_cbo_phap_nhan.ValueMember = DM_PHAP_NHAN.ID;
m_cbo_phap_nhan.DisplayMember = DM_PHAP_NHAN.TEN_PHAP_NHAN;
DataRow v_dr = v_ds.DM_PHAP_NHAN.NewRow();
v_dr[DM_PHAP_NHAN.ID] = -1;
v_dr[DM_PHAP_NHAN.MA_PHAP_NHAN] = "";
v_dr[DM_PHAP_NHAN.TEN_PHAP_NHAN] = "Tất cả";
v_dr[DM_PHAP_NHAN.GHI_CHU] = " ";
v_ds.DM_PHAP_NHAN.Rows.InsertAt(v_dr, 0);
m_cbo_phap_nhan.SelectedIndex = 0;
}
private void load_data_2_grid()
{
DateTime v_dat_thang = CIPConvert.ToDatetime("01/"+m_dtp_thang.Text,"dd/MM/yyyy");
decimal v_dc_id_phap_nhan = CIPConvert.ToDecimal(m_cbo_phap_nhan.SelectedValue);
decimal v_dc_id_trung_tam = CIPConvert.ToDecimal(m_cbo_trung_tam.SelectedValue);
private void get_thong_tin_don_hang()
{
US_V_GD_DON_DAT_HANG v_us = new US_V_GD_DON_DAT_HANG();
DS_V_GD_DON_DAT_HANG v_ds = new DS_V_GD_DON_DAT_HANG();
v_us.FillDataset(v_ds,"where id="+ CIPConvert.ToDecimal(m_hdf_id_don_hang.Value));
m_hdf_ma_don_hang.Value = v_ds.V_GD_DON_DAT_HANG.Rows[0]["MA_HD"].ToString();
DateTime v_ngay_dat_hang = (DateTime)v_ds.V_GD_DON_DAT_HANG.Rows[0]["NGAY_DAT_HANG"];
m_hdf_ngay_dat.Value = v_ngay_dat_hang.ToString("dd/MM/yyyy");
m_hdf_lan_dat.Value = v_ds.V_GD_DON_DAT_HANG.Rows[0]["LAN"].ToString();
}
private void load_data_to_chi_tiet_grid()
{
decimal v_id_trung_tam = CIPConvert.ToDecimal(m_hdf_id_trung_tam.Value);
US_V_GD_DON_DAT_HANG v_us = new US_V_GD_DON_DAT_HANG();
DS_V_GD_DON_DAT_HANG v_ds = new DS_V_GD_DON_DAT_HANG();
v_us.FillDataset(v_ds, v_id_trung_tam, CIPConvert.ToDatetime(m_txt_tu_ngay.Text), CIPConvert.ToDatetime(m_txt_den_ngay.Text));
m_grv_chi_tiet_bc.DataSource = v_ds.V_GD_DON_DAT_HANG;
m_grv_chi_tiet_bc.DataBind();
}
public void Nhap_ma_hoa_don_NCC(DS_V_GD_DON_DAT_HANG m_ds, DateTime v_dt_tu_ngay, DateTime v_dt_den_ngay, decimal id_trang_thai, decimal id_phong_ban)
{
CStoredProc v_stored_proc = new CStoredProc("pr_Nhap_ma_hoa_don_NCC");
v_stored_proc.addDatetimeInputParam("@TU_NGAY", v_dt_tu_ngay);
v_stored_proc.addDatetimeInputParam("@DEN_NGAY", v_dt_den_ngay);
v_stored_proc.addDecimalInputParam("@ID_TRANG_THAI", id_trang_thai);
v_stored_proc.addDecimalInputParam("@ID_PHONG_BAN", id_phong_ban);
v_stored_proc.fillDataSetByCommand(this, m_ds);
}
public US_V_GD_DON_DAT_HANG()
{
pm_objDS = new DS_V_GD_DON_DAT_HANG();
pm_strTableName = c_TableName;
pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow();
}
public void FillDatasetSearch_phap_nhan(DS_V_GD_DON_DAT_HANG ip_ds, DateTime ip_dat_thang, decimal ip_dc_id_phap_nhan, decimal ip_id_trang_thai, decimal ip_id_trung_tam)
{
CStoredProc v_stored_proc = new CStoredProc("pr_V_GD_DON_DAT_HANG_Search_Phapnhan");
v_stored_proc.addDecimalInputParam("@ID_PHAP_NHAN", ip_dc_id_phap_nhan);
v_stored_proc.addDatetimeInputParam("@NGAY", ip_dat_thang);
v_stored_proc.addDecimalInputParam("@ID_TRANG_THAI", ip_id_trang_thai);
v_stored_proc.addNVarcharInputParam("@ID_PHONG_BAN", ip_id_trung_tam);
v_stored_proc.fillDataSetByCommand(this, ip_ds);
}
public void FillDataset(DS_V_GD_DON_DAT_HANG ip_v_ds, decimal ip_v_id_trung_tam, DateTime ip_v_dt_tu_ngay, DateTime ip_v_dt_den_ngay)
{
CStoredProc v_stored_proc = new CStoredProc("pr_TRA_CUU_TINH_HINH_VPP_WEB_chi_tiet_Search");
v_stored_proc.addDatetimeInputParam("@TU_NGAY", ip_v_dt_tu_ngay);
v_stored_proc.addDatetimeInputParam("@DEN_NGAY", ip_v_dt_den_ngay);
v_stored_proc.addDecimalInputParam("@ID_TRUNG_TAM", ip_v_id_trung_tam);
v_stored_proc.fillDataSetByCommand(this, ip_v_ds);
}
