/// <summary> /// 对象编辑 /// </summary> /// <param name="TBaseAttrbuteValue3_UpdateSet">UpdateSet用户对象</param> /// <param name="TBaseAttrbuteValue3_UpdateWhere">UpdateWhere用户对象</param> /// <returns>是否成功</returns> public bool Edit(TBaseAttrbuteValue3Vo TBaseAttrbuteValue3_UpdateSet, TBaseAttrbuteValue3Vo TBaseAttrbuteValue3_UpdateWhere) { string strSQL = SqlHelper.BuildUpdateExpress(TBaseAttrbuteValue3_UpdateSet, TBaseAttrbuteValue3Vo.T_BASE_ATTRBUTE_VALUE3_TABLE); strSQL += this.BuildWhereStatement(TBaseAttrbuteValue3_UpdateWhere); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="TBaseAttrbuteValue3">用户对象</param> /// <returns>是否成功</returns> public bool Edit(TBaseAttrbuteValue3Vo TBaseAttrbuteValue3) { string strSQL = SqlHelper.BuildUpdateExpress(TBaseAttrbuteValue3, TBaseAttrbuteValue3Vo.T_BASE_ATTRBUTE_VALUE3_TABLE); strSQL += string.Format(" where ID='{0}' ", TBaseAttrbuteValue3.ID); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 获取对象DataTable /// </summary> /// <param name="TBaseAttrbuteValue3">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public DataTable SelectByTable(TBaseAttrbuteValue3Vo TBaseAttrbuteValue3, int iIndex, int iCount) { string strSQL = " select * from T_BASE_ATTRBUTE_VALUE3 {0} "; strSQL = String.Format(strSQL, BuildWhereStatement(TBaseAttrbuteValue3)); return(SqlHelper.ExecuteDataTable(BuildPagerExpress(strSQL, iIndex, iCount))); }
/// <summary> /// 点位描述信息拷贝 /// </summary> /// <returns></returns> protected void AttributeValueCopy() { TMisMonitorTaskPointVo objTaskPoint = new TMisMonitorTaskPointVo(); objTaskPoint.SUBTASK_ID = this.SUBTASK_ID.Value; DataTable dt = new TMisMonitorTaskPointLogic().SelectByTable(objTaskPoint); for (int i = 0; i < dt.Rows.Count; i++) { TBaseAttrbuteValueVo objAttrbuteValue = new TBaseAttrbuteValueVo(); objAttrbuteValue.OBJECT_ID = dt.Rows[i]["POINT_ID"].ToString(); TBaseAttrbuteValue3Vo objAttrbuteValue3 = new TBaseAttrbuteValue3Vo(); objAttrbuteValue3.OBJECT_ID = dt.Rows[i]["ID"].ToString(); DataTable dtAtt3 = new TBaseAttrbuteValue3Logic().SelectByTable(objAttrbuteValue3); if (dtAtt3.Rows.Count > 0) return; DataTable dtAtt = new TBaseAttrbuteValueLogic().SelectByTable(objAttrbuteValue); for (int j = 0; j < dtAtt.Rows.Count; j++) { objAttrbuteValue3 = new TBaseAttrbuteValue3Vo(); objAttrbuteValue3.ID = GetSerialNumber("t_base_attribute_value3_id"); objAttrbuteValue3.OBJECT_TYPE = dtAtt.Rows[j]["OBJECT_TYPE"].ToString(); objAttrbuteValue3.OBJECT_ID = dt.Rows[i]["ID"].ToString(); objAttrbuteValue3.ATTRBUTE_CODE = dtAtt.Rows[j]["ATTRBUTE_CODE"].ToString(); objAttrbuteValue3.ATTRBUTE_VALUE = dtAtt.Rows[j]["ATTRBUTE_VALUE"].ToString(); objAttrbuteValue3.IS_DEL = dtAtt.Rows[j]["IS_DEL"].ToString(); new TBaseAttrbuteValue3Logic().Create(objAttrbuteValue3); } } }
/// <summary> /// 对象删除 /// </summary> /// <param name="Id">ID</param> /// <returns>是否成功</returns> public bool Delete(TBaseAttrbuteValue3Vo TBaseAttrbuteValue3) { string strSQL = "delete from T_BASE_ATTRBUTE_VALUE3 "; strSQL += this.BuildWhereStatement(TBaseAttrbuteValue3); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
public static string SaveDataAttr(string strPointID, string strAttrID, string strAttribute) { bool isSuccess = true; TMisMonitorTaskPointVo objPoint = new TMisMonitorTaskPointVo(); objPoint.ID = strPointID; objPoint.DYNAMIC_ATTRIBUTE_ID = strAttrID; isSuccess = new TMisMonitorTaskPointLogic().Edit(objPoint); TBaseAttrbuteValue3Logic logicAttrValue = new TBaseAttrbuteValue3Logic(); //清掉原有动态属性值 TBaseAttrbuteValue3Vo objAttrValueDelWhere = new TBaseAttrbuteValue3Vo(); objAttrValueDelWhere.OBJECT_ID = strPointID; 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 = strPointID; objAttrValueAdd.ATTRBUTE_CODE = arrAttrValue[1]; objAttrValueAdd.ATTRBUTE_VALUE = arrAttrValue[2]; isSuccess = logicAttrValue.Create(objAttrValueAdd); } } if (isSuccess) { return("1"); } else { return("0"); } }
//获取点位对应的动态属性值 private void GetAttrValue(string strID) { TMisMonitorTaskPointVo objPoint = new TMisMonitorTaskPointLogic().Details(strID); TBaseAttrbuteValue3Vo objAttrValue = new TBaseAttrbuteValue3Vo(); objAttrValue.IS_DEL = "0"; objAttrValue.OBJECT_ID = strID; DataTable dt = new TBaseAttrbuteValue3Logic().SelectByTable(objAttrValue); string strJson = DataTableToJson(dt); Response.Write(strJson); Response.End(); }
public static string saveSample(string id, string strPointID, string strCellName, string strCellValue) { bool isSuccess = false; if (!strCellName.Contains("@")) { isSuccess = new TMisMonitorSampleInfoLogic().UpdateSampleCell(id, strCellName, strCellValue); } else { if (strPointID == "") { isSuccess = false; } else { string[] strInfo = strCellName.Split('@'); TBaseAttrbuteValue3Vo objAttValue = new TBaseAttrbuteValue3Vo(); objAttValue.OBJECT_ID = strPointID; objAttValue.ATTRBUTE_CODE = strInfo[0].ToString(); objAttValue.IS_DEL = "0"; objAttValue = new TBaseAttrbuteValue3Logic().Details(objAttValue); if (objAttValue.ID == "") { objAttValue.ID = GetSerialNumber("t_base_attribute_value3_id"); objAttValue.IS_DEL = "0"; objAttValue.OBJECT_ID = strPointID; objAttValue.OBJECT_TYPE = strInfo[3].ToString(); objAttValue.ATTRBUTE_CODE = strInfo[0].ToString(); objAttValue.ATTRBUTE_VALUE = strCellValue; isSuccess = new TBaseAttrbuteValue3Logic().Create(objAttValue); } else { objAttValue.ATTRBUTE_VALUE = strCellValue; isSuccess = new TBaseAttrbuteValue3Logic().Edit(objAttValue); } } } return(isSuccess == true ? "1" : "0"); }
public static string deletePoint(string strValue) { TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoLogic().Details(strValue); TMisMonitorTaskPointVo objPoint = new TMisMonitorTaskPointVo(); objPoint.ID = objSample.POINT_ID; objPoint.IS_DEL = "1"; bool isSuccess = new TMisMonitorTaskPointLogic().Edit(objPoint); TBaseAttrbuteValue3Vo objAttrValueDelWhere = new TBaseAttrbuteValue3Vo(); objAttrValueDelWhere.OBJECT_ID = strValue; objAttrValueDelWhere.IS_DEL = "0"; TBaseAttrbuteValue3Vo objAttrValueDelSet = new TBaseAttrbuteValue3Vo(); objAttrValueDelSet.IS_DEL = "1"; new TBaseAttrbuteValue3Logic().Edit(objAttrValueDelSet, objAttrValueDelWhere); new TMisMonitorSampleInfoLogic().Delete(objSample); return(isSuccess == true ? "1" : "0"); }
/// <summary> /// 对象明细 /// </summary> /// <param name="TBaseAttrbuteValue3">对象条件</param> /// <returns>对象</returns> public TBaseAttrbuteValue3Vo Details(TBaseAttrbuteValue3Vo TBaseAttrbuteValue3) { string strSQL = String.Format("select * from T_BASE_ATTRBUTE_VALUE3 " + this.BuildWhereStatement(TBaseAttrbuteValue3)); return(SqlHelper.ExecuteObject(new TBaseAttrbuteValue3Vo(), strSQL)); }
/// <summary> /// 获得查询结果总行数,用于分页 /// </summary> /// <param name="TBaseAttrbuteValue3">对象</param> /// <returns>返回行数</returns> public int GetSelectResultCount(TBaseAttrbuteValue3Vo TBaseAttrbuteValue3) { string strSQL = "select Count(*) from T_BASE_ATTRBUTE_VALUE3 " + this.BuildWhereStatement(TBaseAttrbuteValue3); return(Convert.ToInt32(SqlHelper.ExecuteScalar(strSQL))); }
/// <summary> /// 根据对象构造条件语句 /// </summary> /// <param name="TBaseAttrbuteValue3"></param> /// <returns></returns> public string BuildWhereStatement(TBaseAttrbuteValue3Vo TBaseAttrbuteValue3) { StringBuilder strWhereStatement = new StringBuilder(" Where 1=1 "); if (null != TBaseAttrbuteValue3) { //ID if (!String.IsNullOrEmpty(TBaseAttrbuteValue3.ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND ID = '{0}'", TBaseAttrbuteValue3.ID.ToString())); } //对象类型 if (!String.IsNullOrEmpty(TBaseAttrbuteValue3.OBJECT_TYPE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND OBJECT_TYPE = '{0}'", TBaseAttrbuteValue3.OBJECT_TYPE.ToString())); } //对象ID if (!String.IsNullOrEmpty(TBaseAttrbuteValue3.OBJECT_ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND OBJECT_ID = '{0}'", TBaseAttrbuteValue3.OBJECT_ID.ToString())); } //属性名称 if (!String.IsNullOrEmpty(TBaseAttrbuteValue3.ATTRBUTE_CODE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND ATTRBUTE_CODE = '{0}'", TBaseAttrbuteValue3.ATTRBUTE_CODE.ToString())); } //属性值 if (!String.IsNullOrEmpty(TBaseAttrbuteValue3.ATTRBUTE_VALUE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND ATTRBUTE_VALUE = '{0}'", TBaseAttrbuteValue3.ATTRBUTE_VALUE.ToString())); } //使用状态(0为启用、1为停用) if (!String.IsNullOrEmpty(TBaseAttrbuteValue3.IS_DEL.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND IS_DEL = '{0}'", TBaseAttrbuteValue3.IS_DEL.ToString())); } //备注1 if (!String.IsNullOrEmpty(TBaseAttrbuteValue3.REMARK1.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK1 = '{0}'", TBaseAttrbuteValue3.REMARK1.ToString())); } //备注2 if (!String.IsNullOrEmpty(TBaseAttrbuteValue3.REMARK2.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK2 = '{0}'", TBaseAttrbuteValue3.REMARK2.ToString())); } //备注3 if (!String.IsNullOrEmpty(TBaseAttrbuteValue3.REMARK3.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK3 = '{0}'", TBaseAttrbuteValue3.REMARK3.ToString())); } //备注4 if (!String.IsNullOrEmpty(TBaseAttrbuteValue3.REMARK4.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK4 = '{0}'", TBaseAttrbuteValue3.REMARK4.ToString())); } //备注5 if (!String.IsNullOrEmpty(TBaseAttrbuteValue3.REMARK5.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK5 = '{0}'", TBaseAttrbuteValue3.REMARK5.ToString())); } } return(strWhereStatement.ToString()); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="TBaseAttrbuteValue3_UpdateSet">UpdateSet用户对象</param> /// <param name="TBaseAttrbuteValue3_UpdateWhere">UpdateWhere用户对象</param> /// <returns>是否成功</returns> public bool Edit(TBaseAttrbuteValue3Vo TBaseAttrbuteValue3_UpdateSet, TBaseAttrbuteValue3Vo TBaseAttrbuteValue3_UpdateWhere) { return(access.Edit(TBaseAttrbuteValue3_UpdateSet, TBaseAttrbuteValue3_UpdateWhere)); }
/// <summary> /// 对象删除 /// </summary> /// <param name="Id">ID</param> /// <returns>是否成功</returns> public bool Delete(TBaseAttrbuteValue3Vo TBaseAttrbuteValue33) { return(access.Delete(TBaseAttrbuteValue33)); }
/// <summary> /// 对象明细 /// </summary> /// <param name="TBaseAttrbuteValue33">对象条件</param> /// <returns>对象</returns> public TBaseAttrbuteValue3Vo Details(TBaseAttrbuteValue3Vo TBaseAttrbuteValue33) { return(access.Details(TBaseAttrbuteValue33)); }
/// <summary> /// 根据对象获取全部数据,用Table承载 /// 数据量较小时使用【不推荐】 /// </summary> /// <param name="TBaseAttrbuteValue3"></param> /// <returns></returns> public DataTable SelectByTable(TBaseAttrbuteValue3Vo TBaseAttrbuteValue3) { string strSQL = "select * from T_BASE_ATTRBUTE_VALUE3 " + this.BuildWhereStatement(TBaseAttrbuteValue3); return(SqlHelper.ExecuteDataTable(strSQL)); }
/// <summary> /// 对象添加 /// </summary> /// <param name="sysRole">对象</param> /// <returns>是否成功</returns> public bool Create(TBaseAttrbuteValue3Vo TBaseAttrbuteValue33) { return(access.Create(TBaseAttrbuteValue33)); }
public string UpdateSubTaskInfo(string workID, string strUser, string JsonSubTask, string JsonPoint, string JsonItem) { string strResult = "false"; var identification = CCFlowFacade.GetFlowIdentification(strUser, long.Parse(workID)); TMisMonitorSubtaskVo objSubtaskVo = new TMisMonitorSubtaskLogic().Details(identification); TMisMonitorTaskVo objTaskVo = new TMisMonitorTaskLogic().Details(objSubtaskVo.TASK_ID); DataTable dtSubTask = JSONToDataTable2(JsonSubTask); DataTable dtPoint = JSONToDataTable2(JsonPoint); DataTable dtItem = JSONToDataTable2(JsonItem); //更新任务的现状信息 if (dtSubTask.Rows.Count > 0) { objSubtaskVo.SAMPLE_ASK_DATE = dtSubTask.Rows[0]["SAMPLE_ASK_DATE"].ToString(); new TMisMonitorSubtaskLogic().Edit(objSubtaskVo); for (int i = 0; i < dtSubTask.Columns.Count; i++) { if (dtSubTask.Columns[i].ColumnName != "TICKET_NUM" && dtSubTask.Columns[i].ColumnName != "SAMPLE_ASK_DATE") { TMisMonitorSampleSkyVo objSampleSky = new TMisMonitorSampleSkyVo(); objSampleSky.SUBTASK_ID = objSubtaskVo.ID; objSampleSky.WEATHER_ITEM = dtSubTask.Columns[i].ColumnName; objSampleSky = new TMisMonitorSampleSkyLogic().Details(objSampleSky); if (objSampleSky.ID.Length > 0) { objSampleSky.WEATHER_INFO = dtSubTask.Rows[0][i].ToString(); new TMisMonitorSampleSkyLogic().Edit(objSampleSky); } else { objSampleSky.ID = GetSerialNumber("TMisMonitorSampleSky"); objSampleSky.SUBTASK_ID = objSubtaskVo.ID; objSampleSky.WEATHER_ITEM = dtSubTask.Columns[i].ColumnName; objSampleSky.WEATHER_INFO = dtSubTask.Rows[0][i].ToString(); new TMisMonitorSampleSkyLogic().Create(objSampleSky); } } } strResult = "true"; } //更新监测点位信息 if (dtPoint.Rows.Count > 0) { for (int i = 0; i < dtPoint.Rows.Count; i++) { TMisMonitorSampleInfoVo objSampleInfoVo = new TMisMonitorSampleInfoVo(); objSampleInfoVo.SUBTASK_ID = objSubtaskVo.ID; objSampleInfoVo.SAMPLE_NAME = dtPoint.Rows[i]["SAMPLE_NAME"].ToString(); objSampleInfoVo = new TMisMonitorSampleInfoLogic().Details(objSampleInfoVo); if (objSampleInfoVo.ID.Length > 0) { objSampleInfoVo.SAMPLE_COUNT = dtPoint.Rows[i]["SAMPLE_COUNT"].ToString(); new TMisMonitorSampleInfoLogic().Edit(objSampleInfoVo); #region 更新点位图 if (dtPoint.Rows[i]["photo"].ToString().Length > 0) { string strImage = dtPoint.Rows[i]["photo"].ToString(); int tag = 0; FileStream out1 = null; byte[] bs = Convert.FromBase64String(strImage); //获取主文件路径 string mastPath = System.Configuration.ConfigurationManager.AppSettings["AttPath"].ToString(); //获取业务Id string strBusinessId = objSampleInfoVo.ID; //获取业务类型 string strBusinessType = "PointPoto"; //获取完整文件名称 string strFullName = strBusinessId + ".png"; //获取文件扩展名称 string strExtendName = strFullName.Substring(strFullName.LastIndexOf(".")); string strSerialNumber = GetSerialNumber("attFileId"); //文件夹路径 string strfolderPath = strBusinessType + "\\" + DateTime.Now.ToString("yyyyMMdd"); //新命名的文件名称 string strNewFileName = DateTime.Now.ToString("yyyyMMddHHmm") + "-" + strSerialNumber + strExtendName; //上传的完整路径 string strResultPath = mastPath + "\\" + strfolderPath + "\\" + strNewFileName; //开始上传附件 try { //判断文件夹是否存在,如果不存在则创建 if (Directory.Exists(mastPath + "\\" + strfolderPath) == false) { Directory.CreateDirectory(mastPath + "\\" + strfolderPath); } //判断原来是否已经上传过文件,如果有的话则获取原来已经上传的文件路径 TOaAttVo TOaAttVo = new TOaAttVo(); TOaAttVo.BUSINESS_TYPE = strBusinessType; TOaAttVo.BUSINESS_ID = strBusinessId; //TOaAttVo.ATTACH_NAME = this.ATTACH_NAME.Text.Trim(); DataTable objTable = new TOaAttLogic().SelectByTable(TOaAttVo); if (objTable.Rows.Count > 0) { //如果存在记录 //获取该记录的ID string strId = objTable.Rows[0]["ID"].ToString(); //获取原来文件的路径 string strOldFilePath = objTable.Rows[0]["UPLOAD_PATH"].ToString(); //如果存在的话,删除原来的文件 if (File.Exists(mastPath + "\\" + strOldFilePath)) { File.Delete(mastPath + "\\" + strOldFilePath); } //将新的信息写入数据库 TOaAttVo TOaAttVoTemp = new TOaAttVo(); TOaAttVoTemp.ID = strId; TOaAttVoTemp.ATTACH_NAME = "点位图"; TOaAttVoTemp.ATTACH_TYPE = strExtendName; TOaAttVoTemp.UPLOAD_PATH = strfolderPath + "\\" + strNewFileName; TOaAttVoTemp.UPLOAD_DATE = DateTime.Now.ToString("yyyy-MM-dd"); TOaAttVoTemp.UPLOAD_PERSON = strUser; TOaAttVoTemp.DESCRIPTION = "点位图"; TOaAttVoTemp.REMARKS = bs.Length + "KB";//文件的大小 new TOaAttLogic().Edit(TOaAttVoTemp); } else { //如果不存在记录 TOaAttVo TOaAttVoTemp = new TOaAttVo(); TOaAttVoTemp.ID = strSerialNumber; TOaAttVoTemp.BUSINESS_ID = strBusinessId; TOaAttVoTemp.BUSINESS_TYPE = strBusinessType; TOaAttVoTemp.ATTACH_NAME = "点位图"; TOaAttVoTemp.ATTACH_TYPE = strExtendName; TOaAttVoTemp.UPLOAD_PATH = strfolderPath + "\\" + strNewFileName; TOaAttVoTemp.UPLOAD_DATE = DateTime.Now.ToString("yyyy-MM-dd"); TOaAttVoTemp.UPLOAD_PERSON = strUser; TOaAttVoTemp.DESCRIPTION = "点位图"; TOaAttVoTemp.REMARKS = bs.Length + "KB";//文件的大小 new TOaAttLogic().Create(TOaAttVoTemp); } if (tag == 0) { out1 = new FileStream(strResultPath, FileMode.CreateNew, FileAccess.Write); } else { out1 = new FileStream(strResultPath, FileMode.Append, FileAccess.Write); } out1.Write(bs, 0, bs.Length); if (out1 != null) { try { out1.Close(); } catch (IOException e) { // TODO Auto-generated catch block } } } catch (Exception ex) { } } #endregion for (int j = 0; j < dtPoint.Columns.Count; j++) { if (dtPoint.Columns[j].ColumnName != "SAMPLE_NAME" && dtPoint.Columns[j].ColumnName != "SAMPLE_COUNT" && dtPoint.Columns[j].ColumnName != "photo") { TBaseAttributeInfoVo objAttributeInfoVo = new TBaseAttributeInfoVo(); objAttributeInfoVo.IS_DEL = "0"; objAttributeInfoVo.ATTRIBUTE_NAME = dtPoint.Columns[j].ColumnName; objAttributeInfoVo = new TBaseAttributeInfoLogic().Details(objAttributeInfoVo); if (objAttributeInfoVo.ID.Length > 0) { string Attribute_Code = objAttributeInfoVo.ID; TBaseAttrbuteValue3Vo objAttValue = new TBaseAttrbuteValue3Vo(); objAttValue.OBJECT_ID = objSampleInfoVo.POINT_ID; objAttValue.ATTRBUTE_CODE = Attribute_Code; objAttValue.IS_DEL = "0"; objAttValue = new TBaseAttrbuteValue3Logic().Details(objAttValue); if (objAttValue.ID == "") { objAttValue.ID = GetSerialNumber("t_base_attribute_value3_id"); objAttValue.IS_DEL = "0"; objAttValue.OBJECT_ID = objSampleInfoVo.POINT_ID; objAttValue.OBJECT_TYPE = objAttributeInfoVo.CONTROL_NAME; objAttValue.ATTRBUTE_CODE = Attribute_Code; objAttValue.ATTRBUTE_VALUE = dtPoint.Rows[i][dtPoint.Columns[j].ColumnName.ToString()].ToString(); new TBaseAttrbuteValue3Logic().Create(objAttValue); } else { objAttValue.ATTRBUTE_VALUE = dtPoint.Rows[i][dtPoint.Columns[j].ColumnName.ToString()].ToString(); new TBaseAttrbuteValue3Logic().Edit(objAttValue); } } } } } } strResult = "true"; } //更新监测项目的信息 if (dtItem.Rows.Count > 0) { for (int i = 0; i < dtItem.Rows.Count; i++) { TMisMonitorSampleInfoVo objSampleInfoVo = new TMisMonitorSampleInfoVo(); objSampleInfoVo.SUBTASK_ID = objSubtaskVo.ID; objSampleInfoVo.SAMPLE_NAME = dtItem.Rows[i]["SAMPLE_NAME"].ToString(); objSampleInfoVo = new TMisMonitorSampleInfoLogic().Details(objSampleInfoVo); if (objSampleInfoVo.ID.Length > 0) { TBaseItemInfoVo objItemInfoVo = new TBaseItemInfoVo(); objItemInfoVo.ITEM_NAME = dtItem.Rows[i]["ITEM_NAME"].ToString(); objItemInfoVo.IS_DEL = "0"; objItemInfoVo = new TBaseItemInfoLogic().Details(objItemInfoVo); TMisMonitorResultVo objResultVo = new TMisMonitorResultVo(); objResultVo.SAMPLE_ID = objSampleInfoVo.ID; objResultVo.ITEM_ID = objItemInfoVo.ID; TMisMonitorResultVo objResultSetVo = new TMisMonitorResultVo(); objResultSetVo.ITEM_RESULT = dtItem.Rows[i]["ITEM_RESULT"].ToString(); new TMisMonitorResultLogic().Edit(objResultSetVo, objResultVo); } } strResult = "true"; } return(strResult); }
/// <summary> /// 根据对象获取全部数据,用Table承载 /// 数据量较小时使用【不推荐】 /// </summary> /// <param name="TBaseAttrbuteValue33"></param> /// <returns></returns> public DataTable SelectByTable(TBaseAttrbuteValue3Vo TBaseAttrbuteValue33) { return(access.SelectByTable(TBaseAttrbuteValue33)); }
/// <summary> /// 获取对象DataTable /// </summary> /// <param name="TBaseAttrbuteValue33">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public DataTable SelectByTable(TBaseAttrbuteValue3Vo TBaseAttrbuteValue33, int iIndex, int iCount) { return(access.SelectByTable(TBaseAttrbuteValue33, iIndex, iCount)); }
/// <summary> /// 获取对象List /// </summary> /// <param name="TBaseAttrbuteValue33">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public List <TBaseAttrbuteValue3Vo> SelectByObject(TBaseAttrbuteValue3Vo TBaseAttrbuteValue33, int iIndex, int iCount) { return(access.SelectByObject(TBaseAttrbuteValue33, iIndex, iCount)); }
/// <summary> /// 获取对象List /// </summary> /// <param name="TBaseAttrbuteValue3">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public List <TBaseAttrbuteValue3Vo> SelectByObject(TBaseAttrbuteValue3Vo TBaseAttrbuteValue3, int iIndex, int iCount) { string strSQL = String.Format("select * from T_BASE_ATTRBUTE_VALUE3 " + this.BuildWhereStatement(TBaseAttrbuteValue3)); return(SqlHelper.ExecuteObjectList(TBaseAttrbuteValue3, BuildPagerExpress(strSQL, iIndex, iCount))); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="TBaseAttrbuteValue33">用户对象</param> /// <returns>是否成功</returns> public bool Edit(TBaseAttrbuteValue3Vo TBaseAttrbuteValue33) { return(access.Edit(TBaseAttrbuteValue33)); }
/// <summary> /// 对象添加 /// </summary> /// <param name="TBaseAttrbuteValue3">对象</param> /// <returns>是否成功</returns> public bool Create(TBaseAttrbuteValue3Vo TBaseAttrbuteValue3) { string strSQL = SqlHelper.BuildInsertExpress(TBaseAttrbuteValue3, TBaseAttrbuteValue3Vo.T_BASE_ATTRBUTE_VALUE3_TABLE); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
public TBaseAttrbuteValue3Logic(TBaseAttrbuteValue3Vo _TBaseAttrbuteValue3) { TBaseAttrbuteValue33 = _TBaseAttrbuteValue3; access = new TBaseAttrbuteValue3Access(); }
/// <summary> /// 获得查询结果总行数,用于分页 /// </summary> /// <param name="TBaseAttrbuteValue33">对象</param> /// <returns>返回行数</returns> public int GetSelectResultCount(TBaseAttrbuteValue3Vo TBaseAttrbuteValue33) { return(access.GetSelectResultCount(TBaseAttrbuteValue33)); }
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="TBaseAttrbuteValue33">对象</param> /// <returns></returns> public TBaseAttrbuteValue3Vo SelectByObject(TBaseAttrbuteValue3Vo TBaseAttrbuteValue33) { return(access.SelectByObject(TBaseAttrbuteValue33)); }