public void load_dot_thanh_toan_by_trang_thai(decimal ip_dc_trang_thai_dot, DS_V_DM_DOT_THANH_TOAN op_ds_dm_dot_thanh_toan)
{
CStoredProc v_cstore = new CStoredProc("pr_V_GD_THANH_TOAN_Load_Dot_Thanh_Toan_by_Trang_thai");
v_cstore.addDecimalInputParam("@ID_TRANG_THAI_DOT_THANH_TOAN", ip_dc_trang_thai_dot);
v_cstore.fillDataSetByCommand(this, op_ds_dm_dot_thanh_toan);
}
private void load_data_2_cbo_dot_thanh_toan(decimal ip_dc_thang_tt, decimal ip_dc_nam_tt, decimal ip_dc_id_don_vi_tt)
{
DS_V_DM_DOT_THANH_TOAN v_ds_dot_thanh_toan = new DS_V_DM_DOT_THANH_TOAN();
US_V_DM_DOT_THANH_TOAN v_us_dot_thanh_toan = new US_V_DM_DOT_THANH_TOAN();
// Load đợt thanh toán dựa vào tháng và năm thanh toán
v_us_dot_thanh_toan.load_data_2_dot_tt_by_thang_nam(ip_dc_thang_tt, ip_dc_nam_tt, ip_dc_id_don_vi_tt, v_ds_dot_thanh_toan);
DataRow v_dr = v_ds_dot_thanh_toan.V_DM_DOT_THANH_TOAN.NewV_DM_DOT_THANH_TOANRow();
v_dr[V_DM_DOT_THANH_TOAN.ID] = 0;
v_dr[V_DM_DOT_THANH_TOAN.MA_DOT_TT] = "All";
v_dr[V_DM_DOT_THANH_TOAN.TEN_DOT_TT] = "Tất cả";
v_dr[V_DM_DOT_THANH_TOAN.NGAY_TT_DU_KIEN] = CIPConvert.ToDatetime("01/01/2010");
v_dr[V_DM_DOT_THANH_TOAN.ID_DON_VI_THANH_TOAN] = 0;
v_dr[V_DM_DOT_THANH_TOAN.TRANG_THAI_DOT_TT] = 0;
v_dr[V_DM_DOT_THANH_TOAN.ID_TRANG_THAI_DOT_TT] = 0;
v_dr[V_DM_DOT_THANH_TOAN.DON_VI_THANH_TOAN] = "All";
v_ds_dot_thanh_toan.V_DM_DOT_THANH_TOAN.Rows.InsertAt(v_dr, 0);
m_cbo_dot_thanh_toan.DataTextField = V_DM_DOT_THANH_TOAN.TEN_DOT_TT;
m_cbo_dot_thanh_toan.DataValueField = V_DM_DOT_THANH_TOAN.ID;
m_cbo_dot_thanh_toan.DataSource = v_ds_dot_thanh_toan.V_DM_DOT_THANH_TOAN;
m_cbo_dot_thanh_toan.DataBind();
//ListItem v_items = new ListItem(get_id_kho());
//m_cbo_dot_thanh_toan.Items.Remove(v_items);
}
public string get_ma_dot_tt_form_id(decimal ip_dc_id_dot)
{
US_V_DM_DOT_THANH_TOAN v_us_v_dm_dot_tt = new US_V_DM_DOT_THANH_TOAN();
DS_V_DM_DOT_THANH_TOAN v_ds_v_dm_dot_tt = new DS_V_DM_DOT_THANH_TOAN();
v_us_v_dm_dot_tt.FillDataset(v_ds_v_dm_dot_tt, " WHERE ID=" + ip_dc_id_dot);
return(v_ds_v_dm_dot_tt.V_DM_DOT_THANH_TOAN.Rows[0][V_DM_DOT_THANH_TOAN.MA_DOT_TT].ToString());
}
public void search_dot_tt_by_ma(string ip_str_ma_dot_tt
, DS_V_DM_DOT_THANH_TOAN op_ds_v_dm_dot_thanh_toan)
{
CStoredProc v_cstore = new CStoredProc("pr_V_DM_DOT_THANH_TOAN_Search");
v_cstore.addNVarcharInputParam("@MA_DOT_TT", ip_str_ma_dot_tt);
v_cstore.fillDataSetByCommand(this, op_ds_v_dm_dot_thanh_toan);
}
private string get_id_kho()
{
US_V_DM_DOT_THANH_TOAN v_us_dm_dot_tt = new US_V_DM_DOT_THANH_TOAN();
DS_V_DM_DOT_THANH_TOAN v_ds_dm_dot_tt = new DS_V_DM_DOT_THANH_TOAN();
v_us_dm_dot_tt.FillDataset(v_ds_dm_dot_tt, " WHERE MA_DOT_TT LIKE N'KHO'");
//if(v_ds)
return(CIPConvert.ToStr(v_ds_dm_dot_tt.V_DM_DOT_THANH_TOAN.Rows[0][V_DM_DOT_THANH_TOAN.ID]));
}
public bool check_exist_ma_dot_thanh_toan(string ip_str_ma_dot_tt)
{
DS_V_DM_DOT_THANH_TOAN v_ds_dot_thanh_toan = new DS_V_DM_DOT_THANH_TOAN();
this.FillDataset(v_ds_dot_thanh_toan, " WHERE MA_DOT_TT= '" + ip_str_ma_dot_tt + "'");
if (v_ds_dot_thanh_toan.V_DM_DOT_THANH_TOAN.Rows.Count > 0)
{
return(true);
}
return(false);
}
private void load_data_2_cbo_dot_thanh_toan()
{
DS_V_DM_DOT_THANH_TOAN v_ds_dot_thanh_toan = new DS_V_DM_DOT_THANH_TOAN();
US_V_DM_DOT_THANH_TOAN v_us_dot_thanh_toan = new US_V_DM_DOT_THANH_TOAN();
v_us_dot_thanh_toan.FillDataset(v_ds_dot_thanh_toan, " WHERE ID_TRANG_THAI_DOT_TT=" + get_id_trang_thai_da_thanh_toan());
m_cbo_dot_thanh_toan.DataTextField = V_DM_DOT_THANH_TOAN.TEN_DOT_TT;
m_cbo_dot_thanh_toan.DataValueField = V_DM_DOT_THANH_TOAN.ID;
m_cbo_dot_thanh_toan.DataSource = v_ds_dot_thanh_toan.V_DM_DOT_THANH_TOAN;
m_cbo_dot_thanh_toan.DataBind();
}
private string get_ma_dot_tt_kho()
{
US_V_DM_DOT_THANH_TOAN v_us_v_dm_dot_tt = new US_V_DM_DOT_THANH_TOAN();
DS_V_DM_DOT_THANH_TOAN v_ds_v_dm_dot_tt = new DS_V_DM_DOT_THANH_TOAN();
v_us_v_dm_dot_tt.FillDataset(v_ds_v_dm_dot_tt, " WHERE MA_DOT_TT LIKE '%KHO%'");
if (v_ds_v_dm_dot_tt.V_DM_DOT_THANH_TOAN.Rows.Count == 0)
{
return("KHO");
}
return(CIPConvert.ToStr(v_ds_v_dm_dot_tt.V_DM_DOT_THANH_TOAN.Rows[0][V_DM_DOT_THANH_TOAN.MA_DOT_TT]));
}
private decimal get_id_of_dot_tt_kho()
{
US_V_DM_DOT_THANH_TOAN v_us_v_dm_dot_tt = new US_V_DM_DOT_THANH_TOAN();
DS_V_DM_DOT_THANH_TOAN v_ds_v_dm_dot_tt = new DS_V_DM_DOT_THANH_TOAN();
v_us_v_dm_dot_tt.FillDataset(v_ds_v_dm_dot_tt, " WHERE MA_DOT_TT LIKE '%KHO%'");
if (v_ds_v_dm_dot_tt.V_DM_DOT_THANH_TOAN.Rows.Count == 0)
{
return(25);
}
return(CIPConvert.ToDecimal(v_ds_v_dm_dot_tt.V_DM_DOT_THANH_TOAN.Rows[0][V_DM_DOT_THANH_TOAN.ID]));
}
// Chỉ load lên những đợt thanh toán đang ở trạng thái 1 - đã lập đợt
private void load_data_2_dot_tt()
{
DS_V_DM_DOT_THANH_TOAN v_ds_dot_thanh_toan = new DS_V_DM_DOT_THANH_TOAN();
US_V_DM_DOT_THANH_TOAN v_us_dot_thanh_toan = new US_V_DM_DOT_THANH_TOAN();
v_us_dot_thanh_toan.load_dot_thanh_toan_by_trang_thai(ID_TRANG_THAI_DOT_TT.DA_LAP_BANG_KE_XONG, v_ds_dot_thanh_toan);
//v_us_dot_thanh_toan.FillDataset(v_ds_dot_thanh_toan, " WHERE ID_TRANG_THAI_DOT_TT = " + get_id_trang_thai_dot_tt_da_lap_bang_ke());
m_cbo_dot_thanh_toan.DataTextField = V_DM_DOT_THANH_TOAN.TEN_DOT_TT;
m_cbo_dot_thanh_toan.DataValueField = V_DM_DOT_THANH_TOAN.ID;
m_cbo_dot_thanh_toan.DataSource = v_ds_dot_thanh_toan.V_DM_DOT_THANH_TOAN;
m_cbo_dot_thanh_toan.DataBind();
}
private decimal get_id_dot_tt_by_ma_dot(string ip_str_ma_dot)
{
DS_V_DM_DOT_THANH_TOAN v_ds_dot_tt = new DS_V_DM_DOT_THANH_TOAN();
US_V_DM_DOT_THANH_TOAN v_us_dot_thanh_toan = new US_V_DM_DOT_THANH_TOAN();
v_us_dot_thanh_toan.FillDataset(v_ds_dot_tt, " WHERE MA_DOT_TT = '" + ip_str_ma_dot + "'");
if (v_ds_dot_tt.V_DM_DOT_THANH_TOAN.Rows.Count == 0)
{
return(0);
}
return(CIPConvert.ToDecimal(v_ds_dot_tt.V_DM_DOT_THANH_TOAN.Rows[0][V_DM_DOT_THANH_TOAN.ID]));
}
public void load_danh_muc_dot_tt(decimal ip_dc_thang_tt
, decimal ip_dc_id_don_vi_tt
, decimal ip_dc_id_trang_thai_dot_tt
, DS_V_DM_DOT_THANH_TOAN op_ds_v_dm_dot_thanh_toan)
{
CStoredProc v_cstore = new CStoredProc("pr_V_DM_DOT_THANH_TOAN_Search_Danh_Muc");
v_cstore.addDecimalInputParam("@ID_DON_VI_TT", ip_dc_id_don_vi_tt);
v_cstore.addDecimalInputParam("@ID_TRANG_THAI_DOT_TT", ip_dc_id_trang_thai_dot_tt);
v_cstore.addDecimalInputParam("@THANG_TT", ip_dc_thang_tt);
v_cstore.fillDataSetByCommand(this, op_ds_v_dm_dot_thanh_toan);
}
public string get_ma_dot_tt_by_id_dot(decimal ip_dc_ma_dot)
{
DS_V_DM_DOT_THANH_TOAN v_ds_dot_tt = new DS_V_DM_DOT_THANH_TOAN();
US_V_DM_DOT_THANH_TOAN v_us_dot_thanh_toan = new US_V_DM_DOT_THANH_TOAN();
v_us_dot_thanh_toan.FillDataset(v_ds_dot_tt, " WHERE ID = " + ip_dc_ma_dot);
if (v_ds_dot_tt.V_DM_DOT_THANH_TOAN.Rows.Count == 0)
{
return("");
}
return(CIPConvert.ToStr(v_ds_dot_tt.V_DM_DOT_THANH_TOAN.Rows[0][V_DM_DOT_THANH_TOAN.MA_DOT_TT]));
}
public US_V_DM_DOT_THANH_TOAN(decimal i_dbID)
{
pm_objDS = new DS_V_DM_DOT_THANH_TOAN();
pm_strTableName = c_TableName;
IMakeSelectCmd v_objMkCmd = new CMakeAndSelectCmd(pm_objDS, c_TableName);
v_objMkCmd.AddCondition("ID", i_dbID, eKieuDuLieu.KieuNumber, eKieuSoSanh.Bang);
SqlCommand v_cmdSQL;
v_cmdSQL = v_objMkCmd.getSelectCmd();
this.FillDatasetByCommand(pm_objDS, v_cmdSQL);
pm_objDR = getRowClone(pm_objDS.Tables[pm_strTableName].Rows[0]);
}
private void load_data_2_cbo_dot_thanh_toan(decimal ip_dc_giang_vien, decimal ip_dc_thang_tt, decimal ip_dc_nam_tt, decimal ip_dc_id_don_vi_tt)
{
DS_V_DM_DOT_THANH_TOAN v_ds_dot_thanh_toan = new DS_V_DM_DOT_THANH_TOAN();
US_V_DM_DOT_THANH_TOAN v_us_dot_thanh_toan = new US_V_DM_DOT_THANH_TOAN();
// Load đợt thanh toán dựa vào tháng và năm thanh toán
v_us_dot_thanh_toan.load_data_2_dot_tt_by_thang_nam_and_giang_vien(ip_dc_giang_vien, ip_dc_thang_tt, ip_dc_nam_tt, ip_dc_id_don_vi_tt, v_ds_dot_thanh_toan);
DataRow v_dr = v_ds_dot_thanh_toan.V_DM_DOT_THANH_TOAN.NewV_DM_DOT_THANH_TOANRow();
m_cbo_dot_thanh_toan.DataTextField = V_DM_DOT_THANH_TOAN.TEN_DOT_TT;
m_cbo_dot_thanh_toan.DataValueField = V_DM_DOT_THANH_TOAN.MA_DOT_TT;
m_cbo_dot_thanh_toan.DataSource = v_ds_dot_thanh_toan.V_DM_DOT_THANH_TOAN;
m_cbo_dot_thanh_toan.DataBind();
}
private void load_data_2_cbo_dot_thanh_toan()
{
DS_V_DM_DOT_THANH_TOAN v_ds_dot_thanh_toan = new DS_V_DM_DOT_THANH_TOAN();
US_V_DM_DOT_THANH_TOAN v_us_dot_thanh_toan = new US_V_DM_DOT_THANH_TOAN();
// Vì đợt thanh toán kho có trạng thái là đã lập đợt
v_us_dot_thanh_toan.load_dot_thanh_toan_by_trang_thai_tru_kho(ID_TRANG_THAI_DOT_TT.DA_LAP_DOT, v_ds_dot_thanh_toan);
m_cbo_dot_thanh_toan.DataTextField = V_DM_DOT_THANH_TOAN.TEN_DOT_TT;
m_cbo_dot_thanh_toan.DataValueField = V_DM_DOT_THANH_TOAN.ID;
m_cbo_dot_thanh_toan.DataSource = v_ds_dot_thanh_toan.V_DM_DOT_THANH_TOAN;
m_cbo_dot_thanh_toan.DataBind();
}
// Chỉ load lên những đợt thanh toán chưa kết thúc
private void load_data_2_cbo_dot_thanh_toan()
{
DS_V_DM_DOT_THANH_TOAN v_ds_dot_thanh_toan = new DS_V_DM_DOT_THANH_TOAN();
US_V_DM_DOT_THANH_TOAN v_us_dot_thanh_toan = new US_V_DM_DOT_THANH_TOAN();
v_us_dot_thanh_toan.load_dot_thanh_toan_by_trang_thai(ID_TRANG_THAI_DOT_TT.DA_LAP_DOT, v_ds_dot_thanh_toan);
//v_us_dot_thanh_toan.FillDataset(v_ds_dot_thanh_toan, " WHERE ID_TRANG_THAI_DOT_TT = " + get_id_trang_thai_dot_tt_da_lap_dot()+" ORDER BY ID DESC");
for (int i = 0; i < v_ds_dot_thanh_toan.V_DM_DOT_THANH_TOAN.Rows.Count; i++)
{
if (CIPConvert.ToDecimal(v_ds_dot_thanh_toan.V_DM_DOT_THANH_TOAN.Rows[i][V_DM_DOT_THANH_TOAN.ID]) != get_id_of_dot_tt_kho())
{
m_cbo_dot_thanh_toan.Items.Add(new ListItem(CIPConvert.ToStr(v_ds_dot_thanh_toan.V_DM_DOT_THANH_TOAN.Rows[i][V_DM_DOT_THANH_TOAN.TEN_DOT_TT]), CIPConvert.ToStr(v_ds_dot_thanh_toan.V_DM_DOT_THANH_TOAN.Rows[i][V_DM_DOT_THANH_TOAN.ID])));
}
}
}
// Chỉ load đợt thanh toán đã lập đợt và không load các thanh toán của KHO lên
private void load_data_2_cbo_dot_thanh_toan()
{
DS_V_DM_DOT_THANH_TOAN v_ds_dot_thanh_toan = new DS_V_DM_DOT_THANH_TOAN();
US_V_DM_DOT_THANH_TOAN v_us_dot_thanh_toan = new US_V_DM_DOT_THANH_TOAN();
// Vì đợt thanh toán kho có trạng thái là đã lập đợt
v_us_dot_thanh_toan.load_dot_thanh_toan_by_trang_thai(ID_TRANG_THAI_DOT_TT.DA_LAP_DOT, v_ds_dot_thanh_toan);
//v_us_dot_thanh_toan.FillDataset(v_ds_dot_thanh_toan, " WHERE ID_TRANG_THAI_DOT_TT = " + get_id_trang_thai_dot_tt_da_lap_dot());
// Chỉ load đợt thanh toán kho lên
for (int i = 0; i < v_ds_dot_thanh_toan.V_DM_DOT_THANH_TOAN.Rows.Count; i++)
{
if (CIPConvert.ToDecimal(v_ds_dot_thanh_toan.V_DM_DOT_THANH_TOAN.Rows[i][V_DM_DOT_THANH_TOAN.ID]) != CIPConvert.ToDecimal(lblUser.ToolTip))
{
m_cbo_dot_thanh_toan.Items.Add(new ListItem(CIPConvert.ToStr(v_ds_dot_thanh_toan.V_DM_DOT_THANH_TOAN.Rows[i][V_DM_DOT_THANH_TOAN.TEN_DOT_TT]), CIPConvert.ToStr(v_ds_dot_thanh_toan.V_DM_DOT_THANH_TOAN.Rows[i][V_DM_DOT_THANH_TOAN.ID])));
}
}
}
private void load_data_2_cbo_dot_thanh_toan(decimal ip_dc_thang_tt, decimal ip_dc_nam_tt)
{
DS_V_DM_DOT_THANH_TOAN v_ds_dot_thanh_toan = new DS_V_DM_DOT_THANH_TOAN();
US_V_DM_DOT_THANH_TOAN v_us_dot_thanh_toan = new US_V_DM_DOT_THANH_TOAN();
// Load đợt thanh toán dựa vào tháng và năm thanh toán
v_us_dot_thanh_toan.load_data_2_dot_tt_by_thang_nam(ip_dc_thang_tt, ip_dc_nam_tt, 0, v_ds_dot_thanh_toan);
m_cbo_dot_thanh_toan.DataTextField = V_DM_DOT_THANH_TOAN.TEN_DOT_TT;
m_cbo_dot_thanh_toan.DataValueField = V_DM_DOT_THANH_TOAN.ID;
m_cbo_dot_thanh_toan.DataSource = v_ds_dot_thanh_toan.V_DM_DOT_THANH_TOAN;
m_cbo_dot_thanh_toan.DataBind();
if (m_cbo_dot_thanh_toan.Items.Count == 0)
{
m_cmd_tim_kiem.Enabled = false;
m_lbl_thong_bao.Text = "Không có đợt thanh toán nào phù hợp";
m_grv_danh_sach_du_toan.DataSource = null;
m_grv_danh_sach_du_toan.DataBind();
}
else
{
m_cmd_tim_kiem.Enabled = true;
fill_data_2_thong_tin_dot_tt(CIPConvert.ToDecimal(m_cbo_dot_thanh_toan.SelectedValue));
}
}
public void load_data_2_dot_tt_by_thang_nam_and_giang_vien(decimal ip_dc_giang_vien, decimal ip_dc_thang_tt, decimal ip_dc_nam_tt, decimal ip_dc_id_dv_tt, DS_V_DM_DOT_THANH_TOAN ip_ds_dm_dot_tt)
{
CStoredProc v_cstore = new CStoredProc("pr_V_DM_DOT_THANH_TOAN_LoadTheoThoiGian_va_giangvien");
v_cstore.addDecimalInputParam("@GIANG_VIEN", ip_dc_giang_vien);
v_cstore.addDecimalInputParam("@NAM_TT", ip_dc_nam_tt);
v_cstore.addDecimalInputParam("@THANG_TT", ip_dc_thang_tt);
v_cstore.addDecimalInputParam("@ID_DON_VI_TT", ip_dc_id_dv_tt);
v_cstore.fillDataSetByCommand(this, ip_ds_dm_dot_tt);
}
public US_V_DM_DOT_THANH_TOAN()
{
pm_objDS = new DS_V_DM_DOT_THANH_TOAN();
pm_strTableName = c_TableName;
pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow();
}
