Пример #1
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(SoilNutrientSoft.Model.CropsMeg model, Dictionary <SqlConnection, SqlTransaction> MyDict)
        {
            try
            {
                StringBuilder strSql = new StringBuilder();
                strSql.Append("update CropsMeg set ");
                strSql.Append("CropType=@CropType,");
                strSql.Append("Varieties=@Varieties,");
                strSql.Append("Yield=@Yield,");
                strSql.Append("urea=@urea,");
                strSql.Append("An=@An,");
                strSql.Append("K=@K,");
                strSql.Append("Organic_manure=@Organic_manure,");
                strSql.Append("Others=@Others,");
                strSql.Append("Irrigation_times=@Irrigation_times,");
                strSql.Append("All_id=@All_id");
                strSql.Append(" where Id=@Id");
                SqlParameter[] parameters =
                {
                    new SqlParameter("@CropType",         SqlDbType.NVarChar, 50),
                    new SqlParameter("@Varieties",        SqlDbType.NVarChar, 50),
                    new SqlParameter("@Yield",            SqlDbType.Float,     8),
                    new SqlParameter("@urea",             SqlDbType.Float,     8),
                    new SqlParameter("@An",               SqlDbType.Float,     8),
                    new SqlParameter("@K",                SqlDbType.Float,     8),
                    new SqlParameter("@Organic_manure",   SqlDbType.Float,     8),
                    new SqlParameter("@Others",           SqlDbType.Float,     8),
                    new SqlParameter("@Irrigation_times", SqlDbType.Int,       4),
                    new SqlParameter("@All_id",           SqlDbType.Int,       4),
                    new SqlParameter("@Id",               SqlDbType.Int, 4)
                };
                parameters[0].Value  = model.CropType;
                parameters[1].Value  = model.Varieties;
                parameters[2].Value  = model.Yield;
                parameters[3].Value  = model.urea;
                parameters[4].Value  = model.An;
                parameters[5].Value  = model.K;
                parameters[6].Value  = model.Organic_manure;
                parameters[7].Value  = model.Others;
                parameters[8].Value  = model.Irrigation_times;
                parameters[9].Value  = model.All_id;
                parameters[10].Value = model.Id;

                int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), MyDict, parameters);
                if (rows > 0)
                {
                    return(true);
                }
                else
                {
                    return(false);
                }
            }
            catch (Exception e)
            {
                throw e;
            }
        }
Пример #2
0
 /// <summary>
 /// 得到一个对象实体
 /// </summary>
 public SoilNutrientSoft.Model.CropsMeg DataRowToModel(DataRow row)
 {
     SoilNutrientSoft.Model.CropsMeg model = new SoilNutrientSoft.Model.CropsMeg();
     if (row != null)
     {
         if (row["Id"] != null && row["Id"].ToString() != "")
         {
             model.Id = int.Parse(row["Id"].ToString());
         }
         if (row["CropType"] != null)
         {
             model.CropType = row["CropType"].ToString();
         }
         if (row["Varieties"] != null)
         {
             model.Varieties = row["Varieties"].ToString();
         }
         if (row["Yield"] != null && row["Yield"].ToString() != "")
         {
             model.Yield = decimal.Parse(row["Yield"].ToString());
         }
         if (row["urea"] != null && row["urea"].ToString() != "")
         {
             model.urea = decimal.Parse(row["urea"].ToString());
         }
         if (row["An"] != null && row["An"].ToString() != "")
         {
             model.An = decimal.Parse(row["An"].ToString());
         }
         if (row["K"] != null && row["K"].ToString() != "")
         {
             model.K = decimal.Parse(row["K"].ToString());
         }
         if (row["Organic_manure"] != null && row["Organic_manure"].ToString() != "")
         {
             model.Organic_manure = decimal.Parse(row["Organic_manure"].ToString());
         }
         if (row["Others"] != null && row["Others"].ToString() != "")
         {
             model.Others = decimal.Parse(row["Others"].ToString());
         }
         if (row["Irrigation_times"] != null && row["Irrigation_times"].ToString() != "")
         {
             model.Irrigation_times = int.Parse(row["Irrigation_times"].ToString());
         }
         if (row["All_id"] != null && row["All_id"].ToString() != "")
         {
             model.All_id = int.Parse(row["All_id"].ToString());
         }
     }
     return(model);
 }
Пример #3
0
        /*
         * /// <summary>
         * /// 分页获取数据列表
         * /// </summary>
         * public DataSet GetList(int PageSize,int PageIndex,string strWhere)
         * {
         *      SqlParameter[] parameters = {
         *                      new SqlParameter("@tblName", SqlDbType.VarChar, 255),
         *                      new SqlParameter("@fldName", SqlDbType.VarChar, 255),
         *                      new SqlParameter("@PageSize", SqlDbType.Int),
         *                      new SqlParameter("@PageIndex", SqlDbType.Int),
         *                      new SqlParameter("@IsReCount", SqlDbType.Bit),
         *                      new SqlParameter("@OrderType", SqlDbType.Bit),
         *                      new SqlParameter("@strWhere", SqlDbType.VarChar,1000),
         *                      };
         *      parameters[0].Value = "CropsMeg";
         *      parameters[1].Value = "Id";
         *      parameters[2].Value = PageSize;
         *      parameters[3].Value = PageIndex;
         *      parameters[4].Value = 0;
         *      parameters[5].Value = 0;
         *      parameters[6].Value = strWhere;
         *      return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds");
         * }*/

        #endregion  BasicMethod
        #region  ExtensionMethod
        /// <summary>
        /// 自己的增加一条数据
        /// </summary>
        public int Add(SoilNutrientSoft.Model.CropsMeg model, Dictionary <SqlConnection, SqlTransaction> MyDict)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into CropsMeg(");
            strSql.Append("CropType,Varieties,Yield,urea,An,K,Organic_manure,Others,Irrigation_times,All_id)");
            strSql.Append(" values (");
            strSql.Append("@CropType,@Varieties,@Yield,@urea,@An,@K,@Organic_manure,@Others,@Irrigation_times,@All_id)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters =
            {
                new SqlParameter("@CropType",         SqlDbType.NVarChar, 50),
                new SqlParameter("@Varieties",        SqlDbType.NVarChar, 50),
                new SqlParameter("@Yield",            SqlDbType.Float,     8),
                new SqlParameter("@urea",             SqlDbType.Float,     8),
                new SqlParameter("@An",               SqlDbType.Float,     8),
                new SqlParameter("@K",                SqlDbType.Float,     8),
                new SqlParameter("@Organic_manure",   SqlDbType.Float,     8),
                new SqlParameter("@Others",           SqlDbType.Float,     8),
                new SqlParameter("@Irrigation_times", SqlDbType.Int,       4),
                new SqlParameter("@All_id",           SqlDbType.Int, 4)
            };
            parameters[0].Value = model.CropType;
            parameters[1].Value = model.Varieties;
            parameters[2].Value = model.Yield;
            parameters[3].Value = model.urea;
            parameters[4].Value = model.An;
            parameters[5].Value = model.K;
            parameters[6].Value = model.Organic_manure;
            parameters[7].Value = model.Others;
            parameters[8].Value = model.Irrigation_times;
            parameters[9].Value = model.All_id;

            try
            {
                object obj = DbHelperSQL.GetSingle(strSql.ToString(), MyDict, parameters);
                if (obj == null)
                {
                    return(0);
                }
                else
                {
                    return(Convert.ToInt32(obj));
                }
            }
            catch
            {
                throw;
            }
        }
Пример #4
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public SoilNutrientSoft.Model.CropsMeg GetModel(int Id)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select  top 1 Id,CropType,Varieties,Yield,urea,An,K,Organic_manure,Others,Irrigation_times,All_id from CropsMeg ");
            strSql.Append(" where Id=@Id");
            SqlParameter[] parameters =
            {
                new SqlParameter("@Id", SqlDbType.Int, 4)
            };
            parameters[0].Value = Id;

            SoilNutrientSoft.Model.CropsMeg model = new SoilNutrientSoft.Model.CropsMeg();
            DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                return(DataRowToModel(ds.Tables[0].Rows[0]));
            }
            else
            {
                return(null);
            }
        }
Пример #5
0
        public void ProcessRequest(HttpContext context)
        {
            Dictionary <SqlConnection, SqlTransaction> MyDict = new Dictionary <SqlConnection, SqlTransaction>();

            try
            {
                context.Response.ContentType = "text/plain";
                //第一张表单  农田信息数据录入后返回的最大id
                int getMaxId = 0;
                //第一张表单  农田信息数据录入返回的结果值
                int resultNumFLM = 0;

                //HttpPostedFile file = context.Request.Files["file"];
                #region 第一张表单  农田信息

                SoilNutrientSoft.Model.FarmlandMeg newFarmlandMegModel = new SoilNutrientSoft.Model.FarmlandMeg();

                newFarmlandMegModel.City                  = context.Request["city"];
                newFarmlandMegModel.County                = context.Request["country"];
                newFarmlandMegModel.Town                  = context.Request["townName"].Length == 0 ? "暂无" : context.Request["townName"];
                newFarmlandMegModel.Village               = context.Request["villageName"].Length == 0 ? "暂无" : context.Request["villageName"];
                newFarmlandMegModel.Sample_name           = context.Request["SampleName"].Length == 0 ? "暂无" : context.Request["SampleName"];
                newFarmlandMegModel.Lon                   = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["LongitudeDegree"]) ? "0" : context.Request["LongitudeDegree"]) + Convert.ToDecimal(String.IsNullOrEmpty(context.Request["LongitudeMinute"]) ? "0" : context.Request["LongitudeMinute"]) / (decimal)60.0 + Convert.ToDecimal(String.IsNullOrEmpty(context.Request["LongitudeSecond"]) ? "0" : context.Request["LongitudeSecond"]) / (decimal)3600.0;
                newFarmlandMegModel.Lat                   = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["LatitudeDegree"]) ? "0" : context.Request["LatitudeDegree"]) + Convert.ToDecimal(String.IsNullOrEmpty(context.Request["LatitudeMinute"]) ? "0" : context.Request["LatitudeMinute"]) / (decimal)60.0 + Convert.ToDecimal(String.IsNullOrEmpty(context.Request["LatitudeSecond"]) ? "0" : context.Request["LatitudeSecond"]) / (decimal)3600.0;
                newFarmlandMegModel.Name_of_householder   = context.Request["NameOfHouseholder"];
                newFarmlandMegModel.Phone_number          = context.Request["PhoneNumber"];
                newFarmlandMegModel.Irrigation_Conditions = Convert.ToInt32(String.IsNullOrEmpty(context.Request["IrrigationConditions"]) ? "1" : context.Request["IrrigationConditions"]);
                newFarmlandMegModel.Acreage               = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["Acreage"]) ? "0" : context.Request["Acreage"]);
                //int.Parse(context.Request["Acreage"]);
                newFarmlandMegModel.Fertility = Convert.ToInt32(String.IsNullOrEmpty(context.Request["Fertility"]) ? "1" : context.Request["Fertility"]);
                newFarmlandMegModel.Weeds     = context.Request["Weeds"];

                //需要先将农田信息写入数据库
                //然后返回农田信息表中的最大ID给其他三张表的All_id使用
                //以建立四张表的联系

                SoilNutrientSoft.BLL.FarmlandMeg newFarmlandMegBLL = new SoilNutrientSoft.BLL.FarmlandMeg();

                //提交数据,返回插入的id
                resultNumFLM = newFarmlandMegBLL.Add(newFarmlandMegModel, MyDict);
                if (resultNumFLM > 0)
                {
                    //表示农田信息表单成功录入
                    //该表中的最大id
                    getMaxId = resultNumFLM;    // newFarmlandMegBLL.GetMaxId()-1;
                }
                else
                {
                    context.Response.Write("农田信息表单数据录入失败");
                    //将信息返回给客户端,停止该页的执行
                    context.Response.End();
                }

                #endregion
                if (getMaxId <= 0)
                {
                    //如果getMaxId<=0表示第一张表插入失败
                    context.Response.Write("信息录入失败");
                    //将信息返回给客户端,停止该页的执行
                    context.Response.End();
                }
                else
                {
                    #region 第二张表单 土壤养分信息

                    SoilNutrientSoft.Model.SoilNutrientMeg newSoilNutrientMegModel = new SoilNutrientSoft.Model.SoilNutrientMeg();
                    newSoilNutrientMegModel.N = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["N_SoilNutrient"]) ? "0" : context.Request["N_SoilNutrient"]);
                    newSoilNutrientMegModel.P = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["P_SoilNutrient"]) ? "0" : context.Request["P_SoilNutrient"]);

                    newSoilNutrientMegModel.K             = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["K_SoilNutrient"]) ? "0" : context.Request["K_SoilNutrient"]);
                    newSoilNutrientMegModel.HydrolyticN   = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["HydrolyticN_SoilNutrient"]) ? "0" : context.Request["HydrolyticN_SoilNutrient"]);
                    newSoilNutrientMegModel.QuickP        = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["QuickP_SoilNutrient"]) ? "0" : context.Request["QuickP_SoilNutrient"]);
                    newSoilNutrientMegModel.QUicK         = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["QuickK_SoilNutrient"]) ? "0" : context.Request["QuickK_SoilNutrient"]);
                    newSoilNutrientMegModel.OrganicMatter = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["OrganicMatter_SoilNutrient"]) ? "0" : context.Request["OrganicMatter_SoilNutrient"]);
                    newSoilNutrientMegModel.PH            = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["PH_SoilNutrient"]) ? "0" : context.Request["PH_SoilNutrient"]);
                    newSoilNutrientMegModel.All_id        = getMaxId;

                    //土壤养分信息录入
                    SoilNutrientSoft.BLL.SoilNutrientMeg newSoilNutrientMegBll = new SoilNutrientSoft.BLL.SoilNutrientMeg();

                    int resultNumSoil = newSoilNutrientMegBll.Add(newSoilNutrientMegModel, MyDict);

                    #endregion

                    #region 第三张表  作物信息

                    SoilNutrientSoft.Model.CropsMeg newCropsMegModel = new SoilNutrientSoft.Model.CropsMeg();
                    newCropsMegModel.CropType         = context.Request["CropType_CropInfo"];
                    newCropsMegModel.Varieties        = context.Request["Varieties_CropInfo"];
                    newCropsMegModel.Yield            = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["Yield_CropInfo"]) ? "0" : context.Request["Yield_CropInfo"]);
                    newCropsMegModel.urea             = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["urea_CropInfo"]) ? "0" : context.Request["urea_CropInfo"]);
                    newCropsMegModel.An               = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["An_CropInfo"]) ? "0" : context.Request["An_CropInfo"]);
                    newCropsMegModel.K                = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["K_CropInfo"]) ? "0" : context.Request["K_CropInfo"]);
                    newCropsMegModel.Organic_manure   = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["Organic_manure_CropInfo"]) ? "0" : context.Request["Organic_manure_CropInfo"]);
                    newCropsMegModel.Others           = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["Others_CropInfo"]) ? "0" : context.Request["Others_CropInfo"]);
                    newCropsMegModel.Irrigation_times = Convert.ToInt32(String.IsNullOrEmpty(context.Request["Irrigation_times"]) ? "0" : context.Request["Irrigation_times_CropInfo"]);
                    newCropsMegModel.All_id           = getMaxId;

                    //作物信息录入
                    SoilNutrientSoft.BLL.CropsMeg newCropsMegBll = new SoilNutrientSoft.BLL.CropsMeg();
                    int resultNumCrops = newCropsMegBll.Add(newCropsMegModel, MyDict);
                    #endregion

                    #region 第四张表    农田管理建议

                    SoilNutrientSoft.Model.FarmlandMSug newFarmlandMSugModel = new SoilNutrientSoft.Model.FarmlandMSug();
                    newFarmlandMSugModel.CropType        = context.Request["CropType_ManaSug"];
                    newFarmlandMSugModel.Varieties       = context.Request["Varieties_ManaSug"];
                    newFarmlandMSugModel.TargetYield     = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["TargetYield_ManaSug"]) ? "0" : context.Request["TargetYield_ManaSug"]);
                    newFarmlandMSugModel.urea            = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["urea_ManaSug"]) ? "0" : context.Request["urea_ManaSug"]);
                    newFarmlandMSugModel.An              = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["An_ManaSug"]) ? "0" : context.Request["An_ManaSug"]);
                    newFarmlandMSugModel.K               = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["K_ManaSug"]) ? "0" : context.Request["K_ManaSug"]);
                    newFarmlandMSugModel.OrganicManure   = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["Organic_manure_ManaSug"]) ? "0" : context.Request["Organic_manure_ManaSug"]);
                    newFarmlandMSugModel.Others          = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["Others_ManaSug"]) ? "0" : context.Request["Others_ManaSug"]);
                    newFarmlandMSugModel.IrrigationTimes = Convert.ToInt32(String.IsNullOrEmpty(context.Request["Irrigation_times_ManaSug"]) ? "0" : context.Request["Irrigation_times_ManaSug"]);
                    newFarmlandMSugModel.SowingAmount    = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["SowingAmount_ManaSug"]) ? "0" : context.Request["SowingAmount_ManaSug"]);
                    newFarmlandMSugModel.SowingMethod    = context.Request["SowingMethod_ManaSug"];
                    newFarmlandMSugModel.WeedControl     = context.Request["WeedControl_ManaSug"];
                    newFarmlandMSugModel.PestControl     = context.Request["PestControl_ManaSug"];
                    newFarmlandMSugModel.FieldManagement = context.Request["FieldManagement_ManaSug"];
                    newFarmlandMSugModel.Remarks         = context.Request["Remarks_ManaSug"];
                    newFarmlandMSugModel.All_id          = getMaxId;
                    //录入 农田管理建议
                    SoilNutrientSoft.BLL.FarmlandMSug newFarmlandMSugBll = new SoilNutrientSoft.BLL.FarmlandMSug();
                    int resultFLMS = newFarmlandMSugBll.Add(newFarmlandMSugModel, MyDict);
                    #endregion

                    //插入图片路径
                    //picPath:/UpImages/d5ceb1ff-319c-42e3-8881-5a8a87900a8b.jpeg
                    List <int> resultPic = new List <int>();
                    if (context.Request["picPath"].Length > 0)
                    {
                        string[] picPaths = context.Request["picPath"].Split(';');
                        SoilNutrientSoft.Model.Picture newPictureModel = new SoilNutrientSoft.Model.Picture();
                        SoilNutrientSoft.BLL.Picture   newPictureBll   = new SoilNutrientSoft.BLL.Picture();
                        foreach (var item in picPaths)
                        {
                            newPictureModel.picturePath = item;
                            newPictureModel.All_id      = getMaxId;
                            resultPic.Add(newPictureBll.Add(newPictureModel, MyDict));
                        }
                    }
                    else
                    {
                        resultPic.Add(1);
                    }

                    //判断四张表是否都插入
                    if (resultFLMS > 0 && resultNumCrops > 0 && resultNumFLM > 0 && resultNumSoil > 0 && resultPic.Min() > 0)
                    {
                        context.Response.Write("ok");
                    }
                    else
                    {
                        context.Response.Write("信息录入失败");
                    }
                }

                QuitConnTrans(MyDict);
            }
            catch (Exception E)
            {
                ExceptionQuitConnTrans(MyDict);
                //如有异常 将异常信息返回
                context.Response.Write(E.Message);
                //将信息返回给客户端,停止该页的执行
                context.Response.End();
            }
        }
        public void ProcessRequest(HttpContext context)
        {
            context.Response.ContentType = "text/plain";
            Dictionary <SqlConnection, SqlTransaction> MyDict = new Dictionary <SqlConnection, SqlTransaction>();

            try
            {
                //获取当前数据在数据库中对应的id
                int FarmlandMegId = Convert.ToInt32(context.Request["hiddenID"]);

                //根据“农田信息”表中的id分别查出其他三个表中的id

                //土壤养分信息录入表
                SoilNutrientSoft.BLL.SoilNutrientMeg          newSoilNutrientMegBll  = new SoilNutrientSoft.BLL.SoilNutrientMeg();
                List <SoilNutrientSoft.Model.SoilNutrientMeg> newSoilNutrientMegList = newSoilNutrientMegBll.GetModelList(" All_id = " + FarmlandMegId);
                //获取其在土壤养分信息录入表中对应的id
                int SoilNutrientMegId = newSoilNutrientMegList[0].Id;


                //作物信息录入表
                SoilNutrientSoft.BLL.CropsMeg          newCropsMegBll  = new SoilNutrientSoft.BLL.CropsMeg();
                List <SoilNutrientSoft.Model.CropsMeg> newCropsMegList = newCropsMegBll.GetModelList(" All_id = " + FarmlandMegId);
                //获取其在作物信息录入表中对应的id
                int CropsMegId = newCropsMegList[0].Id;


                //农田管理建议表
                SoilNutrientSoft.BLL.FarmlandMSug          newFarmlandMSugBll  = new SoilNutrientSoft.BLL.FarmlandMSug();
                List <SoilNutrientSoft.Model.FarmlandMSug> newFarmlandMSugList = newFarmlandMSugBll.GetModelList(" All_id = " + FarmlandMegId);
                //获取其在农田管理建议表中对应的id
                int FarmlandMSugId = newFarmlandMSugList[0].Id;


                #region 第一张表单  农田信息

                SoilNutrientSoft.Model.FarmlandMeg newFarmlandMegModel = new SoilNutrientSoft.Model.FarmlandMeg();

                newFarmlandMegModel.Id                    = FarmlandMegId;
                newFarmlandMegModel.City                  = context.Request["city"];
                newFarmlandMegModel.County                = context.Request["country"];
                newFarmlandMegModel.Town                  = context.Request["townName"];
                newFarmlandMegModel.Village               = context.Request["villageName"];
                newFarmlandMegModel.Sample_name           = context.Request["SampleName"];
                newFarmlandMegModel.Lon                   = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["LongitudeDegree"]) ? "0" : context.Request["LongitudeDegree"]);
                newFarmlandMegModel.Lat                   = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["LatitudeDegree"]) ? "0" : context.Request["LatitudeDegree"]);
                newFarmlandMegModel.Name_of_householder   = context.Request["NameOfHouseholder"];
                newFarmlandMegModel.Phone_number          = context.Request["PhoneNumber"];
                newFarmlandMegModel.Irrigation_Conditions = Convert.ToInt32(String.IsNullOrEmpty(context.Request["IrrigationConditions"]) ? "1" : context.Request["IrrigationConditions"]);
                newFarmlandMegModel.Acreage               = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["Acreage"]) ? "0" : context.Request["Acreage"]);
                newFarmlandMegModel.Fertility             = Convert.ToInt32(String.IsNullOrEmpty(context.Request["Fertility"]) ? "1" : context.Request["Fertility"]);
                newFarmlandMegModel.Weeds                 = context.Request["Weeds"];

                SoilNutrientSoft.BLL.FarmlandMeg newFarmlandMegBLL = new SoilNutrientSoft.BLL.FarmlandMeg();

                //更新数据,返回bool类型的值
                bool resultNumFLM = newFarmlandMegBLL.Update(newFarmlandMegModel, MyDict);

                #endregion

                #region 第二张表单 土壤养分信息

                SoilNutrientSoft.Model.SoilNutrientMeg newSoilNutrientMegModel = new SoilNutrientSoft.Model.SoilNutrientMeg();
                newSoilNutrientMegModel.Id            = SoilNutrientMegId;
                newSoilNutrientMegModel.N             = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["N_SoilNutrient"]) ? "0" : context.Request["N_SoilNutrient"]);
                newSoilNutrientMegModel.P             = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["P_SoilNutrient"]) ? "0" : context.Request["P_SoilNutrient"]);
                newSoilNutrientMegModel.K             = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["K_SoilNutrient"]) ? "0" : context.Request["K_SoilNutrient"]);
                newSoilNutrientMegModel.HydrolyticN   = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["HydrolyticN_SoilNutrient"]) ? "0" : context.Request["HydrolyticN_SoilNutrient"]);
                newSoilNutrientMegModel.QuickP        = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["QuickP_SoilNutrient"]) ? "0" : context.Request["QuickP_SoilNutrient"]);
                newSoilNutrientMegModel.QUicK         = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["QuickK_SoilNutrient"]) ? "0" : context.Request["QuickK_SoilNutrient"]);
                newSoilNutrientMegModel.OrganicMatter = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["OrganicMatter_SoilNutrient"]) ? "0" : context.Request["OrganicMatter_SoilNutrient"]);
                newSoilNutrientMegModel.PH            = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["PH_SoilNutrient"]) ? "0" : context.Request["PH_SoilNutrient"]);
                newSoilNutrientMegModel.All_id        = FarmlandMegId;


                //更新数据,返回bool类型的值
                bool resultNumSoil = newSoilNutrientMegBll.Update(newSoilNutrientMegModel, MyDict);

                #endregion

                #region 第三张表  作物信息

                SoilNutrientSoft.Model.CropsMeg newCropsMegModel = new SoilNutrientSoft.Model.CropsMeg();
                newCropsMegModel.Id               = CropsMegId;
                newCropsMegModel.CropType         = context.Request["CropType_CropInfo"];
                newCropsMegModel.Varieties        = context.Request["Varieties_CropInfo"];
                newCropsMegModel.Yield            = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["Yield_CropInfo"]) ? "0" : context.Request["Yield_CropInfo"]);
                newCropsMegModel.urea             = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["urea_CropInfo"]) ? "0" : context.Request["urea_CropInfo"]);
                newCropsMegModel.An               = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["An_CropInfo"]) ? "0" : context.Request["An_CropInfo"]);
                newCropsMegModel.K                = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["K_CropInfo"]) ? "0" : context.Request["K_CropInfo"]);
                newCropsMegModel.Organic_manure   = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["Organic_manure_CropInfo"]) ? "0" : context.Request["Organic_manure_CropInfo"]);
                newCropsMegModel.Others           = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["Others_CropInfo"]) ? "0" : context.Request["Others_CropInfo"]);
                newCropsMegModel.Irrigation_times = Convert.ToInt32(String.IsNullOrEmpty(context.Request["Irrigation_times"]) ? "0" : context.Request["Irrigation_times_CropInfo"]);
                newCropsMegModel.All_id           = FarmlandMegId;

                //更新数据,返回bool类型的值
                bool resultNumCrops = newCropsMegBll.Update(newCropsMegModel, MyDict);


                #endregion

                #region 第四张表    农田管理建议

                SoilNutrientSoft.Model.FarmlandMSug newFarmlandMSugModel = new SoilNutrientSoft.Model.FarmlandMSug();
                newFarmlandMSugModel.Id              = FarmlandMSugId;
                newFarmlandMSugModel.CropType        = context.Request["CropType_ManaSug"];
                newFarmlandMSugModel.Varieties       = context.Request["Varieties_ManaSug"];
                newFarmlandMSugModel.TargetYield     = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["TargetYield_ManaSug"]) ? "0" : context.Request["TargetYield_ManaSug"]);
                newFarmlandMSugModel.urea            = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["urea_ManaSug"]) ? "0" : context.Request["urea_ManaSug"]);
                newFarmlandMSugModel.An              = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["An_ManaSug"]) ? "0" : context.Request["An_ManaSug"]);
                newFarmlandMSugModel.K               = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["K_ManaSug"]) ? "0" : context.Request["K_ManaSug"]);
                newFarmlandMSugModel.OrganicManure   = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["Organic_manure_ManaSug"]) ? "0" : context.Request["Organic_manure_ManaSug"]);
                newFarmlandMSugModel.Others          = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["Others_ManaSug"]) ? "0" : context.Request["Others_ManaSug"]);
                newFarmlandMSugModel.IrrigationTimes = Convert.ToInt32(String.IsNullOrEmpty(context.Request["Irrigation_times_ManaSug"]) ? "0" : context.Request["Irrigation_times_ManaSug"]);
                newFarmlandMSugModel.SowingAmount    = Convert.ToDecimal(String.IsNullOrEmpty(context.Request["SowingAmount_ManaSug"]) ? "0" : context.Request["SowingAmount_ManaSug"]);
                newFarmlandMSugModel.SowingMethod    = context.Request["SowingMethod_ManaSug"];
                newFarmlandMSugModel.WeedControl     = context.Request["WeedControl_ManaSug"];
                newFarmlandMSugModel.PestControl     = context.Request["PestControl_ManaSug"];
                newFarmlandMSugModel.FieldManagement = context.Request["FieldManagement_ManaSug"];
                newFarmlandMSugModel.Remarks         = context.Request["Remarks_ManaSug"];
                newFarmlandMSugModel.All_id          = FarmlandMegId;

                //更新数据,返回bool类型的值
                bool resultFLMS = newFarmlandMSugBll.Update(newFarmlandMSugModel, MyDict);
                #endregion

                //判断四张表是否都更新
                if (resultFLMS && resultNumCrops && resultNumFLM && resultNumSoil)
                {
                    context.Response.Write("ok");
                }
                else
                {
                    context.Response.Write("信息录入失败");
                }
                QuitConnTrans(MyDict);
            }
            catch (Exception E)
            {
                ExceptionQuitConnTrans(MyDict);
                context.Response.Write("更新数据时发生异常:" + E.Message);
                //将信息返回给客户端,停止该页的执行
                context.Response.End();
            }
        }