private void update_thoi_gian_hoan_thanh_don_hang()
{
US_GD_DAT_HANG v_us = new US_GD_DAT_HANG(m_us.dcID_DON_HANG);
v_us.datTHOI_GIAN_HOAN_THANH = System.DateTime.Now;
v_us.Update();
}
private void update_thoi_gian_hoan_thanh(US_GD_DAT_HANG M_us)
{
US_GD_DAT_HANG v_us = new US_GD_DAT_HANG(M_us.dcID);
v_us.datTHOI_GIAN_HOAN_THANH = System.DateTime.Now;
v_us.Update();
}
private void update_danh_gia()
{
if (m_radio_chua_dat.Checked)
{
m_us.dcID_DANH_GIA_TU_USER_DAT_HANG = 127;
}
else if (m_radio_hoi_duoi.Checked)
{
m_us.dcID_DANH_GIA_TU_USER_DAT_HANG = 126;
}
else if (m_radio_xong_viec.Checked)
{
m_us.dcID_DANH_GIA_TU_USER_DAT_HANG = 125;
}
else if (m_radio_hai_long.Checked)
{
m_us.dcID_DANH_GIA_TU_USER_DAT_HANG = 124;
}
else if (m_radio_rat_hai_long.Checked)
{
m_us.dcID_DANH_GIA_TU_USER_DAT_HANG = 123;
}
m_us.Update();
MessageBox.Show("Cám ơn bạn đã đánh giá!");
}
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 tu_dong_danh_gia()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
string v_str_query = "SELECT * FROM GD_DAT_HANG WHERE THOI_GIAN_HOAN_THANH is not null AND ID_DANH_GIA_TU_USER_DAT_HANG IS NULL";
v_us.FillDatasetWithQuery(v_ds, v_str_query);
for (int i = 0; i < v_ds.Tables[0].Rows.Count; i++)
{
US_GD_DAT_HANG v_us_gd_dat_hang = new US_GD_DAT_HANG(CIPConvert.ToDecimal(v_ds.Tables[0].Rows[i]["ID"].ToString()));
DateTime v_thoi_gian_hoan_thanh = v_us_gd_dat_hang.datTHOI_GIAN_HOAN_THANH.AddDays(3);
if (System.DateTime.Compare(v_thoi_gian_hoan_thanh, System.DateTime.Now) == -1)
{
v_us_gd_dat_hang.dcID_DANH_GIA_TU_USER_DAT_HANG = 124;
v_us_gd_dat_hang.Update();
}
}
}