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);
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
{
Mail.sendEmail(user_email, password, to_cc, TIEU_DE, NOI_DUNG);
}
catch (Exception v_e)
{
CSystemLog_301.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 m_btn_remind_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 =10");
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_don_hang_ht_chua_danh_gia.GetDataRow(m_grv_ds_don_hang_ht_chua_danh_gia.FocusedRowHandle);
decimal v_id_giao_dich = CIPConvert.ToDecimal(v_dr["ID"].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);
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();
// to_cc = "*****@*****.**";
try
{
Mail.sendEmail(user_email, password, to_cc, TIEU_DE, NOI_DUNG);
MessageBox.Show("Hoàn thành!");
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(v_e);
}
}
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();
}
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();
}
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 grid2us_object(US_V_GD_DAT_HANG i_us
, int i_grid_row)
{
DataRow v_dr;
v_dr = (DataRow) m_fg.Rows[i_grid_row].UserData;
m_obj_trans.GridRow2DataRow(i_grid_row,v_dr);
i_us.DataRow2Me(v_dr);
}
private void delete_v_gd_dat_hang()
{
if (!CGridUtils.IsThere_Any_NonFixed_Row(m_fg)) return;
if (!CGridUtils.isValid_NonFixed_RowIndex(m_fg, m_fg.Row)) return;
if (BaseMessages.askUser_DataCouldBeDeleted(8) != BaseMessages.IsDataCouldBeDeleted.CouldBeDeleted) return;
US_V_GD_DAT_HANG v_us = new US_V_GD_DAT_HANG();
grid2us_object(v_us, m_fg.Row);
try {
v_us.BeginTransaction();
v_us.Delete();
v_us.CommitTransaction();
m_fg.Rows.Remove(m_fg.Row);
}
catch (Exception v_e) {
v_us.Rollback();
CDBExceptionHandler v_objErrHandler = new CDBExceptionHandler(v_e,
new CDBClientDBExceptionInterpret());
v_objErrHandler.showErrorMessage();
}
}
private void us_object2grid(US_V_GD_DAT_HANG i_us
, int i_grid_row)
{
DataRow v_dr = (DataRow) m_fg.Rows[i_grid_row].UserData;
i_us.Me2DataRow(v_dr);
m_obj_trans.DataRow2GridRow(v_dr, i_grid_row);
}
private void us_2_form(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);
US_DM_LOAI_YEU_CAU v_us_dich_vu = new US_DM_LOAI_YEU_CAU(v_us.dcID_DV_YEU_CAU);
US_DM_LOAI_YEU_CAU v_us_nhom_dich_vu = new US_DM_LOAI_YEU_CAU(v_us_dich_vu.dcID_CHA);
m_cbo_loai_dich_vu.SelectedValue = v_us_nhom_dich_vu.dcID_CHA;
m_cbo_nhom_dich_vu.SelectedValue = v_us_dich_vu.dcID_CHA;
load_data_to_cbo_dich_vu();
m_cbo_dich_vu.SelectedValue = v_us_dich_vu.dcID;
m_cbo_user_nhan_vien_dat_hang.SelectedValue = v_us.dcID_USER_NV_DAT_HANG;
m_cbo_dv_don_vi.SelectedValue = v_us.dcID_DON_VI;
m_cmd_danh_sach_nguoi_xu_ly.Enabled = false;
m_cmd_tu_choi.Enabled = false;
m_cbo_nguoi_nhan_dat_hang.SelectedValue = v_us.dcID_NGUOI_TAO;
m_cbo_thoi_gian_hoan_thanh.SelectedValue = v_us.dcID_LOAI_THOI_GIAN_CAN_HOAN_THANH;
m_dat_thoi_diem_can_hoan_thanh.Value = v_us.datTHOI_DIEM_CAN_HOAN_THANH;
m_txt_yeu_cau_cu_the.Text = v_us.strNOI_DUNG_DAT_HANG;
m_txt_phan_hoi_tu_dvmc.Text = v_us.strPHAN_HOI_TU_DVMC;
m_cbo_trang_thai_don_hang.Text = v_us_v_gd_dat_hang.strTRANG_THAI_DON_HANG;
m_cbo_phuong_thuc_dat_hang.SelectedValue = v_us.dcID_PHUONG_THUC_DAT_HANG;
}
