/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="sw">参见模型T_SYS_PEST_OBSERVEAREA_SW</param>
/// <returns>参见模型T_SYS_TREESPECIES_PEST_Model</returns>
public static IEnumerable <T_SYS_TREESPECIES_PEST_Model> getListModel(T_SYS_TREESPECIES_PEST_SW sw)
{
var result = new List <T_SYS_TREESPECIES_PEST_Model>();
DataTable dt = BaseDT.T_SYS_TREESPECIES_PEST.getDT(sw);
for (int i = 0; i < dt.Rows.Count; i++)
{
T_SYS_TREESPECIES_PEST_Model m = new T_SYS_TREESPECIES_PEST_Model();
m.PESTCODE = dt.Rows[i]["PESTCODE"].ToString();
m.TSPCODE = dt.Rows[i]["TSPCODE"].ToString();
result.Add(m);
}
dt.Clear();
dt.Dispose();
return(result);
}
/// <summary>
/// 获取单条记录
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static T_SYS_TREESPECIES_PEST_Model getModel(T_SYS_TREESPECIES_PEST_SW sw)
{
DataTable dt = BaseDT.T_SYS_TREESPECIES_PEST.getDT(sw);
T_SYS_TREESPECIES_PEST_Model m = new T_SYS_TREESPECIES_PEST_Model();
if (dt.Rows.Count > 0)
{
int i = 0;
//数据库表字段
m.PESTCODE = dt.Rows[i]["PESTCODE"].ToString();
m.TSPCODE = dt.Rows[i]["TSPCODE"].ToString();
//扩充字段
}
dt.Clear();
dt.Dispose();
return(m);
}
/// <summary>
/// 保存
/// </summary>
/// <param name="m">参见模型</param>
/// <returns></returns>
public static Message Save(T_SYS_TREESPECIES_PEST_Model m)
{
string[] arrTSPCODE = m.TSPCODE.Split(',');
List <string> sqllist = new List <string>();
#region 先删除
string sql = "delete from T_SYS_TREESPECIES_PEST where PESTCODE='" + m.PESTCODE + "'";
DataBaseClass.ExeSql(sql);
#endregion
#region 再更新
if (arrTSPCODE.Length > 0)
{
StringBuilder sbInsert = new StringBuilder();
sbInsert.AppendFormat("INSERT INTO T_SYS_TREESPECIES_PEST(PESTCODE,TSPCODE)");
for (int i = 0; i < arrTSPCODE.Length; i++)
{
sbInsert.AppendFormat(" select '{0}'", ClsSql.EncodeSql(m.PESTCODE));
sbInsert.AppendFormat(",'{0}'", ClsSql.EncodeSql(arrTSPCODE[i]));
if (i != arrTSPCODE.Length - 1)
{
sbInsert.AppendFormat(" UNION ALL ");
}
}
sqllist.Add(sbInsert.ToString());
}
#endregion
#region 再更新本地有害生物状态
StringBuilder sbUpdate = new StringBuilder();
sbUpdate.AppendFormat("UPDATE T_SYS_PEST SET ISLOCAL='1' where PESTCODE= '{0}'", ClsSql.EncodeSql(m.PESTCODE));
sqllist.Add(sbUpdate.ToString());
#endregion
var y = DataBaseClass.ExecuteSqlTran(sqllist);
if (y >= 0)
{
return(new Message(true, "关联成功!", ""));
}
else
{
return(new Message(false, "关联失败，事物回滚机制!", ""));
}
}
/// <summary>
/// 保存
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Manager(T_SYS_TREESPECIES_PEST_Model m)
{
return(BaseDT.T_SYS_TREESPECIES_PEST.Save(m));
}
