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