public bool Insert_GhiBan(GhiBan gb)
{
SqlParameter[] pa = new SqlParameter[5];
string ma = "BT";
int mabt = 0;
if (string.Compare(gb.Mabt, "") != 0)
{
mabt = int.Parse(gb.Mabt.Replace("BT", ""));
}
mabt++;
if (mabt < 10)
{
gb.Mabt = ma + "0" + mabt;
}
else
{
gb.Mabt = ma + mabt;
}
pa[0] = new SqlParameter("@mabt", gb.Mabt);
pa[1] = new SqlParameter("@matrd", gb.Matrd);
pa[2] = new SqlParameter("@mact", gb.Mact);
pa[3] = new SqlParameter("@thoidiem", gb.Thoidiem);
pa[4] = new SqlParameter("@ghichu", gb.Ghichu);
return SQLProvider.Execute_NonQuery("Insert_ghiban_1", pa);
}
public bool Update_GhiBan(GhiBan gb)
{
SqlParameter[] pa = new SqlParameter[5];
pa[0] = new SqlParameter("@mabt", gb.Mabt);
pa[1] = new SqlParameter("@matrd", gb.Matrd);
pa[2] = new SqlParameter("@mact", gb.Mact);
pa[3] = new SqlParameter("@thoidiem", gb.Thoidiem);
pa[4] = new SqlParameter("@ghichu", gb.Ghichu);
return SQLProvider.Execute_NonQuery("Update_ghiban_1", pa);
}
public bool Update_GhiBan(GhiBan gb)
{
return adapter_dsgb.Update_GhiBan(gb);
}
public bool Delete_GhiBan(GhiBan gb)
{
return adapter_dsgb.Delete_GhiBan(gb);
}
public bool Insert_GhiBan(GhiBan gb)
{
return adapter_dsgb.Insert_GhiBan(gb);
}
public bool Delete_GhiBan(GhiBan gb)
{
SqlParameter[] pa = new SqlParameter[1];
pa[0] = new SqlParameter("@mabt", gb.Mabt);
return SQLProvider.Execute_NonQuery("delete_ghiban_1", pa);
}