/// <summary>
/// 空间库火险等级更新 根据QH_CODE更新
/// </summary>
/// <param name="m"></param>
/// <returns></returns>
public static Message UpdateAceHuoXianDengJiByQHCODE(YJ_DANGERCLASS_Model m)
{
List <string> sqllist = new List <string>();
var arrBYORGNO = m.BYORGNO.Split(',');
var arrDANGERCLASS = m.DANGERCLASS.Split(',');
Message ms = null;
StringBuilder sb1 = new StringBuilder();
for (int i = 0; i < arrBYORGNO.Length - 1; i++)
{
if (ClsSql.EncodeSql(arrDANGERCLASS[i]) != "")
{
string QHCODE = arrBYORGNO[i] + "000";
sb1.AppendFormat(" Update HUOXIANDENGJI set DValue={0}", ClsSql.EncodeSql(arrDANGERCLASS[i]));
sb1.AppendFormat(" Where QH_CODE='{0}'", ClsSql.EncodeSql(QHCODE));
sqllist.Add(sb1.ToString());
sb1.Remove(0, sb1.Length);
}
}
var j = SDEDataBaseClass.ExecuteSqlTran(sqllist);
if (j >= 0)
{
ms = new Message(true, "保存成功!", "");
}
else
{
ms = new Message(false, "保存失败,事物回滚!", "");
}
return(ms);
}
/// <summary>
/// 更新三维库危害等级
/// </summary>
/// <param name="m"></param>
/// <returns></returns>
public static Message UpdateAceHarmClass(PEST_HARMCLASS_Model m)
{
List <string> sqllist = new List <string>();
var arrBYORGNO = m.BYORGNO.Split(',');
var arrHARMCLASS = m.HARMCLASS.Split(',');
var arrDCDATE = m.DCDATE.Split(',');
for (int i = 0; i < arrBYORGNO.Length - 1; i++)
{
if (ClsSql.EncodeSql(arrHARMCLASS[i]) != "")
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat(" UPDATE PESTHARMCLASS SET ");
sb.AppendFormat(" HARMCLASS='{0}'", ClsSql.EncodeSql(arrHARMCLASS[i]));
sb.AppendFormat(",DCDATE={0}", ClsSql.saveNullField(arrDCDATE[i]));
sb.AppendFormat(" WHERE BYORGNO='{0}'", ClsSql.EncodeSql(arrBYORGNO[i]));
sqllist.Add(sb.ToString());
}
}
var j = SDEDataBaseClass.ExecuteSqlTran(sqllist);
if (j >= 0)
{
return(new Message(true, "保存成功!", ""));
}
else
{
return(new Message(false, "保存失败,事物回滚!", ""));
}
}
/// <summary>
/// 更新三维库危害等级
/// </summary>
/// <param name="m"></param>
/// <returns></returns>
public static Message UpdateAceHarmClass_XZ(PEST_HARMCLASS_Model m)
{
Message ms = null;
StringBuilder sb1 = new StringBuilder();
sb1.AppendFormat(" Update PESTHARMCLASS_XZ Set DValue={0}", ClsSql.EncodeSql(m.DValue));
sb1.AppendFormat(" Where NAME='{0}'", ClsSql.EncodeSql(m.Name));
List <string> sqllist = new List <string>();
sqllist.Add(sb1.ToString());
var i = SDEDataBaseClass.ExecuteSqlTran(sqllist);
if (i > 0)
{
ms = new Message(true, "更新成功!", "");
}
else
{
ms = new Message(false, "更新失败,事物回滚机制!", "");
}
return(ms);
}
/// <summary>
/// 空间火险等级更新
/// </summary>
/// <param name="m"></param>
/// <returns></returns>
public static Message UpdateAceHuoXianDengJi(YJ_DANGERCLASS_Model m)
{
Message ms = null;
StringBuilder sb1 = new StringBuilder();
sb1.AppendFormat(" Update HUOXIANDENGJI set DValue={0}", ClsSql.EncodeSql(m.DValue));
sb1.AppendFormat(" Where NAME='{0}'", ClsSql.EncodeSql(m.Name));
List <string> sqllist = new List <string>();
sqllist.Add(sb1.ToString());
var i = SDEDataBaseClass.ExecuteSqlTran(sqllist);
if (i > 0)
{
ms = new Message(true, "处理成功!", "");
}
else
{
ms = new Message(false, "处理失败，事物回滚机制!", "");
}
return(ms);
}