public DataTable Congthuc_KtLuong(CongThucDTO congthuc, string soluong)
{
DataTable dt = congthuc_dal.CongThuc_KtLuongSp(congthuc);
if (dt.Rows[0][1].ToString() == "khong")
{
return(dt);
}
else
{
DataTable dt2 = new DataTable();
for (int i = 0; i < dt.Rows.Count; i++)
{
CongThucDTO congthuc2 = new CongThucDTO();
congthuc2.MaSp = congthuc.MaSp;
congthuc2.MaNl = dt.Rows[i][0].ToString();
congthuc2.TieuHao = dt.Rows[i][1].ToString();
congthuc2.DVt = dt.Rows[i][2].ToString();
dt2 = congthuc_dal.CongThuc_KtLuongNl(congthuc2, soluong);
if (dt2 != null)
{
break;
}
}
return(dt2);
}
}
public bool CongThuc_ThucThi(CongThucDTO congthuc, string soluong)
{
DataTable dt = congthuc_dal.CongThuc_KtLuongSp(congthuc);
if (dt.Rows[0][1].ToString() == "khong")
{
return(false);
}
else
{
bool thucthi = new bool();
for (int i = 0; i < dt.Rows.Count; i++)
{
CongThucDTO congthuc2 = new CongThucDTO();
congthuc2.MaNl = dt.Rows[i][0].ToString();
congthuc2.TieuHao = dt.Rows[i][1].ToString();
congthuc2.DVt = dt.Rows[i][2].ToString();
thucthi = congthuc_dal.CongThuc_ThucThi(congthuc2, soluong);
if (thucthi == false)
{
break;
}
}
return(thucthi);
}
}
public void CongThuc_SelectAllMaSp()
{
CongThucDTO congthuc = new CongThucDTO();
congthuc.MaSp = cbtensp.SelectedValue.ToString();
datacongthuc.DataSource = congthuc_bus.CongThuc_SelectAllMaSp(congthuc);
}
public void CongThuc_ThucThi()
{
for (int i = 0; i < datachonsp.RowCount - 1; i++)
{
CongThucDTO congthuc = new CongThucDTO();
congthuc.MaSp = datachonsp.Rows[i].Cells[0].Value.ToString();
string soluong = datachonsp.Rows[i].Cells[2].Value.ToString();
congthuc_bus.CongThuc_ThucThi(congthuc, soluong).ToString();
}
}
public void CongThuc_Delete()
{
CongThucDTO congthuc = new CongThucDTO();
congthuc.MaSp = cbtensp.Text;
congthuc.MaNl = cbtennl.Text;
congthuc.TieuHao = txttieuhao.Text;
congthuc.DVt = cbdvt.Text;
DataTable dt = congthuc_bus.CongThuc_Delete(congthuc);
MessageBox.Show(dt.Rows[0][0].ToString(), "Thông báo", MessageBoxButtons.OK);
}
public DataTable CongThuc_SelectAllMaSp(CongThucDTO congthuc)
{
try
{
openConnect();
SqlCommand cmd = new SqlCommand("CONGTHUC_SELECTALLMASP", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@MASANPHAM", congthuc.MaSp));
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);
closeConnect();
return(dt);
}
catch
{
return(null);
}
}
public DataTable Congthuc_KtLuong()
{
DataTable dt = new DataTable();
for (int i = 0; i < datachonsp.Rows.Count - 1; i++)
{
CongThucDTO congthuc = new CongThucDTO();
congthuc.MaSp = datachonsp.Rows[i].Cells[0].Value.ToString();
double soluong = Convert.ToInt32(datachonsp.Rows[i].Cells[2].Value.ToString());
for (int j = 0; j < i; j++)
{
if (datachonsp.Rows[j].Cells[0].Value.ToString() == congthuc.MaSp)
{
soluong = soluong + Convert.ToDouble(datachonsp.Rows[j].Cells[2].Value.ToString());
}
}
dt = congthuc_bus.Congthuc_KtLuong(congthuc, soluong.ToString());
}
return(dt);
}
public bool CongThuc_ThucThi(CongThucDTO congthuc, string soluong)
{
try
{
openConnect();
SqlCommand cmd = new SqlCommand("CONGTHUC_THUCTHI", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@SOLUONG", Convert.ToInt32(soluong)));
cmd.Parameters.Add(new SqlParameter("@MANGUYENLIEU", congthuc.MaNl));
cmd.Parameters.Add(new SqlParameter("@TIEUHAO", Convert.ToDouble(congthuc.TieuHao)));
cmd.Parameters.Add(new SqlParameter("@DONVITINH", congthuc.DVt));
cmd.ExecuteNonQuery();
closeConnect();
return(true);
}
catch
{
return(false);
}
}
public DataTable CongThuc_Update(CongThucDTO congthuc)
{
try
{
openConnect();
SqlCommand cmd = new SqlCommand("CONGTHUC_UPDATE", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@TENSANPHAM", congthuc.MaSp));
cmd.Parameters.Add(new SqlParameter("@TENNGUYENLIEU", congthuc.MaNl));
cmd.Parameters.Add(new SqlParameter("@TIEUHAO", Convert.ToDouble(congthuc.TieuHao)));
cmd.Parameters.Add(new SqlParameter("@DONVITINH", congthuc.DVt));
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);
closeConnect();
return(dt);
}
catch
{
return(null);
}
}
public DataTable CongThuc_KtLuongNl(CongThucDTO congthuc, string soluong)
{
try
{
openConnect();
SqlCommand cmd = new SqlCommand("CONGTHUC_KTLUONGNL", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@SOLUONG", Convert.ToInt32(soluong)));
cmd.Parameters.Add(new SqlParameter("@MASANPHAM", congthuc.MaSp));
cmd.Parameters.Add(new SqlParameter("@MANGUYENLIEU", congthuc.MaNl));
cmd.Parameters.Add(new SqlParameter("@TIEUHAO", Convert.ToDouble(congthuc.TieuHao)));
cmd.Parameters.Add(new SqlParameter("@DONVITINH", congthuc.DVt));
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);
closeConnect();
return(dt);
}
catch
{
return(null);
}
}
public DataTable CongThuc_Delete(CongThucDTO congthuc)
{
return(congthuc_dal.CongThuc_Delete(congthuc));
}
public DataTable CongThuc_Insert(CongThucDTO congthuc)
{
return(congthuc_dal.CongThuc_Insert(congthuc));
}
public DataTable CongThuc_SelectAllMaSp(CongThucDTO congthuc)
{
return(congthuc_dal.CongThuc_SelectAllMaSp(congthuc));
}
