/// <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));
}
