public int UpdateKH(Info.KhachHangInfo info)
{
cn.ExecuteNonQuery("SP_UPDATEKH",
new string[] { "@MAKH", "@CODEKH", "@MANHOM", "@TEN", "@TUOI", "@GIOITINH", "@MATINH", "@DIACHI", "@DIENTHOAI", "@CAPDO", "@MST", "@HANNO" },
new object[] { info.MAKH, info.CODEKH, info.MANHOM, info.TEN, info.TUOI, info.GIOITINH, info.MATINH, info.DIACHI, info.DIENTHOAI, info.CAPDO, info.MST, info.HanNo });
return(1);
}
public int DeleteKH(Info.KhachHangInfo info)
{
int id = cn.ExecuteNonQuery("sp_DeleteKH",
new string[] { "@MAKH" },
new object[] { info.MAKH });
return(id);
}
public int InsertKH(Info.KhachHangInfo info)
{
int id = cn.ExecuteInsert("SP_INSERTKH",
new string[] { "@CODEKH", "@MANHOM", "@TEN", "@TUOI", "@GIOITINH", "@MATINH", "@DIACHI", "@DIENTHOAI", "@CAPDO", "@MST", "@HANNO" },
new object[] { info.CODEKH, info.MANHOM, info.TEN, info.TUOI, info.GIOITINH, info.MATINH, info.DIACHI, info.DIENTHOAI, info.CAPDO, info.MST, info.HanNo });
return(id);
}
