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) { } }
private void update_log_tiep_nhan(decimal id_don_hang, decimal user_id, decimal id_nhom) { US_GD_LOG_DAT_HANG v_US = new US_GD_LOG_DAT_HANG(); US_DUNG_CHUNG v_us = new US_DUNG_CHUNG(); DataSet v_ds = new DataSet(); v_ds.Tables.Add(new DataTable()); if (id_nhom == 2) { v_us.FillDatasetWithQuery(v_ds, "SELECT *FROM GD_LOG_DAT_HANG WHERE ID_GD_DAT_HANG =" + id_don_hang + "And ID_LOAI_THAO_TAC in (295,311) And THAO_TAC_HET_HAN_YN = 'N' AND ID_NGUOI_NHAN_THAO_TAC = " + user_id); } else if (id_nhom == 3) { v_us.FillDatasetWithQuery(v_ds, "SELECT *FROM GD_LOG_DAT_HANG WHERE ID_GD_DAT_HANG =" + id_don_hang + "And ID_LOAI_THAO_TAC in (303) And THAO_TAC_HET_HAN_YN = 'N' AND ID_NGUOI_NHAN_THAO_TAC = " + user_id); } else if (id_nhom == 5) { v_us.FillDatasetWithQuery(v_ds, "SELECT *FROM GD_LOG_DAT_HANG WHERE ID_GD_DAT_HANG =" + id_don_hang + "And ID_LOAI_THAO_TAC in (305) And THAO_TAC_HET_HAN_YN = 'N' AND ID_NGUOI_NHAN_THAO_TAC = " + user_id); } 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(); } }
public void load_data_2_grid_dp_lai(decimal id_user) { string query = "select * from V_GD_DAT_HANG_GD_LOG_DAT_HANG where THAO_TAC_HET_HAN_YN = 'N'"; query += "And ID_LOAI_THAO_TAC in (295,311) And ID_NGUOI_NHAN_THAO_TAC = " + id_user; 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, query); JavaScriptSerializer js = new JavaScriptSerializer(); Context.Response.Clear(); Context.Response.ContentType = "application/json"; List <Dictionary <string, object> > rows = new List <Dictionary <string, object> >(); Dictionary <string, object> row; foreach (DataRow dr in v_ds.Tables[0].Rows) { row = new Dictionary <string, object>(); foreach (DataColumn col in v_ds.Tables[0].Columns) { row.Add(col.ColumnName, dr[col]); } rows.Add(row); } Context.Response.Write(js.Serialize(rows)); }
public void load_data_2_grid_dp_lai(decimal id_user) { string query = "select * from V_GD_DAT_HANG_GD_LOG_DAT_HANG where THAO_TAC_HET_HAN_YN = 'N'"; query += "And ID_LOAI_THAO_TAC in (295,311) And ID_NGUOI_NHAN_THAO_TAC = " + id_user; 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, query); JavaScriptSerializer js = new JavaScriptSerializer(); Context.Response.Clear(); Context.Response.ContentType = "application/json"; List<Dictionary<string, object>> rows = new List<Dictionary<string, object>>(); Dictionary<string, object> row; foreach (DataRow dr in v_ds.Tables[0].Rows) { row = new Dictionary<string, object>(); foreach (DataColumn col in v_ds.Tables[0].Columns) { row.Add(col.ColumnName, dr[col]); } rows.Add(row); } Context.Response.Write(js.Serialize(rows)); }
private void insert_log_gui_cho_pm(decimal id_don_hang, decimal id_pm, string str_gui_kem) { 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 = id_don_hang; v_US.dcID_NGUOI_TAO_THAO_TAC = us_user.dcID; v_US.dcID_NGUOI_NHAN_THAO_TAC = id_pm; 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(id_pm) + ", gửi kèm: " + str_gui_kem; v_US.Insert(); }
private void update_log_gui_cho_pm(decimal id, decimal user_id) { US_GD_LOG_DAT_HANG v_US = new US_GD_LOG_DAT_HANG(id); if (us_user.dcIDNhom == 1) { 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 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'"); 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(); } } else if (us_user.dcIDNhom == 2) { v_US.strTHAO_TAC_HET_HAN_YN = "Y"; v_US.Update(); } }