public static bool LuuPhieuBeNgoan(TheoDoiThang phieubengoan)
{
DataTable dt = PhieuBeNgoanDAL.LuuPhieuBeNgoan(phieubengoan);
foreach (DataRow row in dt.Rows)
{
if (row.ItemArray[0].ToString().Trim() == "0")
{
return(true);
}
}
return(false);
}
private void LuuPhieuBeNgoan(DataGridView dgvPhieuBeNgoan)
{
for (int i = 0; i < dgvPhieuBeNgoan.Rows.Count; i++)
{
TheoDoiThang phieubengoan = new TheoDoiThang();
phieubengoan.MaTre = dgvPhieuBeNgoan.Rows[i].Cells["MaTre"].Value.ToString();
string ngaylapphieu = dtThangLapPhieu.Text;
phieubengoan.Nam = Int32.Parse(ngaylapphieu.Split('/')[1]);
phieubengoan.Thang = Int32.Parse(ngaylapphieu.Split('/')[0]);
phieubengoan.NhanXetThang = dgvPhieuBeNgoan.Rows[i].Cells["NhanXetThang"].Value.ToString();
phieubengoan.PhieuTuan1 = Int32.Parse(dgvPhieuBeNgoan.Rows[i].Cells["PhieuBeNgoanTuan1"].Value.ToString());
phieubengoan.PhieuTuan2 = Int32.Parse(dgvPhieuBeNgoan.Rows[i].Cells["PhieuBeNgoanTuan2"].Value.ToString());
phieubengoan.PhieuTuan3 = Int32.Parse(dgvPhieuBeNgoan.Rows[i].Cells["PhieuBeNgoanTuan3"].Value.ToString());
phieubengoan.PhieuTuan4 = Int32.Parse(dgvPhieuBeNgoan.Rows[i].Cells["PhieuBeNgoanTuan4"].Value.ToString());
phieubengoan.PhieuThang = Int32.Parse(dgvPhieuBeNgoan.Rows[i].Cells["PhieuBeNgoanThang"].Value.ToString());
PhieuBeNgoanBLL.LuuPhieuBeNgoan(phieubengoan);
}
}
public static DataTable LuuPhieuBeNgoan(TheoDoiThang phieubengoan)
{
DataAccessHelper.GetInstance().Open();
SqlCommand cmd = DataAccessHelper.GetInstance().Command("LUU_PHIEU_BE_NGOAN");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MaTre", phieubengoan.MaTre);
cmd.Parameters.AddWithValue("@Thang", phieubengoan.Thang);
cmd.Parameters.AddWithValue("@Nam", phieubengoan.Nam);
cmd.Parameters.AddWithValue("@NhanXetThang", phieubengoan.NhanXetThang);
cmd.Parameters.AddWithValue("@PhieuBeNgoanTuan1", phieubengoan.PhieuTuan1);
cmd.Parameters.AddWithValue("@PhieuBeNgoanTuan2", phieubengoan.PhieuTuan2);
cmd.Parameters.AddWithValue("@PhieuBeNgoanTuan3", phieubengoan.PhieuTuan3);
cmd.Parameters.AddWithValue("@PhieuBeNgoanTuan4", phieubengoan.PhieuTuan4);
cmd.Parameters.AddWithValue("@PhieuBeNgoanThang", phieubengoan.PhieuThang);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataAccessHelper.GetInstance().SetDataTable(new DataTable());
da.Fill(DataAccessHelper.GetInstance().GetDataTable());
DataAccessHelper.GetInstance().Close();
return(DataAccessHelper.GetInstance().GetDataTable());
}
