private void m_cmd_OK_Click(object sender, EventArgs e)
{
if (m_txt_ly_do.Text == "")
{
MessageBox.Show("Nhập lý do từ chối!");
m_txt_ly_do.Focus();
}
else
{
if (kieu_load_form == 1)
{
us_user.TD_tu_choi = m_txt_ly_do.Text;
update_log_admin_huy_don_hang();
ghi_log_admin_da_huy_don_hang();
US_V_GD_DAT_HANG v_us_gd = new US_V_GD_DAT_HANG(v_us.dcID);
us_user.gui_mail_huy_don_hang(v_us_gd, m_txt_ly_do.Text);
MessageBox.Show("Đơn hàng đã được hủy !");
this.Close();
}
else
{
us_user.TD_tu_choi = m_txt_ly_do.Text;
ghi_log_huy_dieu_phoi();
update_log_dieu_phoi();
MessageBox.Show("Đã hủy điều phối!");
this.Close();
}
}
}
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();
}
private void luu_danh_gia_don_hang()
{
US_V_GD_DAT_HANG v_us_dm_dat_hang = new US_V_GD_DAT_HANG();
decimal v_dc_id_don_hang = 0;
v_dc_id_don_hang = CIPConvert.ToDecimal(hdf_id_don_hang.Value);
decimal v_dc_id_danh_gia = 0;
if (m_rdb_rat_hai_long.Checked)
{
v_dc_id_danh_gia = ID_HANG_DANH_GIA.RAT_HAI_LONG;
}
else if (m_rdb_hai_long.Checked)
{
v_dc_id_danh_gia = ID_HANG_DANH_GIA.HAI_LONG;
}
else if (m_rdb_xong_viec.Checked)
{
v_dc_id_danh_gia = ID_HANG_DANH_GIA.XONG_VIEC;
}
else if (m_rdb_hoi_duoi.Checked)
{
v_dc_id_danh_gia = ID_HANG_DANH_GIA.HOI_DUOI;
}
else if (m_rdb_khong_dat.Checked)
{
v_dc_id_danh_gia = ID_HANG_DANH_GIA.KHONG_DAT;
}
string v_str_y_kien_khac = m_txt_y_kien_khac.Text.Trim();
v_us_dm_dat_hang.danh_gia_don_hang(v_dc_id_don_hang, v_dc_id_danh_gia, v_str_y_kien_khac);
Response.Redirect("Thanks.aspx", false);
HttpContext.Current.ApplicationInstance.CompleteRequest();
}
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 static void gui_mail_huy_don_hang(US_V_GD_DAT_HANG v_us_log_gd, string v_ly_do)
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithQuery(v_ds, "select * from dm_mau_email where id =7");
string TIEU_DE = v_ds.Tables[0].Rows[0]["TIEU_DE_MAIL"].ToString();
string NOI_DUNG = v_ds.Tables[0].Rows[0]["NOI_DUNG_EMAIL"].ToString();
string GUI_CC = v_ds.Tables[0].Rows[0]["GUI_CC"].ToString();
TIEU_DE = TIEU_DE.Replace("MA_DON_HANG", v_us_log_gd.strMA_DON_HANG);
NOI_DUNG = NOI_DUNG.Replace("MA_DON_HANG", v_us_log_gd.strMA_DON_HANG);
NOI_DUNG = NOI_DUNG.Replace("USER_NHAN_VIEN", v_us_log_gd.strHO_TEN_USER_DAT_HANG);
NOI_DUNG = NOI_DUNG.Replace("USER_DON_VI", v_us_log_gd.strMA_DON_VI);
NOI_DUNG = NOI_DUNG.Replace("USER_DIEN_THOAI", v_us_log_gd.strDIEN_THOAI);
NOI_DUNG = NOI_DUNG.Replace("USER_THOI_GIAN_DAT_HANG", v_us_log_gd.datTHOI_GIAN_TAO.ToString());
NOI_DUNG = NOI_DUNG.Replace("LOAI_DICH_VU_HO_TRO", v_us_log_gd.strTEN_YEU_CAU);
NOI_DUNG = NOI_DUNG.Replace("YEU_CAU_CU_THE", v_us_log_gd.strNOI_DUNG_DAT_HANG);
NOI_DUNG = NOI_DUNG.Replace("THOI_GIAN_HOAN_THANH_THUC_TE", "chưa có");
NOI_DUNG = NOI_DUNG.Replace("LICH_SU_TRAO_DOI", "Vừa tiếp nhận.");
NOI_DUNG = NOI_DUNG.Replace("THOI_GIAN_MONG_MUON_SUA_XONG", v_us_log_gd.datTHOI_DIEM_CAN_HOAN_THANH + " hoặc thời gian hoàn thành là:" + v_us_log_gd.datTHOI_GIAN_HOAN_THANH);
NOI_DUNG = NOI_DUNG.Replace("PHAN_HOI_CUA_DVMC", "Đơn hàng của bạn đã bị hủy với lý do: " + v_ly_do);
string nguoi_xu_ly = "";
US_DUNG_CHUNG v_us_3 = new US_DUNG_CHUNG();
DataSet v_ds_3 = new DataSet();
v_ds_3.Tables.Add(new DataTable());
v_us_3.FillDatasetWithQuery(v_ds_3, "select * from V_GD_DAT_HANG_GD_LOG_DAT_HANG where ten_nguoi_tao_thao_tac_log is not null and THAO_TAC_HET_HAN_YN ='N' and ID_DON_HANG=" + v_us_log_gd.dcID);
for (int i = 0; i < v_ds_3.Tables[0].Rows.Count; i++)
{
nguoi_xu_ly += "," + v_ds_3.Tables[0].Rows[i]["TEN_NGUOI_TAO_THAO_TAC_LOG"].ToString();
}
NOI_DUNG = NOI_DUNG.Replace("NGUOI_XU_LY_DON_HANG", nguoi_xu_ly);
NOI_DUNG = NOI_DUNG.Replace("NGUOI_NHAN_DAT_HANG", v_us_log_gd.strNGUOI_TAO);
US_DUNG_CHUNG v_us_kh = new US_DUNG_CHUNG();
DataSet v_ds_kh = new DataSet();
v_ds_kh.Tables.Add(new DataTable());
v_us_kh.FillDatasetWithQuery(v_ds_kh, "select * from dm_khach_hang where id=" + v_us_log_gd.dcID_USER_NV_DAT_HANG);
string to_cc = "";
to_cc = v_ds_kh.Tables[0].Rows[0]["EMAIL"].ToString();
try
{
string user_email = "*****@*****.**";
string password = "******";
HelpUtils.send_mail("Dịch Vụ Một Cửa<Thông báo hủy đơn hàng>", user_email, password, to_cc, GUI_CC, TIEU_DE, NOI_DUNG);
}
catch (Exception v_e)
{
CSystemLog_100.ExceptionHandle(v_e);
}
}
private void load_data_2_form(IPCOREUS.US_GD_DAT_HANG v_us)
{
US_V_GD_DAT_HANG v_us_v_gd_dat_hang = new US_V_GD_DAT_HANG(v_us.dcID);
m_txt_ma_don_hang.Text = v_us_v_gd_dat_hang.strMA_DON_HANG;
m_txt_user_dat_hang.Text = v_us_v_gd_dat_hang.strHO_TEN_USER_DAT_HANG;
m_txt_dien_thoai.Text = v_us_v_gd_dat_hang.strDIEN_THOAI;
m_txt_don_vi.Text = v_us_v_gd_dat_hang.strMA_DON_VI;
m_txt_chi_nhanh.Text = v_us_v_gd_dat_hang.strTEN_CHI_NHANH;
m_txt_dich_vu_yeu_cau.Text = v_us_v_gd_dat_hang.strTEN_YEU_CAU;
m_txt_noi_dung_yeu_cau_cu_the.Text = v_us_v_gd_dat_hang.strNOI_DUNG_DAT_HANG;
}
private void simpleButton1_Click(object sender, EventArgs e)
{
string user_email = "*****@*****.**";
string password = "******";
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithQuery(v_ds, "select * from dm_mau_email where id =6");
string TIEU_DE = v_ds.Tables[0].Rows[0]["TIEU_DE_MAIL"].ToString();
string NOI_DUNG = v_ds.Tables[0].Rows[0]["NOI_DUNG_EMAIL"].ToString();
string GUI_CC = v_ds.Tables[0].Rows[0]["GUI_CC"].ToString();
DataRow v_dr = m_grv_ds_dh_hoan_thanh.GetDataRow(m_grv_ds_dh_hoan_thanh.FocusedRowHandle);
decimal v_id_giao_dich = CIPConvert.ToDecimal(v_dr["ID_DON_HANG"].ToString());
US_V_GD_DAT_HANG m_us = new US_V_GD_DAT_HANG(v_id_giao_dich);
TIEU_DE = TIEU_DE.Replace("MA_DON_HANG", m_us.strMA_DON_HANG);
NOI_DUNG = NOI_DUNG.Replace("MA_DON_HANG", m_us.strMA_DON_HANG);
NOI_DUNG = NOI_DUNG.Replace("USER_NHAN_VIEN", m_us.strHO_TEN_USER_DAT_HANG);
NOI_DUNG = NOI_DUNG.Replace("USER_DON_VI", m_us.strMA_DON_VI);
NOI_DUNG = NOI_DUNG.Replace("USER_DIEN_THOAI", m_us.strDIEN_THOAI);
NOI_DUNG = NOI_DUNG.Replace("USER_THOI_GIAN_DAT_HANG", m_us.datTHOI_GIAN_TAO.ToString());
NOI_DUNG = NOI_DUNG.Replace("LOAI_DICH_VU_HO_TRO", m_us.strTEN_YEU_CAU);
NOI_DUNG = NOI_DUNG.Replace("YEU_CAU_CU_THE", m_us.strNOI_DUNG_DAT_HANG);
NOI_DUNG = NOI_DUNG.Replace("THOI_GIAN_HOAN_THANH_THUC_TE", m_us.datTHOI_GIAN_HOAN_THANH.ToString());
NOI_DUNG = NOI_DUNG.Replace("LICH_SU_TRAO_DOI", "Vừa tiếp nhận.");
NOI_DUNG = NOI_DUNG.Replace("THOI_GIAN_MONG_MUON_SUA_XONG", m_us.datTHOI_DIEM_CAN_HOAN_THANH + "hoặc thời gian hoàn thành là:" + m_us.datTHOI_GIAN_HOAN_THANH);
NOI_DUNG = NOI_DUNG.Replace("PHAN_HOI_CUA_DVMC", "Quý khách vui lòng đáng giá chất lượng dịch vụ một cửa");
NOI_DUNG = NOI_DUNG.Replace("NGUOI_XU_LY_DON_HANG", m_us.strNGUOI_XU_LY);
NOI_DUNG = NOI_DUNG.Replace("NGUOI_NHAN_DAT_HANG", m_us.strNGUOI_TAO);
NOI_DUNG = NOI_DUNG.Replace("LINK_DANH_GIA_DON_HANG", "app.websomot.com:8888/chucnang/f200_kh_danh_gia_dich_vu.aspx?ma=" + m_us.strMA_DON_HANG);
US_DUNG_CHUNG v_us_1 = new US_DUNG_CHUNG();
DataSet v_ds_1 = new DataSet();
v_ds_1.Tables.Add(new DataTable());
v_us_1.FillDatasetWithQuery(v_ds_1, "select * from dm_khach_hang where id=" + m_us.dcID_USER_NV_DAT_HANG);
string to_cc = "";
to_cc = v_ds_1.Tables[0].Rows[0]["EMAIL"].ToString();
try
{
HelpUtils.send_mail("Dịch Vụ Một Cửa", user_email, password, to_cc, GUI_CC, TIEU_DE, NOI_DUNG);
}
catch (Exception v_e)
{
CSystemLog_100.ExceptionHandle(v_e);
}
}
public void display_for_update_hoan_thanh_don_hang(US_V_GD_DAT_HANG ip_us_v_gd_dat_hang)
{
m_us_v_gd_dat_hang = ip_us_v_gd_dat_hang;
m_e_fome_mode = e_form_mode.HOAN_THANH_DON_HANG;
this.ShowDialog();
}
public void display_for_update(US_V_GD_DAT_HANG ip_us_v_gd_dat_hang)
{
m_us_v_gd_dat_hang = ip_us_v_gd_dat_hang;
m_e_fome_mode = e_form_mode.UPDATE_DATA;
this.ShowDialog();
}
public void display_to_danh_gia(US_V_GD_DAT_HANG ip_us_dat_hang)
{
m_us_dat_hang = ip_us_dat_hang;
this.ShowDialog();
}
private void gui_email_bao_hoan_thanh()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
US_V_GD_DAT_HANG m_us_v_gd_dat_hang = new US_V_GD_DAT_HANG(M_us.dcID);
v_us.FillDatasetWithQuery(v_ds, "select * from dm_mau_email where id =6");
string TIEU_DE = v_ds.Tables[0].Rows[0]["TIEU_DE_MAIL"].ToString();
string NOI_DUNG = v_ds.Tables[0].Rows[0]["NOI_DUNG_EMAIL"].ToString();
string GUI_CC = v_ds.Tables[0].Rows[0]["GUI_CC"].ToString();
TIEU_DE = TIEU_DE.Replace("MA_DON_HANG", m_us_v_gd_dat_hang.strMA_DON_HANG);
NOI_DUNG = NOI_DUNG.Replace("MA_DON_HANG", m_us_v_gd_dat_hang.strMA_DON_HANG);
NOI_DUNG = NOI_DUNG.Replace("USER_NHAN_VIEN", m_us_v_gd_dat_hang.strHO_TEN_USER_DAT_HANG);
NOI_DUNG = NOI_DUNG.Replace("USER_DON_VI", m_us_v_gd_dat_hang.strMA_DON_VI);
NOI_DUNG = NOI_DUNG.Replace("USER_DIEN_THOAI", M_us.strDIEN_THOAI);
NOI_DUNG = NOI_DUNG.Replace("USER_THOI_GIAN_DAT_HANG", M_us.datTHOI_GIAN_TAO.ToString());
NOI_DUNG = NOI_DUNG.Replace("LOAI_DICH_VU_HO_TRO", m_us_v_gd_dat_hang.strTEN_YEU_CAU);
NOI_DUNG = NOI_DUNG.Replace("YEU_CAU_CU_THE", M_us.strNOI_DUNG_DAT_HANG);
NOI_DUNG = NOI_DUNG.Replace("THOI_GIAN_HOAN_THANH_THUC_TE", M_us.datTHOI_GIAN_HOAN_THANH.ToString());
NOI_DUNG = NOI_DUNG.Replace("LICH_SU_TRAO_DOI", "Hoàn thành");
NOI_DUNG = NOI_DUNG.Replace("THOI_GIAN_MONG_MUON_SUA_XONG", M_us.datTHOI_DIEM_CAN_HOAN_THANH + "hoặc thời gian hoàn thành là:" + M_us.datTHOI_GIAN_HOAN_THANH);
NOI_DUNG = NOI_DUNG.Replace("PHAN_HOI_CUA_DVMC", M_us.strPHAN_HOI_TU_DVMC);
NOI_DUNG = NOI_DUNG.Replace("LINK_DANH_GIA_DON_HANG", "dvmc2.topica.vn/chucnang/f201_kh_danh_gia_dv.aspx?ma=" + m_us_v_gd_dat_hang.strMA_DON_HANG);
string nguoi_xu_ly = "";
List <decimal> m_lst_id_nguoi_xu_ly = new List <decimal>();
US_DUNG_CHUNG v_us_3 = new US_DUNG_CHUNG();
DataSet v_ds_3 = new DataSet();
v_ds_3.Tables.Add(new DataTable());
v_us_3.FillDatasetWithQuery(v_ds_3, "select * from V_GD_DAT_HANG_GD_LOG_DAT_HANG where ten_nguoi_tao_thao_tac_log is not null and thao_tac_het_han_yn='N' and ID_DON_HANG=" + M_us.dcID);
for (int i = 0; i < v_ds_3.Tables[0].Rows.Count; i++)
{
nguoi_xu_ly += "," + v_ds_3.Tables[0].Rows[i]["TEN_NGUOI_TAO_THAO_TAC_LOG"].ToString();
}
NOI_DUNG = NOI_DUNG.Replace("NGUOI_XU_LY_DON_HANG", nguoi_xu_ly);
NOI_DUNG = NOI_DUNG.Replace("NGUOI_NHAN_DAT_HANG", m_us_v_gd_dat_hang.strNGUOI_TAO);
US_DUNG_CHUNG v_us_1 = new US_DUNG_CHUNG();
DataSet v_ds_1 = new DataSet();
v_ds_1.Tables.Add(new DataTable());
v_us_1.FillDatasetWithQuery(v_ds_1, "select * from dm_khach_hang where id=" + M_us.dcID_USER_NV_DAT_HANG);
string to_cc = "";
to_cc = v_ds_1.Tables[0].Rows[0]["EMAIL"].ToString();
string user_email = "*****@*****.**";
string password = "******";
try
{
HelpUtils.send_mail("Dịch Vụ Một Cửa", user_email, password, to_cc, GUI_CC, TIEU_DE, NOI_DUNG);
}
catch (Exception v_e)
{
CSystemLog_100.ExceptionHandle(v_e);
}
}
