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();
}
