/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(STBC.Model.EVALUATEDATA model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into EVALUATEDATA(");
strSql.Append("坡度,流失强度,覆盖度,可供投资,距道路,距居民地,土地利用,劳力密度,政府决策,K,综经济林果,综封禁,综低效林改,综生态林,适宜性选择)");
strSql.Append(" values (");
strSql.Append(":坡度,:流失强度,:覆盖度,:可供投资,:距道路,:距居民地,:土地利用,:劳力密度,:政府决策,:K:综经济林果,:综封禁,:综低效林改,:综生态林,:适宜性选择)");
OracleParameter[] parameters =
{
new OracleParameter(":坡度", OracleDbType.Decimal, 38),
new OracleParameter(":流失强度", OracleDbType.NVarchar2),
new OracleParameter(":覆盖度", OracleDbType.Decimal, 38),
new OracleParameter(":可供投资", OracleDbType.Decimal, 38),
new OracleParameter(":距道路", OracleDbType.Decimal, 38),
new OracleParameter(":距居民地", OracleDbType.Decimal, 38),
new OracleParameter(":土地利用", OracleDbType.NVarchar2),
new OracleParameter(":劳力密度", OracleDbType.Decimal, 38),
new OracleParameter(":政府决策", OracleDbType.NVarchar2),
new OracleParameter(":K", OracleDbType.Decimal, 15),
new OracleParameter(":综经济林果", OracleDbType.Decimal, 38),
new OracleParameter(":综封禁", OracleDbType.Decimal, 38),
new OracleParameter(":综低效林改", OracleDbType.Decimal, 38),
new OracleParameter(":综生态林", OracleDbType.Decimal, 38),
new OracleParameter(":适宜性选择", OracleDbType.NVarchar2)
};
parameters[0].Value = model.坡度;
parameters[1].Value = model.流失强度;
parameters[2].Value = model.覆盖度;
parameters[3].Value = model.可供投资;
parameters[4].Value = model.距道路;
parameters[5].Value = model.距居民地;
parameters[6].Value = model.土地利用;
parameters[7].Value = model.劳力密度;
parameters[8].Value = model.政府决策;
parameters[9].Value = model.K;
parameters[10].Value = model.综经济林果;
parameters[11].Value = model.综封禁;
parameters[12].Value = model.综低效林改;
parameters[13].Value = model.综生态林;
parameters[14].Value = model.适宜性选择;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public STBC.Model.EVALUATEDATA GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select OBJECTID,GRIDFID,坡度,流失强度,覆盖度,可供投资,距道路,距居民地,土地利用,劳力密度,政府决策,适宜性得分,适宜性级别,K,经济林果,封禁,低效林改造,生态林草,综经济林果,综封禁,综低效林改,综生态林,适宜性选择,SHAPE,经林等级,封禁等级,低林等级,生林等级 from EVALUATEDATA ");
strSql.Append(" where ");
OracleParameter[] parameters =
{
};
STBC.Model.EVALUATEDATA model = new STBC.Model.EVALUATEDATA();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 计算权重，并插入到evaluatedata这张表里面
/// </summary>
/// <param name="strMeasure">传入的措施</param>
protected void calcuFanallyWeight(string strMeasure)
{
STBC.BLL.EVALUATEDATA evaluatedataB = new STBC.BLL.EVALUATEDATA();
STBC.Model.EVALUATEDATA evaluatedataM = new STBC.Model.EVALUATEDATA();
DataSet ds = evaluatedataB.GetList("");
DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
//处理相关数据
double laoli = double.Parse(dr["劳力密度"].ToString().Trim());
string zhenfu = dr["政府决策"].ToString().Trim();
double zhengfud = 0.0;
double touzi = double.Parse(dr["可供投资"].ToString().Trim());
double judao = double.Parse(dr["距道路"].ToString().Trim());
double juJu = double.Parse(dr["距居民地"].ToString().Trim());
string liushi = dr["流失强度"].ToString().Trim();
double liushid = 0.0;
double kyin = double.Parse(dr["K"].ToString().Trim());
double podu = double.Parse(dr["坡度"].ToString().Trim());
double fugai = double.Parse(dr["覆盖度"].ToString().Trim());
string tudiliyong = dr["土地利用"].ToString().Trim();
double tudiliyongd = 0.0;
//首先处理坡度
foreach (DataRow dr2 in dtw.Rows)
{
#region 计算过程
//存放因子名字
string factName = dr2["NAME"].ToString();
//存放因子权重
double WEIGHT = double.Parse(dr2["WEIGHT"].ToString());
//存放因子拐点设置
string INFLEXION = dr2["INFLEXION"].ToString();
//存放因子拐点函数类型
string FUNCTTYPE = dr2["FUNCTTYPE"].ToString();
string[] strarr = INFLEXION.Split('|');
if (factName == "农村劳动力密度")
{
//if (FUNCTTYPE=="特征函数")
//{
// laoli=CommonClass.SingEvalMethod.EigenFunct(strarr,lao
//}
if (FUNCTTYPE == "升半梯形")
{
laoli = CommonClass.SingEvalMethod.RiseTrap(strarr, laoli);
laoli = laoli * WEIGHT;
}
else if (FUNCTTYPE == "降半梯形")
{
laoli = CommonClass.SingEvalMethod.DropTrap(strarr, laoli);
laoli = laoli * WEIGHT;
}
//抛物线型
else
{
laoli = CommonClass.SingEvalMethod.Parabola(strarr, laoli);
laoli = laoli * WEIGHT;
}
}
else if (factName == "政府决策因素")
{
//不用选择，这个坑定是特征函数
zhengfud = CommonClass.SingEvalMethod.EigenFunct(strarr, zhenfu);
zhengfud = zhengfud * WEIGHT;
}
else if (factName == "建设需求投资")
{
if (FUNCTTYPE == "升半梯形")
{
touzi = CommonClass.SingEvalMethod.RiseTrap(strarr, touzi);
touzi = touzi * WEIGHT;
}
else if (FUNCTTYPE == "降半梯形")
{
touzi = CommonClass.SingEvalMethod.DropTrap(strarr, touzi);
touzi = touzi * WEIGHT;
}
//抛物线型
else
{
touzi = CommonClass.SingEvalMethod.Parabola(strarr, touzi);
touzi = touzi * WEIGHT;
}
}
else if (factName == "距道路距离")
{
//dr["距道路"].ToString();
if (FUNCTTYPE == "升半梯形")
{
judao = CommonClass.SingEvalMethod.RiseTrap(strarr, judao);
judao = judao * WEIGHT;
}
else if (FUNCTTYPE == "降半梯形")
{
judao = CommonClass.SingEvalMethod.DropTrap(strarr, judao);
judao = judao * WEIGHT;
}
//抛物线型
else
{
judao = CommonClass.SingEvalMethod.Parabola(strarr, judao);
judao = judao * WEIGHT;
}
}
else if (factName == "距居民点距离")
{
//dr["距居民地"].ToString();
if (FUNCTTYPE == "升半梯形")
{
juJu = CommonClass.SingEvalMethod.RiseTrap(strarr, juJu);
juJu = juJu * WEIGHT;
}
else if (FUNCTTYPE == "降半梯形")
{
juJu = CommonClass.SingEvalMethod.DropTrap(strarr, juJu);
juJu = juJu * WEIGHT;
}
//抛物线型
else
{
juJu = CommonClass.SingEvalMethod.Parabola(strarr, juJu);
juJu = juJu * WEIGHT;
}
}
else if (factName == "水土流失强度")
{
//dr["流失强度"].ToString();
liushid = CommonClass.SingEvalMethod.EigenFunct(strarr, liushi);
liushid = liushid * WEIGHT;
}
else if (factName == "土壤可蚀因子")
{
//dr["K"].ToString();
if (FUNCTTYPE == "升半梯形")
{
kyin = CommonClass.SingEvalMethod.RiseTrap(strarr, kyin);
kyin = kyin * WEIGHT;
}
else if (FUNCTTYPE == "降半梯形")
{
kyin = CommonClass.SingEvalMethod.DropTrap(strarr, kyin);
kyin = kyin * WEIGHT;
}
//抛物线型
else
{
kyin = CommonClass.SingEvalMethod.Parabola(strarr, kyin);
kyin = kyin * WEIGHT;
}
}
else if (factName == "坡度")
{
//dr["坡度"].ToString();
if (FUNCTTYPE == "升半梯形")
{
podu = CommonClass.SingEvalMethod.RiseTrap(strarr, podu);
podu = podu * WEIGHT;
}
else if (FUNCTTYPE == "降半梯形")
{
podu = CommonClass.SingEvalMethod.DropTrap(strarr, podu);
podu = podu * WEIGHT;
}
//抛物线型
else
{
podu = CommonClass.SingEvalMethod.Parabola(strarr, podu);
podu = podu * WEIGHT;
}
}
else if (factName == "植被覆盖")
{
//dr["覆盖度"].ToString();
if (FUNCTTYPE == "升半梯形")
{
fugai = CommonClass.SingEvalMethod.RiseTrap(strarr, fugai);
fugai = fugai * WEIGHT;
}
else if (FUNCTTYPE == "降半梯形")
{
fugai = CommonClass.SingEvalMethod.DropTrap(strarr, fugai);
fugai = fugai * WEIGHT;
}
//抛物线型
else
{
fugai = CommonClass.SingEvalMethod.Parabola(strarr, fugai);
fugai = fugai * WEIGHT;
}
}
//土地利用现状
else
{
tudiliyongd = CommonClass.SingEvalMethod.EigenFunct(strarr, tudiliyong);
tudiliyongd = tudiliyongd * WEIGHT;
}
#endregion
}
//zong1为适宜性评价的综合
double zong1 = laoli + zhengfud + touzi + judao + juJu + liushid + kyin + podu + fugai + tudiliyongd;
//zong2为效益型评价的综合
double zong2 = CommonClass.BenFactHelp.GetBenWeight(lsBenWeight, strMeasure);
//总的适宜性评价
double zong = Math.Sqrt(zong1 * zong2);
//evaluatedataM.经济林果 = (decimal)zong1;
evaluatedataM.OBJECTID = (decimal)double.Parse(dr["OBJECTID"].ToString().Trim());
evaluatedataB.UpdateSummary(evaluatedataM, strMeasure, zong);
}
CallBackValue = "单项措施计算成功";
//this.GridView1.DataSource = ds.Tables[0].DefaultView;
//this.GridView1.DataBind();
}
/// <summary>
/// 计算权重，并插入到evaluatedata这张表里面
/// </summary>
/// <param name="strMeasure">传入的措施</param>
protected void calcuFanallyWeight(string strMeasure)
{
STBC.BLL.EVALUATEDATA evaluatedataB = new STBC.BLL.EVALUATEDATA();
STBC.Model.EVALUATEDATA evaluatedataM = new STBC.Model.EVALUATEDATA();
DataSet ds = evaluatedataB.GetList("");
DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
//处理相关数据
double laoli = double.Parse(dr["劳力密度"].ToString().Trim());
string zhenfu = dr["政府决策"].ToString().Trim();
double zhengfud = 0.0;
double touzi = double.Parse(dr["可供投资"].ToString().Trim());
double judao = double.Parse(dr["距道路"].ToString().Trim());
double juJu = double.Parse(dr["距居民地"].ToString().Trim());
string liushi = dr["流失强度"].ToString().Trim();
double liushid = 0.0;
double kyin = double.Parse(dr["K"].ToString().Trim());
double podu = double.Parse(dr["坡度"].ToString().Trim());
double fugai = double.Parse(dr["覆盖度"].ToString().Trim());
string tudiliyong = dr["土地利用"].ToString().Trim();
double tudiliyongd = 0.0;
//首先处理坡度
foreach (DataRow dr2 in dtw.Rows)
{
#region 计算过程
//存放因子名字
string factName = dr2["NAME"].ToString();
//存放因子权重
double WEIGHT = double.Parse(dr2["WEIGHT"].ToString());
//存放因子拐点设置
string INFLEXION = dr2["INFLEXION"].ToString();
//存放因子拐点函数类型
string FUNCTTYPE = dr2["FUNCTTYPE"].ToString();
string[] strarr = INFLEXION.Split('|');
if (factName == "农村劳动力密度")
{
//if (FUNCTTYPE=="特征函数")
//{
// laoli=CommonClass.SingEvalMethod.EigenFunct(strarr,lao
//}
if (FUNCTTYPE == "升半梯形")
{
laoli = CommonClass.SingEvalMethod.RiseTrap(strarr, laoli);
laoli = laoli * WEIGHT;
}
else if (FUNCTTYPE == "降半梯形")
{
laoli = CommonClass.SingEvalMethod.DropTrap(strarr, laoli);
laoli = laoli * WEIGHT;
}
//抛物线型
else
{
laoli = CommonClass.SingEvalMethod.Parabola(strarr, laoli);
laoli = laoli * WEIGHT;
}
}
else if (factName == "政府决策因素")
{
//不用选择，这个坑定是特征函数
zhengfud = CommonClass.SingEvalMethod.EigenFunct(strarr, zhenfu);
zhengfud = zhengfud * WEIGHT;
}
else if (factName == "建设需求投资")
{
if (FUNCTTYPE == "升半梯形")
{
touzi = CommonClass.SingEvalMethod.RiseTrap(strarr, touzi);
touzi = touzi * WEIGHT;
}
else if (FUNCTTYPE == "降半梯形")
{
touzi = CommonClass.SingEvalMethod.DropTrap(strarr, touzi);
touzi = touzi * WEIGHT;
}
//抛物线型
else
{
touzi = CommonClass.SingEvalMethod.Parabola(strarr, touzi);
touzi = touzi * WEIGHT;
}
}
else if (factName == "距道路距离")
{
//dr["距道路"].ToString();
if (FUNCTTYPE == "升半梯形")
{
judao = CommonClass.SingEvalMethod.RiseTrap(strarr, judao);
judao = judao * WEIGHT;
}
else if (FUNCTTYPE == "降半梯形")
{
judao = CommonClass.SingEvalMethod.DropTrap(strarr, judao);
judao = judao * WEIGHT;
}
//抛物线型
else
{
judao = CommonClass.SingEvalMethod.Parabola(strarr, judao);
judao = judao * WEIGHT;
}
}
else if (factName == "距居民点距离")
{
//dr["距居民地"].ToString();
if (FUNCTTYPE == "升半梯形")
{
juJu = CommonClass.SingEvalMethod.RiseTrap(strarr, juJu);
juJu = juJu * WEIGHT;
}
else if (FUNCTTYPE == "降半梯形")
{
juJu = CommonClass.SingEvalMethod.DropTrap(strarr, juJu);
juJu = juJu * WEIGHT;
}
//抛物线型
else
{
juJu = CommonClass.SingEvalMethod.Parabola(strarr, juJu);
juJu = juJu * WEIGHT;
}
}
else if (factName == "水土流失强度")
{
//dr["流失强度"].ToString();
liushid = CommonClass.SingEvalMethod.EigenFunct(strarr, liushi);
liushid = liushid * WEIGHT;
}
else if (factName == "土壤可蚀因子")
{
//dr["K"].ToString();
if (FUNCTTYPE == "升半梯形")
{
kyin = CommonClass.SingEvalMethod.RiseTrap(strarr, kyin);
kyin = kyin * WEIGHT;
}
else if (FUNCTTYPE == "降半梯形")
{
kyin = CommonClass.SingEvalMethod.DropTrap(strarr, kyin);
kyin = kyin * WEIGHT;
}
//抛物线型
else
{
kyin = CommonClass.SingEvalMethod.Parabola(strarr, kyin);
kyin = kyin * WEIGHT;
}
}
else if (factName == "坡度")
{
//dr["坡度"].ToString();
if (FUNCTTYPE == "升半梯形")
{
podu = CommonClass.SingEvalMethod.RiseTrap(strarr, podu);
podu = podu * WEIGHT;
}
else if (FUNCTTYPE == "降半梯形")
{
podu = CommonClass.SingEvalMethod.DropTrap(strarr, podu);
podu = podu * WEIGHT;
}
//抛物线型
else
{
podu = CommonClass.SingEvalMethod.Parabola(strarr, podu);
podu = podu * WEIGHT;
}
}
else if (factName == "植被覆盖")
{
//dr["覆盖度"].ToString();
if (FUNCTTYPE == "升半梯形")
{
fugai = CommonClass.SingEvalMethod.RiseTrap(strarr, fugai);
fugai = fugai * WEIGHT;
}
else if (FUNCTTYPE == "降半梯形")
{
fugai = CommonClass.SingEvalMethod.DropTrap(strarr, fugai);
fugai = fugai * WEIGHT;
}
//抛物线型
else
{
fugai = CommonClass.SingEvalMethod.Parabola(strarr, fugai);
fugai = fugai * WEIGHT;
}
}
//土地利用现状
else
{
tudiliyongd = CommonClass.SingEvalMethod.EigenFunct(strarr, tudiliyong);
tudiliyongd = tudiliyongd * WEIGHT;
}
#endregion
}
//zong1为适宜性评价的综合
double zong1 = laoli + zhengfud + touzi + judao + juJu + liushid + kyin + podu + fugai + tudiliyongd;
//zong2为效益型评价的综合
double zong2 = CommonClass.BenFactHelp.GetBenWeight(lsBenWeight, strMeasure);
//总的适宜性评价
double zong = Math.Sqrt(zong1 * zong2);
//evaluatedataM.经济林果 = (decimal)zong1;
evaluatedataM.OBJECTID = (decimal)double.Parse(dr["OBJECTID"].ToString().Trim());
evaluatedataB.UpdateSummary(evaluatedataM, strMeasure, zong);
}
CallBackValue = "单项措施计算成功";
//this.GridView1.DataSource = ds.Tables[0].DefaultView;
//this.GridView1.DataBind();
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public STBC.Model.EVALUATEDATA DataRowToModel(DataRow row)
{
STBC.Model.EVALUATEDATA model = new STBC.Model.EVALUATEDATA();
if (row != null)
{
//if(row["OBJECTID"]!=null && row["OBJECTID"].ToString()!="")
//{
// model.OBJECTID=decimal.Parse(row["OBJECTID"].ToString());
//}
//if(row["GRIDFID"]!=null && row["GRIDFID"].ToString()!="")
//{
// model.GRIDFID=decimal.Parse(row["GRIDFID"].ToString());
//}
if (row["坡度"] != null && row["坡度"].ToString() != "")
{
model.坡度 = decimal.Parse(row["坡度"].ToString());
}
if (row["流失强度"] != null)
{
model.流失强度 = row["流失强度"].ToString();
}
if (row["覆盖度"] != null && row["覆盖度"].ToString() != "")
{
model.覆盖度 = decimal.Parse(row["覆盖度"].ToString());
}
if (row["可供投资"] != null && row["可供投资"].ToString() != "")
{
model.可供投资 = decimal.Parse(row["可供投资"].ToString());
}
if (row["距道路"] != null && row["距道路"].ToString() != "")
{
model.距道路 = decimal.Parse(row["距道路"].ToString());
}
if (row["距居民地"] != null && row["距居民地"].ToString() != "")
{
model.距居民地 = decimal.Parse(row["距居民地"].ToString());
}
if (row["土地利用"] != null)
{
model.土地利用 = row["土地利用"].ToString();
}
if (row["劳力密度"] != null && row["劳力密度"].ToString() != "")
{
model.劳力密度 = decimal.Parse(row["劳力密度"].ToString());
}
if (row["政府决策"] != null)
{
model.政府决策 = row["政府决策"].ToString();
}
//if(row["适宜性得分"]!=null && row["适宜性得分"].ToString()!="")
//{
// model.适宜性得分=decimal.Parse(row["适宜性得分"].ToString());
//}
//if(row["适宜性级别"]!=null)
//{
// model.适宜性级别=row["适宜性级别"].ToString();
//}
if (row["K"] != null && row["K"].ToString() != "")
{
model.K = decimal.Parse(row["K"].ToString());
}
//if (row["经济林果"] != null && row["经济林果"].ToString() != "")
//{
// model.经济林果 = decimal.Parse(row["经济林果"].ToString());
//}
//if (row["封禁"] != null && row["封禁"].ToString() != "")
//{
// model.封禁 = decimal.Parse(row["封禁"].ToString());
//}
//if (row["低效林改造"] != null && row["低效林改造"].ToString() != "")
//{
// model.低效林改造 = decimal.Parse(row["低效林改造"].ToString());
//}
//if (row["生态林草"] != null && row["生态林草"].ToString() != "")
//{
// model.生态林草 = decimal.Parse(row["生态林草"].ToString());
//}
if (row["综经济林果"] != null && row["综经济林果"].ToString() != "")
{
model.综经济林果 = decimal.Parse(row["综经济林果"].ToString());
}
if (row["综封禁"] != null && row["综封禁"].ToString() != "")
{
model.综封禁 = decimal.Parse(row["综封禁"].ToString());
}
if (row["综低效林改"] != null && row["综低效林改"].ToString() != "")
{
model.综低效林改 = decimal.Parse(row["综低效林改"].ToString());
}
if (row["综生态林"] != null && row["综生态林"].ToString() != "")
{
model.综生态林 = decimal.Parse(row["综生态林"].ToString());
}
if (row["适宜性选择"] != null)
{
model.适宜性选择 = row["适宜性选择"].ToString();
}
//model.SHAPE=row["SHAPE"].ToString();
//if (row["经林等级"] != null)
//{
// model.经林等级 = row["经林等级"].ToString();
//}
//if (row["封禁等级"] != null)
//{
// model.封禁等级 = row["封禁等级"].ToString();
//}
//if (row["低林等级"] != null)
//{
// model.低林等级 = row["低林等级"].ToString();
//}
//if (row["生林等级"] != null)
//{
// model.生林等级 = row["生林等级"].ToString();
//}
}
return model;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public STBC.Model.EVALUATEDATA GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select OBJECTID,GRIDFID,坡度,流失强度,覆盖度,可供投资,距道路,距居民地,土地利用,劳力密度,政府决策,适宜性得分,适宜性级别,K,经济林果,封禁,低效林改造,生态林草,综经济林果,综封禁,综低效林改,综生态林,适宜性选择,SHAPE,经林等级,封禁等级,低林等级,生林等级 from EVALUATEDATA ");
strSql.Append(" where ");
OracleParameter[] parameters = {
};
STBC.Model.EVALUATEDATA model = new STBC.Model.EVALUATEDATA();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(STBC.Model.EVALUATEDATA model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update EVALUATEDATA set ");
strSql.Append("坡度=:坡度,");
strSql.Append("流失强度=:流失强度,");
strSql.Append("覆盖度=:覆盖度,");
strSql.Append("可供投资=:可供投资,");
strSql.Append("距道路=:距道路,");
strSql.Append("距居民地=:距居民地,");
strSql.Append("土地利用=:土地利用,");
strSql.Append("劳力密度=:劳力密度,");
strSql.Append("政府决策=:政府决策,");
strSql.Append("K=:K,");
strSql.Append("综经济林果=:综经济林果,");
strSql.Append("综封禁=:综封禁,");
strSql.Append("综低效林改=:综低效林改,");
strSql.Append("综生态林=:综生态林,");
strSql.Append("适宜性选择=:适宜性选择");
strSql.Append(" where ");
OracleParameter[] parameters =
{
new OracleParameter(":坡度", OracleDbType.Decimal, 38),
new OracleParameter(":流失强度", OracleDbType.NVarchar2),
new OracleParameter(":覆盖度", OracleDbType.Decimal, 38),
new OracleParameter(":可供投资", OracleDbType.Decimal, 38),
new OracleParameter(":距道路", OracleDbType.Decimal, 38),
new OracleParameter(":距居民地", OracleDbType.Decimal, 38),
new OracleParameter(":土地利用", OracleDbType.NVarchar2),
new OracleParameter(":劳力密度", OracleDbType.Decimal, 38),
new OracleParameter(":政府决策", OracleDbType.NVarchar2),
new OracleParameter(":K", OracleDbType.Decimal, 15),
new OracleParameter(":综经济林果", OracleDbType.Decimal, 38),
new OracleParameter(":综封禁", OracleDbType.Decimal, 38),
new OracleParameter(":综低效林改", OracleDbType.Decimal, 38),
new OracleParameter(":综生态林", OracleDbType.Decimal, 38),
new OracleParameter(":适宜性选择", OracleDbType.NVarchar2)
};
parameters[0].Value = model.坡度;
parameters[1].Value = model.流失强度;
parameters[2].Value = model.覆盖度;
parameters[3].Value = model.可供投资;
parameters[4].Value = model.距道路;
parameters[5].Value = model.距居民地;
parameters[6].Value = model.土地利用;
parameters[7].Value = model.劳力密度;
parameters[8].Value = model.政府决策;
parameters[9].Value = model.K;
parameters[10].Value = model.综经济林果;
parameters[11].Value = model.综封禁;
parameters[12].Value = model.综低效林改;
parameters[13].Value = model.综生态林;
parameters[14].Value = model.适宜性选择;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public STBC.Model.EVALUATEDATA DataRowToModel(DataRow row)
{
STBC.Model.EVALUATEDATA model = new STBC.Model.EVALUATEDATA();
if (row != null)
{
//if(row["OBJECTID"]!=null && row["OBJECTID"].ToString()!="")
//{
// model.OBJECTID=decimal.Parse(row["OBJECTID"].ToString());
//}
//if(row["GRIDFID"]!=null && row["GRIDFID"].ToString()!="")
//{
// model.GRIDFID=decimal.Parse(row["GRIDFID"].ToString());
//}
if (row["坡度"] != null && row["坡度"].ToString() != "")
{
model.坡度 = decimal.Parse(row["坡度"].ToString());
}
if (row["流失强度"] != null)
{
model.流失强度 = row["流失强度"].ToString();
}
if (row["覆盖度"] != null && row["覆盖度"].ToString() != "")
{
model.覆盖度 = decimal.Parse(row["覆盖度"].ToString());
}
if (row["可供投资"] != null && row["可供投资"].ToString() != "")
{
model.可供投资 = decimal.Parse(row["可供投资"].ToString());
}
if (row["距道路"] != null && row["距道路"].ToString() != "")
{
model.距道路 = decimal.Parse(row["距道路"].ToString());
}
if (row["距居民地"] != null && row["距居民地"].ToString() != "")
{
model.距居民地 = decimal.Parse(row["距居民地"].ToString());
}
if (row["土地利用"] != null)
{
model.土地利用 = row["土地利用"].ToString();
}
if (row["劳力密度"] != null && row["劳力密度"].ToString() != "")
{
model.劳力密度 = decimal.Parse(row["劳力密度"].ToString());
}
if (row["政府决策"] != null)
{
model.政府决策 = row["政府决策"].ToString();
}
//if(row["适宜性得分"]!=null && row["适宜性得分"].ToString()!="")
//{
// model.适宜性得分=decimal.Parse(row["适宜性得分"].ToString());
//}
//if(row["适宜性级别"]!=null)
//{
// model.适宜性级别=row["适宜性级别"].ToString();
//}
if (row["K"] != null && row["K"].ToString() != "")
{
model.K = decimal.Parse(row["K"].ToString());
}
//if (row["经济林果"] != null && row["经济林果"].ToString() != "")
//{
// model.经济林果 = decimal.Parse(row["经济林果"].ToString());
//}
//if (row["封禁"] != null && row["封禁"].ToString() != "")
//{
// model.封禁 = decimal.Parse(row["封禁"].ToString());
//}
//if (row["低效林改造"] != null && row["低效林改造"].ToString() != "")
//{
// model.低效林改造 = decimal.Parse(row["低效林改造"].ToString());
//}
//if (row["生态林草"] != null && row["生态林草"].ToString() != "")
//{
// model.生态林草 = decimal.Parse(row["生态林草"].ToString());
//}
if (row["综经济林果"] != null && row["综经济林果"].ToString() != "")
{
model.综经济林果 = decimal.Parse(row["综经济林果"].ToString());
}
if (row["综封禁"] != null && row["综封禁"].ToString() != "")
{
model.综封禁 = decimal.Parse(row["综封禁"].ToString());
}
if (row["综低效林改"] != null && row["综低效林改"].ToString() != "")
{
model.综低效林改 = decimal.Parse(row["综低效林改"].ToString());
}
if (row["综生态林"] != null && row["综生态林"].ToString() != "")
{
model.综生态林 = decimal.Parse(row["综生态林"].ToString());
}
if (row["适宜性选择"] != null)
{
model.适宜性选择 = row["适宜性选择"].ToString();
}
//model.SHAPE=row["SHAPE"].ToString();
//if (row["经林等级"] != null)
//{
// model.经林等级 = row["经林等级"].ToString();
//}
//if (row["封禁等级"] != null)
//{
// model.封禁等级 = row["封禁等级"].ToString();
//}
//if (row["低林等级"] != null)
//{
// model.低林等级 = row["低林等级"].ToString();
//}
//if (row["生林等级"] != null)
//{
// model.生林等级 = row["生林等级"].ToString();
//}
}
return(model);
}
/// <summary>
/// 更新经济林果适宜性评价值
/// </summary>
public bool UpdateSummary(STBC.Model.EVALUATEDATA model, string strMeasure, double zong)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update EVALUATEDATA set ");
int rows = 0;
if (strMeasure == "经济林果")
{
strSql.Append("综经济林果=:综经济林果");
strSql.Append(" where OBJECTID=:OBJECTID");
OracleParameter[] parameters =
{
new OracleParameter(":综经济林果", OracleDbType.Decimal, 38),
new OracleParameter(":OBJECTID", OracleDbType.Decimal, 4),
};
parameters[0].Value = (decimal)zong;
parameters[1].Value = model.OBJECTID;
rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
}
else if (strMeasure == "低效林改造")
{
strSql.Append("综低效林改=:综低效林改");
strSql.Append(" where OBJECTID=:OBJECTID");
OracleParameter[] parameters =
{
new OracleParameter(":综低效林改", OracleDbType.Decimal, 38),
new OracleParameter(":OBJECTID", OracleDbType.Decimal, 4),
};
parameters[0].Value = (decimal)zong;
parameters[1].Value = model.OBJECTID;
rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
}
else if (strMeasure == "封禁")
{
strSql.Append("综封禁=:综封禁");
strSql.Append(" where OBJECTID=:OBJECTID");
OracleParameter[] parameters =
{
new OracleParameter(":综封禁", OracleDbType.Decimal, 38),
new OracleParameter(":OBJECTID", OracleDbType.Decimal, 4),
};
parameters[0].Value = (decimal)zong;
parameters[1].Value = model.OBJECTID;
rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
}
//生态林草
else
{
strSql.Append("综生态林=:综生态林");
strSql.Append(" where OBJECTID=:OBJECTID");
OracleParameter[] parameters =
{
new OracleParameter(":综生态林", OracleDbType.Decimal, 38),
new OracleParameter(":OBJECTID", OracleDbType.Decimal, 4),
};
parameters[0].Value = (decimal)zong;
parameters[1].Value = model.OBJECTID;
rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
}
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
