public void Insert(Core.Business.JointReviewFormsAdditional jointReviewFormsAdditional)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@FormID", SqlDbType.UniqueIdentifier, jointReviewFormsAdditional.FormID);
sql.AddParameter("@Name", SqlDbType.NVarChar, jointReviewFormsAdditional.Name);
sql.AddParameter("@Model", SqlDbType.NVarChar, jointReviewFormsAdditional.Model);
sql.AddParameter("@Nub", SqlDbType.Float, jointReviewFormsAdditional.Nub);
sql.AddParameter("@Price", SqlDbType.NVarChar, jointReviewFormsAdditional.Price);
sql.AddParameter("@Des", SqlDbType.NVarChar, jointReviewFormsAdditional.Des);
sql.AddOutputParameter("@Id", SqlDbType.UniqueIdentifier);
SqlDataReader reader = sql.ExecuteSPReader("usp_InsertJointReviewFormsAdditional");
if (reader != null && !reader.IsClosed && reader.Read())
{
if (!reader.IsDBNull(0)) jointReviewFormsAdditional.Id = reader.GetGuid(0);
reader.Close();
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public void Insert(Core.Business.UnitInfo unitInfo)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@Name", SqlDbType.NVarChar, unitInfo.Name);
sql.AddParameter("@SuperUnit", SqlDbType.UniqueIdentifier, unitInfo.SuperUnit);
sql.AddParameter("@Place", SqlDbType.NVarChar, unitInfo.Place);
sql.AddParameter("@UnitSign", SqlDbType.NVarChar, unitInfo.UnitSign);
sql.AddParameter("@UnitPostCode", SqlDbType.NVarChar, unitInfo.UnitPostCode);
sql.AddParameter("@UnitPhone", SqlDbType.NVarChar, unitInfo.UnitPhone);
sql.AddOutputParameter("@Code", SqlDbType.UniqueIdentifier);
SqlDataReader reader = sql.ExecuteSPReader("usp_InsertUnitInfo");
if (reader != null && !reader.IsClosed && reader.Read())
{
if (!reader.IsDBNull(0)) unitInfo.Id = reader.GetGuid(0);
reader.Close();
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public void Insert(Core.Business.VirtualLabDataSon virtualLabDataSon)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@Name", SqlDbType.NVarChar, virtualLabDataSon.Name);
sql.AddParameter("@Content", SqlDbType.NVarChar, virtualLabDataSon.Content);
sql.AddParameter("@AddTime", SqlDbType.DateTime, virtualLabDataSon.AddTime);
sql.AddParameter("@AddPerson", SqlDbType.NVarChar, virtualLabDataSon.AddPerson);
sql.AddParameter("@HasAnnex", SqlDbType.Int, virtualLabDataSon.HasAnnex);
sql.AddParameter("@frontID",SqlDbType.UniqueIdentifier,virtualLabDataSon.FrontID);
sql.AddOutputParameter("@ID", SqlDbType.UniqueIdentifier);
SqlDataReader reader = sql.ExecuteSPReader("usp_InsertVirtualLabDataSon");
if (reader != null && !reader.IsClosed && reader.Read())
{
if (!reader.IsDBNull(0)) virtualLabDataSon.Id = reader.GetGuid(0);
reader.Close();
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public void Insert(Core.Business.CommissionedCompletionRecord commissionedCompletionRecord)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@ApplicationID", SqlDbType.UniqueIdentifier, commissionedCompletionRecord.ApplicationID);
sql.AddParameter("@FillPerson", SqlDbType.UniqueIdentifier, commissionedCompletionRecord.FillPerson);
sql.AddParameter("@AchieveTime", SqlDbType.DateTime, commissionedCompletionRecord.AchieveTime);
sql.AddParameter("@SamplesNub", SqlDbType.Float, commissionedCompletionRecord.SamplesNub);
sql.AddParameter("@MachineTime", SqlDbType.Float, commissionedCompletionRecord.MachineTime);
sql.AddParameter("@Charges", SqlDbType.NVarChar, commissionedCompletionRecord.Charges);
sql.AddParameter("@FeesReceivable", SqlDbType.NVarChar, commissionedCompletionRecord.FeesReceivable);
sql.AddParameter("@ActualCharges", SqlDbType.NVarChar, commissionedCompletionRecord.ActualCharges);
sql.AddParameter("@Units", SqlDbType.UniqueIdentifier, commissionedCompletionRecord.Units);
sql.AddParameter("@FillTime", SqlDbType.DateTime, commissionedCompletionRecord.FillTime);
sql.AddOutputParameter("@Id", SqlDbType.UniqueIdentifier);
SqlDataReader reader = sql.ExecuteSPReader("usp_InsertCommissionedCompletionRecord");
if (reader != null && !reader.IsClosed && reader.Read())
{
if (!reader.IsDBNull(0)) commissionedCompletionRecord.Id = reader.GetGuid(0);
reader.Close();
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public void Insert(Core.Business.StimulationType stimulationType)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@StimulationId", SqlDbType.UniqueIdentifier, stimulationType.StimulationId);
sql.AddParameter("@StimulatedType", SqlDbType.Int, stimulationType.StimulatedType);
sql.AddParameter("@State", SqlDbType.Int, stimulationType.State);
sql.AddParameter("@ApplyingEndDate", SqlDbType.DateTime, stimulationType.ApplyingEndDate);
sql.AddParameter("@FirstChenEndDate", SqlDbType.DateTime, stimulationType.FirstChenEndDate);
sql.AddParameter("@SecondCheckEndDate", SqlDbType.DateTime, stimulationType.SecondCheckEndDate);
sql.AddParameter("@ExpertCheckEndDate", SqlDbType.DateTime, stimulationType.ExpertCheckEndDate);
sql.AddParameter("@Des",SqlDbType.NVarChar,stimulationType.Des);
sql.AddOutputParameter("@Id", SqlDbType.UniqueIdentifier);
SqlDataReader reader = sql.ExecuteSPReader("usp_InsertStimulationType");
if (reader != null && !reader.IsClosed && reader.Read())
{
if (!reader.IsDBNull(0)) stimulationType.Id = reader.GetGuid(0);
reader.Close();
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public void Insert(Core.Business.JointReview jointReview)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@InstrumentName", SqlDbType.NVarChar, jointReview.InstrumentName);
sql.AddParameter("@ApplicationUint", SqlDbType.NVarChar, jointReview.ApplicationUint);
sql.AddParameter("@ApplicationUintID", SqlDbType.UniqueIdentifier, jointReview.ApplicationUintID);
sql.AddParameter("@Corporate", SqlDbType.NVarChar, jointReview.Corporate);
sql.AddParameter("@ApplicaitionPerson", SqlDbType.UniqueIdentifier, jointReview.ApplicaitionPerson);
sql.AddParameter("@ApplicationTime", SqlDbType.DateTime, jointReview.ApplicationTime);
sql.AddParameter("@CreateTime", SqlDbType.DateTime, jointReview.CreateTime);
sql.AddParameter("@Status", SqlDbType.Int, jointReview.Status);
sql.AddParameter("@ApplicationDes", SqlDbType.NVarChar, jointReview.ApplicationDes);
sql.AddParameter("@AuditDes", SqlDbType.NVarChar, jointReview.AuditDes);
sql.AddOutputParameter("@Id", SqlDbType.UniqueIdentifier);
SqlDataReader reader = sql.ExecuteSPReader("usp_InsertJointReview");
if (reader != null && !reader.IsClosed && reader.Read())
{
if (!reader.IsDBNull(0)) jointReview.Id = reader.GetGuid(0);
reader.Close();
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public void Insert(Core.Business.FeePaying feePaying)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@AccountCode", SqlDbType.UniqueIdentifier, feePaying.AccountCode);
sql.AddParameter("@InsteadPersonCode", SqlDbType.UniqueIdentifier, feePaying.InsteadPersonCode);
sql.AddParameter("@InsteadPersonName", SqlDbType.NVarChar, feePaying.InsteadPersonName);
sql.AddParameter("@Limit", SqlDbType.Decimal, feePaying.Limit);
sql.AddParameter("@Mode", SqlDbType.NVarChar, feePaying.Mode);
sql.AddParameter("@PayDate", SqlDbType.DateTime, feePaying.PayDate);
sql.AddOutputParameter("@Code", SqlDbType.UniqueIdentifier);
SqlDataReader reader = sql.ExecuteSPReader("usp_InsertFeePaying");
if (reader != null && !reader.IsClosed && reader.Read())
{
if (!reader.IsDBNull(0)) feePaying.Id = reader.GetGuid(0);
reader.Close();
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public void Insert(Core.Business.NewsPhoto newsPhoto)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@Title", SqlDbType.NVarChar, newsPhoto.Title);
sql.AddParameter("@PhotoSrc", SqlDbType.NVarChar, newsPhoto.PhotoSrc);
sql.AddParameter("@Author", SqlDbType.NVarChar, newsPhoto.Author);
sql.AddParameter("@AddDate", SqlDbType.DateTime, newsPhoto.AddDate);
sql.AddParameter("@ContentUrl",SqlDbType.NVarChar,newsPhoto.ContentUrl);
sql.AddParameter("@Status", SqlDbType.Int, newsPhoto.Status);
sql.AddParameter("@ContentID", SqlDbType.UniqueIdentifier, newsPhoto.ContentID);
sql.AddOutputParameter("@Id", SqlDbType.UniqueIdentifier);
SqlDataReader reader = sql.ExecuteSPReader("usp_InsertNewsPhoto");
if (reader != null && !reader.IsClosed && reader.Read())
{
if (!reader.IsDBNull(0)) newsPhoto.Id = reader.GetGuid(0);
reader.Close();
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public void Insert(Core.Business.Account account)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@AccountId", SqlDbType.NVarChar, account.AccountId);
sql.AddParameter("@Remain", SqlDbType.Decimal, account.Remain);
sql.AddParameter("@ApplyDate", SqlDbType.DateTime, account.ApplyDate);
sql.AddParameter("@UserCode", SqlDbType.UniqueIdentifier, account.UserCode);
sql.AddParameter("@LimitOfCommon", SqlDbType.Decimal, account.LimitOfCommon);
sql.AddParameter("@PayTimeOfCommon", SqlDbType.DateTime, account.PayTimeOfCommon);
sql.AddParameter("@PayModeOfCommon", SqlDbType.NVarChar, account.PayModeOfCommon);
sql.AddOutputParameter("@Code", SqlDbType.UniqueIdentifier);
SqlDataReader reader = sql.ExecuteSPReader("usp_InsertAccount");
if (reader != null && !reader.IsClosed && reader.Read())
{
if (!reader.IsDBNull(0)) account.Id = reader.GetGuid(0);
reader.Close();
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public void Insert(Core.Business.JointReviewScoreTable jointReviewScoreTable)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@Joi_Id", SqlDbType.UniqueIdentifier, jointReviewScoreTable.Joi_Id);
sql.AddParameter("@JointReviewExpertsID", SqlDbType.UniqueIdentifier, jointReviewScoreTable.JointReviewExpertsID);
sql.AddParameter("@NeedUtilization", SqlDbType.Int, jointReviewScoreTable.NeedUtilization);
sql.AddParameter("@NeedDevelopment", SqlDbType.Int, jointReviewScoreTable.NeedDevelopment);
sql.AddParameter("@NeedExpected", SqlDbType.Int, jointReviewScoreTable.NeedExpected);
sql.AddParameter("@SharingForm", SqlDbType.Int, jointReviewScoreTable.SharingForm);
sql.AddParameter("@ApplicabilityPerformance", SqlDbType.Int, jointReviewScoreTable.ApplicabilityPerformance);
sql.AddParameter("@ApplicabilityConfiguration", SqlDbType.Int, jointReviewScoreTable.ApplicabilityConfiguration);
sql.AddParameter("@ManagementStaffing", SqlDbType.Int, jointReviewScoreTable.ManagementStaffing);
sql.AddParameter("@ManagementComplementary", SqlDbType.Int, jointReviewScoreTable.ManagementComplementary);
sql.AddParameter("@Budget", SqlDbType.Int, jointReviewScoreTable.Budget);
sql.AddParameter("@BudgetImplementation", SqlDbType.Int, jointReviewScoreTable.BudgetImplementation);
sql.AddParameter("@TotalScore", SqlDbType.Int, jointReviewScoreTable.TotalScore);
sql.AddOutputParameter("@Id", SqlDbType.UniqueIdentifier);
SqlDataReader reader = sql.ExecuteSPReader("usp_InsertJointReviewScoreTable");
if (reader != null && !reader.IsClosed && reader.Read())
{
if (!reader.IsDBNull(0)) jointReviewScoreTable.Id = reader.GetGuid(0);
reader.Close();
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public void Insert(Core.Business.SubCenterNote subCenterNote)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@SubCenterID", SqlDbType.UniqueIdentifier, subCenterNote.SubCenterID);
sql.AddParameter("@Title", SqlDbType.NVarChar, subCenterNote.Title);
sql.AddParameter("@Content", SqlDbType.NVarChar, subCenterNote.Content);
sql.AddParameter("@Annex", SqlDbType.UniqueIdentifier, subCenterNote.Annex);
sql.AddParameter("@Author", SqlDbType.NVarChar, subCenterNote.Author);
sql.AddParameter("@Addtime", SqlDbType.DateTime, subCenterNote.Addtime);
sql.AddOutputParameter("@Id", SqlDbType.UniqueIdentifier);
SqlDataReader reader = sql.ExecuteSPReader("usp_InsertSubCenterNote");
if (reader != null && !reader.IsClosed && reader.Read())
{
if (!reader.IsDBNull(0)) subCenterNote.Id = reader.GetGuid(0);
reader.Close();
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public void Insert(Core.Business.InstrumentCode instrumentCode)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddOutputParameter("@InstruId", SqlDbType.UniqueIdentifier);
SqlDataReader reader = sql.ExecuteSPReader("usp_InsertInstrumentCode");
if (reader != null && !reader.IsClosed && reader.Read())
{
if (!reader.IsDBNull(0)) instrumentCode.Id = reader.GetGuid(0);
reader.Close();
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public void Insert(Core.Business.AttainWayCode attainWayCode)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@Name", SqlDbType.NVarChar, attainWayCode.Name);
sql.AddOutputParameter("@Id", SqlDbType.UniqueIdentifier);
SqlDataReader reader = sql.ExecuteSPReader("usp_InsertAttainWayCode");
if (reader != null && !reader.IsClosed && reader.Read())
{
if (!reader.IsDBNull(0)) attainWayCode.Id = reader.GetGuid(0);
reader.Close();
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public void Insert(Core.Business.ActivitiesType activitiesType)
{
SqlServerUtility sql = new SqlServerUtility(connectionString);
sql.AddParameter("@Name", SqlDbType.NVarChar, activitiesType.Name);
sql.AddOutputParameter("@Id", SqlDbType.Int);
SqlDataReader reader = sql.ExecuteSPReader("usp_InsertActivitiesType");
if (reader != null && !reader.IsClosed && reader.Read())
{
if (!reader.IsDBNull(0)) activitiesType.Id = int.Parse(reader.GetInt32(0).ToString());
reader.Close();
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public void Insert(Core.Business.OperateSort operateSort)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@OperateSortName", SqlDbType.NVarChar, operateSort.OperateSortName);
sql.AddOutputParameter("@Id", SqlDbType.UniqueIdentifier);
SqlDataReader reader = sql.ExecuteSPReader("usp_InsertOperateSort");
if (reader != null && !reader.IsClosed && reader.Read())
{
if (!reader.IsDBNull(0)) operateSort.Id = reader.GetGuid(0);
reader.Close();
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public void Insert(Core.Business.STATUSMESSAGECODE sTATUSMESSAGECODE)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@StatusMessageNAME", SqlDbType.NVarChar, sTATUSMESSAGECODE.StatusMessageNAME);
sql.AddOutputParameter("@Id", SqlDbType.UniqueIdentifier);
SqlDataReader reader = sql.ExecuteSPReader("usp_InsertSTATUSMESSAGECODE");
if (reader != null && !reader.IsClosed && reader.Read())
{
if (!reader.IsDBNull(0)) sTATUSMESSAGECODE.Id = reader.GetGuid(0);
reader.Close();
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public void Insert(Core.Business.InstrumentProductedAreaClass instrumentProductedAreaClass)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@Name", SqlDbType.NVarChar, instrumentProductedAreaClass.Name);
sql.AddOutputParameter("@Id", SqlDbType.UniqueIdentifier);
SqlDataReader reader = sql.ExecuteSPReader("usp_InsertInstrumentProductedAreaClass");
if (reader != null && !reader.IsClosed && reader.Read())
{
if (!reader.IsDBNull(0)) instrumentProductedAreaClass.Id = reader.GetGuid(0);
reader.Close();
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public void Insert(Core.Business.UserEducation userEducation)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@EducationName", SqlDbType.NVarChar, userEducation.EducationName);
sql.AddOutputParameter("@EducationID", SqlDbType.UniqueIdentifier);
SqlDataReader reader = sql.ExecuteSPReader("usp_InsertUserEducation");
if (reader != null && !reader.IsClosed && reader.Read())
{
if (!reader.IsDBNull(0)) userEducation.Id = reader.GetGuid(0);
reader.Close();
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public void Insert(Core.Business.City city)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@Name", SqlDbType.NVarChar, city.Name);
sql.AddParameter("@ProvinceID", SqlDbType.UniqueIdentifier, city.ProvinceID);
sql.AddOutputParameter("@Id", SqlDbType.UniqueIdentifier);
SqlDataReader reader = sql.ExecuteSPReader("usp_InsertCity");
if (reader != null && !reader.IsClosed && reader.Read())
{
if (!reader.IsDBNull(0)) city.Id = reader.GetGuid(0);
reader.Close();
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public void Insert(Core.Business.ObjectStimulatedType objectStimulatedType)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@Name", SqlDbType.NVarChar, objectStimulatedType.Name);
sql.AddParameter("@Description", SqlDbType.NVarChar, objectStimulatedType.Description);
sql.AddOutputParameter("@Id", SqlDbType.Int);
SqlDataReader reader = sql.ExecuteSPReader("usp_InsertObjectStimulatedType");
if (reader != null && !reader.IsClosed && reader.Read())
{
if (!reader.IsDBNull(0)) objectStimulatedType.Id = int.Parse(reader.GetDecimal(0).ToString());
reader.Close();
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public void Insert(Core.Business.SysSetting sysSetting)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@Name", SqlDbType.NVarChar, sysSetting.Name);
sql.AddParameter("@SysValue", SqlDbType.NVarChar, sysSetting.SysValue);
sql.AddOutputParameter("@Id", SqlDbType.UniqueIdentifier);
SqlDataReader reader = sql.ExecuteSPReader("usp_InsertSysSetting");
if (reader != null && !reader.IsClosed && reader.Read())
{
if (!reader.IsDBNull(0)) sysSetting.Id = reader.GetGuid(0);
reader.Close();
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public void Insert(Core.Business.SubCenterPluginList subCenterPluginList)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@Name", SqlDbType.NVarChar, subCenterPluginList.Name);
sql.AddParameter("@URI", SqlDbType.NVarChar, subCenterPluginList.URI);
sql.AddOutputParameter("@Id", SqlDbType.UniqueIdentifier);
SqlDataReader reader = sql.ExecuteSPReader("usp_InsertSubCenterPluginList");
if (reader != null && !reader.IsClosed && reader.Read())
{
if (!reader.IsDBNull(0)) subCenterPluginList.Id = reader.GetGuid(0);
reader.Close();
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public void Insert(Core.Business.VirtualLabDataBigClass virtualLabDataBigClass)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@Name", SqlDbType.NVarChar, virtualLabDataBigClass.Name);
sql.AddParameter("@VirturlLabID", SqlDbType.UniqueIdentifier, virtualLabDataBigClass.VirturlLabID);
sql.AddOutputParameter("@ID", SqlDbType.UniqueIdentifier);
SqlDataReader reader = sql.ExecuteSPReader("usp_InsertVirtualLabDataBigClass");
if (reader != null && !reader.IsClosed && reader.Read())
{
if (!reader.IsDBNull(0)) virtualLabDataBigClass.Id = reader.GetGuid(0);
reader.Close();
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public void Insert(Core.Business.LinkClass linkClass)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@ClassName", SqlDbType.NVarChar, linkClass.ClassName);
sql.AddParameter("@Index", SqlDbType.Int, linkClass.Index);
sql.AddOutputParameter("@Id", SqlDbType.UniqueIdentifier);
SqlDataReader reader = sql.ExecuteSPReader("usp_InsertLinkClas");
if (reader != null && !reader.IsClosed && reader.Read())
{
if (!reader.IsDBNull(0)) linkClass.Id = reader.GetGuid(0);
reader.Close();
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public void Insert(Core.Business.UserInLab userInLab)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@LabID", SqlDbType.UniqueIdentifier, userInLab.LabID);
sql.AddParameter("@UserID", SqlDbType.UniqueIdentifier, userInLab.UserID);
sql.AddOutputParameter("@Id", SqlDbType.UniqueIdentifier);
SqlDataReader reader = sql.ExecuteSPReader("usp_InsertUserInLab");
if (reader != null && !reader.IsClosed && reader.Read())
{
if (!reader.IsDBNull(0)) userInLab.Id = reader.GetGuid(0);
reader.Close();
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public void Insert(Core.Business.Role role)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@Description", SqlDbType.NVarChar, role.Description);
sql.AddParameter("@UserCode", SqlDbType.UniqueIdentifier, role.UserCode);
sql.AddOutputParameter("@RoleId", SqlDbType.Int);
SqlDataReader reader = sql.ExecuteSPReader("usp_InsertRole");
if (reader != null && !reader.IsClosed && reader.Read())
{
if (!reader.IsDBNull(0)) role.Id = int.Parse(reader.GetDecimal(0).ToString());
reader.Close();
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public void Insert(Core.Business.JXTUserLevel jXTUserLevel)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@Name", SqlDbType.NVarChar, jXTUserLevel.Name);
sql.AddParameter("@Desc", SqlDbType.NVarChar, jXTUserLevel.Desc);
sql.AddOutputParameter("@Code", SqlDbType.Int);
SqlDataReader reader = sql.ExecuteSPReader("usp_InsertJXTUserLevel");
if (reader != null && !reader.IsClosed && reader.Read())
{
if (!reader.IsDBNull(0)) jXTUserLevel.Id = int.Parse(reader.GetDecimal(0).ToString());
reader.Close();
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public void Insert(Core.Business.VirtualLabInstrument virtualLabInstrument)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@ExperimentalID", SqlDbType.UniqueIdentifier, virtualLabInstrument.ExperimentalID);
sql.AddParameter("@InstrumentID", SqlDbType.UniqueIdentifier, virtualLabInstrument.InstrumentID);
sql.AddOutputParameter("@ID", SqlDbType.UniqueIdentifier);
SqlDataReader reader = sql.ExecuteSPReader("usp_InsertVirtualLabInstrument");
if (reader != null && !reader.IsClosed && reader.Read())
{
if (!reader.IsDBNull(0)) virtualLabInstrument.Id = reader.GetGuid(0);
reader.Close();
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public void Insert(Core.Business.QuestionDomain questionDomain)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@QuestionID", SqlDbType.UniqueIdentifier, questionDomain.QuestionID);
sql.AddParameter("@DomainID", SqlDbType.UniqueIdentifier, questionDomain.DomainID);
sql.AddOutputParameter("@Id", SqlDbType.UniqueIdentifier);
SqlDataReader reader = sql.ExecuteSPReader("usp_InsertQuestionDomain");
if (reader != null && !reader.IsClosed && reader.Read())
{
if (!reader.IsDBNull(0)) questionDomain.Id = reader.GetGuid(0);
reader.Close();
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public void Insert(Core.Business.StimulationExpertAssignment stimulationExpertAssignment)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@StimulationAppID", SqlDbType.UniqueIdentifier, stimulationExpertAssignment.StimulationAppID);
sql.AddParameter("@ExpertID", SqlDbType.UniqueIdentifier, stimulationExpertAssignment.ExpertID);
sql.AddOutputParameter("@Id", SqlDbType.UniqueIdentifier);
SqlDataReader reader = sql.ExecuteSPReader("usp_InsertStimulationExpertAssignment");
if (reader != null && !reader.IsClosed && reader.Read())
{
if (!reader.IsDBNull(0)) stimulationExpertAssignment.Id = reader.GetGuid(0);
reader.Close();
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}