public virtual System.Int32 Add(DanhMucItemData obj) { JDataAccess dao = new JDataAccess(ConnectionString); dao.SetCommandText(SP_DANHMUCITEM_INSERT, CommandType.StoredProcedure); dao.SetParameters(new IDataParameter[] { dao.CreateParameter("@ID", obj.ID), dao.CreateParameter("@MaLoaiDanhMuc", obj.MaLoaiDanhMuc), dao.CreateParameter("@MaDanhMuc", obj.MaDanhMuc), dao.CreateParameter("@TenDanhMuc", obj.TenDanhMuc), dao.CreateParameter("@MoTa", obj.MoTa), dao.CreateParameter("@ThuTu", obj.ThuTu), dao.CreateParameter("@IntVal1", obj.IntVal1), dao.CreateParameter("@IntVal2", obj.IntVal2), dao.CreateParameter("@IntVal3", obj.IntVal3), dao.CreateParameter("@DecVal1", obj.DecVal1), dao.CreateParameter("@DecVal2", obj.DecVal2), dao.CreateParameter("@DecVal3", obj.DecVal3), dao.CreateParameter("@StrVal1", obj.StrVal1), dao.CreateParameter("@StrVal2", obj.StrVal2), dao.CreateParameter("@StrVal3", obj.StrVal3), dao.CreateParameter("@Active", obj.Active) }); return(dao.SubmitChange()); }
public virtual System.Int32 Add(DanhMucData obj) { JDataAccess dao = new JDataAccess(ConnectionString); dao.SetCommandText(SP_DANHMUC_INSERT, CommandType.StoredProcedure); dao.SetParameters(new IDataParameter[]{ dao.CreateParameter("@MaLoaiDanhMuc", obj.MaLoaiDanhMuc), dao.CreateParameter("@TenLoaiDanhMuc", obj.TenLoaiDanhMuc), dao.CreateParameter("@ThuTu", obj.ThuTu), dao.CreateParameter("@System", obj.System) }); return dao.SubmitChange(); }
public virtual System.Int32 Change(DanhMucData obj) { JDataAccess dao = new JDataAccess(ConnectionString); dao.SetCommandText(SP_DANHMUC_UPDATE, CommandType.StoredProcedure); dao.SetParameters(new IDataParameter[] { dao.CreateParameter("@MaLoaiDanhMuc", obj.MaLoaiDanhMuc), dao.CreateParameter("@TenLoaiDanhMuc", obj.TenLoaiDanhMuc), dao.CreateParameter("@ThuTu", obj.ThuTu), dao.CreateParameter("@System", obj.System) }); return(dao.SubmitChange()); }
public virtual System.Int32 Add(SysGroupData obj) { JDataAccess dao = new JDataAccess(ConnectionString); dao.SetCommandText(SP_SYSGROUP_INSERT, CommandType.StoredProcedure); dao.SetParameters(new IDataParameter[]{ dao.CreateParameter("@ID", obj.ID), dao.CreateParameter("@ID_Creator", obj.ID_Creator), dao.CreateParameter("@Name", obj.Name), dao.CreateParameter("@Description", obj.Description), dao.CreateParameter("@Active", obj.Active) }); return dao.SubmitChange(); }
public virtual System.Int32 Change(SysGroupData obj) { JDataAccess dao = new JDataAccess(ConnectionString); dao.SetCommandText(SP_SYSGROUP_UPDATE, CommandType.StoredProcedure); dao.SetParameters(new IDataParameter[] { dao.CreateParameter("@ID", obj.ID), dao.CreateParameter("@ID_Creator", obj.ID_Creator), dao.CreateParameter("@Name", obj.Name), dao.CreateParameter("@Description", obj.Description), dao.CreateParameter("@Active", obj.Active) }); return(dao.SubmitChange()); }
public virtual System.Int32 Add(SysAccountData obj) { JDataAccess dao = new JDataAccess(ConnectionString); dao.SetCommandText(SP_SYSACCOUNT_INSERT, CommandType.StoredProcedure); dao.SetParameters(new IDataParameter[] { dao.CreateParameter("@ID", obj.ID), dao.CreateParameter("@Username", obj.Username), dao.CreateParameter("@Password", obj.Password), dao.CreateParameter("@RealName", obj.RealName), dao.CreateParameter("@Email", obj.Email), dao.CreateParameter("@ID_DonVis", obj.ID_DonVis), dao.CreateParameter("@LastAccess", obj.LastAccess), dao.CreateParameter("@Active", obj.Active), dao.CreateParameter("@AccountType", obj.AccountType), dao.CreateParameter("@Creator_ID", obj.Creator_ID), dao.CreateParameter("@ID_DonViGoc", obj.ID_DonViGoc), dao.CreateParameter("@IsUpdate", obj.IsUpdate) }); return(dao.SubmitChange()); }
public virtual System.Int32 Add(SysAccountData obj) { JDataAccess dao = new JDataAccess(ConnectionString); dao.SetCommandText(SP_SYSACCOUNT_INSERT, CommandType.StoredProcedure); dao.SetParameters(new IDataParameter[]{ dao.CreateParameter("@ID", obj.ID), dao.CreateParameter("@Username", obj.Username), dao.CreateParameter("@Password", obj.Password), dao.CreateParameter("@RealName", obj.RealName), dao.CreateParameter("@Email", obj.Email), dao.CreateParameter("@ID_DonVis", obj.ID_DonVis), dao.CreateParameter("@LastAccess", obj.LastAccess), dao.CreateParameter("@Active", obj.Active), dao.CreateParameter("@AccountType", obj.AccountType), dao.CreateParameter("@Creator_ID", obj.Creator_ID), dao.CreateParameter("@ID_DonViGoc", obj.ID_DonViGoc), dao.CreateParameter("@IsUpdate", obj.IsUpdate) }); return dao.SubmitChange(); }
public virtual System.Int32 Change(DanhMucItemData obj) { JDataAccess dao = new JDataAccess(ConnectionString); dao.SetCommandText(SP_DANHMUCITEM_UPDATE, CommandType.StoredProcedure); dao.SetParameters(new IDataParameter[]{ dao.CreateParameter("@ID", obj.ID), dao.CreateParameter("@MaLoaiDanhMuc", obj.MaLoaiDanhMuc), dao.CreateParameter("@MaDanhMuc", obj.MaDanhMuc), dao.CreateParameter("@TenDanhMuc", obj.TenDanhMuc), dao.CreateParameter("@MoTa", obj.MoTa), dao.CreateParameter("@ThuTu", obj.ThuTu), dao.CreateParameter("@IntVal1", obj.IntVal1), dao.CreateParameter("@IntVal2", obj.IntVal2), dao.CreateParameter("@IntVal3", obj.IntVal3), dao.CreateParameter("@DecVal1", obj.DecVal1), dao.CreateParameter("@DecVal2", obj.DecVal2), dao.CreateParameter("@DecVal3", obj.DecVal3), dao.CreateParameter("@StrVal1", obj.StrVal1), dao.CreateParameter("@StrVal2", obj.StrVal2), dao.CreateParameter("@StrVal3", obj.StrVal3), dao.CreateParameter("@Active", obj.Active) }); return dao.SubmitChange(); }