public static void ThemBaoCao(BC_DOANHSO baoCao)
{
DataAccessHelper db = new DataAccessHelper();
SqlCommand cmd = db.Command("THEMBCDS");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MABC", baoCao.MaBaoCaoDoanhSo);
cmd.Parameters.AddWithValue("@THANG", baoCao.Thang);
cmd.Parameters.AddWithValue("@NAM", baoCao.Nam);
SqlDataAdapter da = new SqlDataAdapter(cmd);
db.dt = new DataTable();
da.Fill(db.dt);
}
public static string GetMaBaoCao(int thang, int nam)
{
DataAccessHelper db = new DataAccessHelper();
SqlCommand cmd = db.Command("GETBAOCAODOANHSO");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@THANG", thang);
cmd.Parameters.AddWithValue("@NAM", nam);
SqlDataAdapter da = new SqlDataAdapter(cmd);
db.dt = new DataTable();
da.Fill(db.dt);
foreach (DataRow row in db.dt.Rows)
{
return(row.ItemArray[0].ToString());
}
return("");
}