/*
* /// <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 = "FarmlandMeg";
* 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>
/// <param name="model"></param>
/// <param name="Myconn"></param>
/// <returns></returns>
public int Add(SoilNutrientSoft.Model.FarmlandMeg model, Dictionary <SqlConnection, SqlTransaction> MyDict)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into FarmlandMeg(");
strSql.Append("City,County,Town,Village,Sample_name,Lon,Lat,Name_of_householder,Phone_number,Irrigation_Conditions,Acreage,Fertility,Weeds)");
strSql.Append(" values (");
strSql.Append("@City,@County,@Town,@Village,@Sample_name,@Lon,@Lat,@Name_of_householder,@Phone_number,@Irrigation_Conditions,@Acreage,@Fertility,@Weeds)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@City", SqlDbType.NVarChar, 50),
new SqlParameter("@County", SqlDbType.NVarChar, 50),
new SqlParameter("@Town", SqlDbType.NVarChar, 50),
new SqlParameter("@Village", SqlDbType.NVarChar, 50),
new SqlParameter("@Sample_name", SqlDbType.NVarChar, 50),
new SqlParameter("@Lon", SqlDbType.Float, 8),
new SqlParameter("@Lat", SqlDbType.Float, 8),
new SqlParameter("@Name_of_householder", SqlDbType.NVarChar, 50),
new SqlParameter("@Phone_number", SqlDbType.NVarChar, 11),
new SqlParameter("@Irrigation_Conditions", SqlDbType.Int, 4),
new SqlParameter("@Acreage", SqlDbType.Float, 8),
new SqlParameter("@Fertility", SqlDbType.Int, 4),
new SqlParameter("@Weeds", SqlDbType.NVarChar, 100)
};
parameters[0].Value = model.City;
parameters[1].Value = model.County;
parameters[2].Value = model.Town;
parameters[3].Value = model.Village;
parameters[4].Value = model.Sample_name;
parameters[5].Value = model.Lon;
parameters[6].Value = model.Lat;
parameters[7].Value = model.Name_of_householder;
parameters[8].Value = model.Phone_number;
parameters[9].Value = model.Irrigation_Conditions;
parameters[10].Value = model.Acreage;
parameters[11].Value = model.Fertility;
parameters[12].Value = model.Weeds;
try
{
object obj = DbHelperSQL.GetSingle(strSql.ToString(), MyDict, parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
catch
{
throw;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public SoilNutrientSoft.Model.FarmlandMeg GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Id,City,County,Town,Village,Sample_name,Lon,Lat,Name_of_householder,Phone_number,Irrigation_Conditions,Acreage,Fertility,Weeds from FarmlandMeg ");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = Id;
SoilNutrientSoft.Model.FarmlandMeg model = new SoilNutrientSoft.Model.FarmlandMeg();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
//获取到标记对应的id
int markerID = Convert.ToInt32(context.Request["id"]);
//农田基本数据对象
SoilNutrientSoft.BLL.FarmlandMeg newFarmlandMegBll = new SoilNutrientSoft.BLL.FarmlandMeg();
SoilNutrientSoft.Model.FarmlandMeg newFarmlandMegModel = new SoilNutrientSoft.Model.FarmlandMeg();
//根据id查询数据
newFarmlandMegModel = newFarmlandMegBll.GetModel(markerID);
//创建序列化对象
JavaScriptSerializer JavaScriptSerializer = new JavaScriptSerializer();
//转换成JSON字符串
// var dataStr = JavaScriptSerializer.Serialize(newFarmlandMegModel);
//**************************************************
//土壤养分信息
SoilNutrientSoft.BLL.SoilNutrientMeg newSoilNutrientMegBll = new SoilNutrientSoft.BLL.SoilNutrientMeg();
List <SoilNutrientSoft.Model.SoilNutrientMeg> newSoilNutrientMegList = newSoilNutrientMegBll.GetModelList(" All_id = " + markerID.ToString());
//转换成JSON字符串
// var dataStr = JavaScriptSerializer.Serialize(newSoilNutrientMegList[0]);
//**************************************************
//作物数据
SoilNutrientSoft.BLL.CropsMeg newCropsMegBll = new SoilNutrientSoft.BLL.CropsMeg();
List <SoilNutrientSoft.Model.CropsMeg> newCropsMegList = newCropsMegBll.GetModelList(" All_id = " + markerID.ToString());
//转换成JSON字符串
//var dataStr = JavaScriptSerializer.Serialize(newCropsMegList[0]);
//***************************************
//农田建议
SoilNutrientSoft.BLL.FarmlandMSug newFarmlandMSugBll = new SoilNutrientSoft.BLL.FarmlandMSug();
List <SoilNutrientSoft.Model.FarmlandMSug> newFarmlandMSugList = newFarmlandMSugBll.GetModelList(" All_id = " + markerID.ToString());
//转换成JSON字符串
//var dataStr = JavaScriptSerializer.Serialize(newFarmlandMSugList[0]);
//***************************************
//图片
SoilNutrientSoft.BLL.Picture newPictureBll = new SoilNutrientSoft.BLL.Picture();
//得到数据集合
List <SoilNutrientSoft.Model.Picture> newPictureModelList = newPictureBll.GetModelList(" All_id = " + markerID.ToString());
//添加至内部类List中
List <Pic> newPicList = new List <Pic>();
foreach (var item in newPictureModelList)
{
newPicList.Add(new Pic()
{
picPath = item.picturePath
});
}
//转换成JSON字符串
//var dataStr = JavaScriptSerializer.Serialize(newPicList);
SerializeObject newSerializeObject = new SerializeObject()
{
FarmlandMegObject = newFarmlandMegModel,
SoilNutrientMegObject = newSoilNutrientMegList[0],
CropsMegObject = newCropsMegList[0],
FarmlandMSugObject = newFarmlandMSugList[0],
PicObject = newPicList
};
var dataStr = JavaScriptSerializer.Serialize(newSerializeObject);
context.Response.Write(dataStr);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public SoilNutrientSoft.Model.FarmlandMeg DataRowToModel(DataRow row)
{
SoilNutrientSoft.Model.FarmlandMeg model = new SoilNutrientSoft.Model.FarmlandMeg();
if (row != null)
{
if (row["Id"] != null && row["Id"].ToString() != "")
{
model.Id = int.Parse(row["Id"].ToString());
}
if (row["City"] != null)
{
model.City = row["City"].ToString();
}
if (row["County"] != null)
{
model.County = row["County"].ToString();
}
if (row["Town"] != null)
{
model.Town = row["Town"].ToString();
}
if (row["Village"] != null)
{
model.Village = row["Village"].ToString();
}
if (row["Sample_name"] != null)
{
model.Sample_name = row["Sample_name"].ToString();
}
if (row["Lon"] != null && row["Lon"].ToString() != "")
{
model.Lon = decimal.Parse(row["Lon"].ToString());
}
if (row["Lat"] != null && row["Lat"].ToString() != "")
{
model.Lat = decimal.Parse(row["Lat"].ToString());
}
if (row["Name_of_householder"] != null)
{
model.Name_of_householder = row["Name_of_householder"].ToString();
}
if (row["Phone_number"] != null)
{
model.Phone_number = row["Phone_number"].ToString();
}
if (row["Irrigation_Conditions"] != null && row["Irrigation_Conditions"].ToString() != "")
{
model.Irrigation_Conditions = int.Parse(row["Irrigation_Conditions"].ToString());
}
if (row["Acreage"] != null && row["Acreage"].ToString() != "")
{
model.Acreage = decimal.Parse(row["Acreage"].ToString());
}
if (row["Fertility"] != null && row["Fertility"].ToString() != "")
{
model.Fertility = int.Parse(row["Fertility"].ToString());
}
if (row["Weeds"] != null)
{
model.Weeds = row["Weeds"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(SoilNutrientSoft.Model.FarmlandMeg model, Dictionary <SqlConnection, SqlTransaction> MyDict)
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update FarmlandMeg set ");
strSql.Append("City=@City,");
strSql.Append("County=@County,");
strSql.Append("Town=@Town,");
strSql.Append("Village=@Village,");
strSql.Append("Sample_name=@Sample_name,");
strSql.Append("Lon=@Lon,");
strSql.Append("Lat=@Lat,");
strSql.Append("Name_of_householder=@Name_of_householder,");
strSql.Append("Phone_number=@Phone_number,");
strSql.Append("Irrigation_Conditions=@Irrigation_Conditions,");
strSql.Append("Acreage=@Acreage,");
strSql.Append("Fertility=@Fertility,");
strSql.Append("Weeds=@Weeds");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@City", SqlDbType.NVarChar, 50),
new SqlParameter("@County", SqlDbType.NVarChar, 50),
new SqlParameter("@Town", SqlDbType.NVarChar, 50),
new SqlParameter("@Village", SqlDbType.NVarChar, 50),
new SqlParameter("@Sample_name", SqlDbType.NVarChar, 50),
new SqlParameter("@Lon", SqlDbType.Float, 8),
new SqlParameter("@Lat", SqlDbType.Float, 8),
new SqlParameter("@Name_of_householder", SqlDbType.NVarChar, 50),
new SqlParameter("@Phone_number", SqlDbType.NVarChar, 11),
new SqlParameter("@Irrigation_Conditions", SqlDbType.Int, 4),
new SqlParameter("@Acreage", SqlDbType.Float, 8),
new SqlParameter("@Fertility", SqlDbType.Int, 4),
new SqlParameter("@Weeds", SqlDbType.NVarChar, 100),
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = model.City;
parameters[1].Value = model.County;
parameters[2].Value = model.Town;
parameters[3].Value = model.Village;
parameters[4].Value = model.Sample_name;
parameters[5].Value = model.Lon;
parameters[6].Value = model.Lat;
parameters[7].Value = model.Name_of_householder;
parameters[8].Value = model.Phone_number;
parameters[9].Value = model.Irrigation_Conditions;
parameters[10].Value = model.Acreage;
parameters[11].Value = model.Fertility;
parameters[12].Value = model.Weeds;
parameters[13].Value = model.Id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), MyDict, parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception e)
{
throw e;
}
}
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();
}
}
