/// <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));
}
private void AddOrModify(HttpContext context)
{
//===============================================================
//获取字段:【用户name】
string id, name, year, administratorArea, isSubmited, planTypeId, consArea, agriArea, arabArea, issuedQuota, remainQuota, releaseNo, releaseTime, des;
id = name = year = administratorArea = planTypeId = isSubmited = consArea = agriArea = arabArea = issuedQuota = remainQuota = releaseNo = releaseTime = des = "";
if (null != context.Request.QueryString["id"])
{
id = context.Request.QueryString["id"].ToString().Trim();
}
if (null != context.Request.QueryString["name"])
{
name = context.Request.QueryString["name"].ToString().Trim();
}
if (null != context.Request.QueryString["year"])
{
year = context.Request.QueryString["year"].ToString().Trim();
}
if (null != context.Request.QueryString["administratorArea"])
{
administratorArea = context.Request.QueryString["administratorArea"].ToString().Trim();
}
if (null != context.Request.QueryString["isSubmited"])
{
isSubmited = context.Request.QueryString["isSubmited"].ToString().Trim();
}
if (null != context.Request.QueryString["planTypeId"])
{
planTypeId = context.Request.QueryString["planTypeId"].ToString().Trim();
}
if (null != context.Request.QueryString["consArea"])
{
consArea = context.Request.QueryString["consArea"].ToString().Trim();
}
if (null != context.Request.QueryString["agriArea"])
{
agriArea = context.Request.QueryString["agriArea"].ToString().Trim();
}
if (null != context.Request.QueryString["arabArea"])
{
arabArea = context.Request.QueryString["arabArea"].ToString().Trim();
}
if (null != context.Request.QueryString["issuedQuota"])
{
issuedQuota = context.Request.QueryString["issuedQuota"].ToString().Trim();
}
if (null != context.Request.QueryString["remainQuota"])
{
remainQuota = context.Request.QueryString["remainQuota"].ToString().Trim();
}
if (null != context.Request.QueryString["releaseNo"])
{
releaseNo = context.Request.QueryString["releaseNo"].ToString().Trim();
}
if (null != context.Request.QueryString["releaseTime"])
{
releaseTime = context.Request.QueryString["releaseTime"].ToString().Trim();
}
if (null != context.Request.QueryString["des"])
{
des = context.Request.QueryString["des"].ToString().Trim();
}
if (id == "")
{
Model.T_Plan model = new Model.T_Plan();
model.name = name;
model.year = year;
model.administratorArea = administratorArea;
if (planTypeId != "")
{
model.planTypeId = Convert.ToInt32(planTypeId);
}
else
{
model.planTypeId = 0;
}
if (consArea != "")
{
model.consArea = Convert.ToDecimal(consArea);
}
else
{
model.consArea = 0;
}
if (agriArea != "")
{
model.agriArea = Convert.ToDecimal(agriArea);
}
else
{
model.agriArea = 0;
}
if (arabArea != "")
{
model.arabArea = Convert.ToDecimal(arabArea);
}
else
{
model.arabArea = 0;
}
if (issuedQuota != "")
{
model.issuedQuota = Convert.ToDecimal(issuedQuota);
}
else
{
model.issuedQuota = 0;
}
if (remainQuota != "")
{
model.remainQuota = Convert.ToDecimal(remainQuota);
}
else
{
model.remainQuota = 0;
}
model.releaseNo = releaseNo;
if (releaseTime != "")
{
model.releaseTime = Convert.ToDateTime(releaseTime);
}
else
{
model.releaseTime = System.DateTime.Now;
}
if (context.Session["user_id"].ToString() != "")
{
model.userId = Convert.ToInt32(context.Session["user_id"]);
}
else
{
model.userId = 0;
}
if (isSubmited != "")
{
model.isSubmited = Convert.ToInt32(isSubmited);
}
else
{
model.isSubmited = 0;
}
model.createTime = System.DateTime.Now;
model.isDeleted = 0;
model.des = des;
int n = bll_plan.Add(model);
if (n > 0)
{
message.flag = true;
message.msg = "添加成功";
}
else
{
message.flag = false;
message.msg = "添加失败";
}
}
else
{
Model.T_Plan model = bll_plan.GetModel(Convert.ToInt32(id));
model.name = name;
model.year = year;
model.administratorArea = administratorArea;
if (planTypeId != "")
{
model.planTypeId = Convert.ToInt32(planTypeId);
}
if (consArea != "")
{
model.consArea = Convert.ToDecimal(consArea);
}
else
{
model.consArea = 0;
}
if (agriArea != "")
{
model.agriArea = Convert.ToDecimal(agriArea);
}
else
{
model.agriArea = 0;
}
if (arabArea != "")
{
model.arabArea = Convert.ToDecimal(arabArea);
}
else
{
model.arabArea = 0;
}
if (issuedQuota != "")
{
model.issuedQuota = Convert.ToDecimal(issuedQuota);
}
else
{
model.issuedQuota = 0;
}
if (remainQuota != "")
{
model.remainQuota = Convert.ToDecimal(remainQuota);
}
else
{
model.remainQuota = 0;
}
model.releaseNo = releaseNo;
if (releaseTime != "")
{
model.releaseTime = Convert.ToDateTime(releaseTime);
}
else
{
model.releaseTime = System.DateTime.Now;
}
if (context.Session["user_id"].ToString() != "")
{
model.userId = Convert.ToInt32(context.Session["user_id"]);
}
else
{
model.userId = 0;
}
model.createTime = System.DateTime.Now;
model.des = des;
bool flag = bll_plan.Update(model);
if (flag)
{
message.flag = true;
message.msg = "修改成功";
}
else
{
message.flag = false;
message.msg = "修改失败";
}
}
String jsonString = JsonHelper.Object2Json <Message>(message);
context.Response.Write(jsonString);
}
