private void butLuu_Click(object sender, System.EventArgs e)
{
if (!kiemtra())
{
return;
}
if (ten.Text != "" && mavp.Text != "")
{
int itable = m.tableid(m.mmyy(s_ngay), "v_vpkhoa");
if (l_id == 0)
{
l_id = v.get_id_vpkhoa;
m.upd_eve_tables(s_ngay, itable, i_userid, "ins");
}
else
{
m.upd_eve_tables(s_ngay, itable, i_userid, "upd");
m.upd_eve_upd_del(s_ngay, itable, i_userid, "upd", l_id.ToString() + "^" + s_mabn + "^" + l_mavaovien.ToString() + "^" + l_maql.ToString() + "^" + l_idkhoa.ToString() + "^" + s_ngay + "^" + s_makp + "^" + madoituong.SelectedValue.ToString() + "^" + mavp.Text + "^" + soluong.Text + "^" + d_dongia.ToString() + "^" + d_vattu.ToString() + "^" + i_userid.ToString() + "^" + i_buoi.ToString());
foreach (DataRow r in v.get_data("select * from " + xxx + ".v_vpkhoa where id=" + l_id).Tables[0].Rows)
{
d.upd_theodoicongno(d.delete, r["mabn"].ToString(), decimal.Parse(r["mavaovien"].ToString()), decimal.Parse(r["maql"].ToString()), decimal.Parse(r["idkhoa"].ToString()), int.Parse(r["madoituong"].ToString()), decimal.Parse(r["soluong"].ToString()) * (decimal.Parse(r["dongia"].ToString()) + decimal.Parse(r["vattu"].ToString())), "vienphi");
}
}
if (!v.upd_vpkhoa(l_id, s_mabn, l_mavaovien, l_maql, l_idkhoa, s_ngay, s_makp, int.Parse(madoituong.SelectedValue.ToString()), int.Parse(mavp.Text), decimal.Parse(soluong.Text), d_dongia, d_vattu, i_userid, i_buoi))
{
MessageBox.Show(lan.Change_language_MessageText("Không cập nhật được thông tin viện phí !"), LibMedi.AccessData.Msg);
return;
}
d.upd_theodoicongno(d.insert, s_mabn, l_mavaovien, l_maql, l_idkhoa, int.Parse(madoituong.SelectedValue.ToString()), decimal.Parse(soluong.Text) * (d_dongia + d_vattu), "vienphi");
m.updrec_chidinh(ds.Tables[0], l_id, s_ngay, s_makp, "", int.Parse(madoituong.SelectedValue.ToString()), madoituong.Text, int.Parse(mavp.Text), ten.Text, s_dvt, decimal.Parse(soluong.Text), d_dongia, d_vattu, i_paid, i_done, 0, 0, "");
}
ena_object(false);
}
private void butMoi_Click(object sender, System.EventArgs e)
{
try
{
stt.Value = decimal.Parse(v.get_data("select max(stt) from " + user + ".ct_giavp where id_loai=" + decimal.Parse(nhom.SelectedValue.ToString())).Tables[0].Rows[0][0].ToString()) + 1;
}
catch { stt.Value = 1; }
l_id = 0;
ma.Text = ""; ten.Text = ""; ghichu.Text = ""; makp.SelectedIndex = -1;
gia_nv.Text = "0"; gia_ngv.Text = "0";
ena_object(true);
stt.Focus();
}
private void frmDmgiuong_Load(object sender, System.EventArgs e)
{
user = m.user;
bhyt.DisplayMember = "CHITRA";
bhyt.ValueMember = "CHITRA";
bhyt.DataSource = v.get_data("select * from " + user + ".d_dmbhyt order by stt").Tables[0];
makp.DisplayMember = "TENKP";
makp.ValueMember = "MAKP";
makp.DataSource = m.get_data("select * from " + user + ".btdkp_bv where makp<>'01' and loai in (0,4) order by loai,makp").Tables[0];
phong.DisplayMember = "TEN";
phong.ValueMember = "ID";
if (makp.SelectedIndex != -1)
{
dtp = m.get_data("select * from " + user + ".dmphong where makp='" + makp.SelectedValue.ToString() + "' order by stt").Tables[0];
phong.DataSource = dtp;
}
load_grid();
AddGridTableStyle();
lan.Read_dtgrid_to_Xml(dataGrid1, this.Name.ToString() + "_" + dataGrid1.Name.ToString());
lan.Change_dtgrid_HeaderText_to_English(dataGrid1, this.Name.ToString() + "_" + dataGrid1.Name.ToString());
}
