/// <summary> /// 对象编辑 /// </summary> /// <param name="tMisMonitorQcEmptyBat_UpdateSet">UpdateSet用户对象</param> /// <param name="tMisMonitorQcEmptyBat_UpdateWhere">UpdateWhere用户对象</param> /// <returns>是否成功</returns> public bool Edit(TMisMonitorQcEmptyBatVo tMisMonitorQcEmptyBat_UpdateSet, TMisMonitorQcEmptyBatVo tMisMonitorQcEmptyBat_UpdateWhere) { string strSQL = SqlHelper.BuildUpdateExpress(tMisMonitorQcEmptyBat_UpdateSet, TMisMonitorQcEmptyBatVo.T_MIS_MONITOR_QC_EMPTY_BAT_TABLE); strSQL += this.BuildWhereStatement(tMisMonitorQcEmptyBat_UpdateWhere); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tMisMonitorQcEmptyBat">用户对象</param> /// <returns>是否成功</returns> public bool Edit(TMisMonitorQcEmptyBatVo tMisMonitorQcEmptyBat) { string strSQL = SqlHelper.BuildUpdateExpress(tMisMonitorQcEmptyBat, TMisMonitorQcEmptyBatVo.T_MIS_MONITOR_QC_EMPTY_BAT_TABLE); strSQL += string.Format(" where ID='{0}' ", tMisMonitorQcEmptyBat.ID); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 获取对象DataTable /// </summary> /// <param name="tMisMonitorQcEmptyBat">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public DataTable SelectByTable(TMisMonitorQcEmptyBatVo tMisMonitorQcEmptyBat, int iIndex, int iCount) { string strSQL = " select * from T_MIS_MONITOR_QC_EMPTY_BAT {0} "; strSQL = String.Format(strSQL, BuildWhereStatement(tMisMonitorQcEmptyBat)); return(SqlHelper.ExecuteDataTable(BuildPagerExpress(strSQL, iIndex, iCount))); }
/// <summary> /// 对象删除 /// </summary> /// <param name="Id">ID</param> /// <returns>是否成功</returns> public bool Delete(TMisMonitorQcEmptyBatVo tMisMonitorQcEmptyBat) { string strSQL = "delete from T_MIS_MONITOR_QC_EMPTY_BAT "; strSQL += this.BuildWhereStatement(tMisMonitorQcEmptyBat); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 对象删除 /// </summary> /// <param name="Id">ID</param> /// <returns>是否成功</returns> public bool Delete(TMisMonitorQcEmptyBatVo tMisMonitorQcEmptyBat) { return(access.Delete(tMisMonitorQcEmptyBat)); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tMisMonitorQcEmptyBat_UpdateSet">UpdateSet用户对象</param> /// <param name="tMisMonitorQcEmptyBat_UpdateWhere">UpdateWhere用户对象</param> /// <returns>是否成功</returns> public bool Edit(TMisMonitorQcEmptyBatVo tMisMonitorQcEmptyBat_UpdateSet, TMisMonitorQcEmptyBatVo tMisMonitorQcEmptyBat_UpdateWhere) { return(access.Edit(tMisMonitorQcEmptyBat_UpdateSet, tMisMonitorQcEmptyBat_UpdateWhere)); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tMisMonitorQcEmptyBat">用户对象</param> /// <returns>是否成功</returns> public bool Edit(TMisMonitorQcEmptyBatVo tMisMonitorQcEmptyBat) { return(access.Edit(tMisMonitorQcEmptyBat)); }
/// <summary> /// 对象添加 /// </summary> /// <param name="sysRole">对象</param> /// <returns>是否成功</returns> public bool Create(TMisMonitorQcEmptyBatVo tMisMonitorQcEmptyBat) { return(access.Create(tMisMonitorQcEmptyBat)); }
/// <summary> /// 对象添加 /// </summary> /// <param name="tMisMonitorQcEmptyBat">对象</param> /// <returns>是否成功</returns> public bool Create(TMisMonitorQcEmptyBatVo tMisMonitorQcEmptyBat) { string strSQL = SqlHelper.BuildInsertExpress(tMisMonitorQcEmptyBat, TMisMonitorQcEmptyBatVo.T_MIS_MONITOR_QC_EMPTY_BAT_TABLE); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 获取对象DataTable /// </summary> /// <param name="tMisMonitorQcEmptyBat">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public DataTable SelectByTable(TMisMonitorQcEmptyBatVo tMisMonitorQcEmptyBat, int iIndex, int iCount) { return(access.SelectByTable(tMisMonitorQcEmptyBat, iIndex, iCount)); }
/// <summary> /// 对象明细 /// </summary> /// <param name="tMisMonitorQcEmptyBat">对象条件</param> /// <returns>对象</returns> public TMisMonitorQcEmptyBatVo Details(TMisMonitorQcEmptyBatVo tMisMonitorQcEmptyBat) { return(access.Details(tMisMonitorQcEmptyBat)); }
/// <summary> /// 获取对象List /// </summary> /// <param name="tMisMonitorQcEmptyBat">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public List <TMisMonitorQcEmptyBatVo> SelectByObject(TMisMonitorQcEmptyBatVo tMisMonitorQcEmptyBat, int iIndex, int iCount) { string strSQL = String.Format("select * from T_MIS_MONITOR_QC_EMPTY_BAT " + this.BuildWhereStatement(tMisMonitorQcEmptyBat)); return(SqlHelper.ExecuteObjectList(tMisMonitorQcEmptyBat, BuildPagerExpress(strSQL, iIndex, iCount))); }
/// <summary> /// 对象明细 /// </summary> /// <param name="tMisMonitorQcEmptyBat">对象条件</param> /// <returns>对象</returns> public TMisMonitorQcEmptyBatVo Details(TMisMonitorQcEmptyBatVo tMisMonitorQcEmptyBat) { string strSQL = String.Format("select * from T_MIS_MONITOR_QC_EMPTY_BAT " + this.BuildWhereStatement(tMisMonitorQcEmptyBat)); return(SqlHelper.ExecuteObject(new TMisMonitorQcEmptyBatVo(), strSQL)); }
/// <summary> /// 获得查询结果总行数,用于分页 /// </summary> /// <param name="tMisMonitorQcEmptyBat">对象</param> /// <returns>返回行数</returns> public int GetSelectResultCount(TMisMonitorQcEmptyBatVo tMisMonitorQcEmptyBat) { string strSQL = "select Count(*) from T_MIS_MONITOR_QC_EMPTY_BAT " + this.BuildWhereStatement(tMisMonitorQcEmptyBat); return(Convert.ToInt32(SqlHelper.ExecuteScalar(strSQL))); }
/// <summary> /// 根据对象构造条件语句 /// </summary> /// <param name="tMisMonitorQcEmptyBat"></param> /// <returns></returns> public string BuildWhereStatement(TMisMonitorQcEmptyBatVo tMisMonitorQcEmptyBat) { StringBuilder strWhereStatement = new StringBuilder(" Where 1=1 "); if (null != tMisMonitorQcEmptyBat) { //ID if (!String.IsNullOrEmpty(tMisMonitorQcEmptyBat.ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND ID = '{0}'", tMisMonitorQcEmptyBat.ID.ToString())); } //空白批次 if (!String.IsNullOrEmpty(tMisMonitorQcEmptyBat.QC_EMPTY_IN_NUM.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND QC_EMPTY_IN_NUM = '{0}'", tMisMonitorQcEmptyBat.QC_EMPTY_IN_NUM.ToString())); } //空白测试日期 if (!String.IsNullOrEmpty(tMisMonitorQcEmptyBat.QC_EMPTY_IN_DATE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND QC_EMPTY_IN_DATE = '{0}'", tMisMonitorQcEmptyBat.QC_EMPTY_IN_DATE.ToString())); } //实验室空白个数 if (!String.IsNullOrEmpty(tMisMonitorQcEmptyBat.QC_EMPTY_IN_COUNT.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND QC_EMPTY_IN_COUNT = '{0}'", tMisMonitorQcEmptyBat.QC_EMPTY_IN_COUNT.ToString())); } //实验室空白值 if (!String.IsNullOrEmpty(tMisMonitorQcEmptyBat.QC_EMPTY_IN_RESULT.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND QC_EMPTY_IN_RESULT = '{0}'", tMisMonitorQcEmptyBat.QC_EMPTY_IN_RESULT.ToString())); } //相对偏差(%) if (!String.IsNullOrEmpty(tMisMonitorQcEmptyBat.QC_EMPTY_OFFSET.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND QC_EMPTY_OFFSET = '{0}'", tMisMonitorQcEmptyBat.QC_EMPTY_OFFSET.ToString())); } //空白是否合格 if (!String.IsNullOrEmpty(tMisMonitorQcEmptyBat.QC_EMPTY_ISOK.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND QC_EMPTY_ISOK = '{0}'", tMisMonitorQcEmptyBat.QC_EMPTY_ISOK.ToString())); } //备注1 if (!String.IsNullOrEmpty(tMisMonitorQcEmptyBat.REMARK1.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK1 = '{0}'", tMisMonitorQcEmptyBat.REMARK1.ToString())); } //备注2 if (!String.IsNullOrEmpty(tMisMonitorQcEmptyBat.REMARK2.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK2 = '{0}'", tMisMonitorQcEmptyBat.REMARK2.ToString())); } //备注3 if (!String.IsNullOrEmpty(tMisMonitorQcEmptyBat.REMARK3.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK3 = '{0}'", tMisMonitorQcEmptyBat.REMARK3.ToString())); } //备注4 if (!String.IsNullOrEmpty(tMisMonitorQcEmptyBat.REMARK4.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK4 = '{0}'", tMisMonitorQcEmptyBat.REMARK4.ToString())); } //备注5 if (!String.IsNullOrEmpty(tMisMonitorQcEmptyBat.REMARK5.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK5 = '{0}'", tMisMonitorQcEmptyBat.REMARK5.ToString())); } } return(strWhereStatement.ToString()); }
public TMisMonitorQcEmptyBatLogic(TMisMonitorQcEmptyBatVo _tMisMonitorQcEmptyBat) { tMisMonitorQcEmptyBat = _tMisMonitorQcEmptyBat; access = new TMisMonitorQcEmptyBatAccess(); }
/// <summary> /// 获得查询结果总行数,用于分页 /// </summary> /// <param name="tMisMonitorQcEmptyBat">对象</param> /// <returns>返回行数</returns> public int GetSelectResultCount(TMisMonitorQcEmptyBatVo tMisMonitorQcEmptyBat) { return(access.GetSelectResultCount(tMisMonitorQcEmptyBat)); }
/// <summary> /// 根据对象获取全部数据,用Table承载 /// 数据量较小时使用【不推荐】 /// </summary> /// <param name="tMisMonitorQcEmptyBat"></param> /// <returns></returns> public DataTable SelectByTable(TMisMonitorQcEmptyBatVo tMisMonitorQcEmptyBat) { string strSQL = "select * from T_MIS_MONITOR_QC_EMPTY_BAT " + this.BuildWhereStatement(tMisMonitorQcEmptyBat); return(SqlHelper.ExecuteDataTable(strSQL)); }
/// <summary> /// 获取对象List /// </summary> /// <param name="tMisMonitorQcEmptyBat">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public List <TMisMonitorQcEmptyBatVo> SelectByObject(TMisMonitorQcEmptyBatVo tMisMonitorQcEmptyBat, int iIndex, int iCount) { return(access.SelectByObject(tMisMonitorQcEmptyBat, iIndex, iCount)); }
/// <summary> /// 根据对象特征获取单一对象 /// </summary> /// <param name="tMisMonitorQcEmptyBat">对象</param> /// <returns></returns> public TMisMonitorQcEmptyBatVo SelectByObject(TMisMonitorQcEmptyBatVo tMisMonitorQcEmptyBat) { return(access.SelectByObject(tMisMonitorQcEmptyBat)); }
/// <summary> /// 根据对象获取全部数据,用Table承载 /// 数据量较小时使用【不推荐】 /// </summary> /// <param name="tMisMonitorQcEmptyBat"></param> /// <returns></returns> public DataTable SelectByTable(TMisMonitorQcEmptyBatVo tMisMonitorQcEmptyBat) { return(access.SelectByTable(tMisMonitorQcEmptyBat)); }
/// <summary> /// 保存质控数据 /// </summary> /// <returns></returns> public string saveQcValue() { bool isSuccess = false; if (this.hidQC_TYPE.Value == "5") { //空白数据 string strEmptyValue1 = Request["QC_EMPTY_IN_VALUE1"] == "" ? "0" : Request["QC_EMPTY_IN_VALUE1"].ToString(); string strEmptyValue2 = Request["QC_EMPTY_IN_VALUE2"] == "" ? "0" : Request["QC_EMPTY_IN_VALUE2"].ToString(); string strEmptyValue3 = Request["QC_EMPTY_IN_VALUE3"] == "" ? "0" : Request["QC_EMPTY_IN_VALUE3"].ToString(); string strEmptyValue = Request["QC_EMPTY_IN_RESULT"] == "" ? "0" : Request["QC_EMPTY_IN_RESULT"].ToString(); string strEmptyCount = this.dEmptyCount.Value.Trim() == "" ? "0" : this.dEmptyCount.Value.Trim(); TMisMonitorQcEmptyBatVo QcEmptyBatVo = new TMisMonitorQcEmptyBatVo(); QcEmptyBatVo.ID = this.hidID.Value; QcEmptyBatVo.QC_EMPTY_IN_RESULT = strEmptyValue; QcEmptyBatVo.REMARK1 = strEmptyValue1; QcEmptyBatVo.REMARK2 = strEmptyValue2; QcEmptyBatVo.REMARK3 = strEmptyValue3; QcEmptyBatVo.QC_EMPTY_IN_COUNT = strEmptyCount; isSuccess = new TMisMonitorQcEmptyBatLogic().Edit(QcEmptyBatVo); } if (this.hidQC_TYPE.Value == "8") { //标准样数据 string strSRC_IN_VALUE1 = Request["SRC_IN_VALUE1"] == "" ? "0" : Request["SRC_IN_VALUE1"].ToString(); string strSRC_IN_VALUE2 = Request["SRC_IN_VALUE2"] == "" ? "0" : Request["SRC_IN_VALUE2"].ToString(); string strSRC_IN_VALUE3 = Request["SRC_IN_VALUE3"] == "" ? "0" : Request["SRC_IN_VALUE3"].ToString(); string strStResult = this.dSrcCount.Value.Trim() == "" ? "0" : this.dSrcCount.Value.Trim(); TMisMonitorQcStVo QcStVo = new TMisMonitorQcStVo(); QcStVo.ID = this.hidID.Value; QcStVo.REMARK1 = strSRC_IN_VALUE1; QcStVo.REMARK2 = strSRC_IN_VALUE2; QcStVo.REMARK3 = strSRC_IN_VALUE3; QcStVo.ST_RESULT = strStResult; isSuccess = new TMisMonitorQcStLogic().Edit(QcStVo); } if (this.hidQC_TYPE.Value == "6") { //实验室加标数据 string strAddResultEx = Request["ADD_RESULT_EX"] == "" ? "0" : Request["ADD_RESULT_EX"].ToString(); string strQcAdd = Request["QC_ADD"] == "" ? "0" : Request["QC_ADD"].ToString(); string strAddBack = Request["ADD_BACK"] == "" ? "0" : Request["ADD_BACK"].ToString(); TMisMonitorQcAddVo QcAddVo = new TMisMonitorQcAddVo(); QcAddVo.ID = this.hidID.Value; QcAddVo.ADD_RESULT_EX = strAddResultEx; QcAddVo.QC_ADD = strQcAdd; QcAddVo.ADD_BACK = strAddBack; isSuccess = new TMisMonitorQcAddLogic().Edit(QcAddVo); } if (this.hidQC_TYPE.Value == "7") { //实验室明码平行 string strTwinResult1 = Request["TWIN_RESULT1"] == "" ? "0" : Request["TWIN_RESULT1"].ToString(); string strTwinResult2 = Request["TWIN_RESULT2"] == "" ? "0" : Request["TWIN_RESULT2"].ToString(); string strTwinAvg = Request["TWIN_AVG"] == "" ? "0" : Request["TWIN_AVG"].ToString(); string strTwinOffSet = Request["TWIN_OFFSET"] == "" ? "0" : Request["TWIN_OFFSET"].ToString(); TMisMonitorQcTwinVo QcTwinVo = new TMisMonitorQcTwinVo(); QcTwinVo.ID = this.hidID.Value; QcTwinVo.TWIN_RESULT1 = strTwinResult1; QcTwinVo.TWIN_RESULT2 = strTwinResult2; QcTwinVo.TWIN_AVG = strTwinAvg; QcTwinVo.TWIN_OFFSET = strTwinOffSet; isSuccess = new TMisMonitorQcTwinLogic().Edit(QcTwinVo); if (isSuccess) { TMisMonitorResultVo ResultVo = new TMisMonitorResultVo(); ResultVo.ID = this.hidSrcResultID.Value; ResultVo.ITEM_RESULT = strTwinAvg; isSuccess = new TMisMonitorResultLogic().Edit(ResultVo); } } return(isSuccess == true ? "1" : "0"); }