private void load_data_to_cbo_cong_trinh_from_data_giao_von(
DropDownList op_ddl
, WebformControls.LOAI_DU_AN ip_loai_du_an)
{
if (m_hdf_id_dm_giai_ngan.Value.Trim().Equals("") | m_hdf_id_dm_giai_ngan.Value.Trim().Equals("-1"))
{
op_ddl.Items.Clear();
}
else
{
US_DM_GIAI_NGAN v_us_dm_giai_ngan = new US_DM_GIAI_NGAN(CIPConvert.ToDecimal(m_hdf_id_dm_giai_ngan.Value));
WebformControls.load_data_to_cbo_du_an_cong_trinh_from_giao_von(
ip_loai_du_an
, op_ddl);
}
}
private void form_to_us_object(US_DM_GIAI_NGAN op_us)
{
op_us.strNT_TEN_DON_VI = m_txt_nt_ten_don_vi.Text;
op_us.strNT_MA_SO_THUE = m_txt_nt_ma_so_thue.Text;
op_us.strNT_MA_NDKT = m_txt_nt_ma_ndkt.Text;
op_us.strNT_MA_CHUONG = m_txt_nt_ma_chuong.Text;
op_us.strNT_CQ_QL_THU = m_txt_nt_co_quan_quan_ly_thu.Text;
op_us.strNT_MA_CQ_THU = m_txt_nt_ma_cq_thu.Text;
op_us.strNT_KBNN_HACH_TOAN_KHOAN_THU = m_txt_nt_kbnn_hach_toan_thu.Text;
op_us.strNT_SO_TIEN_NOP_THUE = m_txt_nt_so_tien_nop_thue.Text;
op_us.strTTDVH_DON_VI_NHAN_TIEN = m_txt_ttdvh_don_vi_nhan_tien.Text;
op_us.strTTDVH_MA_DVQHNS = m_txt_ttdvh_ma_dvqhns.Text;
op_us.strTTDVH_DIA_CHI = m_txt_ttdvh_dia_chi.Text;
op_us.strTTDVH_TAI_KHOAN = m_txt_ttdvh_tai_khoan.Text;
op_us.strTTDVH_MA_CTMT_DA_VA_HTCT = m_txt_ttdvh_ma_ctmt_da_htct.Text;
op_us.strTTDVH_KHO_BAC = m_txt_ttdvh_tai_kbnn.Text;
op_us.strTTDVH_SO_TIEN = m_txt_ttdvh_so_tien_thanh_toan.Text;
op_us.strIS_NGUON_NS_YN = STR_NGUON.QUY_BAO_TRI;
op_us.strMA_TKKT = m_rdb_ma_tkkt_quy.Checked ? m_rdb_ma_tkkt_quy.Text :
m_rdb_ma_tkkt_quy_2.Checked ? m_rdb_ma_tkkt_quy_2.Text :
m_rdb_ma_tkkt_quy_3.Checked ? m_rdb_ma_tkkt_quy_3.Text :
m_rdb_ma_tkkt_quy_4.Checked ? m_rdb_ma_tkkt_quy_4.Text : "";
}
private void insert_unc()
{
US_DM_GIAI_NGAN v_us_dm_giai_ngan = new US_DM_GIAI_NGAN();
m_hdf_id_dm_giai_ngan.Value = "";
//check validate luu quyet dinh
if (!check_validate_input_dm_giai_ngan_is_ok()) return;
// insert dm giai ngan
form_to_us_dm_giai_ngan(v_us_dm_giai_ngan);
v_us_dm_giai_ngan.Insert();
WebformControls.ghiLogDuToan("Thêm mới uỷ nhiệm chi số " + v_us_dm_giai_ngan.strSO_UNC);
m_hdf_id_dm_giai_ngan.Value = v_us_dm_giai_ngan.dcID.ToString();
m_lbl_mess_master.Text = C_STR_LUU_THANH_CONG_UNC;
//reload data by form mode
set_enable_control_giai_ngan(false);
load_data_to_grid_chi_tiet_uy_nhiem_chi();
format_control_print_and_save_info();
}
protected void m_grv_bao_cao_giao_von_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
if (e.CommandName.ToUpper() == "XOA")
{
US_DM_GIAI_NGAN v_us_dm_giai_ngan = new US_DM_GIAI_NGAN();
if (v_us_dm_giai_ngan.deleteAllDataOfUNC(CIPConvert.ToDecimal(e.CommandArgument)))
{
m_lbl_mess.Text = "Bạn đã xoá Uỷ nhiệm chi thành công";
load_data_to_grid();
}
else m_lbl_mess.Text = "Đã có lỗi trong quá trình thực hiện, bạn hãy thực hiện lại thao tác";
}
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(this, v_e);
}
}
private void form_to_us_dm_giai_ngan(US_DM_GIAI_NGAN op_us)
{
op_us.dcID_DON_VI = CIPConvert.ToDecimal(m_ddl_don_vi.SelectedValue);
op_us.strMA_CTMT_DA_HTCT = m_txt_ma_ctmt_da_htct.Text.Trim();
string v_str_ma_dvqhns = "";
if (m_rdb_ma_dvqhns.Checked)
{
v_str_ma_dvqhns = m_rdb_ma_dvqhns.Text;
}
else if (m_rdb_ma_dvqhns_1.Checked)
{
v_str_ma_dvqhns = m_rdb_ma_dvqhns_1.Text;
}
else if (m_rdb_ma_dvqhns_2.Checked)
{
v_str_ma_dvqhns = m_rdb_ma_dvqhns_2.Text;
}
op_us.strMA_DVQHNS = v_str_ma_dvqhns;
op_us.strIS_NGUON_NS_YN = WebformFunctions.getValue_from_query_string<string>(
this
, FormInfo.QueryString.NGUON_NGAN_SACH
, STR_NGUON.QUY_BAO_TRI
);
op_us.strSO_UNC = m_txt_so_unc.Text.Trim();
op_us.datNGAY_THANG = CIPConvert.ToDatetime(m_txt_ngay_thang.Text.Trim(), "dd/MM/yyyy");
op_us.strNT_TEN_DON_VI = m_txt_nt_ten_don_vi.Text.Trim();
op_us.strNT_MA_SO_THUE = m_txt_nt_ma_so_thue.Text.Trim();
op_us.strNT_MA_NDKT = m_txt_nt_ma_ndkt.Text.Trim();
op_us.strNT_MA_CHUONG = m_txt_nt_ma_chuong.Text.Trim();
op_us.strNT_CQ_QL_THU = m_txt_nt_co_quan_quan_ly_thu.Text.Trim();
op_us.strNT_MA_CQ_THU = m_txt_nt_ma_cq_thu.Text.Trim();
op_us.strNT_KBNN_HACH_TOAN_KHOAN_THU = m_txt_nt_kbnn_hach_toan_thu.Text.Trim();
op_us.strNT_SO_TIEN_NOP_THUE = m_txt_nt_so_tien_nop_thue.Text.Trim();
op_us.strTTDVH_DON_VI_NHAN_TIEN = m_txt_ttdvh_don_vi_nhan_tien.Text.Trim();
op_us.strTTDVH_MA_DVQHNS = m_txt_ttdvh_ma_dvqhns.Text.Trim();
op_us.strTTDVH_DIA_CHI = m_txt_ttdvh_dia_chi.Text.Trim();
op_us.strTTDVH_TAI_KHOAN = m_txt_ttdvh_tai_khoan.Text.Trim();
op_us.strTTDVH_MA_CTMT_DA_VA_HTCT = m_txt_ttdvh_ma_ctmt_da_htct.Text.Trim();
op_us.strTTDVH_KHO_BAC = m_txt_ttdvh_tai_kbnn.Text.Trim();
op_us.strTTDVH_SO_TIEN = m_txt_ttdvh_so_tien_thanh_toan.Text.Trim();
op_us.strMA_TKKT = m_rdb_ma_tkkt_quy.Checked ? m_rdb_ma_tkkt_quy.Text :
m_rdb_ma_tkkt_quy_2.Checked ? m_rdb_ma_tkkt_quy_2.Text :
m_rdb_ma_tkkt_quy_3.Checked ? m_rdb_ma_tkkt_quy_3.Text :
m_rdb_ma_tkkt_quy_4.Checked ? m_rdb_ma_tkkt_quy_4.Text : "";
}
private void us_object_to_form(US_DM_GIAI_NGAN ip_us)
{
US_DM_THONG_TIN_DON_VI v_us_dm_thong_tin_don_vi = new US_DM_THONG_TIN_DON_VI();
v_us_dm_thong_tin_don_vi.InitByID_DON_VI(CIPConvert.ToDecimal(m_ddl_don_vi.SelectedValue));
m_txt_ngay_thang.Text = CIPConvert.ToStr(ip_us.datNGAY_THANG, "dd/MM/yyyy");
if (m_rdb_ma_tkkt_quy.Text == ip_us.strMA_TKKT) m_rdb_ma_tkkt_quy.Checked = true;
else if (m_rdb_ma_tkkt_quy_2.Text == ip_us.strMA_TKKT) m_rdb_ma_tkkt_quy_2.Checked = true;
else if (m_rdb_ma_tkkt_quy_3.Text == ip_us.strMA_TKKT) m_rdb_ma_tkkt_quy_3.Checked = true;
else if (m_rdb_ma_tkkt_quy_4.Text == ip_us.strMA_TKKT) m_rdb_ma_tkkt_quy_4.Checked = true;
else
m_rdb_ma_tkkt_quy.Checked = true;
if (ip_us.strMA_DVQHNS == v_us_dm_thong_tin_don_vi.strMA_DVQHNS)
{
m_rdb_ma_dvqhns.Checked = true;
}
else if (ip_us.strMA_DVQHNS == v_us_dm_thong_tin_don_vi.strMA_DVQHNS_1)
{
m_rdb_ma_dvqhns_1.Checked = true;
}
else if (ip_us.strMA_DVQHNS == v_us_dm_thong_tin_don_vi.strMA_DVQHNS_2)
{
m_rdb_ma_dvqhns_2.Checked = true;
}
//m_lbl_ma_dvqhns.Text = ip_us.strMA_DVQHNS;
m_txt_ma_ctmt_da_htct.Text = ip_us.strMA_CTMT_DA_HTCT;
//info dm unc
m_txt_nt_ten_don_vi.Text = ip_us.strNT_TEN_DON_VI;
m_txt_nt_ma_so_thue.Text = ip_us.strNT_MA_SO_THUE;
m_txt_nt_ma_ndkt.Text = ip_us.strNT_MA_NDKT;
m_txt_nt_ma_chuong.Text = ip_us.strNT_MA_CHUONG;
m_txt_nt_co_quan_quan_ly_thu.Text = ip_us.strNT_CQ_QL_THU;
m_txt_nt_ma_cq_thu.Text = ip_us.strNT_MA_CQ_THU;
m_txt_nt_kbnn_hach_toan_thu.Text = ip_us.strNT_KBNN_HACH_TOAN_KHOAN_THU;
m_txt_nt_so_tien_nop_thue.Text = ip_us.strNT_SO_TIEN_NOP_THUE;
m_txt_ttdvh_don_vi_nhan_tien.Text = ip_us.strTTDVH_DON_VI_NHAN_TIEN;
m_txt_ttdvh_ma_dvqhns.Text = ip_us.strTTDVH_MA_DVQHNS;
m_txt_ttdvh_dia_chi.Text = ip_us.strTTDVH_DIA_CHI;
m_txt_ttdvh_tai_khoan.Text = ip_us.strTTDVH_TAI_KHOAN;
m_txt_ttdvh_ma_ctmt_da_htct.Text = ip_us.strTTDVH_MA_CTMT_DA_VA_HTCT;
m_txt_ttdvh_tai_kbnn.Text = ip_us.strTTDVH_KHO_BAC;
m_txt_ttdvh_so_tien_thanh_toan.Text = ip_us.strTTDVH_SO_TIEN;
}
protected void m_ddl_dm_giai_ngan_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
m_txt_so_unc.Visible = true;
if (m_ddl_dm_giai_ngan.SelectedValue == CONST_GIAO_DICH.STR_VALUE_TAT_CA | m_ddl_dm_giai_ngan.SelectedValue == "")
{
m_hdf_id_dm_giai_ngan.Value = CONST_GIAO_DICH.STR_VALUE_TAT_CA;
}
else
{
m_hdf_id_dm_giai_ngan.Value = m_ddl_dm_giai_ngan.SelectedValue;
format_control_print_and_save_info();
US_DM_GIAI_NGAN v_us_dm_giai_ngan = new US_DM_GIAI_NGAN(CIPConvert.ToDecimal(m_hdf_id_dm_giai_ngan.Value));
US_DM_THONG_TIN_DON_VI v_us_thong_tin_don_vi = new US_DM_THONG_TIN_DON_VI();
m_txt_so_unc.Text = v_us_dm_giai_ngan.strSO_UNC;
v_us_thong_tin_don_vi.InitByID_DON_VI(CIPConvert.ToDecimal(m_ddl_don_vi.SelectedValue));
m_lbl_dia_chi.Text = v_us_thong_tin_don_vi.strDIA_CHI;
m_lbl_tai_kho_bac_nha_nuoc.Text = v_us_thong_tin_don_vi.strKHO_BAC;
us_object_to_form(v_us_dm_giai_ngan);
m_cmd_luu_unc.Visible = false;
m_cmd_nhap_moi_unc.Visible = true;
set_enable_control_giai_ngan(false);
m_ddl_dm_giai_ngan.Visible = false;
load_data_to_grid_chi_tiet_uy_nhiem_chi();
}
//Nếu không phải đơn vị của mình thì không được Nhập UNC,Thêm UNC
//if (m_ddl_don_vi.SelectedValue==Person.get_id_don_vi().ToString())
//{
// m_cmd_luu_unc.Visible = true;
// m_cmd_nhap_moi_unc.Visible = true;
// m_cmd_save_info_unc.Visible = true;
//}
//else
//{
// m_cmd_luu_unc.Visible = false;
// m_cmd_nhap_moi_unc.Visible = false;
// m_cmd_save_info_unc.Visible = false;
//}
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(this, v_e);
}
}
public static void load_data_to_ddl_giai_ngan(
DropDownList op_ddl
, string ip_str_is_nguon_ns
, decimal ip_dc_id_don_vi
, string ip_str_text_tat_ca)
{
US_DM_GIAI_NGAN v_us = new WebUS.US_DM_GIAI_NGAN();
DS_DM_GIAI_NGAN v_ds = new DS_DM_GIAI_NGAN();
v_ds.EnforceConstraints = false;
v_us.FillDataset(v_ds,
"where id_don_vi=" + ip_dc_id_don_vi
+ " and is_nguon_ns_yn ='" + ip_str_is_nguon_ns + "'"
+ " order by ngay_thang desc");
for (int i = 0; i < v_ds.DM_GIAI_NGAN.Count; i++)
{
v_ds.Tables[0].Rows[i][DM_GIAI_NGAN.SO_UNC] =
CIPConvert.ToStr(v_ds.Tables[0].Rows[i][DM_GIAI_NGAN.NGAY_THANG], "dd/MM/yyyy") + " " + v_ds.Tables[0].Rows[i][DM_GIAI_NGAN.SO_UNC];
v_ds.AcceptChanges();
}
op_ddl.DataTextField = DM_GIAI_NGAN.SO_UNC;
op_ddl.DataValueField = DM_GIAI_NGAN.ID;
op_ddl.DataSource = v_ds.DM_GIAI_NGAN;
op_ddl.DataBind();
op_ddl.Items.Insert(0, new ListItem(ip_str_text_tat_ca, "-1"));
}
private void load_data_cong_trinh_du_an_giao_von_to_ddl(DropDownList op_ddl, WinFormControls.LOAI_DU_AN ip_loai_du_an)
{
if (m_hdf_id_dm_uy_nhiem_chi.Value.Trim().Equals("") | m_hdf_id_dm_uy_nhiem_chi.Value.Trim().Equals("-1"))
{
op_ddl.Items.Clear();
}
else
{
US_DM_GIAI_NGAN v_us_dm_unc = new US_DM_GIAI_NGAN(CIPConvert.ToDecimal(m_hdf_id_dm_uy_nhiem_chi.Value));
DateTime v_dat_dau_nam = v_us_dm_unc.datNGAY_THANG;
v_dat_dau_nam = v_dat_dau_nam.AddDays(-v_dat_dau_nam.Day + 1);
v_dat_dau_nam = v_dat_dau_nam.AddMonths(-v_dat_dau_nam.Month + 1);
DateTime v_dat_cuoi_nam = v_dat_dau_nam.AddYears(1);
WinFormControls.load_data_to_cbo_du_an_cong_trinh_from_giao_von(ip_loai_du_an
, op_ddl);
}
}
//protected void m_grv_RowDataBound(object sender, GridViewRowEventArgs e)
//{
// try
// {
// if (e.Row.RowType == DataControlRowType.Header)
// {
// for (int i = 6; i < e.Row.Cells.Count; i++)
// {
// US_DM_QUYET_DINH v_us_qd = new US_DM_QUYET_DINH();
// DS_DM_QUYET_DINH v_ds_qd = new DS_DM_QUYET_DINH();
// v_us_qd.FillDataset(v_ds_qd, "where " + DM_QUYET_DINH.SO_QUYET_DINH + " = N'" + e.Row.Cells[i].Text + "'");
// if (v_ds_qd.DM_QUYET_DINH.Count > 0)
// {
// e.Row.Cells[i].Text = "QĐ số " + v_ds_qd.Tables[0].Rows[0][DM_QUYET_DINH.SO_QUYET_DINH] + " ngày " +
// CIPConvert.ToStr(v_ds_qd.Tables[0].Rows[0][DM_QUYET_DINH.NGAY_THANG], "dd/MM/yyyy");
// }
// }
// }
// }
// catch (Exception v_e)
// {
// CSystemLog_301.ExceptionHandle(this, v_e);
// }
//}
protected void m_grv_RowDataBound(object sender, GridViewRowEventArgs e)
{
try
{
if (e.Row.RowType == DataControlRowType.Header)
{
for (int i = 0; i < e.Row.Controls.Count; i++)
{
var headerCell = e.Row.Controls[i] as DataControlFieldHeaderCell;
if (headerCell != null)
{
US_DM_GIAI_NGAN v_us_qd = new US_DM_GIAI_NGAN();
DS_DM_GIAI_NGAN v_ds_qd = new DS_DM_GIAI_NGAN();
v_us_qd.FillDataset(v_ds_qd, "where " + DM_GIAI_NGAN.SO_UNC + " = N'" + headerCell.ContainingField.ToString().Trim() + "'");
if (v_ds_qd.DM_GIAI_NGAN.Count > 0)
{
headerCell.Text = "Uỷ nhiệm chi số " + v_ds_qd.Tables[0].Rows[0][DM_GIAI_NGAN.SO_UNC] + " ngày " +
CIPConvert.ToStr(v_ds_qd.Tables[0].Rows[0][DM_QUYET_DINH.NGAY_THANG], "dd/MM/yyyy");
}
}
}
}
else if (e.Row.RowType == DataControlRowType.DataRow)
{
if (m_grv.DataKeys[e.Row.RowIndex].Value.ToString().Trim().Equals(""))
{
e.Row.Font.Bold = true;
}
e.Row.Cells[1].Width = 200;
for (int i = 7; i < e.Row.Controls.Count; i++)
{
Label v_lbl = new Label();
if (e.Row.Cells[i] == null)
return;
decimal v_i_so_tien = 0;
bool v_b_is_number = decimal.TryParse(e.Row.Cells[i].Text, out v_i_so_tien);
if (v_b_is_number)
{
v_lbl.Text = CIPConvert.ToStr(WebformControls.get_so_tien(e.Row.Cells[i].Text),"#,###,##");
v_lbl.CssClass = "csscurrency";
}
e.Row.Cells[i].Controls.Add(v_lbl);
e.Row.Cells[i].CssClass = "csscurrency";
e.Row.Cells[i].Width = 80;
}
}
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(this, v_e);
}
}
public static void load_data_to_cbo_dm_uy_nhiem_chi(
DropDownList op_ddl
, DateTime ip_dat_tu_ngay
, DateTime ip_dat_den_ngay
, bool ip_b_is_nguon_ns
, decimal ip_dc_id_don_vi
, string ip_str_text_tat_ca)
{
US_DM_GIAI_NGAN v_us = new WebUS.US_DM_GIAI_NGAN();
DS_DM_GIAI_NGAN v_ds = new DS_DM_GIAI_NGAN();
string v_str_is_nguon_ns = "N";
if (ip_b_is_nguon_ns) v_str_is_nguon_ns = "Y";
v_us.get_dm_uy_nhiem_chi_by_don_vi_va_ngay_thang(v_ds
, ip_dc_id_don_vi
, ip_dat_tu_ngay
, ip_dat_den_ngay
, v_str_is_nguon_ns);
for (int i = 0; i < v_ds.DM_GIAI_NGAN.Count; i++)
{
v_ds.Tables[0].Rows[i][DM_GIAI_NGAN.SO_UNC] =
CIPConvert.ToStr(v_ds.Tables[0].Rows[i][DM_GIAI_NGAN.NGAY_THANG], "dd/MM/yyyy") + " " + v_ds.Tables[0].Rows[i][DM_GIAI_NGAN.SO_UNC];
v_ds.AcceptChanges();
}
op_ddl.DataTextField = DM_GIAI_NGAN.SO_UNC;
op_ddl.DataValueField = DM_GIAI_NGAN.ID;
op_ddl.DataSource = v_ds.DM_GIAI_NGAN;
op_ddl.DataBind();
op_ddl.Items.Insert(0, new ListItem(ip_str_text_tat_ca, "-1"));
}
private void load_content_print(decimal ip_dc_id_dm_unc)
{
US_DM_GIAI_NGAN v_us = new US_DM_GIAI_NGAN(ip_dc_id_dm_unc);
m_lbl_so_unc.Text = v_us.strSO_UNC;
m_lbl_so_tien_ghi_bang_chu.Text = v_us.strTTDVH_SO_TIEN;
US_V_DM_GIAI_NGAN v_us_v_giai_ngan = new US_V_DM_GIAI_NGAN();
m_ds = new DS_V_DM_GIAI_NGAN();
m_ds.EnforceConstraints = false;
US_DM_THONG_TIN_DON_VI v_us_thong_tin_don_vi = new US_DM_THONG_TIN_DON_VI();
decimal v_dc_id_don_vi = m_dc_id_don_vi;
//if (Request.QueryString["ip_dc_id_don_vi"] != null)
//{
// v_dc_id_don_vi = CIPConvert.ToDecimal(Request.QueryString["ip_dc_id_don_vi"]);
//}
v_us_thong_tin_don_vi.InitByID_DON_VI(v_dc_id_don_vi);
US_DM_DON_VI v_us_dm_don_vi = new US_DM_DON_VI(v_dc_id_don_vi);
v_us_v_giai_ngan.FillDataset(m_ds, "where " + V_DM_GIAI_NGAN.ID_DON_VI + "=" + v_dc_id_don_vi
+ " and " + V_DM_GIAI_NGAN.ID + "=" + ip_dc_id_dm_unc);
//load data to Noi dung thanh toan
for (int i = 0; i < m_ds.V_DM_GIAI_NGAN.Count; i++)
{
m_dc_tong_tien += CIPConvert.ToDecimal(m_ds.Tables[0].Rows[i][V_DM_GIAI_NGAN.SO_TIEN_NOP_THUE])
+ CIPConvert.ToDecimal(m_ds.Tables[0].Rows[i][V_DM_GIAI_NGAN.SO_TIEN_TT_CHO_DV_HUONG]);
m_dc_tong_tien_nop_thue += CIPConvert.ToDecimal(m_ds.Tables[0].Rows[i][V_DM_GIAI_NGAN.SO_TIEN_NOP_THUE]);
m_dc_tong_tien_thanh_toan_cho_don_vi_huong += CIPConvert.ToDecimal(m_ds.Tables[0].Rows[i][V_DM_GIAI_NGAN.SO_TIEN_TT_CHO_DV_HUONG]);
}
//load info Don vi tra tien
m_lbl_don_vi_rut_du_toan.Text = v_us_dm_don_vi.strTEN_DON_VI;
m_lbl_tai_kbns.Text = v_us_thong_tin_don_vi.strKHO_BAC;
m_lbl_tai_khoan.Text = v_us.strMA_TKKT;
m_lbl_ma_dvqhns.Text = v_us.strMA_DVQHNS;
m_lbl_ma_ctmt_da_htct.Text = v_us.strMA_CTMT_DA_HTCT;
m_lbl_so_tien_ghi_bang_chu.Text = "...........................................................................................................";
m_lbl_so_tien_ghi_bang_chu.Text = IP.Core.IPCommon.CRead.ChuyenSo(m_dc_tong_tien.ToString());
//load info Nop thue
m_lbl_nt_ten_don_vi.Text = v_us.strNT_TEN_DON_VI;
m_lbl_nt_ma_so_thue.Text = v_us.strNT_MA_SO_THUE;
m_lbl_nt_ma_ndkt.Text = v_us.strNT_MA_NDKT;
m_lbl_nt_ma_chuong.Text = v_us.strNT_MA_CHUONG;
m_lbl_nt_co_quan_quan_ly_thu.Text = v_us.strNT_CQ_QL_THU;
m_lbl_nt_ma_cq_thu.Text = v_us.strNT_MA_CQ_THU;
m_lbl_nt_so_tien_nop_thue.Text = IP.Core.IPCommon.CRead.ChuyenSo(m_dc_tong_tien_nop_thue.ToString());
//load info Thanh toan cho don vi huong
m_lbl_ttdvh_don_vi_nhan_tien.Text = v_us.strTTDVH_DON_VI_NHAN_TIEN;
m_lbl_ttdvh_ma_dvqhns.Text = v_us.strTTDVH_MA_DVQHNS;
m_lbl_ttdvh_dia_chi.Text = v_us.strTTDVH_DIA_CHI;
m_lbl_ttdvh_tai_khoan.Text = v_us.strTTDVH_TAI_KHOAN;
m_lbl_ttdvh_ma_ctmt_da_htct.Text = v_us.strTTDVH_MA_CTMT_DA_VA_HTCT;
m_lbl_ttdvh_tai_kbnn.Text = v_us.strTTDVH_KHO_BAC;
m_lbl_ttdvh_so_tien_thanh_toan.Text = IP.Core.IPCommon.CRead.ChuyenSo(m_dc_tong_tien_thanh_toan_cho_don_vi_huong.ToString());
m_lbl_cmnd_so.Text = v_us.strNGUOI_NHAN_TIEN_CMND_SO;
m_lbl_cap_ngay.Text = v_us.strNGUOI_NHAN_TIEN_CAP_NGAY;
m_lbl_noi_cap.Text = v_us.strNGUOI_NHAN_TIEN_NOI_CAP;
m_lbl_ten_ctmt_da.Text = v_us.strTEN_CTMT_DA;
m_lbl_ma_cap_ns.Text = v_us.strMA_CAP_NS;
m_lbl_nam_ns.Text = v_us.datNGAY_THANG.Year.ToString();
m_lbl_so_ckc_hdk.Text = v_us.strSO_CKC_HDK;
m_lbl_so_ckc_hdth.Text = v_us.strSO_CKC_HDTH;
if (v_us.strIS_NGUON_NS_YN == "N")
{
m_lbl_tai_khoan.Text = v_us_thong_tin_don_vi.strMA_TKKT1;
}
else
{
m_lbl_tai_khoan.Text = v_us_thong_tin_don_vi.strMA_TKKT2;
}
//m_ckb_thuc_chi.Checked = getISCheck(v_us.strTHUC_CHI_YN);
//m_ckb_tam_ung.Checked = getISCheck(v_us.strTAM_UNG_YN);
//m_ckb_ung_truoc_chua_du_dk_thanh_toan.Checked = getISCheck(v_us.strUNG_TRUOC_CHUA_DU_DK_THANH_TOAN_YN);
//m_ckb_ung_truoc_du_dk_thanh_toan.Checked = getISCheck(v_us.strUNG_TRUOC_DU_DK_THANH_TOAN_YN);
//m_ckb_chuyen_khoan.Checked = getISCheck(v_us.strCHUYEN_KHOAN_YN);
//m_ckb_tien_mat.Checked = getISCheck(v_us.strTIEN_MAT_YN);
}
private void us_object_to_form(US_DM_GIAI_NGAN ip_us)
{
m_txt_ma_ctmt_da_htct.Text = ip_us.strMA_CTMT_DA_HTCT;
m_ckb_thuc_chi.Checked = getISCheck(ip_us.strTHUC_CHI_YN);
m_ckb_tam_ung.Checked = getISCheck(ip_us.strTAM_UNG_YN);
m_ckb_ung_truoc_chua_du_dk_thanh_toan.Checked = getISCheck(ip_us.strUNG_TRUOC_CHUA_DU_DK_THANH_TOAN_YN);
m_ckb_ung_truoc_du_dk_thanh_toan.Checked = getISCheck(ip_us.strUNG_TRUOC_DU_DK_THANH_TOAN_YN);
m_ckb_chuyen_khoan.Checked = getISCheck(ip_us.strCHUYEN_KHOAN_YN);
m_ckb_tien_mat.Checked = getISCheck(ip_us.strTIEN_MAT_YN);
m_txt_ngay_thang.Text = CIPConvert.ToStr(ip_us.datNGAY_THANG, "dd/MM/yyyy");
m_txt_ma_cap_ns.Text = ip_us.strMA_CAP_NS;
m_txt_ten_ctmt_da.Text = ip_us.strTEN_CTMT_DA;
m_txt_nam_ns.Text = ip_us.datNGAY_THANG.Year.ToString();
m_txt_so_ckc_hdk.Text = ip_us.strSO_CKC_HDK;
m_txt_so_ckc_hdth.Text = ip_us.strSO_CKC_HDTH;
if (m_rdb_ma_tkkt_ns.Text == ip_us.strMA_TKKT) m_rdb_ma_tkkt_ns.Checked = true;
else if (m_rdb_ma_tkkt_ns_2.Text == ip_us.strMA_TKKT) m_rdb_ma_tkkt_ns_2.Checked = true;
else if (m_rdb_ma_tkkt_ns_3.Text == ip_us.strMA_TKKT) m_rdb_ma_tkkt_ns_3.Checked = true;
else if (m_rdb_ma_tkkt_ns_4.Text == ip_us.strMA_TKKT) m_rdb_ma_tkkt_ns_4.Checked = true;
else
m_rdb_ma_tkkt_ns.Checked = true;
m_lbl_ma_dvqhns.Text = ip_us.strMA_DVQHNS;
m_txt_nt_ten_don_vi.Text = ip_us.strNT_TEN_DON_VI;
m_txt_nt_ma_so_thue.Text = ip_us.strNT_MA_SO_THUE;
m_txt_nt_ma_ndkt.Text = ip_us.strNT_MA_NDKT;
m_txt_nt_ma_chuong.Text = ip_us.strNT_MA_CHUONG;
m_txt_nt_co_quan_quan_ly_thu.Text = ip_us.strNT_CQ_QL_THU;
m_txt_nt_ma_cq_thu.Text = ip_us.strNT_MA_CQ_THU;
m_txt_nt_kbnn_hach_toan_thu.Text = ip_us.strNT_KBNN_HACH_TOAN_KHOAN_THU;
m_txt_nt_so_tien_nop_thue.Text = ip_us.strNT_SO_TIEN_NOP_THUE;
m_txt_ttdvh_don_vi_nhan_tien.Text = ip_us.strTTDVH_DON_VI_NHAN_TIEN;
m_txt_ttdvh_ma_dvqhns.Text = ip_us.strTTDVH_MA_DVQHNS;
m_txt_ttdvh_dia_chi.Text = ip_us.strTTDVH_DIA_CHI;
m_txt_ttdvh_tai_khoan.Text = ip_us.strTTDVH_TAI_KHOAN;
m_txt_ttdvh_ma_ctmt_da_htct.Text = ip_us.strTTDVH_MA_CTMT_DA_VA_HTCT;
m_txt_ttdvh_tai_kbnn.Text = ip_us.strTTDVH_KHO_BAC;
m_txt_ttdvh_so_tien_thanh_toan.Text = ip_us.strTTDVH_SO_TIEN;
m_txt_cmnd_so.Text = ip_us.strNGUOI_NHAN_TIEN_CMND_SO;
m_txt_cap_ngay.Text = ip_us.strNGUOI_NHAN_TIEN_CAP_NGAY;
m_txt_noi_cap.Text = ip_us.strNGUOI_NHAN_TIEN_NOI_CAP;
}
private void form_to_us_dm_giai_ngan(US_DM_GIAI_NGAN op_us)
{
if (m_ckb_chuyen_khoan.Checked == true) op_us.strCHUYEN_KHOAN_YN = "Y"; else op_us.strCHUYEN_KHOAN_YN = "N";
if (m_ckb_thuc_chi.Checked == true) op_us.strTHUC_CHI_YN = "Y"; else op_us.strTHUC_CHI_YN = "N";
if (m_ckb_tam_ung.Checked == true) op_us.strTAM_UNG_YN = "Y"; else op_us.strTAM_UNG_YN = "N";
if (m_ckb_ung_truoc_chua_du_dk_thanh_toan.Checked == true) op_us.strUNG_TRUOC_CHUA_DU_DK_THANH_TOAN_YN = "Y"; else op_us.strUNG_TRUOC_CHUA_DU_DK_THANH_TOAN_YN = "N";
if (m_ckb_ung_truoc_du_dk_thanh_toan.Checked == true) op_us.strUNG_TRUOC_DU_DK_THANH_TOAN_YN = "Y"; else op_us.strUNG_TRUOC_DU_DK_THANH_TOAN_YN = "N";
if (m_ckb_tien_mat.Checked == true) op_us.strTIEN_MAT_YN = "Y"; else op_us.strTIEN_MAT_YN = "N";
op_us.dcID_DON_VI = CIPConvert.ToDecimal(m_ddl_don_vi.SelectedValue);
op_us.strMA_CTMT_DA_HTCT = m_txt_ma_ctmt_da_htct.Text.Trim();
op_us.strMA_CAP_NS = m_txt_ma_cap_ns.Text.Trim();
op_us.strTEN_CTMT_DA = m_txt_ten_ctmt_da.Text.Trim();
op_us.strSO_CKC_HDK = m_txt_so_ckc_hdk.Text.Trim();
op_us.strSO_CKC_HDTH = m_txt_so_ckc_hdth.Text.Trim();
op_us.strMA_DVQHNS = m_lbl_ma_dvqhns.Text.Trim();
op_us.strIS_NGUON_NS_YN = STR_NGUON.NGAN_SACH;
op_us.strSO_UNC = m_txt_so_unc.Text.Trim();
op_us.datNGAY_THANG = CIPConvert.ToDatetime(m_txt_ngay_thang.Text.Trim(), "dd/MM/yyyy");
op_us.strNT_TEN_DON_VI = m_txt_nt_ten_don_vi.Text.Trim();
op_us.strNT_MA_SO_THUE = m_txt_nt_ma_so_thue.Text.Trim();
op_us.strNT_MA_NDKT = m_txt_nt_ma_ndkt.Text.Trim();
op_us.strNT_MA_CHUONG = m_txt_nt_ma_chuong.Text.Trim();
op_us.strNT_CQ_QL_THU = m_txt_nt_co_quan_quan_ly_thu.Text.Trim();
op_us.strNT_MA_CQ_THU = m_txt_nt_ma_cq_thu.Text.Trim();
op_us.strNT_KBNN_HACH_TOAN_KHOAN_THU = m_txt_nt_kbnn_hach_toan_thu.Text.Trim();
op_us.strNT_SO_TIEN_NOP_THUE = m_txt_nt_so_tien_nop_thue.Text.Trim();
op_us.strTTDVH_DON_VI_NHAN_TIEN = m_txt_ttdvh_don_vi_nhan_tien.Text.Trim();
op_us.strTTDVH_MA_DVQHNS = m_txt_ttdvh_ma_dvqhns.Text.Trim();
op_us.strTTDVH_DIA_CHI = m_txt_ttdvh_dia_chi.Text.Trim();
op_us.strTTDVH_TAI_KHOAN = m_txt_ttdvh_tai_khoan.Text.Trim();
op_us.strTTDVH_MA_CTMT_DA_VA_HTCT = m_txt_ttdvh_ma_ctmt_da_htct.Text.Trim();
op_us.strTTDVH_KHO_BAC = m_txt_ttdvh_tai_kbnn.Text.Trim();
op_us.strTTDVH_SO_TIEN = m_txt_ttdvh_so_tien_thanh_toan.Text.Trim();
op_us.strNGUOI_NHAN_TIEN_CMND_SO = m_txt_cmnd_so.Text;
op_us.strNGUOI_NHAN_TIEN_CAP_NGAY = m_txt_cap_ngay.Text;
op_us.strNGUOI_NHAN_TIEN_NOI_CAP = m_txt_noi_cap.Text;
op_us.strMA_TKKT = m_rdb_ma_tkkt_ns.Checked ? m_rdb_ma_tkkt_ns.Text :
m_rdb_ma_tkkt_ns_2.Checked ? m_rdb_ma_tkkt_ns_2.Text :
m_rdb_ma_tkkt_ns_3.Checked ? m_rdb_ma_tkkt_ns_3.Text :
m_rdb_ma_tkkt_ns_4.Checked ? m_rdb_ma_tkkt_ns_4.Text : "";
}
private void load_data_to_ddl_muc_tieu_muc(DropDownList op_ddl, decimal ip_dc_id_loai_nhiem_vu)
{
/*
* Mục tiêu: Hiển thị dữ liệu có sẵn về Mục - Tiểu Mục để người dùng lựa chọn
* Tóm tắt:
*/
if (m_hdf_id_dm_giai_ngan.Value.Equals("") | m_hdf_id_dm_giai_ngan.Value.Trim().Equals("-1"))
{
op_ddl.Items.Clear();
op_ddl.Items.Insert(0, new ListItem("---Chọn Mục hoặc Tiểu mục---", "-1"));
return;
}
US_DM_GIAI_NGAN v_us_qd = new US_DM_GIAI_NGAN(CIPConvert.ToDecimal(m_hdf_id_dm_giai_ngan.Value));
DateTime v_dat_dau_nam = v_us_qd.datNGAY_THANG;
v_dat_dau_nam = v_dat_dau_nam.AddDays(-v_dat_dau_nam.Day + 1);
v_dat_dau_nam = v_dat_dau_nam.AddMonths(-v_dat_dau_nam.Month + 1);
DateTime v_dat_cuoi_nam = v_dat_dau_nam.AddYears(1);
DataSet v_ds_muc_tieu_muc =
WebformControls.get_dataset_muc_tieu_muc_from_data_giao_von(ip_dc_id_loai_nhiem_vu
, v_dat_dau_nam
, v_dat_cuoi_nam
, CIPConvert.ToDecimal(m_ddl_don_vi.SelectedValue));
op_ddl.DataTextField = GET_MUC_TIEU_MUC.DISPLAY;
op_ddl.DataValueField = GET_MUC_TIEU_MUC.ID;
op_ddl.DataSource = v_ds_muc_tieu_muc.Tables[0];
op_ddl.DataBind();
op_ddl.Items.Insert(0, new ListItem("---Chọn Mục hoặc Tiểu mục---", "-1"));
}
protected void m_cmd_save_info_unc_Click(object sender, EventArgs e)
{
try
{
if (m_hdf_id_dm_uy_nhiem_chi.Value.Trim().Equals("") | m_hdf_id_dm_uy_nhiem_chi.Value.Trim().Equals("-1"))
{
return;
}
US_DM_GIAI_NGAN v_us_dm_unc = new US_DM_GIAI_NGAN(CIPConvert.ToDecimal(m_hdf_id_dm_uy_nhiem_chi.Value));
v_us_dm_unc.strNT_TEN_DON_VI = m_txt_nt_ten_don_vi.Text;
v_us_dm_unc.strNT_MA_SO_THUE = m_txt_nt_ma_so_thue.Text;
v_us_dm_unc.strNT_MA_NDKT = m_txt_nt_ma_ndkt.Text;
v_us_dm_unc.strNT_MA_CHUONG = m_txt_nt_ma_chuong.Text;
v_us_dm_unc.strNT_CQ_QL_THU = m_txt_nt_co_quan_quan_ly_thu.Text;
v_us_dm_unc.strNT_MA_CQ_THU = m_txt_nt_ma_cq_thu.Text;
v_us_dm_unc.strNT_KBNN_HACH_TOAN_KHOAN_THU = m_txt_nt_kbnn_hach_toan_thu.Text;
v_us_dm_unc.strNT_SO_TIEN_NOP_THUE = m_txt_nt_so_tien_nop_thue.Text;
v_us_dm_unc.strTTDVH_DON_VI_NHAN_TIEN = m_txt_ttdvh_don_vi_nhan_tien.Text;
v_us_dm_unc.strTTDVH_MA_DVQHNS = m_txt_ttdvh_ma_dvqhns.Text;
v_us_dm_unc.strTTDVH_DIA_CHI = m_txt_ttdvh_dia_chi.Text;
v_us_dm_unc.strTTDVH_TAI_KHOAN = m_txt_ttdvh_tai_khoan.Text;
v_us_dm_unc.strTTDVH_MA_CTMT_DA_VA_HTCT = m_txt_ttdvh_ma_ctmt_da_htct.Text;
v_us_dm_unc.strTTDVH_KHO_BAC = m_txt_ttdvh_tai_kbnn.Text;
v_us_dm_unc.strTTDVH_SO_TIEN = m_txt_ttdvh_so_tien_thanh_toan.Text;
if (m_rbl_ma_tkkt.SelectedIndex == 0)
{
v_us_dm_unc.strIS_NGUON_NS_YN = "N";
}
else v_us_dm_unc.strIS_NGUON_NS_YN = "Y";
//v_us_dm_unc.strMA_TKKT = m_rbl_ma_tkkt.SelectedItem.Text;
v_us_dm_unc.Update();
m_lbl_mess_info_unc.Text = "Đã cập nhật thông tin thành công!";
}
catch (Exception v_e)
{
m_lbl_mess_info_unc.Text = v_e.ToString();
}
}
private void us_dm_giai_ngan_to_form(US_DM_GIAI_NGAN ip_us)
{
}
protected void m_ddl_unc_SelectedIndexChanged(object sender, EventArgs e)
{
m_txt_so_unc.Visible = true;
if (m_ddl_unc.SelectedValue == "-1" | m_ddl_unc.SelectedValue == "")
{
m_hdf_id_dm_uy_nhiem_chi.Value = "-1";
}
else
{
m_hdf_id_dm_uy_nhiem_chi.Value = m_ddl_unc.SelectedValue;
if (m_hdf_id_dm_uy_nhiem_chi.Value.Trim().Equals("") | m_hdf_id_dm_uy_nhiem_chi.Value.Trim().Equals("-1"))
m_cmd_save_info_unc.Visible = false;
else
{
m_cmd_save_info_unc.Visible = true;
m_cmd_print.NavigateUrl = "~/ChucNang/F600_print_unc_qbt.aspx?ip_dc_id_dm_unc=" + m_hdf_id_dm_uy_nhiem_chi.Value;
m_cmd_print.Visible = true;
}
US_DM_GIAI_NGAN v_us = new US_DM_GIAI_NGAN(CIPConvert.ToDecimal(m_hdf_id_dm_uy_nhiem_chi.Value));
US_DM_THONG_TIN_DON_VI v_us_thong_tin_don_vi = new US_DM_THONG_TIN_DON_VI();
v_us_thong_tin_don_vi.InitByID_DON_VI(CIPConvert.ToDecimal(m_ddl_don_vi.SelectedValue));
m_lbl_dia_chi.Text = v_us_thong_tin_don_vi.strDIA_CHI;
m_txt_so_unc.Text = v_us.strSO_UNC;
m_txt_ngay_thang.Text = CIPConvert.ToStr(v_us.datNGAY_THANG, "dd/MM/yyyy");
m_lbl_tai_kho_bac_nha_nuoc.Text = v_us_thong_tin_don_vi.strKHO_BAC;
if (v_us.strIS_NGUON_NS_YN.Trim().ToUpper() == "N")
{
m_rbl_ma_tkkt.SelectedIndex = 0;
}
else m_rbl_ma_tkkt.SelectedIndex = 1;
//if (m_rbl_ma_tkkt.Items.FindByText(v_us.strMA_TKKT) != null)
// m_rbl_ma_tkkt.Items.FindByText(v_us.strMA_TKKT).Selected = true;
m_lbl_ma_dvqhns.Text = v_us.strMA_DVQHNS;
m_txt_ma_ctmt_da_htct.Text = v_us.strMA_CTMT_DA_HTCT;
//info dm unc
m_txt_nt_ten_don_vi.Text = v_us.strNT_TEN_DON_VI;
m_txt_nt_ma_so_thue.Text = v_us.strNT_MA_SO_THUE;
m_txt_nt_ma_ndkt.Text = v_us.strNT_MA_NDKT;
m_txt_nt_ma_chuong.Text = v_us.strNT_MA_CHUONG;
m_txt_nt_co_quan_quan_ly_thu.Text = v_us.strNT_CQ_QL_THU;
m_txt_nt_ma_cq_thu.Text = v_us.strNT_MA_CQ_THU;
m_txt_nt_kbnn_hach_toan_thu.Text = v_us.strNT_KBNN_HACH_TOAN_KHOAN_THU;
m_txt_nt_so_tien_nop_thue.Text = v_us.strNT_SO_TIEN_NOP_THUE;
m_txt_ttdvh_don_vi_nhan_tien.Text = v_us.strTTDVH_DON_VI_NHAN_TIEN;
m_txt_ttdvh_ma_dvqhns.Text = v_us.strTTDVH_MA_DVQHNS;
m_txt_ttdvh_dia_chi.Text = v_us.strTTDVH_DIA_CHI;
m_txt_ttdvh_tai_khoan.Text = v_us.strTTDVH_TAI_KHOAN;
m_txt_ttdvh_ma_ctmt_da_htct.Text = v_us.strTTDVH_MA_CTMT_DA_VA_HTCT;
m_txt_ttdvh_tai_kbnn.Text = v_us.strTTDVH_KHO_BAC;
m_txt_ttdvh_so_tien_thanh_toan.Text = v_us.strTTDVH_SO_TIEN;
m_cmd_luu_unc.Visible = false;
m_cmd_nhap_moi_unc.Visible = true;
disable_control_unc();
m_ddl_unc.Visible = false;
data_to_grid_unc();
}
}
protected void m_cmd_save_info_unc_Click(object sender, EventArgs e)
{
try
{
if (m_hdf_id_dm_giai_ngan.Value.Trim().Equals("") | m_hdf_id_dm_giai_ngan.Value.Trim().Equals("-1"))
{
return;
}
US_DM_GIAI_NGAN v_us_dm_unc = new US_DM_GIAI_NGAN(CIPConvert.ToDecimal(m_hdf_id_dm_giai_ngan.Value));
//if (!check_validate_input_dm_giai_ngan_is_ok()) return;
form_to_us_dm_giai_ngan(v_us_dm_unc);
v_us_dm_unc.Update();
WebformControls.ghiLogDuToan("Cập nhật thông tin uỷ nhiệm chi số " + v_us_dm_unc.strSO_UNC);
m_lbl_mess_info_unc.Text = C_STR_LUU_THANH_CONG;
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(this, v_e);
}
}
protected void m_cmd_luu_unc_Click(object sender, EventArgs e)
{
try
{
US_DM_GIAI_NGAN v_us = new US_DM_GIAI_NGAN();
m_hdf_id_dm_uy_nhiem_chi.Value = "";
//check validate luu quyet dinh
if (m_txt_so_unc.Text.Trim().Equals(""))
{
m_lbl_mess_master.Text = "Bạn phải nhập Số Uỷ nhiệm chi!";
m_txt_so_unc.Focus();
return;
}
if (m_txt_ngay_thang.Text.Trim().Equals(""))
{
m_lbl_mess_master.Text = "Bạn phải nhập Ngày tháng!";
m_txt_ngay_thang.Focus();
return;
}
if (!CValidateTextBox.IsValid(m_txt_ma_ctmt_da_htct, DataType.StringType, allowNull.NO))
{
m_lbl_mess_master.Text = "Bạn phải nhập Mã CTMT, DA và HTCT!";
m_txt_ma_ctmt_da_htct.Focus();
return;
}
DateTime v_dat_ngay_thang = DateTime.Now;
try
{
v_dat_ngay_thang = CIPConvert.ToDatetime(m_txt_ngay_thang.Text.Trim(), "dd/MM/yyyy");
}
catch (Exception)
{
m_lbl_mess_master.Text = "Bạn phải nhập Ngày tháng!";
m_txt_ngay_thang.Focus();
return;
}
// insert gd quyet dinh
v_us.dcID_DON_VI = CIPConvert.ToDecimal(m_ddl_don_vi.SelectedValue);
//v_us.strDIA_CHI = m_lbl_dia_chi.Text.Trim();
//v_us.strKHO_BAC_NHA_NUOC = m_lbl_tai_kho_bac_nha_nuoc.Text.Trim();
v_us.strMA_CTMT_DA_HTCT = m_txt_ma_ctmt_da_htct.Text.Trim();
v_us.strMA_DVQHNS = m_lbl_ma_dvqhns.Text.Trim();
//if (m_rbl_ma_tkkt.SelectedIndex == 0)
//{
// v_us.strIS_NGUON_NS_YN = "N";
//}
//else v_us.strIS_NGUON_NS_YN = "Y";
if (Request.QueryString["ip_nguon_ns"]!=null)
{
if (Request.QueryString["ip_nguon_ns"].ToString().Equals("N"))
{
v_us.strIS_NGUON_NS_YN = "N";
}
}
else v_us.strIS_NGUON_NS_YN="Y";
//v_us.strMA_TKKT = m_rbl_ma_tkkt.SelectedItem.Text;
v_us.strSO_UNC = m_txt_so_unc.Text.Trim();
v_us.datNGAY_THANG = CIPConvert.ToDatetime(m_txt_ngay_thang.Text.Trim(), "dd/MM/yyyy");
v_us.Insert();
//do not edit
disable_control_unc();
m_lbl_mess_master.Text = "Lưu Uỷ nhiệm chi thành công!";
//set id to hiddenfield
m_hdf_id_dm_uy_nhiem_chi.Value = v_us.dcID.ToString();
data_to_grid_unc();
//get_so_tien_kh_giao();
if (m_hdf_id_dm_uy_nhiem_chi.Value.Trim().Equals("") | m_hdf_id_dm_uy_nhiem_chi.Value.Trim().Equals("-1"))
m_cmd_save_info_unc.Visible = false;
else
{
m_cmd_save_info_unc.Visible = true;
m_cmd_print.NavigateUrl = "~/ChucNang/F600_print_unc_qbt.aspx?ip_dc_id_dm_unc=" + m_hdf_id_dm_uy_nhiem_chi.Value;
m_cmd_print.Visible = true;
}
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(this, v_e);
}
}
private bool check_validate_input_dm_giai_ngan_is_ok()
{
if (m_txt_so_unc.Text.Trim().Equals(""))
{
m_lbl_mess_master.Text = "Bạn phải nhập Số Uỷ nhiệm chi!";
m_txt_so_unc.Focus();
return false;
}
//Check trung so unc
DS_DM_GIAI_NGAN v_ds_dm_giai_ngan = new DS_DM_GIAI_NGAN();
US_DM_GIAI_NGAN v_us_dm_giai_ngan = new US_DM_GIAI_NGAN();
v_us_dm_giai_ngan.get_dm_uy_nhiem_chi_by_don_vi_va_ngay_thang(
v_ds_dm_giai_ngan
, CIPConvert.ToDecimal(m_ddl_don_vi.SelectedValue)
, CCommonFunction.getDate_dau_nam_from_date(DateTime.Now)
, CCommonFunction.getDate_cuoi_nam_form_date(DateTime.Now)
, WebformFunctions.getValue_from_query_string<string>(this, FormInfo.QueryString.NGUON_NGAN_SACH, STR_NGUON.NGAN_SACH));
List<DBClassModel.DM_GIAI_NGAN> v_lst_giai_ngan = v_ds_dm_giai_ngan.DM_GIAI_NGAN.ToList<DBClassModel.DM_GIAI_NGAN>();
if (v_lst_giai_ngan.Where(x => x.SO_UNC == m_txt_so_unc.Text.Trim()).ToList().Count > 0)
{
m_lbl_mess_master.Text = "Bạn phải nhập Số Uỷ nhiệm chi, đã tồn tại Số uỷ nhiêm chi này!";
m_txt_so_unc.Focus();
return false;
}
if (!CValidateTextBox.IsValid(m_txt_ngay_thang, DataType.DateType, allowNull.NO))
{
m_lbl_mess_master.Text = "Bạn phải nhập Ngày tháng!";
m_txt_ngay_thang.Focus();
return false;
}
if (!CValidateTextBox.IsValid(m_txt_ma_ctmt_da_htct, DataType.StringType, allowNull.NO))
{
m_lbl_mess_master.Text = "Bạn phải nhập Mã CTMT, DA và HTCT!";
m_txt_ma_ctmt_da_htct.Focus();
return false;
}
return true;
}
private void load_content_print(decimal ip_dc_id_dm_unc)
{
US_DM_GIAI_NGAN v_us = new US_DM_GIAI_NGAN(ip_dc_id_dm_unc);
US_V_DM_GIAI_NGAN v_us_v_giai_ngan = new US_V_DM_GIAI_NGAN();
DS_V_DM_GIAI_NGAN v_ds = new DS_V_DM_GIAI_NGAN();
v_ds.EnforceConstraints = false;
US_DM_THONG_TIN_DON_VI v_us_thong_tin_don_vi = new US_DM_THONG_TIN_DON_VI();
decimal v_dc_id_don_vi = Person.get_id_don_vi();
if (Request.QueryString["ip_dc_id_don_vi"]!=null)
{
v_dc_id_don_vi = CIPConvert.ToDecimal(Request.QueryString["ip_dc_id_don_vi"]);
}
v_us_thong_tin_don_vi.InitByID_DON_VI(v_dc_id_don_vi);
US_DM_DON_VI v_us_dm_don_vi = new US_DM_DON_VI(v_dc_id_don_vi);
v_us_v_giai_ngan.FillDataset(v_ds, "where " + V_DM_GIAI_NGAN.ID_DON_VI + "=" + v_dc_id_don_vi
+" and "+V_DM_GIAI_NGAN.ID+"="+ip_dc_id_dm_unc);
m_lbl_ngay_thang.Text = " " + CIPConvert.ToStr(v_us.datNGAY_THANG, "dd") +
" tháng " + CIPConvert.ToStr(v_us.datNGAY_THANG, "MM") +
" năm " + CIPConvert.ToStr(v_us.datNGAY_THANG, "yyyy");
//load data to Noi dung thanh toan
m_grv.DataSource = v_ds.V_DM_GIAI_NGAN;
m_grv.DataBind();
decimal v_dc_tong_tien=0;
decimal v_dc_nop_thue = 0;
decimal v_dc_don_vi_huong = 0;
for (int i = 0; i < v_ds.V_DM_GIAI_NGAN.Count; i++)
{
v_dc_tong_tien+=CIPConvert.ToDecimal( v_ds.Tables[0].Rows[i][V_DM_GIAI_NGAN.SO_TIEN_NOP_THUE])
+CIPConvert.ToDecimal(v_ds.Tables[0].Rows[i][V_DM_GIAI_NGAN.SO_TIEN_TT_CHO_DV_HUONG]);
v_dc_nop_thue += CIPConvert.ToDecimal(v_ds.Tables[0].Rows[i][V_DM_GIAI_NGAN.SO_TIEN_NOP_THUE]);
v_dc_don_vi_huong += CIPConvert.ToDecimal(v_ds.Tables[0].Rows[i][V_DM_GIAI_NGAN.SO_TIEN_TT_CHO_DV_HUONG]);
}
//load info Don vi tra tien
m_lbl_so_unc.Text = v_us.strSO_UNC;
m_lbl_so_tien_ghi_bang_chu.Text = v_us.strTTDVH_SO_TIEN;
m_lbl_dia_chi.Text = v_us_thong_tin_don_vi.strDIA_CHI;
m_lbl_tai_kho_bac_nha_nuoc.Text = v_us_thong_tin_don_vi.strKHO_BAC;
m_lbl_ma_tkkt.Text = v_us.strMA_TKKT ;
m_lbl_ma_dvqhns.Text = v_us.strMA_DVQHNS;
m_lbl_ma_ctmt_da_htct.Text = v_us.strMA_CTMT_DA_HTCT;
m_lbl_so_tien_ghi_bang_chu.Text = "...........................................................................................................";
m_lbl_so_tien_ghi_bang_chu.Text = IP.Core.IPCommon.CRead.ChuyenSo(v_dc_tong_tien.ToString());
//load info Nop thue
m_lbl_nt_ten_don_vi.Text = v_us.strNT_TEN_DON_VI;
m_lbl_nt_ma_so_thue.Text = v_us.strNT_MA_SO_THUE;
m_lbl_nt_ma_ndkt.Text = v_us.strNT_MA_NDKT;
m_lbl_nt_ma_chuong.Text = v_us.strNT_MA_CHUONG;
m_lbl_nt_co_quan_quan_ly_thu.Text = v_us.strNT_CQ_QL_THU;
m_lbl_nt_ma_cq_thu.Text = v_us.strNT_MA_CQ_THU;
m_lbl_nt_so_tien_nop_thue.Text = IP.Core.IPCommon.CRead.ChuyenSo(v_dc_nop_thue.ToString()); ;
//load info Thanh toan cho don vi huong
m_lbl_ttdvh_don_vi_nhan_tien.Text = v_us.strTTDVH_DON_VI_NHAN_TIEN;
m_lbl_ttdvh_ma_dvqhns.Text = v_us.strTTDVH_MA_DVQHNS;
m_lbl_ttdvh_dia_chi.Text = v_us.strTTDVH_DIA_CHI;
m_lbl_ttdvh_tai_khoan.Text = v_us.strTTDVH_TAI_KHOAN;
m_lbl_ttdvh_ma_ctmt_da_htct.Text = v_us.strTTDVH_MA_CTMT_DA_VA_HTCT;
m_lbl_ttdvh_tai_kbnn.Text = v_us.strTTDVH_KHO_BAC;
m_lbl_ttdvh_so_tien_thanh_toan_dvh.Text = IP.Core.IPCommon.CRead.ChuyenSo(v_dc_don_vi_huong.ToString());
}
