/// <summary> /// 对象编辑 /// </summary> /// <param name="tBaseApparatusInfo">用户对象</param> /// <returns>是否成功</returns> public bool Edit(TBaseApparatusInfoVo tBaseApparatusInfo) { string strSQL = SqlHelper.BuildUpdateExpress(tBaseApparatusInfo, TBaseApparatusInfoVo.T_BASE_APPARATUS_INFO_TABLE); strSQL += string.Format(" where ID='{0}' ", tBaseApparatusInfo.ID); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 获取对象DataTable /// </summary> /// <param name="tBaseApparatusInfo">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public DataTable SelectByTable(TBaseApparatusInfoVo tBaseApparatusInfo, int iIndex, int iCount) { string strSQL = " select * from T_BASE_APPARATUS_INFO {0} "; strSQL = String.Format(strSQL, BuildWhereStatement(tBaseApparatusInfo)); return(SqlHelper.ExecuteDataTable(BuildPagerExpress(tBaseApparatusInfo, strSQL, iIndex, iCount))); }
/// <summary> /// 自定义查询 Create By Castle(胡方扬) 2012-11-19 /// </summary> /// <param name="tBaseApparatusInfo">对象</param> /// <param name="iIndex">起始页</param> /// <param name="iCount">条数</param> /// <returns></returns> public DataTable SelectDefinedTadble(TBaseApparatusInfoVo tBaseApparatusInfo, int iIndex, int iCount) { string strSQL = String.Format("SELECT * FROM T_BASE_APPARATUS_INFO WHERE IS_DEL='{0}'", tBaseApparatusInfo.IS_DEL); if (!String.IsNullOrEmpty(tBaseApparatusInfo.APPARATUS_CODE)) { strSQL += String.Format(" AND APPARATUS_CODE LIKE '%{0}%'", tBaseApparatusInfo.APPARATUS_CODE); } if (!String.IsNullOrEmpty(tBaseApparatusInfo.NAME)) { strSQL += String.Format(" AND NAME LIKE '%{0}%'", tBaseApparatusInfo.NAME); } if (!String.IsNullOrEmpty(tBaseApparatusInfo.MODEL)) { strSQL += String.Format(" AND MODEL LIKE '%{0}%'", tBaseApparatusInfo.MODEL); } if (!String.IsNullOrEmpty(tBaseApparatusInfo.FITTINGS_PROVIDER)) { strSQL += String.Format(" AND FITTINGS_PROVIDER LIKE '%{0}%'", tBaseApparatusInfo.FITTINGS_PROVIDER); } return(SqlHelper.ExecuteDataTable(BuildPagerExpress(tBaseApparatusInfo, strSQL, iIndex, iCount))); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tBaseApparatusInfo_UpdateSet">UpdateSet用户对象</param> /// <param name="tBaseApparatusInfo_UpdateWhere">UpdateWhere用户对象</param> /// <returns>是否成功</returns> public bool Edit(TBaseApparatusInfoVo tBaseApparatusInfo_UpdateSet, TBaseApparatusInfoVo tBaseApparatusInfo_UpdateWhere) { string strSQL = SqlHelper.BuildUpdateExpress(tBaseApparatusInfo_UpdateSet, TBaseApparatusInfoVo.T_BASE_APPARATUS_INFO_TABLE); strSQL += this.BuildWhereStatement(tBaseApparatusInfo_UpdateWhere); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 获取自定义查询结果总数 Create By Castle(胡方扬) 2012-11-19 /// </summary> /// <param name="tBaseApparatusInfo">对象</param> /// <returns></returns> public int GetSelecDefinedtResultCount(TBaseApparatusInfoVo tBaseApparatusInfo) { string strSQL = String.Format("SELECT * FROM T_BASE_APPARATUS_INFO WHERE IS_DEL='{0}'", tBaseApparatusInfo.IS_DEL); if (!String.IsNullOrEmpty(tBaseApparatusInfo.APPARATUS_CODE)) { strSQL += String.Format(" AND APPARATUS_CODE LIKE '%{0}%'", tBaseApparatusInfo.APPARATUS_CODE); } if (!String.IsNullOrEmpty(tBaseApparatusInfo.NAME)) { strSQL += String.Format(" AND NAME LIKE '%{0}%'", tBaseApparatusInfo.NAME); } if (!String.IsNullOrEmpty(tBaseApparatusInfo.MODEL)) { strSQL += String.Format(" AND MODEL LIKE '%{0}%'", tBaseApparatusInfo.MODEL); } if (!String.IsNullOrEmpty(tBaseApparatusInfo.FITTINGS_PROVIDER)) { strSQL += String.Format(" AND FITTINGS_PROVIDER LIKE '%{0}%'", tBaseApparatusInfo.FITTINGS_PROVIDER); } return(SqlHelper.ExecuteDataTable(strSQL).Rows.Count); }
/// <summary> /// 增加数据 /// </summary> /// <returns></returns> public string frmAdd() { bool isSuccess = false; TBaseApparatusInfoVo TBaseApparatusInfoVo = autoBindRequest(Request, new TBaseApparatusInfoVo()); TBaseApparatusInfoVo.ID = GetSerialNumber("Apparatus_Id"); TBaseApparatusInfoVo.IS_DEL = "0"; TBaseApparatusInfoVo iApparatusInfoVo = new TBaseApparatusInfoVo(); iApparatusInfoVo.APPARATUS_CODE = TBaseApparatusInfoVo.APPARATUS_CODE; iApparatusInfoVo.IS_DEL = "0"; iApparatusInfoVo = new TBaseApparatusInfoLogic().Details(iApparatusInfoVo); if (iApparatusInfoVo.ID.Length > 0) { isSuccess = false; } else { isSuccess = new TBaseApparatusInfoLogic().Create(TBaseApparatusInfoVo); if (isSuccess) { WriteLog(i3.ValueObject.ObjectBase.LogType.AddApparatusInfo, "", LogInfo.UserInfo.USER_NAME + "添加仪器信息" + TBaseApparatusInfoVo.ID + "成功!"); } } return(isSuccess == true ? "1" : "0"); }
/// <summary> /// 获取仪器信息 /// </summary> /// <returns></returns> private string getApparatusInfo() { int intTotalCount = 0; DataTable dt = new DataTable(); string strSortname = Request.Params["sortname"]; string strSortorder = Request.Params["sortorder"]; //当前页面 int intPageIndex = Convert.ToInt32(Request.Params["page"]); //每页记录数 int intPageSize = Convert.ToInt32(Request.Params["pagesize"]); TBaseApparatusInfoVo TBaseApparatusInfoVo = new TBaseApparatusInfoVo(); TBaseApparatusInfoVo.IS_DEL = "0"; TBaseApparatusInfoVo.SORT_FIELD = strSortname; TBaseApparatusInfoVo.SORT_TYPE = strSortorder; //自定义查询使用 TBaseApparatusInfoVo.APPARATUS_CODE = !String.IsNullOrEmpty(Request.Params["srhApparatus_Code"]) ? Request.Params["srhApparatus_Code"].ToString() : ""; TBaseApparatusInfoVo.NAME = !String.IsNullOrEmpty(Request.Params["srh_Name"]) ? Request.Params["srh_Name"].ToString() : "";; TBaseApparatusInfoVo.MODEL = !String.IsNullOrEmpty(Request.Params["srh_Model"]) ? Request.Params["srh_Model"].ToString() : "";; TBaseApparatusInfoVo.FITTINGS_PROVIDER = !String.IsNullOrEmpty(Request.Params["srhProvider"]) ? Request.Params["srhProvider"].ToString() : "";; intTotalCount = new TBaseApparatusInfoLogic().GetSelecDefinedtResultCount(TBaseApparatusInfoVo); dt = new TBaseApparatusInfoLogic().SelectDefinedTadble(TBaseApparatusInfoVo, intPageIndex, intPageSize); string strJson = CreateToJson(dt, intTotalCount); return(strJson); }
/// <summary> /// 获取仪器信息 /// </summary> /// <returns></returns> private string getApparatusWarn() { int intTotalCount = 0; DataTable dt = new DataTable(); string strSortname = Request.Params["sortname"]; string strSortorder = Request.Params["sortorder"]; //当前页面 int intPageIndex = Convert.ToInt32(Request.Params["page"]); //每页记录数 int intPageSize = Convert.ToInt32(Request.Params["pagesize"]); TBaseApparatusInfoVo TBaseApparatusInfoVo = new TBaseApparatusInfoVo(); TBaseApparatusInfoVo.IS_DEL = "0"; TBaseApparatusInfoVo.SORT_FIELD = strSortname; TBaseApparatusInfoVo.SORT_TYPE = strSortorder; string strAction = Request.Params["action"]; if (strAction == "ident") { //检定报警 dt = new TBaseApparatusInfoLogic().SelectByTable(TBaseApparatusInfoVo, intPageIndex, intPageSize, 2, 1); intTotalCount = new TBaseApparatusInfoLogic().GetSelectResultCount(TBaseApparatusInfoVo, 2, 1); } else { //报废报警 dt = new TBaseApparatusInfoLogic().SelectByTable(TBaseApparatusInfoVo, intPageIndex, intPageSize, 2); intTotalCount = dt.Rows.Count; } string strJson = CreateToJson(dt, intTotalCount); return(strJson); }
/// <summary> /// 对象删除 /// </summary> /// <param name="Id">ID</param> /// <returns>是否成功</returns> public bool Delete(TBaseApparatusInfoVo tBaseApparatusInfo) { string strSQL = "delete from T_BASE_APPARATUS_INFO "; strSQL += this.BuildWhereStatement(tBaseApparatusInfo); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 加载数据 /// </summary> /// <returns></returns> public string frmLoadData() { TBaseApparatusInfoVo TBaseApparatusInfoVo = new TBaseApparatusInfoVo(); TBaseApparatusInfoVo.ID = Request["id"].ToString(); TBaseApparatusInfoVo.IS_DEL = "0"; TBaseApparatusInfoVo TBaseApparatusInfoVoTemp = new TBaseApparatusInfoLogic().Details(TBaseApparatusInfoVo); return(ToJson(TBaseApparatusInfoVoTemp)); }
/// <summary> /// 修改数据 /// </summary> /// <returns></returns> public string frmUpdate() { TBaseApparatusInfoVo TBaseApparatusInfoVo = autoBindRequest(Request, new TBaseApparatusInfoVo()); TBaseApparatusInfoVo.ID = Request["id"].ToString(); TBaseApparatusInfoVo.IS_DEL = "0"; bool isSuccess = new TBaseApparatusInfoLogic().Edit(TBaseApparatusInfoVo); if (isSuccess) { WriteLog(i3.ValueObject.ObjectBase.LogType.EditApparatusInfo, "", LogInfo.UserInfo.USER_NAME + "修改仪器信息" + TBaseApparatusInfoVo.ID + "成功!"); } return(isSuccess == true ? "1" : "0"); }
/// <summary> /// 获取对象DataTable Create By weilin 2013-07-24 /// </summary> /// <param name="tBaseApparatusInfo">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <param name="intIsMonth">1,按月,本月要报废;2,按季度,本季度要报废;3,提前一个月要报废;</param> /// <returns>返回结果</returns> public DataTable SelectByTable(TBaseApparatusInfoVo tBaseApparatusInfo, int iIndex, int iCount, int intIsMonth) { string strStartTime = ""; string strEndTime = ""; GetEndTime(intIsMonth, ref strStartTime, ref strEndTime); string strSQL = " select *"; strSQL += ",case when SCRAP_TIME < '{1}' then '1' else '0' end as is_SCRAP_TIME"; strSQL += " from T_BASE_APPARATUS_INFO {0} "; strSQL = String.Format(strSQL, BuildWhereStatement(tBaseApparatusInfo) + " and SCRAP_TIME < '" + strEndTime + "'", strEndTime); return(SqlHelper.ExecuteDataTable(BuildPagerExpress(strSQL, iIndex, iCount))); }
public static string deleteApparatusInfo(string strValue) { TBaseApparatusInfoVo TBaseApparatusInfoVo = new TBaseApparatusInfoVo(); TBaseApparatusInfoVo.ID = strValue; TBaseApparatusInfoVo.IS_DEL = "1"; bool isSuccess = new TBaseApparatusInfoLogic().Edit(TBaseApparatusInfoVo); if (isSuccess) { new i3.View.PageBase().WriteLog(i3.ValueObject.ObjectBase.LogType.DelApparatusInfo, "", new i3.View.PageBase().LogInfo.UserInfo.USER_NAME + "删除仪器信息" + TBaseApparatusInfoVo.ID + "成功!"); } return(isSuccess == true ? "1" : "0"); }
protected void btnImport_Click(object sender, EventArgs e) { bool isSuccess = false; if (this.importFiles.PostedFile.ContentLength <= 0) { return; } Stream stream = this.importFiles.FileContent; HSSFWorkbook hssfworkbook = new HSSFWorkbook(stream); ISheet sheet = hssfworkbook.GetSheet("Sheet1"); string strSql = ""; ArrayList list = new ArrayList(); DataTable dt = RenderFromExcel(sheet, 0); TBaseApparatusInfoVo tav = new TBaseApparatusInfoVo(); //string[] strArr; for (int i = 0; i < dt.Rows.Count; i++) { tav.ID = GetSerialNumber("Apparatus_Id"); //ID tav.IS_DEL = "0"; //是否删除 0=否,1=是 tav.APPARATUS_CODE = dt.Rows[i + 2][0].ToString().Trim(); //仪器编号 tav.NAME = dt.Rows[i + 2][1].ToString().Trim(); //仪器名称 tav.MODEL = dt.Rows[i + 2][3].ToString().Trim(); //型号规格 tav.MEASURING_RANGE = dt.Rows[i + 2][4].ToString().Trim(); //测量范围 tav.EXPANDED_UNCETAINTY = dt.Rows[i + 2][5].ToString().Trim(); //不确定度 tav.FITTINGS_PROVIDER = dt.Rows[i + 2][6].ToString().Trim(); //供应商 tav.SERIAL_NO = dt.Rows[i + 2][7].ToString().Trim(); //出厂编号 tav.BUY_TIME = dt.Rows[i + 2][8].ToString().Trim(); //购买时间 tav.REMARK2 = dt.Rows[i + 2][9].ToString().Trim(); //金额 tav.POSITION = dt.Rows[i + 2][10].ToString().Trim(); //放置地点(新地点) tav.REMARK3 = dt.Rows[i + 2][11].ToString().Trim(); //放置地点(旧地点) new TBaseApparatusInfoLogic().Create(tav); } labMsg.Text = "导入成功!!!!!!!!!!!!!!!!!!"; }
/// <summary> /// 根据对象构造条件语句 /// </summary> /// <param name="tBaseApparatusInfo"></param> /// <param name="intIsMonth">1,按月,本月要检定;2,按季度,本季度要检定;3,提前一个月要检定;</param> /// <param name="intSrcType">1,全部;2,仅检定/校准时间;3,仅期间核查时间;</param> /// <returns></returns> public string BuildWhereStatementEx(TBaseApparatusInfoVo tBaseApparatusInfo, int intIsMonth, int intSrcType) { StringBuilder strWhereStatement = new StringBuilder(" Where 1=1 "); if (null != tBaseApparatusInfo) { #region other srh condiction //ID if (!String.IsNullOrEmpty(tBaseApparatusInfo.ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND ID = '{0}'", tBaseApparatusInfo.ID.ToString())); } //仪器编号 if (!String.IsNullOrEmpty(tBaseApparatusInfo.APPARATUS_CODE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND APPARATUS_CODE = '{0}'", tBaseApparatusInfo.APPARATUS_CODE.ToString())); } //档案类别 if (!String.IsNullOrEmpty(tBaseApparatusInfo.ARCHIVES_TYPE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND ARCHIVES_TYPE = '{0}'", tBaseApparatusInfo.ARCHIVES_TYPE.ToString())); } //类别1(辅助,非辅助) if (!String.IsNullOrEmpty(tBaseApparatusInfo.SORT1.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND SORT1 = '{0}'", tBaseApparatusInfo.SORT1.ToString())); } //类别2(l流量计,离子计,汽车尾气.......) if (!String.IsNullOrEmpty(tBaseApparatusInfo.SORT2.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND SORT2 = '{0}'", tBaseApparatusInfo.SORT2.ToString())); } //所属仪器或者项目 if (!String.IsNullOrEmpty(tBaseApparatusInfo.BELONG_TO.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND BELONG_TO = '{0}'", tBaseApparatusInfo.BELONG_TO.ToString())); } //仪器名称 if (!String.IsNullOrEmpty(tBaseApparatusInfo.NAME.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND NAME = '{0}'", tBaseApparatusInfo.NAME.ToString())); } //规格型号 if (!String.IsNullOrEmpty(tBaseApparatusInfo.MODEL.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND MODEL = '{0}'", tBaseApparatusInfo.MODEL.ToString())); } //出厂编号 if (!String.IsNullOrEmpty(tBaseApparatusInfo.SERIAL_NO.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND SERIAL_NO = '{0}'", tBaseApparatusInfo.SERIAL_NO.ToString())); } //仪器供应商 if (!String.IsNullOrEmpty(tBaseApparatusInfo.APPARATUS_PROVIDER.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND APPARATUS_PROVIDER = '{0}'", tBaseApparatusInfo.APPARATUS_PROVIDER.ToString())); } //配件供应商 if (!String.IsNullOrEmpty(tBaseApparatusInfo.FITTINGS_PROVIDER.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND FITTINGS_PROVIDER = '{0}'", tBaseApparatusInfo.FITTINGS_PROVIDER.ToString())); } //仪器供应商网址 if (!String.IsNullOrEmpty(tBaseApparatusInfo.WEB_SITE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND WEB_SITE = '{0}'", tBaseApparatusInfo.WEB_SITE.ToString())); } //仪器性能(合格,一级合格,正常) if (!String.IsNullOrEmpty(tBaseApparatusInfo.CAPABILITY.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND CAPABILITY = '{0}'", tBaseApparatusInfo.CAPABILITY.ToString())); } //联系人 if (!String.IsNullOrEmpty(tBaseApparatusInfo.LINK_MAN.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND LINK_MAN = '{0}'", tBaseApparatusInfo.LINK_MAN.ToString())); } //联系电话 if (!String.IsNullOrEmpty(tBaseApparatusInfo.LINK_PHONE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND LINK_PHONE = '{0}'", tBaseApparatusInfo.LINK_PHONE.ToString())); } //邮编 if (!String.IsNullOrEmpty(tBaseApparatusInfo.POST.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND POST = '{0}'", tBaseApparatusInfo.POST.ToString())); } //联系地址 if (!String.IsNullOrEmpty(tBaseApparatusInfo.ADDRESS.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND ADDRESS = '{0}'", tBaseApparatusInfo.ADDRESS.ToString())); } //量值溯源方式(校准、自校、检定) if (!String.IsNullOrEmpty(tBaseApparatusInfo.CERTIFICATE_TYPE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND CERTIFICATE_TYPE = '{0}'", tBaseApparatusInfo.CERTIFICATE_TYPE.ToString())); } //溯源结果(合格,不合格) if (!String.IsNullOrEmpty(tBaseApparatusInfo.TRACE_RESULT.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND TRACE_RESULT = '{0}'", tBaseApparatusInfo.TRACE_RESULT.ToString())); } //检定方式(不检,来检,送检,暂不能检,不详) if (!String.IsNullOrEmpty(tBaseApparatusInfo.TEST_MODE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND TEST_MODE = '{0}'", tBaseApparatusInfo.TEST_MODE.ToString())); } //校正周期 if (!String.IsNullOrEmpty(tBaseApparatusInfo.VERIFY_CYCLE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND VERIFY_CYCLE = '{0}'", tBaseApparatusInfo.VERIFY_CYCLE.ToString())); } //使用科室 if (!String.IsNullOrEmpty(tBaseApparatusInfo.DEPT.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND DEPT = '{0}'", tBaseApparatusInfo.DEPT.ToString())); } //保管人 if (!String.IsNullOrEmpty(tBaseApparatusInfo.KEEPER.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND KEEPER = '{0}'", tBaseApparatusInfo.KEEPER.ToString())); } //放置地点 if (!String.IsNullOrEmpty(tBaseApparatusInfo.POSITION.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND POSITION = '{0}'", tBaseApparatusInfo.POSITION.ToString())); } //使用状况(在用,未用) if (!String.IsNullOrEmpty(tBaseApparatusInfo.STATUS.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND STATUS = '{0}'", tBaseApparatusInfo.STATUS.ToString())); } //档案上传地址 if (!String.IsNullOrEmpty(tBaseApparatusInfo.ARCHIVES_ADDRESS.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND ARCHIVES_ADDRESS = '{0}'", tBaseApparatusInfo.ARCHIVES_ADDRESS.ToString())); } //最近检定/校准时间 if (!String.IsNullOrEmpty(tBaseApparatusInfo.BEGIN_TIME.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND BEGIN_TIME = '{0}'", tBaseApparatusInfo.BEGIN_TIME.ToString())); } //扩展不确定度 if (!String.IsNullOrEmpty(tBaseApparatusInfo.EXPANDED_UNCETAINTY.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND EXPANDED_UNCETAINTY = '{0}'", tBaseApparatusInfo.EXPANDED_UNCETAINTY.ToString())); } //测量范围 if (!String.IsNullOrEmpty(tBaseApparatusInfo.MEASURING_RANGE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND MEASURING_RANGE = '{0}'", tBaseApparatusInfo.MEASURING_RANGE.ToString())); } //检定单位 if (!String.IsNullOrEmpty(tBaseApparatusInfo.EXAMINE_DEPARTMENT.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND EXAMINE_DEPARTMENT = '{0}'", tBaseApparatusInfo.EXAMINE_DEPARTMENT.ToString())); } //检定单位电话 if (!String.IsNullOrEmpty(tBaseApparatusInfo.DEPARTMENT_PHONE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND DEPARTMENT_PHONE = '{0}'", tBaseApparatusInfo.DEPARTMENT_PHONE.ToString())); } //检定单位联系人 if (!String.IsNullOrEmpty(tBaseApparatusInfo.DEPARTMENT_LINKMAN.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND DEPARTMENT_LINKMAN = '{0}'", tBaseApparatusInfo.DEPARTMENT_LINKMAN.ToString())); } //期间核查方式 if (!String.IsNullOrEmpty(tBaseApparatusInfo.VERIFICATION_WAY.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND VERIFICATION_WAY = '{0}'", tBaseApparatusInfo.VERIFICATION_WAY.ToString())); } //期间核查结果 if (!String.IsNullOrEmpty(tBaseApparatusInfo.VERIFICATION_RESULT.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND VERIFICATION_RESULT = '{0}'", tBaseApparatusInfo.VERIFICATION_RESULT.ToString())); } //最近期间核查时间 if (!String.IsNullOrEmpty(tBaseApparatusInfo.VERIFICATION_BEGIN_TIME.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND VERIFICATION_BEGIN_TIME = '{0}'", tBaseApparatusInfo.VERIFICATION_BEGIN_TIME.ToString())); } //备注1 if (!String.IsNullOrEmpty(tBaseApparatusInfo.IS_DEL.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND IS_DEL = '{0}'", tBaseApparatusInfo.IS_DEL.ToString())); } //备注1 if (!String.IsNullOrEmpty(tBaseApparatusInfo.REMARK1.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK1 = '{0}'", tBaseApparatusInfo.REMARK1.ToString())); } //备注2 if (!String.IsNullOrEmpty(tBaseApparatusInfo.REMARK2.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK2 = '{0}'", tBaseApparatusInfo.REMARK2.ToString())); } //备注3 if (!String.IsNullOrEmpty(tBaseApparatusInfo.REMARK3.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK3 = '{0}'", tBaseApparatusInfo.REMARK3.ToString())); } //备注4 if (!String.IsNullOrEmpty(tBaseApparatusInfo.REMARK4.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK4 = '{0}'", tBaseApparatusInfo.REMARK4.ToString())); } //备注5 if (!String.IsNullOrEmpty(tBaseApparatusInfo.REMARK5.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK5 = '{0}'", tBaseApparatusInfo.REMARK5.ToString())); } #endregion string strStartTime = ""; string strEndTime = ""; GetEndTime(intIsMonth, ref strStartTime, ref strEndTime); if (intSrcType == 1) { strWhereStatement.Append(string.Format(" AND (END_TIME < '{0}'", strEndTime)); strWhereStatement.Append(string.Format(" OR VERIFICATION_END_TIME < '{0}')", strEndTime)); } if (intSrcType == 2) { strWhereStatement.Append(string.Format(" AND END_TIME < '{0}'", strEndTime)); } if (intSrcType == 3) { strWhereStatement.Append(string.Format(" AND VERIFICATION_END_TIME < '{0}'", strEndTime)); } } return(strWhereStatement.ToString()); }
/// <summary> /// 对象删除 /// </summary> /// <param name="Id">ID</param> /// <returns>是否成功</returns> public bool Delete(TBaseApparatusInfoVo tBaseApparatusInfo) { return(access.Delete(tBaseApparatusInfo)); }
/// <summary> /// 自定义查询 Create By Castle(胡方扬) 2012-11-19 /// </summary> /// <param name="tBaseEvaluationInfo">对象</param> /// <param name="iIndex">起始页</param> /// <param name="iCount">条数</param> /// <returns></returns> public DataTable SelectDefinedTadble(TBaseApparatusInfoVo tBaseApparatusInfo, int iIndex, int iCount) { return(access.SelectDefinedTadble(tBaseApparatusInfo, iIndex, iCount)); }
/// <summary> /// 获取对象DataTable Create By weilin 2013-07-24 /// </summary> /// <param name="tBaseApparatusInfo">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <param name="intIsMonth">1,按月,本月要检定;2,按季度,本季度要检定;3,提前一个月要检定;</param> /// <returns>返回结果</returns> public DataTable SelectByTable(TBaseApparatusInfoVo tBaseApparatusInfo, int iIndex, int iCount, int intIsMonth) { return(access.SelectByTable(tBaseApparatusInfo, iIndex, iCount, intIsMonth)); }
protected void ExcelExportIn(string excelFilePath) { try { #region excel 打开工作簿 FileStream file = new FileStream(excelFilePath, FileMode.Open, FileAccess.Read); HSSFWorkbook hssfworkbook = new HSSFWorkbook(file); ISheet mySheet = hssfworkbook.GetSheetAt(0); #endregion //选择导入的信息 string strExportIndex = this.SelectExportInfo.SelectedValue; //定义错误日志 //string strLog = ""; //定义错误数 int ErrorCount = 0; //定义导入对象数组 ArrayList arrVo = new ArrayList(); if (strExportIndex == "0")//仪器 { for (int i = 1; ; i++) { IRow row = mySheet.GetRow(i); if (row == null) { break; } string cell1 = row.GetCell(1) != null?row.GetCell(1).ToString() : ""; //名称 string cell2 = row.GetCell(2) != null?row.GetCell(2).ToString() : ""; //性别 string cell3 = row.GetCell(3) != null?row.GetCell(3).ToString() : ""; //年龄 string cell4 = row.GetCell(4) != null?row.GetCell(4).ToString() : ""; //出生 string cell5 = row.GetCell(5) != null?row.GetCell(5).ToString() : ""; //身份证 string cell6 = row.GetCell(6) != null?row.GetCell(6).ToString() : ""; //政治面貌 string cell7 = row.GetCell(7) != null?row.GetCell(7).ToString() : ""; //学历 string cell8 = row.GetCell(8) != null?row.GetCell(8).ToString() : ""; //专业 string cell9 = row.GetCell(9) != null?row.GetCell(9).ToString() : ""; //职称 string cell10 = row.GetCell(10) != null?row.GetCell(10).ToString() : ""; //城市 string cell11 = row.GetCell(11) != null?row.GetCell(11).ToString() : ""; //单位 string cell12 = row.GetCell(12) != null?row.GetCell(12).ToString() : ""; //参加工作时间 TBaseApparatusInfoVo objvo = new TBaseApparatusInfoVo(); objvo.NAME = cell1.ToString().Replace("\n", "").Replace(" ", ""); //仪器名称 objvo.MODEL = cell2.ToString().Replace("\n", "").Replace(" ", ""); //规格 objvo.SERIAL_NO = cell3.ToString().Replace("\n", "").Replace(" ", ""); //出厂编号 objvo.APPARATUS_PROVIDER = cell4.ToString().Replace("\n", "").Replace(" ", ""); //生产商 objvo.BUY_TIME = cell6.ToString().Replace("\n", "").Replace(" ", ""); //购置时间 objvo.APPARATUS_CODE = cell8.ToString().Replace("\n", "").Replace(" ", ""); //管理编号 objvo.POSITION = cell10.ToString().Replace("\n", "").Replace(" ", ""); //地点 objvo.KEEPER = cell11.ToString().Replace("\n", "").Replace(" ", ""); //保管人 objvo.REMARK1 = cell12.ToString().Replace("\n", "").Replace(" ", ""); //备注 objvo.IS_DEL = "0"; if (cell1.ToString() == "") { break; } if (!ItemExist(objvo)) { arrVo.Add(objvo); } } //批量保存数据 if (ErrorCount <= 0) { if (new TBaseApparatusInfoLogic().SaveData(arrVo)) { Alert("导入完成!"); } } } else if (strExportIndex == "1")//点位 { for (int i = 1; ; i++) { IRow row = mySheet.GetRow(i); if (row == null) { break; } string cell0 = row.GetCell(0) != null?row.GetCell(0).ToString().Replace("\n", "").Replace(" ", "") : ""; //企业ID string cell1 = row.GetCell(1) != null?row.GetCell(1).ToString().Replace("\n", "").Replace(" ", "") : ""; //企业名称 string cell2 = row.GetCell(2) != null?row.GetCell(2).ToString().Replace("\n", "").Replace(" ", "") : ""; //点位信息 if (cell2.Length > 0) { int intNum = 0; //点位序号 string[] strMonitor = cell2.Split(';'); //监测类别 foreach (string str in strMonitor) { string[] strPoint = str.Split(':');//监测类别与点位分隔 //点位信息 string[] strPointInfo = strPoint[1].ToString().Split('、'); foreach (string Point in strPointInfo) { //点位信息处理 TBaseCompanyPointVo objvo = new TBaseCompanyPointVo(); intNum++; objvo.MONITOR_ID = strPoint[0].ToString(); objvo.POINT_NAME = Point; objvo.POINT_TYPE = "01"; objvo.FREQ = "1"; objvo.COMPANY_ID = cell0.ToString(); objvo.IS_DEL = "0"; objvo.NUM = intNum.ToString(); arrVo.Add(objvo); } } } if (cell0.ToString() == "") { break; } } //批量保存数据 if (ErrorCount <= 0) { if (new TBaseCompanyPointLogic().SaveData(arrVo)) { Alert("导入完成!"); } } } #region excel 关闭 释放资源 System.GC.Collect(); #endregion } catch (Exception ex) { Alert("<script>alert('未能读取Excel,请稍候再试!" + ex.Message + "')</script>"); } }
/// <summary> /// 对象添加 /// </summary> /// <param name="tBaseApparatusInfo">对象</param> /// <returns>是否成功</returns> public bool Create(TBaseApparatusInfoVo tBaseApparatusInfo) { string strSQL = SqlHelper.BuildInsertExpress(tBaseApparatusInfo, TBaseApparatusInfoVo.T_BASE_APPARATUS_INFO_TABLE); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 根据对象获取全部数据,用Table承载 /// 数据量较小时使用【不推荐】 /// </summary> /// <param name="tBaseApparatusInfo"></param> /// <returns></returns> public DataTable SelectByTable(TBaseApparatusInfoVo tBaseApparatusInfo) { string strSQL = "select * from T_BASE_APPARATUS_INFO " + this.BuildWhereStatement(tBaseApparatusInfo); return(SqlHelper.ExecuteDataTable(strSQL)); }
/// <summary> /// 获得查询结果总行数,用于分页 /// </summary> /// <param name="tBaseApparatusInfo">对象</param> /// <returns>返回行数</returns> public int GetSelectResultCount(TBaseApparatusInfoVo tBaseApparatusInfo) { return(access.GetSelectResultCount(tBaseApparatusInfo)); }
/// <summary> /// 对象明细 /// </summary> /// <param name="tBaseApparatusInfo">对象条件</param> /// <returns>对象</returns> public TBaseApparatusInfoVo Details(TBaseApparatusInfoVo tBaseApparatusInfo) { return(access.Details(tBaseApparatusInfo)); }
/// <summary> /// 获取对象List /// </summary> /// <param name="tBaseApparatusInfo">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public List <TBaseApparatusInfoVo> SelectByObject(TBaseApparatusInfoVo tBaseApparatusInfo, int iIndex, int iCount) { return(access.SelectByObject(tBaseApparatusInfo, iIndex, iCount)); }
/// <summary> /// 获得查询结果总行数,用于分页 /// </summary> /// <param name="tBaseApparatusInfo">对象</param> /// <returns>返回行数</returns> public int GetSelectResultCount(TBaseApparatusInfoVo tBaseApparatusInfo) { string strSQL = "select Count(*) from T_BASE_APPARATUS_INFO " + this.BuildWhereStatement(tBaseApparatusInfo); return(Convert.ToInt32(SqlHelper.ExecuteScalar(strSQL))); }
public TBaseApparatusInfoLogic(TBaseApparatusInfoVo _tBaseApparatusInfo) { tBaseApparatusInfo = _tBaseApparatusInfo; access = new TBaseApparatusInfoAccess(); }
/// <summary> /// 对象明细 /// </summary> /// <param name="tBaseApparatusInfo">对象条件</param> /// <returns>对象</returns> public TBaseApparatusInfoVo Details(TBaseApparatusInfoVo tBaseApparatusInfo) { string strSQL = String.Format("select * from T_BASE_APPARATUS_INFO " + this.BuildWhereStatement(tBaseApparatusInfo)); return(SqlHelper.ExecuteObject(new TBaseApparatusInfoVo(), strSQL)); }
/// <summary> /// 获得查询结果总行数,用于分页 /// </summary> /// <param name="tBaseApparatusInfo">对象</param> /// <param name="intIsMonth">1,按月,本月要检定;2,按季度,本季度要检定;3,提前一个月要检定;</param> /// <param name="intSrcType">1,全部;2,仅检定/校准时间;3,仅期间核查时间;</param> /// <returns>返回行数</returns> public int GetSelectResultCount(TBaseApparatusInfoVo tBaseApparatusInfo, int intIsMonth, int intSrcType) { return(access.GetSelectResultCount(tBaseApparatusInfo, intIsMonth, intSrcType)); }
/// <summary> /// 获取对象List /// </summary> /// <param name="tBaseApparatusInfo">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public List <TBaseApparatusInfoVo> SelectByObject(TBaseApparatusInfoVo tBaseApparatusInfo, int iIndex, int iCount) { string strSQL = String.Format("select * from T_BASE_APPARATUS_INFO " + this.BuildWhereStatement(tBaseApparatusInfo)); return(SqlHelper.ExecuteObjectList(tBaseApparatusInfo, BuildPagerExpress(strSQL, iIndex, iCount))); }
/// <summary> /// 判断存在性 /// </summary> /// <param name="strType"></param> /// <param name="strItem"></param> /// <param name="strMethod"></param> protected bool ItemExist(TBaseApparatusInfoVo objItemVo) { return(new TBaseApparatusInfoLogic().GetSelectResultCount(objItemVo) > 0 ? true : false); }