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