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())); }