private void us_to_form(US_V_GD_DAT_HANG_GD_LOG_DAT_HANG m_us, decimal id_nguoi_tao)
{
v_us = new US_V_GD_DAT_HANG_GD_LOG_DAT_HANG(m_us.dcID);
m_txt_ma_don_hang.Text = m_us.strMA_DON_HANG;//?? văn
m_txt_nguoi_nhan_tao_tac.Text = m_us.strNGUOI_TAO_THAO_TAC;
m_txt_ly_do_tu_choi.Focus();
}
private void load_data_to_form(IPCOREUS.US_V_GD_DAT_HANG_GD_LOG_DAT_HANG v_us)
{
m_us = new US_V_GD_DAT_HANG_GD_LOG_DAT_HANG(v_us.dcID);
m_txt_ma_don_hang.Text = v_us.strMA_DON_HANG;
WinFormControls.load_data_to_combobox_with_query(m_cbo_ds_TD, "ID", "TEN", WinFormControls.eTAT_CA.NO, "SELECT hnsd.ID,hnsd.TEN FROM HT_BO_DICH_VU hbdv,HT_NGUOI_SU_DUNG hnsd WHERE hnsd.ID=hbdv.ID_NGUOI_SU_DUNG AND hbdv.ID_DICH_VU =" + v_us.dcID_NHOM_DV_YEU_CAU.ToString() + "AND hbdv.CAP_SU_DUNG = 5");
m_txt_gui_kem.Focus();
}
private void m_cmd_ok_Click(object sender, EventArgs e)
{
if (m_txt_cap_nhat_xu_ly.Text == "")
{
MessageBox.Show("Vui lòng điền nội dung cập nhật!");
m_txt_cap_nhat_xu_ly.Focus();
}
else
{
US_GD_LOG_DAT_HANG v_us = new US_GD_LOG_DAT_HANG();
v_us.datNGAY_LAP_THAO_TAC = System.DateTime.Now;
v_us.dcID_GD_DAT_HANG = m_us.dcID;
v_us.dcID_LOAI_THAO_TAC = 344;
v_us.dcID_NGUOI_NHAN_THAO_TAC = us_user.dcID;
v_us.dcID_NGUOI_TAO_THAO_TAC = us_user.dcID;
v_us.strTHAO_TAC_HET_HAN_YN = "Y";
v_us.strGHI_CHU = m_txt_cap_nhat_xu_ly.Text;
v_us.Insert();
US_V_GD_DAT_HANG_GD_LOG_DAT_HANG v_us_log = new US_V_GD_DAT_HANG_GD_LOG_DAT_HANG(v_us.dcID);
if (cbSendEmail.Checked == true)
{
us_user.gui_mail_thong_bao_cap_nhat_xu_ly_don_hang(v_us_log, us_user.dcID);
}
MessageBox.Show("Cập nhật thành công!");
this.Close();
}
}
private void load_data_2_ma_don_hang(US_V_GD_DAT_HANG_GD_LOG_DAT_HANG v_us)
{
m_us = new US_V_GD_DAT_HANG_GD_LOG_DAT_HANG(v_us.dcID);
m_txt_ma_don_hang.Text = v_us.strMA_DON_HANG;
m_id_gd_dat_hang = v_us.dcID_DON_HANG;
// m_us = new US_V_GD_DAT_HANG_GD_LOG_DAT_HANG(v_us.dcID);
}
public void tu_choi_xu_ly(decimal id_log, string m_li_do)
{
decimal id_nguoi_tao;
try
{
US_V_GD_DAT_HANG_GD_LOG_DAT_HANG m_us = new US_V_GD_DAT_HANG_GD_LOG_DAT_HANG(id_log);
if (m_us.dcID_LOAI_THAO_TAC == 313)
{
US_DUNG_CHUNG v_us_dung_chung = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us_dung_chung.FillDatasetWithQuery(v_ds, "SELECT id FROM GD_LOG_DAT_HANG gldh WHERE gldh.ID_LOAI_THAO_TAC in (295,311) AND gldh.ID_GD_DAT_HANG = " + m_us.dcID_DON_HANG + "ORDER BY id DESC");
US_GD_LOG_DAT_HANG v_us_log = new US_GD_LOG_DAT_HANG(CIPConvert.ToDecimal(v_ds.Tables[0].Rows[0]["ID"].ToString()));
id_nguoi_tao = v_us_log.dcID_NGUOI_TAO_THAO_TAC;
}
else
{
id_nguoi_tao = m_us.dcID_NGUOI_TAO;
}
ghi_log_tu_choi(m_us, m_li_do);
update_log(id_log);
}
catch (Exception ex)
{
}
}
public static void gui_mail_thong_bao_cap_nhat_xu_ly_don_hang(US_V_GD_DAT_HANG_GD_LOG_DAT_HANG v_us_log, decimal v_id_nguoi_xu_ly)
{
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 = 16");
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.strMA_DON_HANG);
NOI_DUNG = NOI_DUNG.Replace("NOI_DUNG_CAP_NHAT", v_us_log.strGHI_CHU);
NOI_DUNG = NOI_DUNG.Replace("MA_DON_HANG", v_us_log.strMA_DON_HANG);
NOI_DUNG = NOI_DUNG.Replace("USER_NHAN_VIEN", v_us_log.strHO_TEN_USER_DAT_HANG);
NOI_DUNG = NOI_DUNG.Replace("USER_DON_VI", v_us_log.strMA_DON_VI);
NOI_DUNG = NOI_DUNG.Replace("USER_DIEN_THOAI", v_us_log.strDIEN_THOAI);
NOI_DUNG = NOI_DUNG.Replace("USER_THOI_GIAN_DAT_HANG", v_us_log.datTHOI_GIAN_TAO.ToString());
NOI_DUNG = NOI_DUNG.Replace("LOAI_DICH_VU_HO_TRO", v_us_log.strTEN_NHOM_DICH_VU_YEU_CAU);
NOI_DUNG = NOI_DUNG.Replace("YEU_CAU_CU_THE", v_us_log.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", "Hoàn thành đơn hàng chờ TM nghiệm thu");
NOI_DUNG = NOI_DUNG.Replace("THOI_GIAN_MONG_MUON_SUA_XONG", v_us_log.datTHOI_DIEM_CAN_HOAN_THANH + "hoặc thời gian hoàn thành là:" + v_us_log.datTHOI_GIAN_HOAN_THANH);
NOI_DUNG = NOI_DUNG.Replace("PHAN_HOI_CUA_DVMC", v_us_log.strPHAN_HOI_TU_DVMC);
IPCOREUS.US_HT_NGUOI_SU_DUNG v_us_nguoi_xu_ly = new IPCOREUS.US_HT_NGUOI_SU_DUNG(v_id_nguoi_xu_ly);
NOI_DUNG = NOI_DUNG.Replace("NGUOI_XU_LY_DON_HANG", v_us_nguoi_xu_ly.strTEN_TRUY_CAP);
NOI_DUNG = NOI_DUNG.Replace("NGUOI_NHAN_DAT_HANG", v_us_log.strNGUOI_TAO_THAO_TAC);
string to_cc = "";
US_DUNG_CHUNG v_us_tm = new US_DUNG_CHUNG();
DataSet v_ds_tm = new DataSet();
v_ds_tm.Tables.Add(new DataTable());
v_us_tm.FillDatasetWithQuery(v_ds_tm, "SELECT HT_NGUOI_SU_DUNG.ID,HT_NGUOI_SU_DUNG.EMAIL FROM HT_NGUOI_SU_DUNG_NHOM_CHI_NHANH,HT_NGUOI_SU_DUNG WHERE HT_NGUOI_SU_DUNG_NHOM_CHI_NHANH.ID_NGUOI_SU_DUNG = HT_NGUOI_SU_DUNG.ID AND HT_NGUOI_SU_DUNG_NHOM_CHI_NHANH.ID_NHOM = 4");
for (int i = 0; i < v_ds_tm.Tables[0].Rows.Count; i++)
{
if (i == 0)
{
to_cc = v_ds_tm.Tables[0].Rows[i]["EMAIL"].ToString();
}
else
{
GUI_CC += "," + v_ds_tm.Tables[0].Rows[i]["EMAIL"].ToString();
}
}
try
{
string user_email = "*****@*****.**";
string password = "******";
IPCOREUS.US_HT_NGUOI_SU_DUNG v_us_fo = new IPCOREUS.US_HT_NGUOI_SU_DUNG(v_us_log.dcID_NGUOI_TAO);
GUI_CC += "," + v_us_fo.strEMAIL;
HelpUtils.send_mail("Dịch Vụ Một Cửa<Hoàn tất xử lý>", user_email, password, to_cc, GUI_CC, TIEU_DE, NOI_DUNG);
}
catch (Exception v_e)
{
CSystemLog_100.ExceptionHandle(v_e);
}
}
private void update_log_gui_cho_pm(US_V_GD_DAT_HANG_GD_LOG_DAT_HANG m_us)
{
US_GD_LOG_DAT_HANG v_US = new US_GD_LOG_DAT_HANG(m_us.dcID);
v_US.strTHAO_TAC_HET_HAN_YN = "Y";
v_US.strGHI_CHU = "đơn hàng đã được gửi cho TD";
v_US.Update();
}
private void ghi_log_tu_choi(US_V_GD_DAT_HANG_GD_LOG_DAT_HANG v_us, string reason)
{
US_GD_LOG_DAT_HANG v_US = new US_GD_LOG_DAT_HANG();
v_US.dcID_LOAI_THAO_TAC = 310;//CHỜ FO điều phối lại
v_US.dcID_GD_DAT_HANG = v_us.dcID_DON_HANG;
v_US.dcID_NGUOI_TAO_THAO_TAC = v_us.dcID_NGUOI_NHAN_THAO_TAC;
v_US.dcID_NGUOI_NHAN_THAO_TAC = CIPConvert.ToDecimal(v_us.dcID_NGUOI_TAO);
v_US.datNGAY_LAP_THAO_TAC = System.DateTime.Now;
v_US.strTHAO_TAC_HET_HAN_YN = "N";
v_US.strGHI_CHU = v_us.strTEN_NGUOI_NHAN_THAO_TAC + " đã từ chối với lý do " + reason;
v_US.Insert();
}
private void ghi_log_PM_da_nhan_xu_ly(US_V_GD_DAT_HANG_GD_LOG_DAT_HANG m_us)
{
US_GD_LOG_DAT_HANG v_us = new US_GD_LOG_DAT_HANG();
v_us.dcID_LOAI_THAO_TAC = 304;
v_us.dcID_GD_DAT_HANG = m_us.dcID_DON_HANG;
v_us.dcID_NGUOI_TAO_THAO_TAC = us_user.dcID;//thang pm co id 15
v_us.dcID_NGUOI_NHAN_THAO_TAC = us_user.dcID;
v_us.datNGAY_LAP_THAO_TAC = System.DateTime.Now;
v_us.strTHAO_TAC_HET_HAN_YN = "N";
v_us.strGHI_CHU = us_user.strTEN_TRUY_CAP + " đã nhận xử lý";
v_us.Insert();
}
private void ghi_log_dieu_phoi_lai(decimal p, US_V_GD_DAT_HANG_GD_LOG_DAT_HANG m_us)
{
US_DUNG_CHUNG v_us_dc = new US_DUNG_CHUNG();
US_GD_LOG_DAT_HANG v_US = new US_GD_LOG_DAT_HANG();
v_US.dcID_LOAI_THAO_TAC = 311;//fo đã điều phối lại
v_US.dcID_GD_DAT_HANG = m_us.dcID_DON_HANG;
v_US.dcID_NGUOI_TAO_THAO_TAC = us_user.dcID;
v_US.dcID_NGUOI_NHAN_THAO_TAC = p;
v_US.datNGAY_LAP_THAO_TAC = System.DateTime.Now;
v_US.strTHAO_TAC_HET_HAN_YN = "N";
v_US.strGHI_CHU = us_user.strTEN_TRUY_CAP + " đơn hàng đã được điều phối lại cho " + v_us_dc.get_ten_nguoi_su_dung(p);
v_US.Insert();
}
private void insert_log_gui_cho_pm(US_V_GD_DAT_HANG_GD_LOG_DAT_HANG m_us)
{
US_DUNG_CHUNG v_us_dc = new US_DUNG_CHUNG();
US_GD_LOG_DAT_HANG v_US = new US_GD_LOG_DAT_HANG();
v_US.dcID_LOAI_THAO_TAC = 303;//đã chuyển cho PM
v_US.dcID_GD_DAT_HANG = m_us.dcID_DON_HANG;
v_US.dcID_NGUOI_TAO_THAO_TAC = us_user.dcID;
v_US.dcID_NGUOI_NHAN_THAO_TAC = CIPConvert.ToDecimal(m_cbo_PM.SelectedValue);
v_US.datNGAY_LAP_THAO_TAC = System.DateTime.Now;
v_US.strTHAO_TAC_HET_HAN_YN = "N";
v_US.strGHI_CHU = us_user.strTEN_TRUY_CAP + " gửi đơn hàng cho PM " + v_us_dc.get_ten_nguoi_su_dung(CIPConvert.ToDecimal(m_cbo_PM.SelectedValue)) + ", gửi kèm: " + m_txt_gui_kem.Text;
v_US.Insert();
}
private void m_cmd_bo_chuyen_pm_Click(object sender, EventArgs e)
{
try
{
DataRow v_dr = m_grv_gd_dat_hang_gd_log_dat_hang.GetDataRow(m_grv_gd_dat_hang_gd_log_dat_hang.FocusedRowHandle);
US_V_GD_DAT_HANG_GD_LOG_DAT_HANG v_us = new US_V_GD_DAT_HANG_GD_LOG_DAT_HANG(CIPConvert.ToDecimal(v_dr["ID"].ToString()));
f112_FO_chuyen_don_hang_cho_PM v_f = new f112_FO_chuyen_don_hang_cho_PM();
v_f.displayForUpdate(v_us);
load_data_2_grid();
}
catch (Exception v_e)
{
CSystemLog_100.ExceptionHandle(v_e);
}
}
private void m_cmd_PM_dieu_phoi_Click(object sender, EventArgs e)
{
try
{
DataRow v_dr = m_grv_gd_dat_hang_gd_log_dat_hang.GetDataRow(m_grv_gd_dat_hang_gd_log_dat_hang.FocusedRowHandle);
US_V_GD_DAT_HANG_GD_LOG_DAT_HANG v_us = new US_V_GD_DAT_HANG_GD_LOG_DAT_HANG(CIPConvert.ToDecimal(v_dr["ID"].ToString()));
f114_ds_BO v_f114 = new f114_ds_BO();
v_f114.display_dieu_huong(v_us);
load_data_2_grid();
}
catch (Exception v_e)
{
CSystemLog_100.ExceptionHandle(v_e);
}
}
private void insert_log_gui_cho_pm(US_V_GD_DAT_HANG_GD_LOG_DAT_HANG m_us)
{
US_DUNG_CHUNG l_us = new US_DUNG_CHUNG();
DataSet l_ds = new DataSet();
l_ds.Tables.Add(new DataTable());
l_us.FillDatasetWithQuery(l_ds, "select ID_PM from HT_BO_PM_TD where id_PM =" + us_user.dcID);
US_GD_LOG_DAT_HANG v_US = new US_GD_LOG_DAT_HANG();
v_US.dcID_LOAI_THAO_TAC = 305; //đã chuyển cho TD
v_US.dcID_GD_DAT_HANG = m_us.dcID_DON_HANG;
v_US.dcID_NGUOI_TAO_THAO_TAC = us_user.dcID; //Quản lý có id 15
v_US.dcID_NGUOI_NHAN_THAO_TAC = CIPConvert.ToDecimal(m_cbo_ds_TD.SelectedValue.ToString());
v_US.datNGAY_LAP_THAO_TAC = System.DateTime.Now;
v_US.strTHAO_TAC_HET_HAN_YN = "N";
v_US.strGHI_CHU = "đơn hàng đã được gửi cho TD \n" + m_txt_gui_kem.Text;
v_US.Insert();
}
public static void gui_mail_thong_bao_chuyen_don_hang(US_V_GD_DAT_HANG_GD_LOG_DAT_HANG v_us_log_gd, decimal v_id_nguoi_xu_ly, decimal v_id_nguoi_nhan)
{
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();
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_NHOM_DICH_VU_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", v_us_log_gd.strPHAN_HOI_TU_DVMC);
IPCOREUS.US_HT_NGUOI_SU_DUNG v_us_nguoi_xu_ly = new IPCOREUS.US_HT_NGUOI_SU_DUNG(v_id_nguoi_xu_ly);
NOI_DUNG = NOI_DUNG.Replace("NGUOI_XU_LY_DON_HANG", v_us_nguoi_xu_ly.strTEN_TRUY_CAP);
NOI_DUNG = NOI_DUNG.Replace("NGUOI_NHAN_DAT_HANG", v_us_log_gd.strNGUOI_TAO_THAO_TAC);
IPCOREUS.US_HT_NGUOI_SU_DUNG v_us_nguoi_nhan = new IPCOREUS.US_HT_NGUOI_SU_DUNG(v_id_nguoi_nhan);
string to_cc = v_us_nguoi_nhan.strEMAIL;
try
{
string user_email = "*****@*****.**";
string password = "******";
IPCOREUS.US_HT_NGUOI_SU_DUNG v_us_fo = new IPCOREUS.US_HT_NGUOI_SU_DUNG(v_us_log_gd.dcID_NGUOI_TAO);
GUI_CC += "," + v_us_fo.strEMAIL;
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);
}
}
private void update_don_hang(US_V_GD_DAT_HANG_GD_LOG_DAT_HANG m_us)
{
US_GD_LOG_DAT_HANG v_US = new US_GD_LOG_DAT_HANG(m_us.dcID);
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
if (us_user.dcIDNhom == 1)
{
v_us.FillDatasetWithQuery(v_ds, "SELECT *FROM GD_LOG_DAT_HANG WHERE ID_GD_DAT_HANG =" + v_US.dcID_GD_DAT_HANG.ToString() + "AND ID_LOAI_THAO_TAC in(310,313) AND THAO_TAC_HET_HAN_YN = 'N' AND ID_NGUOI_NHAN_THAO_TAC=" + us_user.dcID.ToString());
}
else if (us_user.dcIDNhom == 3)
{
v_us.FillDatasetWithQuery(v_ds, "SELECT *FROM GD_LOG_DAT_HANG WHERE ID_GD_DAT_HANG =" + v_US.dcID_GD_DAT_HANG.ToString() + "And ID_LOAI_THAO_TAC in (303) And THAO_TAC_HET_HAN_YN = 'N' AND ID_NGUOI_NHAN_THAO_TAC = " + us_user.dcID.ToString());
}
for (int i = 0; i < v_ds.Tables[0].Rows.Count; i++)
{
v_US = new US_GD_LOG_DAT_HANG(CIPConvert.ToDecimal(v_ds.Tables[0].Rows[i][0].ToString()));
v_US.strTHAO_TAC_HET_HAN_YN = "Y";
v_US.Update();
}
}
internal void displayForUpdate(US_V_GD_DAT_HANG_GD_LOG_DAT_HANG v_us)
{
load_data_to_form(v_us);
this.ShowDialog();
}
internal void displayForRefuse(US_V_GD_DAT_HANG_GD_LOG_DAT_HANG m_us, decimal id_nguoi_tao)
{
us_to_form(m_us, id_nguoi_tao);
this.ShowDialog();
}
internal void display_dieu_huong(US_V_GD_DAT_HANG_GD_LOG_DAT_HANG v_us)
{
load_data_2_ma_don_hang(v_us);
load_data_2_grid();
this.ShowDialog();
}
private void fill_data_to_m_us()
{
DataRow v_dr = m_grv_gd_dat_hang_gd_log_dat_hang.GetDataRow(m_grv_gd_dat_hang_gd_log_dat_hang.FocusedRowHandle);
m_us = new US_V_GD_DAT_HANG_GD_LOG_DAT_HANG(CIPConvert.ToDecimal(v_dr["ID"].ToString()));
}
