public string PasteItem(string strFID, string strTID, string strSerial) //strfid为源复制的监测项目ID，strTid为目标复制的监测项目ID
{
i3.DataAccess.Channels.Env.Point.Common.CommonAccess com = new Common.CommonAccess();
bool b = true;
string Msg = string.Empty;
DataTable dt = new DataTable();
string sql = string.Empty;
ArrayList list = new ArrayList();
string strID = string.Empty;
string originalType = this.GetType(strFID);
string targetType = this.GetType(strTID);
if (!string.IsNullOrEmpty(originalType) && !string.IsNullOrEmpty(targetType))
{
if (originalType == targetType)
{
#region//都为相同类型时，可以复制
sql = "select * from " + TEnvPPolluteItemVo.T_ENV_P_POLLUTE_ITEM_TABLE + " where POINT_ID='" + strFID + "'";
dt = SqlHelper.ExecuteDataTable(sql);
if (dt.Rows.Count > 0)
{
sql = "delete from " + TEnvPPolluteItemVo.T_ENV_P_POLLUTE_ITEM_TABLE + " where POINT_ID='" + strTID + "'";
list.Add(sql);
foreach (DataRow row in dt.Rows)
{
strID = GetSerialNumber(strSerial);
sql = com.getCopySql(TEnvPPolluteItemVo.T_ENV_P_POLLUTE_ITEM_TABLE, row, "", "", strTID, strID);
list.Add(sql);
}
if (SqlHelper.ExecuteSQLByTransaction(list))
{
b = true;
}
else
{
b = false;
Msg = "数据库更新失败";
}
}
#endregion
}
else
{
Msg = "两个监测点的类型不一致,不能复制";
}
}
if (b)
{
return("({result:true,msg:''})");
}
else
{
return("({result:false,msg:'" + Msg + "'})");
}
}
/// <summary>
/// 监测项目的复制逻辑
/// </summary>
/// <param name="strFID"></param>
/// <param name="strTID"></param>
/// <param name="strSerial"></param>
/// <returns></returns>
public string PasteItem(string strFID, string strTID, string strSerial)
{
i3.DataAccess.Channels.Env.Point.Common.CommonAccess com = new Common.CommonAccess();
bool b = true;
string Msg = string.Empty;
DataTable dt = new DataTable();
string sql = string.Empty;
ArrayList list = new ArrayList();
string strID = string.Empty;
sql = "select * from " + TEnvPSolidItemVo.T_ENV_P_SOLID_ITEM_TABLE + " where POINT_ID='" + strFID + "'";
dt = SqlHelper.ExecuteDataTable(sql);
if (dt.Rows.Count > 0)
{
sql = "delete from " + TEnvPSolidItemVo.T_ENV_P_SOLID_ITEM_TABLE + " where POINT_ID='" + strTID + "'";
list.Add(sql);
foreach (DataRow row in dt.Rows)
{
strID = GetSerialNumber(strSerial);
sql = com.getCopySql(TEnvPSolidItemVo.T_ENV_P_SOLID_ITEM_TABLE, row, "", "", strTID, strID);
list.Add(sql);
}
if (SqlHelper.ExecuteSQLByTransaction(list))
{
b = true;
}
else
{
b = false;
Msg = "数据库更新失败";
}
}
if (b)
{
return("({result:true,msg:''})");
}
else
{
return("({result:false,msg:'" + Msg + "'})");
}
}