/// <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); } } }
//获取点位对应的动态属性值 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(); }
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(""); } }