public static string deletePoint(string strValue) { TBaseCompanyPointVo objPoint = new TBaseCompanyPointVo(); objPoint.ID = strValue; objPoint.IS_DEL = "1"; bool isSuccess = new TBaseCompanyPointLogic().Edit(objPoint); TBaseAttrbuteValueVo objAttrValueDelWhere = new TBaseAttrbuteValueVo(); objAttrValueDelWhere.OBJECT_ID = strValue; objAttrValueDelWhere.IS_DEL = "0"; TBaseAttrbuteValueVo objAttrValueDelSet = new TBaseAttrbuteValueVo(); objAttrValueDelSet.IS_DEL = "1"; if (new TBaseAttrbuteValueLogic().Edit(objAttrValueDelSet, objAttrValueDelWhere)) { new PageBase().WriteLog("删除点位属性", "", new PageBase().LogInfo.UserInfo.USER_NAME + "删除对象ID" + objPoint.ID + "的点位属性成功"); } if (isSuccess) { new PageBase().WriteLog("删除点位", "", new PageBase().LogInfo.UserInfo.USER_NAME + "删除点位" + objPoint.ID + "成功"); } return(isSuccess == true ? "1" : "0"); }
/// <summary> /// 获取对象DataTable /// </summary> /// <param name="tBaseCompanyPoint">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public DataTable SelectByTable(TBaseCompanyPointVo tBaseCompanyPoint, int iIndex, int iCount) { string strSQL = " select * from T_BASE_COMPANY_POINT {0} order by MONITOR_ID,NUM"; strSQL = String.Format(strSQL, BuildWhereStatement(tBaseCompanyPoint)); return(SqlHelper.ExecuteDataTable(BuildPagerExpress(strSQL, iIndex, iCount))); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tBaseCompanyPoint_UpdateSet">UpdateSet用户对象</param> /// <param name="tBaseCompanyPoint_UpdateWhere">UpdateWhere用户对象</param> /// <returns>是否成功</returns> public bool Edit(TBaseCompanyPointVo tBaseCompanyPoint_UpdateSet, TBaseCompanyPointVo tBaseCompanyPoint_UpdateWhere) { string strSQL = SqlHelper.BuildUpdateExpress(tBaseCompanyPoint_UpdateSet, TBaseCompanyPointVo.T_BASE_COMPANY_POINT_TABLE); strSQL += this.BuildWhereStatement(tBaseCompanyPoint_UpdateWhere); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
//获取点位信息 private string getPointList() { string strSortname = Request.Params["sortname"]; string strSortorder = Request.Params["sortorder"]; //当前页面 int intPageIndex = Convert.ToInt32(Request.Params["page"]); //每页记录数 int intPageSize = Convert.ToInt32(Request.Params["pagesize"]); if (strSortname == null || strSortname.Length < 0) { strSortname = TBaseCompanyPointVo.NUM_FIELD; } string strCompanyID = Request.Params["comId"]; if (strCompanyID == null || strCompanyID.Length == 0) { return(""); } TBaseCompanyPointVo objPoint = new TBaseCompanyPointVo(); objPoint.IS_DEL = "0"; objPoint.COMPANY_ID = strCompanyID; objPoint.SORT_FIELD = strSortname; objPoint.SORT_TYPE = strSortorder; DataTable dt = new TBaseCompanyPointLogic().SelectByTable(objPoint, intPageIndex, intPageSize); int intTotalCount = new TBaseCompanyPointLogic().GetSelectResultCount(objPoint); string strJson = CreateToJson(dt, intTotalCount); return(strJson); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tBaseCompanyPoint">用户对象</param> /// <returns>是否成功</returns> public bool Edit(TBaseCompanyPointVo tBaseCompanyPoint) { string strSQL = SqlHelper.BuildUpdateExpress(tBaseCompanyPoint, TBaseCompanyPointVo.T_BASE_COMPANY_POINT_TABLE); strSQL += string.Format(" where ID='{0}' ", tBaseCompanyPoint.ID); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 对象删除 /// </summary> /// <param name="Id">ID</param> /// <returns>是否成功</returns> public bool Delete(TBaseCompanyPointVo tBaseCompanyPoint) { string strSQL = "delete from T_BASE_COMPANY_POINT "; strSQL += this.BuildWhereStatement(tBaseCompanyPoint); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
public int SelectByTableForPlanCount(TBaseCompanyPointVo tBaseCompanyPoint, string strPointIdList) { string strPointId = strPointIdList.Replace(";", "','"); string strSQL = "select Count(*) from T_BASE_COMPANY_POINT " + this.BuildWhereStatement(tBaseCompanyPoint); if (!String.IsNullOrEmpty(strPointId)) { strSQL += String.Format(" AND ID NOT IN('{0}')", strPointId); } return(Convert.ToInt32(SqlHelper.ExecuteScalar(strSQL))); }
public DataTable SelectByTableForPlan(TBaseCompanyPointVo tBaseCompanyPoint, string strPointIdList, int iIndex, int iCount) { string strPointId = strPointIdList.Replace(";", "','"); string strSQL = " select * from T_BASE_COMPANY_POINT {0} "; strSQL = String.Format(strSQL, BuildWhereStatement(tBaseCompanyPoint)); if (!String.IsNullOrEmpty(strPointId)) { strSQL += String.Format(" AND ID NOT IN('{0}')", strPointId); } return(SqlHelper.ExecuteDataTable(BuildPagerExpress(strSQL, iIndex, iCount))); }
//获取点位信息 private string getPointList() { string strSortname = Request.Params["sortname"]; string strSortorder = Request.Params["sortorder"]; //当前页面 int intPageIndex = Convert.ToInt32(Request.Params["page"]); //每页记录数 int intPageSize = Convert.ToInt32(Request.Params["pagesize"]); if (strSortname == null || strSortname.Length < 0) { strSortname = TBaseCompanyPointVo.NUM_FIELD; } string strCompanyID = Request.Params["CompanyID"]; if (strCompanyID.Length == 0) { return(""); } TBaseCompanyPointVo objPoint = new TBaseCompanyPointVo(); objPoint.IS_DEL = "0"; objPoint.COMPANY_ID = strCompanyID; objPoint.SORT_FIELD = strSortname; objPoint.SORT_TYPE = strSortorder; DataTable dt = new TBaseCompanyPointLogic().SelectByTable(objPoint, intPageIndex, intPageSize); for (int i = 0; i < dt.Rows.Count; i++) { TBaseMonitorTypeInfoVo MonitorTypeInfoVo = new TBaseMonitorTypeInfoVo(); MonitorTypeInfoVo = new TBaseMonitorTypeInfoLogic().Details(dt.Rows[i]["MONITOR_ID"].ToString()); dt.Rows[i]["REMARK1"] = MonitorTypeInfoVo.REMARK1; } int intTotalCount = new TBaseCompanyPointLogic().GetSelectResultCount(objPoint); string strJson = CreateToJson(dt, intTotalCount); return(strJson); }
/// <summary> /// 对象添加 /// </summary> /// <param name="sysRole">对象</param> /// <returns>是否成功</returns> public bool Create(TBaseCompanyPointVo tBaseCompanyPoint) { return(access.Create(tBaseCompanyPoint)); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tBaseCompanyPoint">用户对象</param> /// <returns>是否成功</returns> public bool Edit(TBaseCompanyPointVo tBaseCompanyPoint) { return(access.Edit(tBaseCompanyPoint)); }
public static string SaveCompanyPointDataEx(string strPointID, string strCompanyID, string strPOINT_NAME, string strMONITOR_ID, string strPOINT_TYPE, string strDYNAMIC_ATTRIBUTE_ID, string strSAMPLE_DAY, string strSAMPLE_FREQ, string strFREQ, string strCREATE_DATE, string strADDRESS, string strLONGITUDE, string strLATITUDE, string strNUM, string strAttribute, string strNATIONAL_ST_CONDITION_ID, string strLOCAL_ST_CONDITION_ID, string strINDUSTRY_ST_CONDITION_ID) { bool isSuccess = true; string strPointIDs = string.Empty; string[] strPointNames; if (strPointID.Length > 0) { strPointNames = strPOINT_NAME.Split('|'); } else { strPointNames = strPOINT_NAME.Split('、'); } for (int j = 0; j < strPointNames.Length; j++) { TBaseCompanyPointVo objPoint = new TBaseCompanyPointVo(); objPoint.ID = strPointID.Length > 0 ? strPointID : GetSerialNumber("t_base_company_point_id"); objPoint.IS_DEL = "0"; objPoint.COMPANY_ID = strCompanyID; objPoint.POINT_NAME = strPointNames[j].ToString(); objPoint.MONITOR_ID = strMONITOR_ID; objPoint.POINT_TYPE = strPOINT_TYPE; objPoint.DYNAMIC_ATTRIBUTE_ID = strDYNAMIC_ATTRIBUTE_ID; objPoint.SAMPLE_DAY = strSAMPLE_DAY; objPoint.SAMPLE_FREQ = strSAMPLE_FREQ; objPoint.FREQ = "1"; objPoint.CREATE_DATE = strCREATE_DATE; objPoint.ADDRESS = strADDRESS; objPoint.LONGITUDE = strLONGITUDE; objPoint.LATITUDE = strLATITUDE; objPoint.NUM = strNUM; objPoint.NATIONAL_ST_CONDITION_ID = strNATIONAL_ST_CONDITION_ID; objPoint.LOCAL_ST_CONDITION_ID = strLOCAL_ST_CONDITION_ID; objPoint.INDUSTRY_ST_CONDITION_ID = strINDUSTRY_ST_CONDITION_ID; if (strPointID.Length > 0) { isSuccess = new TBaseCompanyPointLogic().Edit(objPoint); if (isSuccess) { new PageBase().WriteLog("编辑点位", "", new PageBase().LogInfo.UserInfo.USER_NAME + "编辑点位" + objPoint.ID + "成功"); } } else { isSuccess = new TBaseCompanyPointLogic().Create(objPoint); if (isSuccess) { new PageBase().WriteLog("新增点位", "", new PageBase().LogInfo.UserInfo.USER_NAME + "新增点位" + objPoint.ID + "成功"); } } strPointIDs += objPoint.ID + "、"; TBaseAttrbuteValueLogic logicAttrValue = new TBaseAttrbuteValueLogic(); //清掉原有动态属性值 TBaseAttrbuteValueVo objAttrValueDelWhere = new TBaseAttrbuteValueVo(); objAttrValueDelWhere.OBJECT_ID = objPoint.ID; objAttrValueDelWhere.IS_DEL = "0"; TBaseAttrbuteValueVo objAttrValueDelSet = new TBaseAttrbuteValueVo(); objAttrValueDelSet.IS_DEL = "1"; if (logicAttrValue.Edit(objAttrValueDelSet, objAttrValueDelWhere)) { new PageBase().WriteLog("清掉动态属性值", "", new PageBase().LogInfo.UserInfo.USER_NAME + "清掉对象ID" + objPoint.ID + "的动态属性值成功"); } //新增动态属性值 if (strAttribute.Length > 0) { string[] arrAttribute = strAttribute.Split('-'); for (int i = 0; i < arrAttribute.Length; i++) { string[] arrAttrValue = arrAttribute[i].Split('|'); TBaseAttrbuteValueVo objAttrValueAdd = new TBaseAttrbuteValueVo(); objAttrValueAdd.ID = GetSerialNumber("t_base_attribute_value_id"); objAttrValueAdd.IS_DEL = "0"; objAttrValueAdd.OBJECT_TYPE = arrAttrValue[0]; objAttrValueAdd.OBJECT_ID = objPoint.ID; objAttrValueAdd.ATTRBUTE_CODE = arrAttrValue[1]; objAttrValueAdd.ATTRBUTE_VALUE = arrAttrValue[2]; if (isSuccess = logicAttrValue.Create(objAttrValueAdd)) { new PageBase().WriteLog("新增动态属性值", "", new PageBase().LogInfo.UserInfo.USER_NAME + "新增动态属性值" + objAttrValueAdd.ID + "成功"); } } } } if (isSuccess) { return(strPointIDs.TrimEnd('、')); } else { return(""); } }
/// <summary> /// 根据对象获取全部数据,用Table承载 /// 数据量较小时使用【不推荐】 /// </summary> /// <param name="tBaseCompanyPoint"></param> /// <returns></returns> public DataTable SelectByTable(TBaseCompanyPointVo tBaseCompanyPoint) { string strSQL = "select * from T_BASE_COMPANY_POINT " + this.BuildWhereStatement(tBaseCompanyPoint); return(SqlHelper.ExecuteDataTable(strSQL)); }
/// <summary> /// 获取对象DataTable /// </summary> /// <param name="tBaseCompanyPoint">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public DataTable SelectByTable(TBaseCompanyPointVo tBaseCompanyPoint, int iIndex, int iCount) { return(access.SelectByTable(tBaseCompanyPoint, iIndex, iCount)); }
/// <summary> /// 对象明细 /// </summary> /// <param name="tBaseCompanyPoint">对象条件</param> /// <returns>对象</returns> public TBaseCompanyPointVo Details(TBaseCompanyPointVo tBaseCompanyPoint) { return(access.Details(tBaseCompanyPoint)); }
public TBaseCompanyPointLogic(TBaseCompanyPointVo _tBaseCompanyPoint) { tBaseCompanyPoint = _tBaseCompanyPoint; access = new TBaseCompanyPointAccess(); }
public DataTable SelectByTableForPlan(TBaseCompanyPointVo tBaseCompanyPoint, string strPointIdList, int iIndex, int iCount) { return(access.SelectByTableForPlan(tBaseCompanyPoint, strPointIdList, iIndex, iCount)); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tBaseCompanyPoint_UpdateSet">UpdateSet用户对象</param> /// <param name="tBaseCompanyPoint_UpdateWhere">UpdateWhere用户对象</param> /// <returns>是否成功</returns> public bool Edit(TBaseCompanyPointVo tBaseCompanyPoint_UpdateSet, TBaseCompanyPointVo tBaseCompanyPoint_UpdateWhere) { return(access.Edit(tBaseCompanyPoint_UpdateSet, tBaseCompanyPoint_UpdateWhere)); }
/// <summary> /// 对象删除 /// </summary> /// <param name="Id">ID</param> /// <returns>是否成功</returns> public bool Delete(TBaseCompanyPointVo tBaseCompanyPoint) { return(access.Delete(tBaseCompanyPoint)); }
public static string SaveDataPoint(string strSubTaskID, string strPointName, string strMonitorID) { bool isSuccess = true; TMisMonitorTaskPointVo objPoint = new TMisMonitorTaskPointVo(); objPoint.ID = GetSerialNumber("t_mis_monitor_taskpointId"); objPoint.IS_DEL = "0"; objPoint.SUBTASK_ID = strSubTaskID; objPoint.POINT_NAME = strPointName; objPoint.MONITOR_ID = strMonitorID; objPoint.FREQ = "1"; objPoint.CREATE_DATE = DateTime.Now.ToString(); TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskLogic().Details(strSubTaskID); TMisMonitorTaskVo objTask = new TMisMonitorTaskLogic().Details(objSubtask.TASK_ID); objPoint.TASK_ID = objTask.ID; //监测任务出现新增排口时,基础资料企业表也要新增 TBaseCompanyPointVo objnewPoint = new TBaseCompanyPointVo(); objnewPoint.ID = GetSerialNumber("t_base_company_point_id"); objnewPoint.IS_DEL = "0"; objnewPoint.POINT_NAME = strPointName; objnewPoint.MONITOR_ID = strMonitorID; objnewPoint.FREQ = "1"; objnewPoint.CREATE_DATE = DateTime.Now.ToString(); TMisMonitorTaskCompanyVo objTaskCompany = new TMisMonitorTaskCompanyVo(); //objTaskCompany.TASK_ID = objTask.ID; ; objTaskCompany = new TMisMonitorTaskCompanyLogic().Details(objTask.TESTED_COMPANY_ID); TMisContractCompanyVo objContractCompany = new TMisContractCompanyLogic().Details(objTaskCompany.COMPANY_ID); objnewPoint.COMPANY_ID = objContractCompany.COMPANY_ID; isSuccess = new TBaseCompanyPointLogic().Create(objnewPoint); objPoint.POINT_ID = objnewPoint.ID; isSuccess = new TMisMonitorTaskPointLogic().Create(objPoint); //增加点位样品信息 TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoVo(); objSample.ID = GetSerialNumber("MonitorSampleId"); objSample.SUBTASK_ID = strSubTaskID; objSample.QC_TYPE = "0"; objSample.NOSAMPLE = "0"; objSample.POINT_ID = objPoint.ID; objSample.SAMPLE_NAME = objPoint.POINT_NAME; isSuccess = new TMisMonitorSampleInfoLogic().Create(objSample); //为新增的测点添加监测项目 DataTable dt = new TMisMonitorSubtaskLogic().getItemBySubTaskID(strSubTaskID); string strItemIDs = ""; for (int i = 0; i < dt.Rows.Count; i++) { strItemIDs += dt.Rows[i]["ID"].ToString() + ","; } isSuccess = SaveDataItem(strSubTaskID, objSample.ID, strItemIDs.TrimEnd(','), true); if (isSuccess) { return("1"); } else { return("0"); } }
public int SelectByTableForPlanCount(TBaseCompanyPointVo tBaseCompanyPoint, string strPointIdList) { return(access.SelectByTableForPlanCount(tBaseCompanyPoint, strPointIdList)); }
/// <summary> /// 判断存在性 /// </summary> /// <param name="strType"></param> /// <param name="strItem"></param> /// <param name="strMethod"></param> protected bool PointExist(TBaseCompanyPointVo objItemVo) { return(new TBaseCompanyPointLogic().GetSelectResultCount(objItemVo) > 0 ? true : false); }
/// <summary> /// 获得查询结果总行数,用于分页 /// </summary> /// <param name="tBaseCompanyPoint">对象</param> /// <returns>返回行数</returns> public int GetSelectResultCount(TBaseCompanyPointVo tBaseCompanyPoint) { return(access.GetSelectResultCount(tBaseCompanyPoint)); }
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> /// 获取对象List /// </summary> /// <param name="tBaseCompanyPoint">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public List <TBaseCompanyPointVo> SelectByObject(TBaseCompanyPointVo tBaseCompanyPoint, int iIndex, int iCount) { return(access.SelectByObject(tBaseCompanyPoint, iIndex, iCount)); }
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); TBaseCompanyInfoVo CompanyInfoVo = new TBaseCompanyInfoVo(); string strCompanyID = ""; TBaseCompanyPointVo CompanyPointVo = new TBaseCompanyPointVo(); string strCompanyPointID = ""; TBaseCompanyPointItemVo CompanyPointItemVo = new TBaseCompanyPointItemVo(); string strCompanyPointItemID = ""; string[] strArr; for (int i = 0; i < dt.Rows.Count; i++) { strCompanyID = ""; strCompanyPointID = ""; strCompanyPointItemID = ""; CompanyInfoVo = new TBaseCompanyInfoVo(); CompanyInfoVo.COMPANY_NAME = dt.Rows[i][0].ToString().Trim(); CompanyInfoVo.IS_DEL = "0"; CompanyInfoVo = new TBaseCompanyInfoLogic().SelectByObject(CompanyInfoVo); strCompanyID = CompanyInfoVo.ID; if (strCompanyID == "") { strCompanyID = GetSerialNumber("Company_Id"); CompanyInfoVo.ID = strCompanyID; CompanyInfoVo.COMPANY_NAME = dt.Rows[i][0].ToString().Trim(); CompanyInfoVo.IS_DEL = "0"; new TBaseCompanyInfoLogic().Create(CompanyInfoVo); } CompanyPointVo = new TBaseCompanyPointVo(); CompanyPointVo.COMPANY_ID = strCompanyID; CompanyPointVo.POINT_NAME = dt.Rows[i][3].ToString().Trim(); CompanyPointVo.MONITOR_ID = dt.Rows[i][4].ToString().Trim(); CompanyPointVo.IS_DEL = "0"; CompanyPointVo = new TBaseCompanyPointLogic().SelectByObject(CompanyPointVo); strCompanyPointID = CompanyPointVo.ID; if (strCompanyPointID == "") { strCompanyPointID = GetSerialNumber("t_base_company_point_id"); CompanyPointVo.ID = strCompanyPointID; CompanyPointVo.COMPANY_ID = strCompanyID; CompanyPointVo.POINT_NAME = dt.Rows[i][3].ToString().Trim(); CompanyPointVo.MONITOR_ID = dt.Rows[i][4].ToString().Trim(); CompanyPointVo.SAMPLE_DAY = dt.Rows[i][1].ToString().Trim(); CompanyPointVo.SAMPLE_FREQ = dt.Rows[i][2].ToString().Trim(); CompanyPointVo.IS_DEL = "0"; new TBaseCompanyPointLogic().Create(CompanyPointVo); } else { CompanyPointVo.SAMPLE_DAY = dt.Rows[i][1].ToString().Trim(); CompanyPointVo.SAMPLE_FREQ = dt.Rows[i][2].ToString().Trim(); new TBaseCompanyPointLogic().Edit(CompanyPointVo); } strArr = dt.Rows[i][5].ToString().Trim().Split(','); for (int j = 0; j < strArr.Length; j++) { strCompanyPointItemID = ""; CompanyPointItemVo = new TBaseCompanyPointItemVo(); CompanyPointItemVo.POINT_ID = strCompanyPointID; CompanyPointItemVo.ITEM_ID = strArr[j].ToString().Trim(); CompanyPointItemVo.IS_DEL = "0"; CompanyPointItemVo = new TBaseCompanyPointItemLogic().SelectByObject(CompanyPointItemVo); strCompanyPointItemID = CompanyPointItemVo.ID; if (strCompanyPointItemID == "") { strCompanyPointItemID = GetSerialNumber("t_base_company_point_item_id"); CompanyPointItemVo.ID = strCompanyPointItemID; CompanyPointItemVo.POINT_ID = strCompanyPointID; CompanyPointItemVo.ITEM_ID = strArr[j].ToString().Trim(); CompanyPointItemVo.IS_DEL = "0"; new TBaseCompanyPointItemLogic().Create(CompanyPointItemVo); } } } labMsg.Text = "导入成功!!!!!!!!!!!!!!!!!!"; }
/// <summary> /// 根据对象获取全部数据,用Table承载 /// 数据量较小时使用【不推荐】 /// </summary> /// <param name="tBaseCompanyPoint"></param> /// <returns></returns> public DataTable SelectByTable(TBaseCompanyPointVo tBaseCompanyPoint) { return(access.SelectByTable(tBaseCompanyPoint)); }
public static string SaveItemSplit(string strSampleID, string strPointName, string strResultItems, string strItems, string strMonitorID, string strSubTaskID) { bool isSuccess = true; TMisMonitorTaskPointVo objPoint = new TMisMonitorTaskPointVo(); objPoint.ID = GetSerialNumber("t_mis_monitor_taskpointId"); objPoint.IS_DEL = "0"; objPoint.SUBTASK_ID = strSubTaskID; objPoint.POINT_NAME = strPointName; objPoint.MONITOR_ID = strMonitorID; objPoint.FREQ = "1"; objPoint.CREATE_DATE = DateTime.Now.ToString(); TMisMonitorSampleInfoVo objSampleVo = new TMisMonitorSampleInfoLogic().Details(strSampleID); TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskLogic().Details(strSubTaskID); TMisMonitorTaskVo objTask = new TMisMonitorTaskLogic().Details(objSubtask.TASK_ID); objPoint.TASK_ID = objTask.ID; //监测任务出现新增排口时,基础资料企业表也要新增 TBaseCompanyPointVo objnewPoint = new TBaseCompanyPointVo(); objnewPoint.ID = GetSerialNumber("t_base_company_point_id"); objnewPoint.IS_DEL = "0"; objnewPoint.POINT_NAME = strPointName; objnewPoint.MONITOR_ID = strMonitorID; objnewPoint.FREQ = "1"; objnewPoint.CREATE_DATE = DateTime.Now.ToString(); TMisMonitorTaskCompanyVo objTaskCompany = new TMisMonitorTaskCompanyVo(); objTaskCompany = new TMisMonitorTaskCompanyLogic().Details(objTask.TESTED_COMPANY_ID); TMisContractCompanyVo objContractCompany = new TMisContractCompanyLogic().Details(objTaskCompany.COMPANY_ID); objnewPoint.COMPANY_ID = objContractCompany.COMPANY_ID; isSuccess = new TBaseCompanyPointLogic().Create(objnewPoint); objPoint.POINT_ID = objnewPoint.ID; isSuccess = new TMisMonitorTaskPointLogic().Create(objPoint); //增加点位样品信息 TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoVo(); objSample.ID = GetSerialNumber("MonitorSampleId"); objSample.SUBTASK_ID = strSubTaskID; objSample.QC_TYPE = "0"; objSample.NOSAMPLE = "0"; objSample.POINT_ID = objPoint.ID; objSample.SAMPLE_NAME = objPoint.POINT_NAME; //新增点位时候,自动生成该点位的样品编码 TBaseSerialruleVo objSerial = new TBaseSerialruleVo(); objSerial.SAMPLE_SOURCE = objTask.SAMPLE_SOURCE; objSerial.SERIAL_TYPE = "2"; objSample.SAMPLECODE_CREATEDATE = DateTime.Now.ToString("yyyy-MM-dd"); objSample.SAMPLE_CODE = CreateBaseDefineCodeForSample(objSerial, objTask, objSubtask); isSuccess = new TMisMonitorSampleInfoLogic().Create(objSample); isSuccess = new TMisMonitorSampleInfoLogic().UpdateSetWhere("T_Mis_MONITOR_RESULT", "SAMPLE_ID='" + objSample.ID + "'", "ID in(" + strResultItems.TrimEnd(',') + ")"); isSuccess = new TMisMonitorSampleInfoLogic().UpdateSetWhere("T_Mis_MONITOR_TASK_ITEM", "TASK_POINT_ID='" + objPoint.ID + "'", "TASK_POINT_ID='" + objSampleVo.POINT_ID + "' AND ITEM_ID in(" + strItems.TrimEnd(',') + ")"); return(isSuccess ? "true" : "false"); }
public static string SaveData(string strPointID, string strSubtaskID, string strPOINT_NAME, string strMONITOR_ID, string strPOINT_TYPE, string strDYNAMIC_ATTRIBUTE_ID, string strFREQ, string strCREATE_DATE, string strADDRESS, string strLONGITUDE, string strLATITUDE, string strNUM, string strAttribute, string strNATIONAL_ST_CONDITION_ID, string strLOCAL_ST_CONDITION_ID, string strINDUSTRY_ST_CONDITION_ID) { bool isSuccess = true; TMisMonitorTaskPointVo objPoint = new TMisMonitorTaskPointVo(); objPoint.ID = strPointID.Length > 0 ? strPointID : GetSerialNumber("t_mis_monitor_taskpointId"); objPoint.IS_DEL = "0"; objPoint.SUBTASK_ID = strSubtaskID; objPoint.POINT_NAME = strPOINT_NAME; objPoint.MONITOR_ID = strMONITOR_ID; objPoint.DYNAMIC_ATTRIBUTE_ID = strDYNAMIC_ATTRIBUTE_ID; objPoint.FREQ = strFREQ; objPoint.CREATE_DATE = strCREATE_DATE; objPoint.ADDRESS = strADDRESS; objPoint.LONGITUDE = strLONGITUDE; objPoint.LATITUDE = strLATITUDE; objPoint.NUM = strNUM; objPoint.NATIONAL_ST_CONDITION_ID = strNATIONAL_ST_CONDITION_ID; objPoint.LOCAL_ST_CONDITION_ID = strLOCAL_ST_CONDITION_ID; objPoint.INDUSTRY_ST_CONDITION_ID = strINDUSTRY_ST_CONDITION_ID; TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskLogic().Details(strSubtaskID); TMisMonitorTaskVo objTask = new TMisMonitorTaskLogic().Details(objSubtask.TASK_ID); objPoint.TASK_ID = objTask.ID; //监测任务出现新增排口时,基础资料企业表也要新增 TBaseCompanyPointVo objnewPoint = new TBaseCompanyPointVo(); if (strPointID.Length == 0) { objnewPoint.ID = GetSerialNumber("t_base_company_point_id"); objnewPoint.IS_DEL = "0"; objnewPoint.POINT_NAME = strPOINT_NAME; objnewPoint.MONITOR_ID = strMONITOR_ID; objnewPoint.DYNAMIC_ATTRIBUTE_ID = strDYNAMIC_ATTRIBUTE_ID; objnewPoint.FREQ = strFREQ; objnewPoint.CREATE_DATE = strCREATE_DATE; objnewPoint.ADDRESS = strADDRESS; objnewPoint.LONGITUDE = strLONGITUDE; objnewPoint.LATITUDE = strLATITUDE; objnewPoint.NUM = strNUM; objnewPoint.NATIONAL_ST_CONDITION_ID = strNATIONAL_ST_CONDITION_ID; objnewPoint.LOCAL_ST_CONDITION_ID = strLOCAL_ST_CONDITION_ID; objnewPoint.INDUSTRY_ST_CONDITION_ID = strINDUSTRY_ST_CONDITION_ID; TMisMonitorTaskCompanyVo objTaskCompany = new TMisMonitorTaskCompanyVo(); objTaskCompany.TASK_ID = objTask.ID;; objTaskCompany = new TMisMonitorTaskCompanyLogic().Details(objTaskCompany); TMisContractCompanyVo objContractCompany = new TMisContractCompanyLogic().Details(objTaskCompany.COMPANY_ID); objnewPoint.COMPANY_ID = objContractCompany.COMPANY_ID; new TBaseCompanyPointLogic().Create(objnewPoint); objPoint.POINT_ID = objnewPoint.ID; } if (strPointID.Length > 0) { isSuccess = new TMisMonitorTaskPointLogic().Edit(objPoint); } else { isSuccess = new TMisMonitorTaskPointLogic().Create(objPoint); //增加点位样品信息 TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoVo(); objSample.ID = GetSerialNumber("MonitorSampleId"); objSample.SUBTASK_ID = strSubtaskID; objSample.QC_TYPE = "0"; objSample.NOSAMPLE = "0"; objSample.POINT_ID = objPoint.ID; objSample.SAMPLE_NAME = objPoint.POINT_NAME; string[] strSampleCode = new string[2] { "S" + DateTime.Now.Year + DateTime.Now.Month, i3.View.PageBase.GetSerialNumber("monitor_samplecode") }; objSample.SAMPLE_CODE = CreateSerialNumber(strSampleCode); new TMisMonitorSampleInfoLogic().Create(objSample); } TBaseAttrbuteValue3Logic logicAttrValue = new TBaseAttrbuteValue3Logic(); //清掉原有动态属性值 TBaseAttrbuteValue3Vo objAttrValueDelWhere = new TBaseAttrbuteValue3Vo(); objAttrValueDelWhere.OBJECT_ID = objPoint.ID; objAttrValueDelWhere.IS_DEL = "0"; TBaseAttrbuteValue3Vo objAttrValueDelSet = new TBaseAttrbuteValue3Vo(); objAttrValueDelSet.IS_DEL = "1"; logicAttrValue.Edit(objAttrValueDelSet, objAttrValueDelWhere); //新增动态属性值 if (strAttribute.Length > 0) { string[] arrAttribute = strAttribute.Split('-'); for (int i = 0; i < arrAttribute.Length; i++) { string[] arrAttrValue = arrAttribute[i].Split('|'); TBaseAttrbuteValue3Vo objAttrValueAdd = new TBaseAttrbuteValue3Vo(); objAttrValueAdd.ID = GetSerialNumber("t_base_attribute_value3_id"); objAttrValueAdd.IS_DEL = "0"; objAttrValueAdd.OBJECT_TYPE = arrAttrValue[0]; objAttrValueAdd.OBJECT_ID = objPoint.ID; objAttrValueAdd.ATTRBUTE_CODE = arrAttrValue[1]; objAttrValueAdd.ATTRBUTE_VALUE = arrAttrValue[2]; isSuccess = logicAttrValue.Create(objAttrValueAdd); } } if (isSuccess) { return("1"); } else { return("0"); } }
/// <summary> /// 根据对象特征获取单一对象 /// </summary> /// <param name="tBaseCompanyPoint">对象</param> /// <returns></returns> public TBaseCompanyPointVo SelectByObject(TBaseCompanyPointVo tBaseCompanyPoint) { return(access.SelectByObject(tBaseCompanyPoint)); }