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