private PHIEU_TIEP_NHAN LayTTPTN_DAT()
{
string ma = txtMa2.Text;
int idnv = frmDANG_NHAP.idnv;
string idbn = txtMaBN2.Text;
string idba = "1";
string idbs = cbBSK2.SelectedValue.ToString();
int idbs2 = int.Parse(idbs);
int stt = int.Parse(txtSTT2.Text);
string dvk = cbDVK.SelectedValue.ToString();
int iddvk = int.Parse(dvk);
int tuoithang = int.Parse(txtTuoithang2.Text);
int tuoinam = int.Parse(txtTuoinam2.Text);
DateTime dt = Convert.ToDateTime(DateNgayhen.Text);
string ngaygio = dt.ToShortDateString();
//string ngaygio = DateNgayhen.Text;
float mach = 0;
float nhietdo = 0;
float nhiptho = 0;
string huyetap = "0";
float chieucao = 0;
float cannang = 0;
float bmi = 0;
int tt = 0;
PHIEU_TIEP_NHAN t = new PHIEU_TIEP_NHAN(ma, idnv, idbn, idba, iddvk, stt, idbs2, dvk, tuoithang, tuoinam, ngaygio, mach, nhietdo, nhiptho, huyetap, chieucao, cannang, bmi, tt);
return(t);
}
public bool InsertPTN(PHIEU_TIEP_NHAN t)
{
try
{
SqlConnection conn = new SqlConnection(connecDB.connectionStr);
SqlCommand cmd = new SqlCommand("themPHIEU_TIEP_NHAN", conn);
cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.Add("@mathuoc", SqlDbType.NVarChar, 20);
//cmd.Parameters["@mathuoc"].Value = mt;
cmd.Parameters.Add("@TN_ID", SqlDbType.NVarChar, 15);
cmd.Parameters.Add("@NV_ID", SqlDbType.Int);
cmd.Parameters.Add("@BN_ID", SqlDbType.NVarChar, 10);
cmd.Parameters.Add("@BA_ID", SqlDbType.NVarChar, 20);
cmd.Parameters.Add("@DVK_ID", SqlDbType.Int);
cmd.Parameters.Add("@TN_STT", SqlDbType.Int);
cmd.Parameters.Add("@TN_BSKHAM", SqlDbType.Int);
cmd.Parameters.Add("@TN_DVKHAM", SqlDbType.NVarChar, 30);
cmd.Parameters.Add("@TN_TUOINAM", SqlDbType.Int);
cmd.Parameters.Add("@TN_TUOITHANG", SqlDbType.Int);
cmd.Parameters.Add("@TN_NGAYGIO", SqlDbType.Date);
cmd.Parameters.Add("@TN_MACH", SqlDbType.Float);
cmd.Parameters.Add("@TN_NHIETDO", SqlDbType.Float);
cmd.Parameters.Add("@TN_NHIPTHO", SqlDbType.Float);
cmd.Parameters.Add("@TN_HUYETAP", SqlDbType.NVarChar, 7);
cmd.Parameters.Add("@TN_CHIEUCAO", SqlDbType.Float);
cmd.Parameters.Add("@TN_CANNANG", SqlDbType.Float);
cmd.Parameters.Add("@TN_BMI", SqlDbType.Float);
cmd.Parameters.Add("@TN_TRANGTHAI", SqlDbType.Int);
cmd.Parameters["@TN_ID"].Value = t.Id_tn;
cmd.Parameters["@NV_ID"].Value = t.Id_nv;
cmd.Parameters["@BN_ID"].Value = t.Id_bn;
cmd.Parameters["@BA_ID"].Value = t.Id_ba;
cmd.Parameters["@DVK_ID"].Value = t.Id_ba;
cmd.Parameters["@TN_STT"].Value = t.Tn_stt;
cmd.Parameters["@TN_BSKHAM"].Value = t.Tn_bsk;
cmd.Parameters["@TN_DVKHAM"].Value = t.Tn_dvk;
cmd.Parameters["@TN_TUOINAM"].Value = t.Tn_tuoinam;
cmd.Parameters["@TN_TUOITHANG"].Value = t.Tn_tuoithang;
cmd.Parameters["@TN_NGAYGIO"].Value = t.Tn_ngaygio;
cmd.Parameters["@TN_MACH"].Value = t.Tn_mach;
cmd.Parameters["@TN_NHIETDO"].Value = t.Tn_nhietdo;
cmd.Parameters["@TN_NHIPTHO"].Value = t.Tn_nhiptho;
cmd.Parameters["@TN_HUYETAP"].Value = t.Tn_huyetap;
cmd.Parameters["@TN_CHIEUCAO"].Value = t.Tn_chieucao;
cmd.Parameters["@TN_CANNANG"].Value = t.Tn_cannang;
cmd.Parameters["@TN_BMI"].Value = t.Tn_bmi;
cmd.Parameters["@TN_TRANGTHAI"].Value = t.Tn_trangthai;
conn.Open();
int result = cmd.ExecuteNonQuery();
conn.Close();
return(result > 0);
}
catch (SqlException e)
{
MessageBox.Show(e.ToString());
return(false);
}
}
public bool UpdatePTN_DK(PHIEU_TIEP_NHAN t)
{
SqlConnection conn = new SqlConnection(connecDB.connectionStr);
SqlCommand cmd = new SqlCommand("suaPHIEU_TIEP_NHAN_DK", conn);
cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.Add("@mathuoc", SqlDbType.NVarChar, 20);
//cmd.Parameters["@mathuoc"].Value = mt;
cmd.Parameters.Add("@TN_ID", SqlDbType.NVarChar, 10);
cmd.Parameters["@TN_ID"].Value = t.Id_tn;
conn.Open();
int result = cmd.ExecuteNonQuery();
conn.Close();
return(result > 0);
}
public bool UpdatePTN(PHIEU_TIEP_NHAN t)
{
SqlConnection conn = new SqlConnection(connecDB.connectionStr);
SqlCommand cmd = new SqlCommand("suaPHIEU_TIEP_NHAN", conn);
cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.Add("@mathuoc", SqlDbType.NVarChar, 20);
//cmd.Parameters["@mathuoc"].Value = mt;
cmd.Parameters.Add("@TN_ID", SqlDbType.NVarChar, 10);
cmd.Parameters.Add("@TN_STT", SqlDbType.Int);
cmd.Parameters.Add("@TN_BSKHAM", SqlDbType.Int);
cmd.Parameters.Add("@TN_DVKHAM", SqlDbType.NVarChar, 30);
cmd.Parameters.Add("@TN_TUOINAM", SqlDbType.Int);
cmd.Parameters.Add("@TN_TUOITHANG", SqlDbType.Int);
cmd.Parameters.Add("@TN_NGAYGIO", SqlDbType.Date);
cmd.Parameters.Add("@TN_MACH", SqlDbType.Float);
cmd.Parameters.Add("@TN_NHIETDO", SqlDbType.Float);
cmd.Parameters.Add("@TN_NHIPTHO", SqlDbType.Float);
cmd.Parameters.Add("@TN_HUYETAP", SqlDbType.Float);
cmd.Parameters.Add("@TN_CHIEUCAO", SqlDbType.Float);
cmd.Parameters.Add("@TN_CANNANG", SqlDbType.Float);
cmd.Parameters.Add("@TN_BMI", SqlDbType.Float);
cmd.Parameters.Add("@TN_TRANGTHAI", SqlDbType.Int);
cmd.Parameters["@TN_ID"].Value = t.Id_tn;
cmd.Parameters["@TN_STT"].Value = t.Tn_stt;
cmd.Parameters["@TN_BSKHAM"].Value = t.Tn_bsk;
cmd.Parameters["@TN_DVKHAM"].Value = t.Tn_dvk;
cmd.Parameters["@TN_TUOINAM"].Value = t.Tn_tuoinam;
cmd.Parameters["@TN_TUOITHANG"].Value = t.Tn_tuoithang;
cmd.Parameters["@TN_NGAYGIO"].Value = t.Tn_ngaygio;
cmd.Parameters["@TN_MACH"].Value = t.Tn_mach;
cmd.Parameters["@TN_NHIETDO"].Value = t.Tn_nhietdo;
cmd.Parameters["@TN_NHIPTHO"].Value = t.Tn_nhiptho;
cmd.Parameters["@TN_HUYETAP"].Value = t.Tn_huyetap;
cmd.Parameters["@TN_CHIEUCAO"].Value = t.Tn_chieucao;
cmd.Parameters["@TN_CANNANG"].Value = t.Tn_cannang;
cmd.Parameters["@TN_BMI"].Value = t.Tn_bmi;
cmd.Parameters["@TN_TRANGTHAI"].Value = t.Tn_trangthai;
conn.Open();
int result = cmd.ExecuteNonQuery();
conn.Close();
return(result > 0);
}
private void btnLuu_Click_1(object sender, EventArgs e)
{
BENH_NHAN b = LayTTBN_DAT();
PHIEU_TIEP_NHAN t = LayTTPTN_DAT();
if (dieukien)
{
if (daoBN.InsertBN(b))
{
if (daoPTN.InsertPTN(t))
{
MessageBox.Show("Thêm thành công");
loadPTNH();
loadPTN();
xuLyControl(false);
//txtMa.Enabled = true;
frm.Visible = false;
//resetText();
}
}
else
{
}
}
else
{
//if (daoPTN.UpdatePTN(t))
//{
// MessageBox.Show("Sửa thành công");
// loadThuoc();
// xuLyControl(false);
// //txtMa.Enabled = true;
// frm.Visible = false;
// resetText();
// //sua(true);
//}
}
}
private void btnLuu2_Click(object sender, EventArgs e)
{
BENH_NHAN b = LayTTBN();
PHIEU_TIEP_NHAN t = LayTTPTN();
if (dieukien == true)
{
dt = daoBN.getTTBN(txtMaBN2.Text);
if (dt.Rows.Count == 0)
{
//MessageBox.Show("Đăng nhập không thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
//txtMaBN2.Focus();
if (daoBN.InsertBN(b))
{
if (daoPTN.InsertPTN(t))
{
//MessageBox.Show("Thêm thành công");
loadPTN();
//loadPTNH();
xuLyControl(false);
//txtMa.Enabled = true;
//frm2.Visible = false;
//resetText();
xuly2(false);
xulyBtn(false);
btnCapnhat(false);
txtMaBN2.Enabled = false;
}
}
}
else
{
if (daoPTN.InsertPTN(t))
{
MessageBox.Show("Thêm thành công");
loadPTN();
//loadPTNH();
xuLyControl(false);
//txtMa.Enabled = true;
//frm2.Visible = false;
//resetText();
xuly2(false);
xulyBtn(false);
btnCapnhat(false);
txtMaBN2.Enabled = false;
}
}
}
else
{
if (daoBN.UpdateBN(b))
{
if (daoPTN.UpdatePTN(t))
{
MessageBox.Show("Sửa thành công");
loadPTN();
loadPTNH();
DateChonNgay_ValueChanged(null, null);
xuLyControl(false);
//txtMa.Enabled = true;
//frm2.Visible = false;
//resetText();
}
else
{
MessageBox.Show("Sửa không thành công");
}
}
}
}
private PHIEU_TIEP_NHAN LayTTPTN()
{
string ma = txtMa2.Text;
int idnv = 1;
string idbn = txtMaBN2.Text;
string idba = "1";
string idbs = cbBSK2.SelectedValue.ToString();
int idbs2 = int.Parse(idbs);
int stt = int.Parse(txtSTT2.Text);
string dvk = cbDVK.SelectedValue.ToString();
int iddvk = int.Parse(dvk);
int tuoithang = int.Parse(txtTuoithang2.Text);
int tuoinam = int.Parse(txtTuoinam2.Text);
string ngaygio = System.DateTime.Now.ToShortDateString();
if (txtTuoinam2.Text == "")
{
txtTuoinam2.Text = "0";
}
if (txtTuoithang2.Text == "")
{
txtTuoithang2.Text = "0";
}
//string ngaygio = DateNgayhen.Text;
if (txtMach.Text == "")
{
txtMach.Text = "0";
}
if (txtNhietdo.Text == "")
{
txtNhietdo.Text = "0";
}
if (txtNhiptho.Text == "")
{
txtNhiptho.Text = "0";
}
if (txtChieucao.Text == "")
{
txtChieucao.Text = "0";
}
if (txtHuyetap.Text == "")
{
txtHuyetap.Text = "0";
}
if (txtHuyetap2.Text == "")
{
txtHuyetap2.Text = "0";
}
if (txtCannang.Text == "")
{
txtCannang.Text = "0";
}
if (txtBMI.Text == "")
{
txtBMI.Text = "0";
}
float mach = float.Parse(txtMach.Text);
float nhietdo = float.Parse(txtNhietdo.Text);
float nhiptho = float.Parse(txtNhiptho.Text);
//float huyetap = float.Parse(txtHuyetap.Text);
float chieucao = float.Parse(txtChieucao.Text);
float cannang = float.Parse(txtCannang.Text);
string huyetap = txtHuyetap.Text + "/" + txtHuyetap2.Text;
float bmi = float.Parse(txtBMI.Text);
int tt = 0;
PHIEU_TIEP_NHAN t = new PHIEU_TIEP_NHAN(ma, idnv, idbn, idba, iddvk, stt, idbs2, dvk, tuoithang, tuoinam, ngaygio, mach, nhietdo, nhiptho, huyetap, chieucao, cannang, bmi, tt);
return(t);
}