private void load_data_2_grid()
{
US_V_GD_DAT_HANG v_us_gd_dat_hang = new US_V_GD_DAT_HANG();
DS_V_GD_DAT_HANG v_ds_gd_dat_hang = new DS_V_GD_DAT_HANG();
string v_str_ma_don_hang = "";
if (Request.QueryString["ma"] != null)
{
v_str_ma_don_hang = CIPConvert.ToStr(Request.QueryString["ma"]);
}
string v_str_username = "";
/*if (Session["USERNAME"] != null)
* v_str_username = CIPConvert.ToStr(Session["USERNAME"]);
*/
v_ds_gd_dat_hang.EnforceConstraints = false;
v_us_gd_dat_hang.load_dat_hang_by_ma(v_str_ma_don_hang, v_str_username, v_ds_gd_dat_hang);
/*if (Session["USERNAME"] == null
* && v_ds_gd_dat_hang.V_GD_DAT_HANG.Rows.Count>0 )
* Session["USERNAME"] = v_ds_gd_dat_hang.V_GD_DAT_HANG.Rows[0][V_GD_DAT_HANG.USER_NV_DAT_HANG];
*/
m_grv_cau_hoi_hoc_vien.DataSource = v_ds_gd_dat_hang.V_GD_DAT_HANG;
m_grv_cau_hoi_hoc_vien.DataBind();
}
public void load_ds_don_hang(DateTime ip_dat_tu_ngay
, DateTime ip_dat_den_ngay
, string ip_str_ma_don_hang
, string ip_str_user_dat_hang
, decimal ip_dc_id_thoi_han_hoan_thanh
, decimal ip_dc_id_trang_thai_don_hang
, decimal ip_dc_id_nguoi_dung
, string ip_str_da_danh_gia_yn
, decimal ip_dc_id_nguoi_tiep_nhan
, decimal ip_dc_id_nguoi_xu_ly
, decimal ip_dc_id_loai_yeu_cau
, decimal ip_dc_id_danh_gia_tu_khach_hang
, DateTime ip_dat_hoan_thanh_tu_ngay
, DateTime ip_dat_hoan_thanh_den_ngay
, DS_V_GD_DAT_HANG op_ds)
{
CStoredProc v_cstore = new CStoredProc("pr_V_GD_DAT_HANG_load_ds_don_hang_v30");
v_cstore.addDatetimeInputParam("@TU_NGAY", ip_dat_tu_ngay);
v_cstore.addDatetimeInputParam("@DEN_NGAY", ip_dat_den_ngay);
v_cstore.addNVarcharInputParam("@MA_DON_HANG", ip_str_ma_don_hang);
v_cstore.addNVarcharInputParam("@USER_DAT_HANG", ip_str_user_dat_hang);
v_cstore.addDecimalInputParam("@ID_THOI_HAN", ip_dc_id_thoi_han_hoan_thanh);
v_cstore.addDecimalInputParam("@ID_TRANG_THAI", ip_dc_id_trang_thai_don_hang);
v_cstore.addDecimalInputParam("@ID_USER", ip_dc_id_nguoi_dung);
v_cstore.addDecimalInputParam("@ID_NGUOI_XU_LY", ip_dc_id_nguoi_xu_ly);
v_cstore.addDecimalInputParam("@ID_NGUOI_TIEP_NHAN", ip_dc_id_nguoi_tiep_nhan);
v_cstore.addDecimalInputParam("@ID_LOAI_YEU_CAU", ip_dc_id_loai_yeu_cau);
v_cstore.addDecimalInputParam("@ID_DANH_GIA_TU_KHACH_HANG", ip_dc_id_danh_gia_tu_khach_hang);
v_cstore.addNVarcharInputParam("@DA_DANH_GIA_YN", ip_str_da_danh_gia_yn);
v_cstore.addDatetimeInputParam("@HOAN_THANH_TU_NGAY", ip_dat_hoan_thanh_tu_ngay);
v_cstore.addDatetimeInputParam("@HOAN_THANH_DEN_NGAY", ip_dat_hoan_thanh_den_ngay);
v_cstore.fillDataSetByCommand(this, op_ds);
}
private void load_thong_tin_don_hang()
{
US_V_GD_DAT_HANG v_us_gd_dat_hang = new US_V_GD_DAT_HANG();
DS_V_GD_DAT_HANG v_ds_gd_dat_hang = new DS_V_GD_DAT_HANG();
string v_str_ma_don_hang = "";
if (Request.QueryString["ma"] != null)
{
v_str_ma_don_hang = CIPConvert.ToStr(Request.QueryString["ma"]);
Session["DON_HANG"] = v_str_ma_don_hang;
}
else if (Session["DON_HANG"] != null)
{
v_str_ma_don_hang = CIPConvert.ToStr(Session["DON_HANG"]);
}
v_ds_gd_dat_hang.EnforceConstraints = false;
v_us_gd_dat_hang.load_dat_hang_by_ma(v_str_ma_don_hang, "", v_ds_gd_dat_hang);
if (Session["USERNAME"] == null)
{
Session["USERNAME"] = v_ds_gd_dat_hang.V_GD_DAT_HANG.Rows[0][V_GD_DAT_HANG.USER_NAME];
}
if (v_ds_gd_dat_hang.V_GD_DAT_HANG.Rows.Count > 0 &&
v_ds_gd_dat_hang.V_GD_DAT_HANG.Rows[0][V_GD_DAT_HANG.ID_DANH_GIA_TU_USER_DAT_HANG].ToString() != "")
{
m_lbl_message.Text = "Đơn hàng này đã được đánh giá.Xin cảm ơn!";
decimal v_dc_id_hang_danh_gia = CIPConvert.ToDecimal(v_ds_gd_dat_hang.V_GD_DAT_HANG.Rows[0][V_GD_DAT_HANG.ID_DANH_GIA_TU_USER_DAT_HANG]);
if (v_dc_id_hang_danh_gia == ID_HANG_DANH_GIA.RAT_HAI_LONG)
{
m_rdb_rat_hai_long.Checked = true;
}
else if (v_dc_id_hang_danh_gia == ID_HANG_DANH_GIA.HAI_LONG)
{
m_rdb_hai_long.Checked = true;
}
else if (v_dc_id_hang_danh_gia == ID_HANG_DANH_GIA.XONG_VIEC)
{
m_rdb_xong_viec.Checked = true;
}
else if (v_dc_id_hang_danh_gia == ID_HANG_DANH_GIA.KHONG_DAT)
{
m_rdb_khong_dat.Checked = true;
}
else if (v_dc_id_hang_danh_gia == ID_HANG_DANH_GIA.HOI_DUOI)
{
m_rdb_hoi_duoi.Checked = true;
}
m_txt_y_kien_khac.Text = v_ds_gd_dat_hang.V_GD_DAT_HANG.Rows[0][V_GD_DAT_HANG.Y_KIEN_KHAC_TU_USER_DAT_HANG].ToString();
m_cmd_gui_danh_gia.Visible = false;
}
if (v_ds_gd_dat_hang.V_GD_DAT_HANG.Rows.Count > 0)
{
m_lbl_ma_don_hang.Text = v_str_ma_don_hang;
m_lbl_loai_dat_hang.Text = v_ds_gd_dat_hang.V_GD_DAT_HANG.Rows[0][V_GD_DAT_HANG.TEN_YEU_CAU].ToString();
m_dat_ngay_dat_hang.Text = v_ds_gd_dat_hang.V_GD_DAT_HANG.Rows[0][V_GD_DAT_HANG.THOI_GIAN_TAO].ToString();
m_lbl_loai_thoi_han.Text = v_ds_gd_dat_hang.V_GD_DAT_HANG.Rows[0][V_GD_DAT_HANG.LOAI_THOI_GIAN_CAN_HOAN_THANH].ToString();
m_txt_noi_dung_dat_hang.Text = v_ds_gd_dat_hang.V_GD_DAT_HANG.Rows[0][V_GD_DAT_HANG.NOI_DUNG_DAT_HANG].ToString();
hdf_id_don_hang.Value = v_ds_gd_dat_hang.V_GD_DAT_HANG.Rows[0][V_GD_DAT_HANG.ID].ToString();
}
}
public void load_dat_hang_by_ma(string ip_str_ma_dat_hang
, string ip_str_username
, DS_V_GD_DAT_HANG op_ds)
{
CStoredProc v_cstore = new CStoredProc("pr_V_GD_DAT_HANG_load_dat_hang_by_ma");
v_cstore.addNVarcharInputParam("@MA_DAT_HANG", ip_str_ma_dat_hang);
v_cstore.addNVarcharInputParam("@USERNAME", ip_str_username);
v_cstore.fillDataSetByCommand(this, op_ds);
}
public US_V_GD_DAT_HANG(decimal i_dbID)
{
pm_objDS = new DS_V_GD_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]);
}
public US_V_GD_DAT_HANG(decimal i_dbID)
{
pm_objDS = new DS_V_GD_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_thong_tin_don_hang()
{
US_V_GD_DAT_HANG v_us_gd_dat_hang = new US_V_GD_DAT_HANG();
DS_V_GD_DAT_HANG v_ds_gd_dat_hang = new DS_V_GD_DAT_HANG();
string v_str_ma_don_hang = "";
if (Request.QueryString["ma"] != null)
{
v_str_ma_don_hang = CIPConvert.ToStr(Request.QueryString["ma"]);
Session["DON_HANG"] = v_str_ma_don_hang;
}
else if (Session["DON_HANG"] != null)
v_str_ma_don_hang = CIPConvert.ToStr(Session["DON_HANG"]);
v_ds_gd_dat_hang.EnforceConstraints = false;
v_us_gd_dat_hang.load_dat_hang_by_ma(v_str_ma_don_hang, "", v_ds_gd_dat_hang);
if (Session["USERNAME"] == null)
Session["USERNAME"] = v_ds_gd_dat_hang.V_GD_DAT_HANG.Rows[0][V_GD_DAT_HANG.USER_NAME];
if (v_ds_gd_dat_hang.V_GD_DAT_HANG.Rows.Count > 0
&& v_ds_gd_dat_hang.V_GD_DAT_HANG.Rows[0][V_GD_DAT_HANG.ID_DANH_GIA_TU_USER_DAT_HANG].ToString()!= "")
{
m_lbl_message.Text = "Đơn hàng này đã được đánh giá.Xin cảm ơn!";
decimal v_dc_id_hang_danh_gia = CIPConvert.ToDecimal(v_ds_gd_dat_hang.V_GD_DAT_HANG.Rows[0][V_GD_DAT_HANG.ID_DANH_GIA_TU_USER_DAT_HANG]);
if (v_dc_id_hang_danh_gia == ID_HANG_DANH_GIA.RAT_HAI_LONG)
m_rdb_rat_hai_long.Checked = true;
else if (v_dc_id_hang_danh_gia == ID_HANG_DANH_GIA.HAI_LONG)
m_rdb_hai_long.Checked = true;
else if (v_dc_id_hang_danh_gia == ID_HANG_DANH_GIA.XONG_VIEC)
m_rdb_xong_viec.Checked = true;
else if (v_dc_id_hang_danh_gia == ID_HANG_DANH_GIA.KHONG_DAT)
m_rdb_khong_dat.Checked = true;
else if (v_dc_id_hang_danh_gia == ID_HANG_DANH_GIA.HOI_DUOI)
m_rdb_hoi_duoi.Checked = true;
m_txt_y_kien_khac.Text = v_ds_gd_dat_hang.V_GD_DAT_HANG.Rows[0][V_GD_DAT_HANG.Y_KIEN_KHAC_TU_USER_DAT_HANG].ToString();
m_cmd_gui_danh_gia.Visible = false;
}
if (v_ds_gd_dat_hang.V_GD_DAT_HANG.Rows.Count > 0)
{
m_lbl_ma_don_hang.Text = v_str_ma_don_hang;
m_lbl_loai_dat_hang.Text = v_ds_gd_dat_hang.V_GD_DAT_HANG.Rows[0][V_GD_DAT_HANG.TEN_YEU_CAU].ToString();
m_dat_ngay_dat_hang.Text = v_ds_gd_dat_hang.V_GD_DAT_HANG.Rows[0][V_GD_DAT_HANG.THOI_GIAN_TAO].ToString();
m_lbl_loai_thoi_han.Text = v_ds_gd_dat_hang.V_GD_DAT_HANG.Rows[0][V_GD_DAT_HANG.LOAI_THOI_GIAN_CAN_HOAN_THANH].ToString();
m_txt_noi_dung_dat_hang.Text = v_ds_gd_dat_hang.V_GD_DAT_HANG.Rows[0][V_GD_DAT_HANG.NOI_DUNG_DAT_HANG].ToString();
hdf_id_don_hang.Value = v_ds_gd_dat_hang.V_GD_DAT_HANG.Rows[0][V_GD_DAT_HANG.ID].ToString();
}
}
private void load_data_2_grid()
{
US_V_GD_DAT_HANG v_us_gd_dat_hang = new US_V_GD_DAT_HANG();
DS_V_GD_DAT_HANG v_ds_gd_dat_hang = new DS_V_GD_DAT_HANG();
string v_str_ma_don_hang = "";
if (Request.QueryString["ma"] != null)
{
v_str_ma_don_hang = CIPConvert.ToStr(Request.QueryString["ma"]);
}
string v_str_username = "";
/*if (Session["USERNAME"] != null)
v_str_username = CIPConvert.ToStr(Session["USERNAME"]);
*/
v_ds_gd_dat_hang.EnforceConstraints = false;
v_us_gd_dat_hang.load_dat_hang_by_ma(v_str_ma_don_hang, v_str_username, v_ds_gd_dat_hang);
/*if (Session["USERNAME"] == null
&& v_ds_gd_dat_hang.V_GD_DAT_HANG.Rows.Count>0 )
Session["USERNAME"] = v_ds_gd_dat_hang.V_GD_DAT_HANG.Rows[0][V_GD_DAT_HANG.USER_NV_DAT_HANG];
*/
m_grv_cau_hoi_hoc_vien.DataSource = v_ds_gd_dat_hang.V_GD_DAT_HANG;
m_grv_cau_hoi_hoc_vien.DataBind();
}
public US_V_GD_DAT_HANG()
{
pm_objDS = new DS_V_GD_DAT_HANG();
pm_strTableName = c_TableName;
pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow();
}
public void load_ds_don_hang(DateTime ip_dat_tu_ngay
, DateTime ip_dat_den_ngay
, string ip_str_ma_don_hang
, string ip_str_user_dat_hang
, decimal ip_dc_id_thoi_han_hoan_thanh
, decimal ip_dc_id_trang_thai_don_hang
, decimal ip_dc_id_nguoi_dung
, string ip_str_da_danh_gia_yn
, decimal ip_dc_id_nguoi_tiep_nhan
, decimal ip_dc_id_nguoi_xu_ly
, decimal ip_dc_id_loai_yeu_cau
, decimal ip_dc_id_danh_gia_tu_khach_hang
, DateTime ip_dat_hoan_thanh_tu_ngay
, DateTime ip_dat_hoan_thanh_den_ngay
, DS_V_GD_DAT_HANG op_ds)
{
CStoredProc v_cstore = new CStoredProc("pr_V_GD_DAT_HANG_load_ds_don_hang_v30");
v_cstore.addDatetimeInputParam("@TU_NGAY", ip_dat_tu_ngay);
v_cstore.addDatetimeInputParam("@DEN_NGAY", ip_dat_den_ngay);
v_cstore.addNVarcharInputParam("@MA_DON_HANG", ip_str_ma_don_hang);
v_cstore.addNVarcharInputParam("@USER_DAT_HANG", ip_str_user_dat_hang);
v_cstore.addDecimalInputParam("@ID_THOI_HAN", ip_dc_id_thoi_han_hoan_thanh);
v_cstore.addDecimalInputParam("@ID_TRANG_THAI", ip_dc_id_trang_thai_don_hang);
v_cstore.addDecimalInputParam("@ID_USER", ip_dc_id_nguoi_dung);
v_cstore.addDecimalInputParam("@ID_NGUOI_XU_LY", ip_dc_id_nguoi_xu_ly);
v_cstore.addDecimalInputParam("@ID_NGUOI_TIEP_NHAN", ip_dc_id_nguoi_tiep_nhan);
v_cstore.addDecimalInputParam("@ID_LOAI_YEU_CAU", ip_dc_id_loai_yeu_cau);
v_cstore.addDecimalInputParam("@ID_DANH_GIA_TU_KHACH_HANG", ip_dc_id_danh_gia_tu_khach_hang);
v_cstore.addNVarcharInputParam("@DA_DANH_GIA_YN", ip_str_da_danh_gia_yn);
v_cstore.addDatetimeInputParam("@HOAN_THANH_TU_NGAY", ip_dat_hoan_thanh_tu_ngay);
v_cstore.addDatetimeInputParam("@HOAN_THANH_DEN_NGAY", ip_dat_hoan_thanh_den_ngay);
v_cstore.fillDataSetByCommand(this, op_ds);
}
public void load_dat_hang_by_ma(string ip_str_ma_dat_hang
, string ip_str_username
, DS_V_GD_DAT_HANG op_ds)
{
CStoredProc v_cstore = new CStoredProc("pr_V_GD_DAT_HANG_load_dat_hang_by_ma");
v_cstore.addNVarcharInputParam("@MA_DAT_HANG", ip_str_ma_dat_hang);
v_cstore.addNVarcharInputParam("@USERNAME", ip_str_username);
v_cstore.fillDataSetByCommand(this, op_ds);
}
private void load_data_2_grid()
{
DateTime v_dat_tu_ngay;
if (m_dat_from_date.Checked) v_dat_tu_ngay = m_dat_from_date.Value;
else v_dat_tu_ngay = CIPConvert.ToDatetime("01/01/1900");
DateTime v_dat_den_ngay;
if (m_dat_to_date.Checked) v_dat_den_ngay = m_dat_to_date.Value;
else v_dat_den_ngay = CIPConvert.ToDatetime("01/01/1900");
DateTime v_dat_hoan_thanh_tu_ngay;
if (m_dat_time_hoan_thanh_tu_ngay.Checked) v_dat_hoan_thanh_tu_ngay = m_dat_time_hoan_thanh_tu_ngay.Value;
else v_dat_hoan_thanh_tu_ngay = CIPConvert.ToDatetime("01/01/1900");
DateTime v_dat_hoan_thanh_den_ngay;
if (m_dat_time_hoan_thanh_den_ngay.Checked) v_dat_hoan_thanh_den_ngay = m_dat_time_hoan_thanh_den_ngay.Value;
else v_dat_hoan_thanh_den_ngay = CIPConvert.ToDatetime("01/01/1900");
string v_str_ma_don_hang = m_txt_ma_don_hang.Text.Trim();
string v_str_user_nguoi_dat_hang = m_txt_nguoi_dat_hang.Text.Trim();
decimal v_dc_id_thoi_gian_hen_hoan_thanh = CIPConvert.ToDecimal(m_cbo_tho_han_xu_ly.SelectedValue);
decimal v_dc_id_trang_thai_don_hang = CIPConvert.ToDecimal(m_cbo_trang_thai_don_hang.SelectedValue);
decimal v_dc_id_nguoi_xu_ly = CIPConvert.ToDecimal(m_cbo_nguoi_xu_ly.SelectedValue);
decimal v_dc_id_nguoi_tiep_nhan = CIPConvert.ToDecimal(m_cbo_nguoi_nhan_dat_hang.SelectedValue);
decimal v_dc_id_loai_yeu_cau = CIPConvert.ToDecimal(m_cbo_loai_yeu_cau.SelectedValue);
decimal v_dc_id_danh_gia_tu_khach_hang = CIPConvert.ToDecimal(m_cbo_danh_gia_tu_khach_hang.SelectedValue);
string v_str_da_danh_gia_yn = "N";
if (m_rdb_danh_gia_all.Checked) v_str_da_danh_gia_yn = "A";
if (m_rdb_danh_gia_yes.Checked) v_str_da_danh_gia_yn = "Y";
m_ds = new DS_V_GD_DAT_HANG();
m_ds.EnforceConstraints = false;
m_us.load_ds_don_hang(v_dat_tu_ngay
, v_dat_den_ngay
, v_str_ma_don_hang
, v_str_user_nguoi_dat_hang
, v_dc_id_thoi_gian_hen_hoan_thanh
, v_dc_id_trang_thai_don_hang
, f002_main_form.m_dc_id_user
, v_str_da_danh_gia_yn
, v_dc_id_nguoi_tiep_nhan
, v_dc_id_nguoi_xu_ly
, v_dc_id_loai_yeu_cau
, v_dc_id_danh_gia_tu_khach_hang
, v_dat_hoan_thanh_tu_ngay
, v_dat_hoan_thanh_den_ngay
, m_ds);
m_fg.Redraw = false;
CGridUtils.Dataset2C1Grid(m_ds, m_fg, m_obj_trans);
CGridUtils.MakeSoTT((int)e_col_Number.STT, m_fg);
m_lbl_so_luong_dat_hang.Text = "Số lượng đặt hàng: " + m_ds.V_GD_DAT_HANG.Rows.Count;
m_fg.Redraw = true;
}
public US_V_GD_DAT_HANG()
{
pm_objDS = new DS_V_GD_DAT_HANG();
pm_strTableName = c_TableName;
pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow();
}
