/// <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); } } }
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> /// 对象编辑 /// </summary> /// <param name="tBaseAttrbuteValue_UpdateSet">UpdateSet用户对象</param> /// <param name="tBaseAttrbuteValue_UpdateWhere">UpdateWhere用户对象</param> /// <returns>是否成功</returns> public bool Edit(TBaseAttrbuteValueVo tBaseAttrbuteValue_UpdateSet, TBaseAttrbuteValueVo tBaseAttrbuteValue_UpdateWhere) { string strSQL = SqlHelper.BuildUpdateExpress(tBaseAttrbuteValue_UpdateSet, TBaseAttrbuteValueVo.T_BASE_ATTRBUTE_VALUE_TABLE); strSQL += this.BuildWhereStatement(tBaseAttrbuteValue_UpdateWhere); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 获取对象DataTable /// </summary> /// <param name="tBaseAttrbuteValue">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public DataTable SelectByTable(TBaseAttrbuteValueVo tBaseAttrbuteValue, int iIndex, int iCount) { string strSQL = " select * from T_BASE_ATTRBUTE_VALUE {0} "; strSQL = String.Format(strSQL, BuildWhereStatement(tBaseAttrbuteValue)); return(SqlHelper.ExecuteDataTable(BuildPagerExpress(strSQL, iIndex, iCount))); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tBaseAttrbuteValue">用户对象</param> /// <returns>是否成功</returns> public bool Edit(TBaseAttrbuteValueVo tBaseAttrbuteValue) { string strSQL = SqlHelper.BuildUpdateExpress(tBaseAttrbuteValue, TBaseAttrbuteValueVo.T_BASE_ATTRBUTE_VALUE_TABLE); strSQL += string.Format(" where ID='{0}' ", tBaseAttrbuteValue.ID); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 对象删除 /// </summary> /// <param name="Id">ID</param> /// <returns>是否成功</returns> public bool Delete(TBaseAttrbuteValueVo tBaseAttrbuteValue) { string strSQL = "delete from T_BASE_ATTRBUTE_VALUE "; strSQL += this.BuildWhereStatement(tBaseAttrbuteValue); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
//获取点位对应的动态属性值 private void GetAttrValue(string strID) { TBaseCompanyPointVo objPoint = new TBaseCompanyPointLogic().Details(strID); TBaseAttrbuteValueVo objAttrValue = new TBaseAttrbuteValueVo(); objAttrValue.IS_DEL = "0"; objAttrValue.OBJECT_ID = strID; DataTable dt = new TBaseAttrbuteValueLogic().SelectByTable(objAttrValue); string strJson = DataTableToJson(dt); Response.Write(strJson); Response.End(); }
/// <summary> /// 对象添加 /// </summary> /// <param name="sysRole">对象</param> /// <returns>是否成功</returns> public bool Create(TBaseAttrbuteValueVo tBaseAttrbuteValue) { return(access.Create(tBaseAttrbuteValue)); }
/// <summary> /// 对象明细 /// </summary> /// <param name="tBaseAttrbuteValue">对象条件</param> /// <returns>对象</returns> public TBaseAttrbuteValueVo Details(TBaseAttrbuteValueVo tBaseAttrbuteValue) { return(access.Details(tBaseAttrbuteValue)); }
/// <summary> /// 对象明细 /// </summary> /// <param name="tBaseAttrbuteValue">对象条件</param> /// <returns>对象</returns> public TBaseAttrbuteValueVo Details(TBaseAttrbuteValueVo tBaseAttrbuteValue) { string strSQL = String.Format("select * from T_BASE_ATTRBUTE_VALUE " + this.BuildWhereStatement(tBaseAttrbuteValue)); return(SqlHelper.ExecuteObject(new TBaseAttrbuteValueVo(), strSQL)); }
public TBaseAttrbuteValueLogic(TBaseAttrbuteValueVo _tBaseAttrbuteValue) { tBaseAttrbuteValue = _tBaseAttrbuteValue; access = new TBaseAttrbuteValueAccess(); }
/// <summary> /// 获得查询结果总行数,用于分页 /// </summary> /// <param name="tBaseAttrbuteValue">对象</param> /// <returns>返回行数</returns> public int GetSelectResultCount(TBaseAttrbuteValueVo tBaseAttrbuteValue) { return(access.GetSelectResultCount(tBaseAttrbuteValue)); }
/// <summary> /// 对象删除 /// </summary> /// <param name="Id">ID</param> /// <returns>是否成功</returns> public bool Delete(TBaseAttrbuteValueVo tBaseAttrbuteValue) { return(access.Delete(tBaseAttrbuteValue)); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tBaseAttrbuteValue_UpdateSet">UpdateSet用户对象</param> /// <param name="tBaseAttrbuteValue_UpdateWhere">UpdateWhere用户对象</param> /// <returns>是否成功</returns> public bool Edit(TBaseAttrbuteValueVo tBaseAttrbuteValue_UpdateSet, TBaseAttrbuteValueVo tBaseAttrbuteValue_UpdateWhere) { return(access.Edit(tBaseAttrbuteValue_UpdateSet, tBaseAttrbuteValue_UpdateWhere)); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tBaseAttrbuteValue">用户对象</param> /// <returns>是否成功</returns> public bool Edit(TBaseAttrbuteValueVo tBaseAttrbuteValue) { return(access.Edit(tBaseAttrbuteValue)); }
/// <summary> /// 根据对象构造条件语句 /// </summary> /// <param name="tBaseAttrbuteValue"></param> /// <returns></returns> public string BuildWhereStatement(TBaseAttrbuteValueVo tBaseAttrbuteValue) { StringBuilder strWhereStatement = new StringBuilder(" Where 1=1 "); if (null != tBaseAttrbuteValue) { //ID if (!String.IsNullOrEmpty(tBaseAttrbuteValue.ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND ID = '{0}'", tBaseAttrbuteValue.ID.ToString())); } //对象类型 if (!String.IsNullOrEmpty(tBaseAttrbuteValue.OBJECT_TYPE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND OBJECT_TYPE = '{0}'", tBaseAttrbuteValue.OBJECT_TYPE.ToString())); } //对象ID if (!String.IsNullOrEmpty(tBaseAttrbuteValue.OBJECT_ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND OBJECT_ID = '{0}'", tBaseAttrbuteValue.OBJECT_ID.ToString())); } //属性名称 if (!String.IsNullOrEmpty(tBaseAttrbuteValue.ATTRBUTE_CODE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND ATTRBUTE_CODE = '{0}'", tBaseAttrbuteValue.ATTRBUTE_CODE.ToString())); } //属性值 if (!String.IsNullOrEmpty(tBaseAttrbuteValue.ATTRBUTE_VALUE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND ATTRBUTE_VALUE = '{0}'", tBaseAttrbuteValue.ATTRBUTE_VALUE.ToString())); } //使用状态(0为启用、1为停用) if (!String.IsNullOrEmpty(tBaseAttrbuteValue.IS_DEL.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND IS_DEL = '{0}'", tBaseAttrbuteValue.IS_DEL.ToString())); } //备注1 if (!String.IsNullOrEmpty(tBaseAttrbuteValue.REMARK1.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK1 = '{0}'", tBaseAttrbuteValue.REMARK1.ToString())); } //备注2 if (!String.IsNullOrEmpty(tBaseAttrbuteValue.REMARK2.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK2 = '{0}'", tBaseAttrbuteValue.REMARK2.ToString())); } //备注3 if (!String.IsNullOrEmpty(tBaseAttrbuteValue.REMARK3.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK3 = '{0}'", tBaseAttrbuteValue.REMARK3.ToString())); } //备注4 if (!String.IsNullOrEmpty(tBaseAttrbuteValue.REMARK4.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK4 = '{0}'", tBaseAttrbuteValue.REMARK4.ToString())); } //备注5 if (!String.IsNullOrEmpty(tBaseAttrbuteValue.REMARK5.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK5 = '{0}'", tBaseAttrbuteValue.REMARK5.ToString())); } } return(strWhereStatement.ToString()); }
/// <summary> /// 获取对象List /// </summary> /// <param name="tBaseAttrbuteValue">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public List <TBaseAttrbuteValueVo> SelectByObject(TBaseAttrbuteValueVo tBaseAttrbuteValue, int iIndex, int iCount) { return(access.SelectByObject(tBaseAttrbuteValue, iIndex, iCount)); }
/// <summary> /// 获得查询结果总行数,用于分页 /// </summary> /// <param name="tBaseAttrbuteValue">对象</param> /// <returns>返回行数</returns> public int GetSelectResultCount(TBaseAttrbuteValueVo tBaseAttrbuteValue) { string strSQL = "select Count(*) from T_BASE_ATTRBUTE_VALUE " + this.BuildWhereStatement(tBaseAttrbuteValue); return(Convert.ToInt32(SqlHelper.ExecuteScalar(strSQL))); }
/// <summary> /// 获取对象DataTable /// </summary> /// <param name="tBaseAttrbuteValue">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public DataTable SelectByTable(TBaseAttrbuteValueVo tBaseAttrbuteValue, int iIndex, int iCount) { return(access.SelectByTable(tBaseAttrbuteValue, iIndex, iCount)); }
/// <summary> /// 获取对象List /// </summary> /// <param name="tBaseAttrbuteValue">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public List <TBaseAttrbuteValueVo> SelectByObject(TBaseAttrbuteValueVo tBaseAttrbuteValue, int iIndex, int iCount) { string strSQL = String.Format("select * from T_BASE_ATTRBUTE_VALUE " + this.BuildWhereStatement(tBaseAttrbuteValue)); return(SqlHelper.ExecuteObjectList(tBaseAttrbuteValue, BuildPagerExpress(strSQL, iIndex, iCount))); }
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="tBaseAttrbuteValue"></param> /// <returns></returns> public DataTable SelectByTable(TBaseAttrbuteValueVo tBaseAttrbuteValue) { string strSQL = "select * from T_BASE_ATTRBUTE_VALUE " + this.BuildWhereStatement(tBaseAttrbuteValue); return(SqlHelper.ExecuteDataTable(strSQL)); }
/// <summary> /// 对象添加 /// </summary> /// <param name="tBaseAttrbuteValue">对象</param> /// <returns>是否成功</returns> public bool Create(TBaseAttrbuteValueVo tBaseAttrbuteValue) { string strSQL = SqlHelper.BuildInsertExpress(tBaseAttrbuteValue, TBaseAttrbuteValueVo.T_BASE_ATTRBUTE_VALUE_TABLE); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 根据对象获取全部数据,用Table承载 /// 数据量较小时使用【不推荐】 /// </summary> /// <param name="tBaseAttrbuteValue"></param> /// <returns></returns> public DataTable SelectByTable(TBaseAttrbuteValueVo tBaseAttrbuteValue) { return(access.SelectByTable(tBaseAttrbuteValue)); }
/// <summary> /// 根据对象特征获取单一对象 /// </summary> /// <param name="tBaseAttrbuteValue">对象</param> /// <returns></returns> public TBaseAttrbuteValueVo SelectByObject(TBaseAttrbuteValueVo tBaseAttrbuteValue) { return(access.SelectByObject(tBaseAttrbuteValue)); }