/// <summary>
/// 获取该批次剩余面积
/// </summary>
/// <param name="context"></param>
private void GetRemainArea(HttpContext context)
{
string planId = "";
if (null != context.Request.QueryString["planId"])
{
planId = context.Request.QueryString["planId"].ToString().Trim();
}
Model.T_Plan t_plan = bll_plan.GetModel(Convert.ToInt32(planId));
//获取该批次已经使用面积
decimal usedConsArea, usedAgriArea, usedArabArea, usedIssuedQuota;
usedConsArea = usedAgriArea = usedArabArea = usedIssuedQuota = 0;
RemainArea2 remainAreas = new RemainArea2();
DataSet ds = bll_batch_plan.GetList(" planId=" + planId);
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (planId == "6")//增减挂钩批次
{
if (dr["issuedQuota"] != null)
{
usedIssuedQuota += Convert.ToDecimal(dr["issuedQuota"]);
}
}
else
{
if (dr["consArea"] != null)
{
usedConsArea += Convert.ToDecimal(dr["consArea"]);
}
if (dr["agriArea"] != null)
{
usedAgriArea += Convert.ToDecimal(dr["agriArea"]);
}
if (dr["arabArea"] != null)
{
usedArabArea += Convert.ToDecimal(dr["arabArea"]);
}
}
}
}
remainAreas.consArea = (Decimal)t_plan.consArea - usedConsArea;
remainAreas.agriArea = (Decimal)t_plan.agriArea - usedAgriArea;
remainAreas.arabArea = (Decimal)t_plan.arabArea - usedArabArea;
remainAreas.issuedQuota = (Decimal)t_plan.agriArea - usedIssuedQuota;
context.Response.Write(JsonHelper.Object2Json <RemainArea2>(remainAreas));
}
/// <summary>
/// 获取该批次剩余面积
/// </summary>
/// <param name="context"></param>
private void GetRemainPlanArea(HttpContext context)
{
string batchId = "";
if (null != context.Request.QueryString["batchId"])
{
batchId = context.Request.QueryString["batchId"].ToString().Trim();
}
Model.T_Batch t_batch = bll_batch.GetModel(Convert.ToInt32(batchId));
DataSet ds = bll_batch_plan.GetList("batchId=" + batchId);
//获取该批次已经使用面积
decimal usedConsArea, usedAgriArea, usedArabArea, usedIssuedQuota;
usedConsArea = usedAgriArea = usedArabArea = usedIssuedQuota = 0;
RemainArea2 remainAreas = new RemainArea2();
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (t_batch.batchTypeId == 4)//增减挂钩批次
{
if (dr["issuedQuota"] != null)
{
usedIssuedQuota += Convert.ToDecimal(dr["issuedQuota"]);
}
}
else
{
if (dr["consArea"] != null)
{
usedConsArea += Convert.ToDecimal(dr["consArea"]);
}
if (dr["agriArea"] != null)
{
usedAgriArea += Convert.ToDecimal(dr["agriArea"]);
}
if (dr["arabArea"] != null)
{
usedArabArea += Convert.ToDecimal(dr["arabArea"]);
}
}
}
}
if (t_batch.batchTypeId == 4)//增减挂钩批次
{
remainAreas.issuedQuota = (Decimal)t_batch.agriArea - usedIssuedQuota;
}
else {
remainAreas.consArea = (Decimal)t_batch.consArea - usedConsArea;
remainAreas.agriArea = (Decimal)t_batch.agriArea - usedAgriArea;
remainAreas.arabArea = (Decimal)t_batch.arabArea - usedArabArea;
}
context.Response.Write(JsonHelper.Object2Json<RemainArea2>(remainAreas));
}
