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();
}
}
private void update_log(decimal id_log)
{
US_GD_LOG_DAT_HANG v_us_tu_choi = new US_GD_LOG_DAT_HANG(id_log);
v_us_tu_choi.strTHAO_TAC_HET_HAN_YN = "Y";
//v_us_tu_choi.strGHI_CHU = "BO đã từ chối";
v_us_tu_choi.Update();
}
private void update_hoan_thanh_don_hang_PM()
{
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 = "PM đã hoàn thành,chờ TM nghiệm thu";
v_us.Update();
}
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 update_log_tu_choi()
{
US_GD_LOG_DAT_HANG v_us_tu_choi = new US_GD_LOG_DAT_HANG(v_us.dcID);
v_us_tu_choi.strTHAO_TAC_HET_HAN_YN = "Y";
//v_us_tu_choi.strGHI_CHU = "BO đã từ chối";
v_us_tu_choi.Update();
}
private void update_hoan_thanh_don_hang_TD()
{
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 = "TD đã xử lý xong";
v_us.Update();
}
private void update_hoan_thanh_don_hang_BO()
{
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 = "BO đã xử lý xong đơn hàng và chờ TM nghiệm thu!";
v_us.Update();
}
private void update_log_da_xu_ly()
{
US_GD_LOG_DAT_HANG v_us = new US_GD_LOG_DAT_HANG();
v_us = m_us;
v_us.strTHAO_TAC_HET_HAN_YN = "Y";
v_us.strGHI_CHU = "đã được PM phê duyệt";
v_us.Update();
}
private void update_log_dieu_phoi()
{
US_DUNG_CHUNG v_us_dc = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us_dc.FillDatasetWithQuery(v_ds, "SELECT * FROM V_GD_DAT_HANG_GD_LOG_DAT_HANG WHERE [ID_DON_HANG] = " + v_us.dcID.ToString());
for (int i = 0; i < v_ds.Tables[0].Rows.Count; i++)
{
US_GD_LOG_DAT_HANG V_us = new US_GD_LOG_DAT_HANG(CIPConvert.ToDecimal(v_ds.Tables[0].Rows[i]["ID"].ToString()));
V_us.strTHAO_TAC_HET_HAN_YN = "Y";
V_us.Update();
}
}
private void update_trang_thai_don_hang(US_GD_DAT_HANG v_us)
{
US_DUNG_CHUNG v_us_dc = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us_dc.FillDatasetWithQuery(v_ds, "SELECT * FROM V_GD_DAT_HANG_GD_LOG_DAT_HANG WHERE THAO_TAC_HET_HAN_YN = 'N' AND [ID_DON_HANG] = " + v_us.dcID.ToString());
for (int i = 0; i < v_ds.Tables[0].Rows.Count; i++)
{
US_GD_LOG_DAT_HANG V_us = new US_GD_LOG_DAT_HANG(CIPConvert.ToDecimal(v_ds.Tables[0].Rows[i]["ID"].ToString()));
V_us.strTHAO_TAC_HET_HAN_YN = "Y";
V_us.Update();
}
//cập nhật thời gian hoàn thành cho đơn hàng
US_GD_DAT_HANG v_us1 = new US_GD_DAT_HANG(v_us.dcID);
v_us1.datTHOI_GIAN_HOAN_THANH = System.DateTime.Now;
v_us1.Update();
}
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();
}
}
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();
}
}
private void update_log()
{
m_us_log.strTHAO_TAC_HET_HAN_YN = "Y";
m_us_log.Update();
}
