/// <summary> /// 获取对象DataTable /// </summary> /// <param name="tMisContractSamplePlan">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public DataTable SelectByTable(TMisContractSamplePlanVo tMisContractSamplePlan, int iIndex, int iCount) { string strSQL = " select * from T_MIS_CONTRACT_SAMPLE_PLAN {0} "; strSQL = String.Format(strSQL, BuildWhereStatement(tMisContractSamplePlan)); return(SqlHelper.ExecuteDataTable(BuildPagerExpress(strSQL, iIndex, iCount))); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tMisContractSamplePlan">用户对象</param> /// <returns>是否成功</returns> public bool Edit(TMisContractSamplePlanVo tMisContractSamplePlan) { string strSQL = SqlHelper.BuildUpdateExpress(tMisContractSamplePlan, TMisContractSamplePlanVo.T_MIS_CONTRACT_SAMPLE_PLAN_TABLE); strSQL += string.Format(" where ID='{0}' ", tMisContractSamplePlan.ID); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tMisContractSamplePlan_UpdateSet">UpdateSet用户对象</param> /// <param name="tMisContractSamplePlan_UpdateWhere">UpdateWhere用户对象</param> /// <returns>是否成功</returns> public bool Edit(TMisContractSamplePlanVo tMisContractSamplePlan_UpdateSet, TMisContractSamplePlanVo tMisContractSamplePlan_UpdateWhere) { string strSQL = SqlHelper.BuildUpdateExpress(tMisContractSamplePlan_UpdateSet, TMisContractSamplePlanVo.T_MIS_CONTRACT_SAMPLE_PLAN_TABLE); strSQL += this.BuildWhereStatement(tMisContractSamplePlan_UpdateWhere); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 自送样流程结束自动插入采样计划数据 /// </summary> /// <param name="task_id"></param> /// <param name="strFreq"></param> /// <returns></returns> public bool CreateSamplePlan(string task_id, string strFreq) { ArrayList arrVo = new ArrayList(); int IntFreq = 0; IntFreq = Convert.ToInt32(strFreq); TMisContractSamplePlanVo objItems = new TMisContractSamplePlanVo(); if (IntFreq > 0) { for (int i = 0; i < IntFreq; i++) { objItems.ID = GetSerialNumber("t_mis_contract_SamplePlanId"); objItems.CONTRACT_ID = task_id; objItems.FREQ = strFreq; objItems.IF_PLAN = "0"; objItems.NUM = (i + 1).ToString(); string strSQL = String.Format(" INSERT INTO T_MIS_CONTRACT_SAMPLE_PLAN(ID,CONTRACT_ID,FREQ,NUM,IF_PLAN) VALUES('{0}','{1}','{2}','{3}','{4}')", objItems.ID, objItems.CONTRACT_ID, objItems.FREQ, objItems.NUM, objItems.IF_PLAN); arrVo.Add(strSQL); strSQL = String.Format(" UPDATE T_MIS_CONTRACT_SAMPLE SET SAMPLE_PLAN_ID='{0}' WHERE CONTRACT_ID='{1}'", objItems.ID, task_id); arrVo.Add(strSQL); } } return(SqlHelper.ExecuteSQLByTransaction(arrVo)); }
/// <summary> /// 根据对象构造条件语句 /// </summary> /// <param name="tMisContractSamplePlan"></param> /// <returns></returns> public string BuildWhereStatement(TMisContractSamplePlanVo tMisContractSamplePlan) { StringBuilder strWhereStatement = new StringBuilder(" Where 1=1 "); if (null != tMisContractSamplePlan) { //ID if (!String.IsNullOrEmpty(tMisContractSamplePlan.ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND ID = '{0}'", tMisContractSamplePlan.ID.ToString())); } //委托书ID if (!String.IsNullOrEmpty(tMisContractSamplePlan.CONTRACT_ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND CONTRACT_ID = '{0}'", tMisContractSamplePlan.CONTRACT_ID.ToString())); } //监测频次 if (!String.IsNullOrEmpty(tMisContractSamplePlan.FREQ.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND FREQ = '{0}'", tMisContractSamplePlan.FREQ.ToString())); } //执行序号 if (!String.IsNullOrEmpty(tMisContractSamplePlan.NUM.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND NUM = '{0}'", tMisContractSamplePlan.NUM.ToString())); } //是否已预约 if (!String.IsNullOrEmpty(tMisContractSamplePlan.IF_PLAN.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND IF_PLAN = '{0}'", tMisContractSamplePlan.IF_PLAN.ToString())); } //备注1 if (!String.IsNullOrEmpty(tMisContractSamplePlan.REMARK1.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK1 = '{0}'", tMisContractSamplePlan.REMARK1.ToString())); } //备注2 if (!String.IsNullOrEmpty(tMisContractSamplePlan.REMARK2.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK2 = '{0}'", tMisContractSamplePlan.REMARK2.ToString())); } //备注3 if (!String.IsNullOrEmpty(tMisContractSamplePlan.REMARK3.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK3 = '{0}'", tMisContractSamplePlan.REMARK3.ToString())); } //备注4 if (!String.IsNullOrEmpty(tMisContractSamplePlan.REMARK4.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK4 = '{0}'", tMisContractSamplePlan.REMARK4.ToString())); } //备注5 if (!String.IsNullOrEmpty(tMisContractSamplePlan.REMARK5.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK5 = '{0}'", tMisContractSamplePlan.REMARK5.ToString())); } } return(strWhereStatement.ToString()); }
/// <summary> /// 获取自送样计划监测类别 胡方扬 2012-12-29 /// </summary> /// <param name="tMisContractSamplePlan"></param> /// <returns></returns> public DataTable GetSamplePlanMonitor(TMisContractSamplePlanVo tMisContractSamplePlan) { string strSQL = String.Format("SELECT MONITOR_ID FROM dbo.T_MIS_CONTRACT_SAMPLE A " + " INNER JOIN dbo.T_MIS_CONTRACT_SAMPLE_PLAN B ON B.ID=A.SAMPLE_PLAN_ID " + " WHERE B.ID='{0}' GROUP BY A.MONITOR_ID", tMisContractSamplePlan.ID); return(SqlHelper.ExecuteDataTable(strSQL)); }
/// <summary> /// 对象删除 /// </summary> /// <param name="Id">ID</param> /// <returns>是否成功</returns> public bool Delete(TMisContractSamplePlanVo tMisContractSamplePlan) { string strSQL = "delete from T_MIS_CONTRACT_SAMPLE_PLAN "; strSQL += this.BuildWhereStatement(tMisContractSamplePlan); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 获取自送样计划样品监测项目 胡方扬 2012-12-29 /// </summary> /// <param name="tMisContractSamplePlan"></param> /// <returns></returns> public DataTable GetSamplePlanItems(TMisContractSamplePlanVo tMisContractSamplePlan) { string strSQL = String.Format("SELECT " + " A.ID AS SAMPLE_ID,A.CONTRACT_ID,A.MONITOR_ID,A.SAMPLE_TYPE,A.SAMPLE_NAME,A.SAMPLE_COUNT, " + " B.ID AS PLAN_ID,B.FREQ,B.NUM,B.IF_PLAN," + " C.ID AS PLAN_ITEM_ID,C.ITEM_ID," + " D.ITEM_NAME,E.MONITOR_TYPE_NAME" + " FROM dbo.T_MIS_CONTRACT_SAMPLE A" + " LEFT JOIN dbo.T_MIS_CONTRACT_SAMPLE_PLAN B ON B.ID=A.SAMPLE_PLAN_ID " + " LEFT JOIN dbo.T_MIS_CONTRACT_SAMPLEITEM C ON C.CONTRACT_SAMPLE_ID=A.ID" + " LEFT JOIN dbo.T_BASE_ITEM_INFO D ON D.ID=C.ITEM_ID" + " LEFT JOIN dbo.T_BASE_MONITOR_TYPE_INFO E ON E.ID=A.MONITOR_ID" + " WHERE B.ID='{0}'", tMisContractSamplePlan.ID); return(SqlHelper.ExecuteDataTable(strSQL)); }
/// <summary> /// 自送样插入采样计划数据 /// </summary> /// <param name="task_id"></param> /// <param name="strFreq"></param> /// <returns></returns> public bool CreateSamplePlan(TMisContractSamplePlanVo tMisContractSamplePlan, string strCompany_Name) { ArrayList arrVo = new ArrayList(); int IntFreq = 0; //string sql = "select ID from T_BASE_COMPANY_INFO Where 1=1 AND IS_DEL = '0' and Company_Name ='" + strCompany_Name + "'"; //strNew_id = SqlHelper.ExecuteScalar(sql).ToString(); if (!String.IsNullOrEmpty(tMisContractSamplePlan.FREQ)) { IntFreq = Convert.ToInt32(tMisContractSamplePlan.FREQ); if (IntFreq > 0) { for (int i = 0; i < IntFreq; i++) { tMisContractSamplePlan.NUM = (i + 1).ToString(); string strSQL = String.Format(" INSERT INTO T_MIS_CONTRACT_SAMPLE_PLAN(ID,CONTRACT_ID,FREQ,NUM,IF_PLAN) VALUES('{0}','{1}','{2}','{3}','{4}')", tMisContractSamplePlan.ID, tMisContractSamplePlan.CONTRACT_ID, tMisContractSamplePlan.FREQ, tMisContractSamplePlan.NUM, tMisContractSamplePlan.IF_PLAN); arrVo.Add(strSQL); } } } return(SqlHelper.ExecuteSQLByTransaction(arrVo)); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tMisContractSamplePlan">用户对象</param> /// <returns>是否成功</returns> public bool Edit(TMisContractSamplePlanVo tMisContractSamplePlan) { return(access.Edit(tMisContractSamplePlan)); }
/// <summary> /// 对象添加 /// </summary> /// <param name="sysRole">对象</param> /// <returns>是否成功</returns> public bool Create(TMisContractSamplePlanVo tMisContractSamplePlan) { return(access.Create(tMisContractSamplePlan)); }
/// <summary> /// 根据对象获取全部数据,用Table承载 /// 数据量较小时使用【不推荐】 /// </summary> /// <param name="tMisContractSamplePlan"></param> /// <returns></returns> public DataTable SelectByTable(TMisContractSamplePlanVo tMisContractSamplePlan) { return(access.SelectByTable(tMisContractSamplePlan)); }
/// <summary> /// 获取对象List /// </summary> /// <param name="tMisContractSamplePlan">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public List <TMisContractSamplePlanVo> SelectByObject(TMisContractSamplePlanVo tMisContractSamplePlan, int iIndex, int iCount) { return(access.SelectByObject(tMisContractSamplePlan, iIndex, iCount)); }
public DataTable GetSamplePlanMonitor(TMisContractSamplePlanVo tMisContractSamplePlan) { return(access.GetSamplePlanMonitor(tMisContractSamplePlan)); }
/// <summary> /// 获取对象List /// </summary> /// <param name="tMisContractSamplePlan">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public List <TMisContractSamplePlanVo> SelectByObject(TMisContractSamplePlanVo tMisContractSamplePlan, int iIndex, int iCount) { string strSQL = String.Format("select * from T_MIS_CONTRACT_SAMPLE_PLAN " + this.BuildWhereStatement(tMisContractSamplePlan)); return(SqlHelper.ExecuteObjectList(tMisContractSamplePlan, BuildPagerExpress(strSQL, iIndex, iCount))); }
/// <summary> /// 对象明细 /// </summary> /// <param name="tMisContractSamplePlan">对象条件</param> /// <returns>对象</returns> public TMisContractSamplePlanVo Details(TMisContractSamplePlanVo tMisContractSamplePlan) { string strSQL = String.Format("select * from T_MIS_CONTRACT_SAMPLE_PLAN " + this.BuildWhereStatement(tMisContractSamplePlan)); return(SqlHelper.ExecuteObject(new TMisContractSamplePlanVo(), strSQL)); }
/// <summary> /// 获得查询结果总行数,用于分页 /// </summary> /// <param name="tMisContractSamplePlan">对象</param> /// <returns>返回行数</returns> public int GetSelectResultCount(TMisContractSamplePlanVo tMisContractSamplePlan) { string strSQL = "select Count(*) from T_MIS_CONTRACT_SAMPLE_PLAN " + this.BuildWhereStatement(tMisContractSamplePlan); return(Convert.ToInt32(SqlHelper.ExecuteScalar(strSQL))); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tMisContractSamplePlan_UpdateSet">UpdateSet用户对象</param> /// <param name="tMisContractSamplePlan_UpdateWhere">UpdateWhere用户对象</param> /// <returns>是否成功</returns> public bool Edit(TMisContractSamplePlanVo tMisContractSamplePlan_UpdateSet, TMisContractSamplePlanVo tMisContractSamplePlan_UpdateWhere) { return(access.Edit(tMisContractSamplePlan_UpdateSet, tMisContractSamplePlan_UpdateWhere)); }
/// <summary> /// 对象删除 /// </summary> /// <param name="Id">ID</param> /// <returns>是否成功</returns> public bool Delete(TMisContractSamplePlanVo tMisContractSamplePlan) { return(access.Delete(tMisContractSamplePlan)); }
/// <summary> /// 自送样插入采样计划数据 /// </summary> /// <param name="task_id"></param> /// <param name="strFreq"></param> /// <returns></returns> public bool CreateSamplePlan(TMisContractSamplePlanVo tMisContractSamplePlan, string strCompany_Name) { return(access.CreateSamplePlan(tMisContractSamplePlan, strCompany_Name)); }
/// <summary> /// 获取自送样计划样品监测项目 胡方扬 2012-12-29 /// </summary> /// <param name="tMisContractSamplePlan"></param> /// <returns></returns> public DataTable GetSamplePlanItems(TMisContractSamplePlanVo tMisContractSamplePlan) { return(access.GetSamplePlanItems(tMisContractSamplePlan)); }
/// <summary> /// 获得查询结果总行数,用于分页 /// </summary> /// <param name="tMisContractSamplePlan">对象</param> /// <returns>返回行数</returns> public int GetSelectResultCount(TMisContractSamplePlanVo tMisContractSamplePlan) { return(access.GetSelectResultCount(tMisContractSamplePlan)); }
public TMisContractSamplePlanLogic(TMisContractSamplePlanVo _tMisContractSamplePlan) { tMisContractSamplePlan = _tMisContractSamplePlan; access = new TMisContractSamplePlanAccess(); }
/// <summary> /// 根据对象获取全部数据,用Table承载 /// 数据量较小时使用【不推荐】 /// </summary> /// <param name="tMisContractSamplePlan"></param> /// <returns></returns> public DataTable SelectByTable(TMisContractSamplePlanVo tMisContractSamplePlan) { string strSQL = "select * from T_MIS_CONTRACT_SAMPLE_PLAN " + this.BuildWhereStatement(tMisContractSamplePlan); return(SqlHelper.ExecuteDataTable(strSQL)); }
/// <summary> /// 对象明细 /// </summary> /// <param name="tMisContractSamplePlan">对象条件</param> /// <returns>对象</returns> public TMisContractSamplePlanVo Details(TMisContractSamplePlanVo tMisContractSamplePlan) { return(access.Details(tMisContractSamplePlan)); }
/// <summary> /// 获取自送样采样计划 /// </summary> /// <param name="tMisContract"></param> /// <returns></returns> public DataTable GetContractInforUnionSamplePlan(TMisContractVo tMisContract, TMisContractSamplePlanVo tMisContractSamplePlan) { string strSQL = "SELECT A.ID,A.CONTRACT_CODE,A.CONTRACT_YEAR,A.PROJECT_NAME,A.CONTRACT_TYPE,A.TEST_TYPES,A.CLIENT_COMPANY_ID,A.TESTED_COMPANY_ID,A.ASKING_DATE,A.SAMPLE_FREQ,A.PROJECT_ID,A.SAMPLE_SOURCE," + " B.ID AS SAMPLE_ID,B.FREQ,B.NUM AS SAMPLENUM,B.IF_PLAN,C.COMPANY_NAME,C.CONTACT_NAME,C.PHONE,D.ID AS TASK_ID,D.TICKET_NUM,D.ASKING_DATE,E.ID AS SUBTASK_ID,F.COMPANY_NAME AS CLIENT_COMPANY_NAME,F.CONTACT_NAME AS CLIENT_CONTACT_NAME,F.PHONE AS CLIENT_PNONE,G.ID AS REPORT_ID,G.REPORT_CODE FROM T_MIS_CONTRACT A " + " INNER JOIN T_MIS_CONTRACT_SAMPLE_PLAN B ON B.CONTRACT_ID=A.ID" + " INNER JOIN T_MIS_CONTRACT_COMPANY C ON C.ID=A.CLIENT_COMPANY_ID" + " INNER JOIN dbo.T_MIS_MONITOR_TASK D ON D.CONTRACT_ID=B.CONTRACT_ID AND D.PLAN_ID=B.ID" + " INNER JOIN dbo.T_MIS_MONITOR_SUBTASK E ON E.TASK_ID=D.ID" + " INNER JOIN T_MIS_CONTRACT_COMPANY F ON F.ID=A.CLIENT_COMPANY_ID " + " INNER JOIN dbo.T_MIS_MONITOR_REPORT G ON G.TASK_ID=D.ID " + " WHERE 1=1"; if (!String.IsNullOrEmpty(tMisContract.ID)) { strSQL += String.Format(" AND A.ID='{0}'", tMisContract.ID); } if (!String.IsNullOrEmpty(tMisContract.BOOKTYPE)) { strSQL += String.Format(" AND A.BOOKTYPE='{0}' ", tMisContract.BOOKTYPE); } if (!String.IsNullOrEmpty(tMisContractSamplePlan.IF_PLAN)) { strSQL += String.Format(" AND B.IF_PLAN='{0}' ", tMisContractSamplePlan.IF_PLAN); } if (!String.IsNullOrEmpty(tMisContractSamplePlan.ID)) { strSQL += String.Format(" AND B.ID='{0}' ", tMisContractSamplePlan.ID); } return(SqlHelper.ExecuteDataTable(strSQL)); }
/// <summary> /// 获取对象DataTable /// </summary> /// <param name="tMisContractSamplePlan">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public DataTable SelectByTable(TMisContractSamplePlanVo tMisContractSamplePlan, int iIndex, int iCount) { return(access.SelectByTable(tMisContractSamplePlan, iIndex, iCount)); }
protected void btnExport_Click(object sender, EventArgs e) { FileStream file = new FileStream(HttpContext.Current.Server.MapPath("../Monitor/sampling/template/WorkTaskSheetQY.xls"), FileMode.Open, FileAccess.Read); HSSFWorkbook hssfworkbook = new HSSFWorkbook(file); ISheet sheet = hssfworkbook.GetSheet("Sheet1"); string strTaskType = "", strMonitorList = "", strWorkContent = ""; TMisMonitorTaskVo objTask = new TMisMonitorTaskVo(); objTask.ID = strWorkTask_Id; TMisContractSamplePlanVo objPlan = new TMisContractSamplePlanVo(); objPlan.ID = strPlanId; DataTable dt = new TMisMonitorTaskLogic().GetContractInforUnionSamplePlan(objTask, objPlan); //插入委托书单号 if (dt.Rows.Count > 0) { sheet.GetRow(4).GetCell(1).SetCellValue(dt.Rows[0]["TICKET_NUM"].ToString()); sheet.GetRow(4).GetCell(6).SetCellValue(dt.Rows[0]["REPORT_CODE"].ToString()); strTaskType = getDictName(dt.Rows[0]["CONTRACT_TYPE"].ToString(), "Contract_Type"); sheet.GetRow(5).GetCell(1).SetCellValue(strTaskType + "任务"); sheet.GetRow(5).GetCell(7).SetCellValue(dt.Rows[0]["CONTRACT_CODE"].ToString()); string[] strMonitroTypeArr = dt.Rows[0]["TEST_TYPE"].ToString().Split(';'); //foreach (string str in strMonitroTypeArr) //{ // string strMonitor = ""; // strMonitor = GetMonitorName(str); // strMonitorList += (strMonitor == "水和废水" ? "废水" : (strMonitor == "气和废气" ? "废气" : strMonitor)) + "、"; //} //strMonitorList = strMonitorList.Substring(0, strMonitorList.Length - 1); sheet.GetRow(6).GetCell(1).SetCellValue(dt.Rows[0]["CLIENT_COMPANY_NAME"].ToString()); TMisContractPointFreqVo objItems = new TMisContractPointFreqVo(); objItems.CONTRACT_ID = ""; DataTable dts = new TMisContractPointFreqLogic().GetPointMonitorInforForPlan(objItems, dt.Rows[0]["ID"].ToString()); if (dts.Rows.Count > 0) { strMonitorList = dts.Rows[0][1].ToString(); } sheet.GetRow(7).GetCell(1).SetCellValue(strMonitorList); if (dt.Rows[0]["SAMPLE_SOURCE"].ToString() == "送样") { //strWorkContent += "地表水、地下水(送样)\n"; int intLen = strMonitroTypeArr.Length; int INTSHOWLEN = 0; foreach (string strMonitor in strMonitroTypeArr) { INTSHOWLEN++; strWorkContent += GetMonitorName(strMonitor) + "、"; if (INTSHOWLEN == intLen) { strWorkContent = strWorkContent.Substring(0, strWorkContent.Length - 1); strWorkContent += "(送样)\n"; } } } DataTable dtPoint = GetSampleDateTable(); string strPoint = "", strPoint_Name = "", strItems = "", strPointItems = ""; int IS_SAMPLEDEPT = 0; //是否存在现场监测项目 int IS_CERTIFICATE = 0; //是否存在实验室监测项目 if (dtPoint.Rows.Count > 0) { foreach (DataRow dr in dtPoint.Rows) { strPoint += dr["SAMPLE_NAME"].ToString() + "、"; DataTable dtPointItems = GetSampleItemsDateTable(dr["ID"].ToString()); if (dtPointItems.Rows.Count > 0) { strPoint_Name = dr["SAMPLE_NAME"].ToString() + ":"; strItems = ""; foreach (DataRow drr in dtPointItems.Rows) { strItems += drr["ITEM_NAME"].ToString() + "、"; if (drr["IS_SAMPLEDEPT"].ToString() == "是") { IS_SAMPLEDEPT = 1; } if (drr["LAB_CERTIFICATE"].ToString() == "是") { IS_CERTIFICATE = 1; } } } if (!String.IsNullOrEmpty(strItems)) { strItems = strItems.Substring(0, strItems.Length - 1); } strPointItems += strPoint_Name + strItems + ";"; } if (!String.IsNullOrEmpty(strPoint)) { strPoint = strPoint.Substring(0, strPoint.Length - 1); } } strWorkContent += "监测样品:" + strPoint + "\n"; strWorkContent += "监测因子与频次:\n" + strPointItems; sheet.GetRow(9).GetCell(1).SetCellValue(strWorkContent); //接收科室 string strJSKS = ""; if (IS_SAMPLEDEPT == 1) { strJSKS += "现场室、"; } if (IS_CERTIFICATE == 1) { strJSKS += "实验室、"; } sheet.GetRow(8).GetCell(1).SetCellValue(strJSKS.TrimEnd('、')); string strLinkPerple = ""; //if (dt.Rows[0]["CONTRACT_TYPE"].ToString() == "02" || dt.Rows[0]["CONTRACT_TYPE"].ToString() == "03")//应急或者管理类的 strMonitorList if (strMonitorList == "02" || strMonitorList == "03")//应急或者管理类的 strMonitorList { strLinkPerple += "联系人:" + dt.Rows[0]["CONTACT_NAME"].ToString() + " \n"; strLinkPerple += "联系电话:" + dt.Rows[0]["PHONE"].ToString() + "\n"; strLinkPerple += "报告编写人:韩永博 \n"; } else { #region//暂不用代码 //string[] strMonitroType = dt.Rows[0]["TEST_TYPE"].ToString().Split(';'); //foreach (string strs in strMonitroType) //{ // string strMonitors = ""; // strMonitors = GetMonitorName(strs); // if (strMonitors == "水和废水") // { // Monitor = "水"; // } // else if (strMonitors == "气和废气") // { // Monitor = "气"; // } // else if (strMonitors == "固废和土壤") // { // Monitor = "固体"; // } // else if (strMonitors.Contains("噪声")) // { // Monitor = "噪声"; // } // Monitor = Monitor + "、"; //} //Monitor = Monitor.Substring(0, Monitor.Length - 1); #endregion if (strMonitorList == "水" || strMonitorList == "固体") { strLinkPerple += "联系人:" + dt.Rows[0]["CONTACT_NAME"].ToString() + " \n"; strLinkPerple += "联系电话:" + dt.Rows[0]["PHONE"].ToString() + "\n"; strLinkPerple += "报告编写人:韩永博 \n"; } else if (strMonitorList == "气" || strMonitorList == "噪声") { strLinkPerple += "联系人:" + dt.Rows[0]["CONTACT_NAME"].ToString() + " \n"; strLinkPerple += "联系电话:" + dt.Rows[0]["PHONE"].ToString() + "\n"; strLinkPerple += "报告编写人:马振芳\n"; } else if (strMonitorList == "水、气、声、固体") { strLinkPerple += "联系人:" + dt.Rows[0]["CONTACT_NAME"].ToString() + " \n"; strLinkPerple += "联系电话:" + dt.Rows[0]["PHONE"].ToString() + "\n"; strLinkPerple += "报告编写人:王志远\n"; } } sheet.GetRow(10).GetCell(1).SetCellValue(strLinkPerple); if (!String.IsNullOrEmpty(dt.Rows[0]["ASKING_DATE"].ToString())) { sheet.GetRow(11).GetCell(1).SetCellValue(DateTime.Parse(dt.Rows[0]["ASKING_DATE"].ToString()).ToString("yyyy-MM-dd")); } //sheet.GetRow(11).GetCell(3).SetCellValue(LogInfo.UserInfo.REAL_NAME); sheet.GetRow(11).GetCell(6).SetCellValue(DateTime.Now.ToString("yyyy-MM-dd")); } using (MemoryStream stream = new MemoryStream()) { hssfworkbook.Write(stream); HttpContext curContext = HttpContext.Current; // 设置编码和附件格式 curContext.Response.ContentType = "application/vnd.ms-excel"; curContext.Response.ContentEncoding = Encoding.UTF8; curContext.Response.Charset = ""; curContext.Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode("工作任务通知单-" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls", Encoding.UTF8)); curContext.Response.BinaryWrite(stream.GetBuffer()); curContext.Response.End(); } }
/// <summary> /// 获取自送样采样计划 /// </summary> /// <param name="tMisContract"></param> /// <returns></returns> public DataTable GetContractInforUnionSamplePlan(TMisMonitorTaskVo tMisTaskContract, TMisContractSamplePlanVo tMisContractSamplePlan) { return(access.GetContractInforUnionSamplePlan(tMisTaskContract, tMisContractSamplePlan)); }
/// <summary> /// 根据对象特征获取单一对象 /// </summary> /// <param name="tMisContractSamplePlan">对象</param> /// <returns></returns> public TMisContractSamplePlanVo SelectByObject(TMisContractSamplePlanVo tMisContractSamplePlan) { return(access.SelectByObject(tMisContractSamplePlan)); }