public int UpdateQC(Info.QuyCachInfo info) { cn.ExecuteNonQuery("usp_UpdateQUYCACH", new string[] { "@MA", "@TEN", "@SLDVT", "@TINHTRANG", "@MA_DONVI_LO " }, new object[] { info.Ma, info.Ten, info.Sldv, info.TinhTrang, info.DVTLo }); return(1); }
public int DeleteQC(Info.QuyCachInfo info) { int id = cn.ExecuteNonQuery("sp_DeleteQuyCach", new string[] { "@MA" }, new object[] { info.Ma }); return(id); }
public int InsertQC(Info.QuyCachInfo info) { int id = cn.ExecuteInsert("SP_INSERTQuyCach", new string[] { "@TEN", "@SLDVT", "@DVTLo", "@TINHTRANG" }, new object[] { info.Ten, info.Sldv, info.DVTLo, info.TinhTrang }); return(id); }