/// <summary>
/// 根据占补平衡id获取剩余面积
/// </summary>
/// <param name="balanceId"></param>
/// <returns></returns>
public static RemainArea1 GetRemainAreaByBalanceId(int balanceId)
{
Model.T_DemandSupplyBalance model = bll_demand_supply_balance.GetModel(Convert.ToInt32(balanceId));
//获取该批次已经使用面积
decimal usedConsArea, usedAgriArea, usedArabArea;
usedConsArea = usedAgriArea = usedArabArea = 0;
DataSet ds = bll_batch_balance.GetList(" dsBalanceId=" + balanceId);
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (dr["agriArea"] != null)
{
usedAgriArea += Convert.ToDecimal(dr["agriArea"]);
}
if (dr["arabArea"] != null)
{
usedArabArea += Convert.ToDecimal(dr["arabArea"]);
}
}
}
RemainArea1 remainAreas = new RemainArea1();
remainAreas.consArea = 0;
remainAreas.agriArea = (Decimal)model.agriArea - usedAgriArea;
remainAreas.arabArea = (Decimal)model.arabArea - usedArabArea;
return(remainAreas);
}
/// <summary>
/// 获取该批次剩余面积
/// </summary>
/// <param name="context"></param>
private void GetRemainArea(HttpContext context)
{
string dsBalanceId = "";
if (null != context.Request.QueryString["dsBalanceId"])
{
dsBalanceId = context.Request.QueryString["dsBalanceId"].ToString().Trim();
}
Model.T_DemandSupplyBalance model = bll_demand_supply_balance.GetModel(Convert.ToInt32(dsBalanceId));
//获取该批次已经使用面积
decimal usedConsArea, usedAgriArea, usedArabArea;
usedConsArea = usedAgriArea = usedArabArea = 0;
DataSet ds = bll_batch_balance.GetList(" dsBalanceId=" + dsBalanceId);
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (dr["agriArea"] != null)
{
usedAgriArea += Convert.ToDecimal(dr["agriArea"]);
}
if (dr["arabArea"] != null)
{
usedArabArea += Convert.ToDecimal(dr["arabArea"]);
}
}
}
RemainArea1 remainAreas = new RemainArea1();
remainAreas.consArea = 0;
remainAreas.agriArea = (Decimal)model.agriArea - usedAgriArea;
remainAreas.arabArea = (Decimal)model.arabArea - usedArabArea;
context.Response.Write(JsonHelper.Object2Json <RemainArea1>(remainAreas));
}
private void AddOrModify(HttpContext context)
{
//===============================================================
//获取字段:【用户name】
string id, no, name, year, administratorAreaId, isSubmited, typeId, scale, agriArea, arabArea, occupyArea, position, acceptUnit, acceptNo, acceptTime, des;
id = no = name = year = administratorAreaId = isSubmited = typeId = scale = agriArea = arabArea = occupyArea = position = acceptUnit = acceptNo = acceptTime = 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["no"])
{
no = context.Request.QueryString["no"].ToString().Trim();
}
if (null != context.Request.QueryString["year"])
{
year = context.Request.QueryString["year"].ToString().Trim();
}
if (null != context.Request.QueryString["administratorArea"])
{
administratorAreaId = context.Request.QueryString["administratorArea"].ToString().Trim();
}
if (null != context.Request.QueryString["isSubmited"])
{
isSubmited = context.Request.QueryString["isSubmited"].ToString().Trim();
}
if (null != context.Request.QueryString["typeId"])
{
typeId = context.Request.QueryString["typeId"].ToString().Trim();
}
if (null != context.Request.QueryString["scale"])
{
scale = context.Request.QueryString["scale"].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["occupyArea"])
{
occupyArea = context.Request.QueryString["occupyArea"].ToString().Trim();
}
if (null != context.Request.QueryString["position"])
{
position = context.Request.QueryString["position"].ToString().Trim();
}
if (null != context.Request.QueryString["acceptUnit"])
{
acceptUnit = context.Request.QueryString["acceptUnit"].ToString().Trim();
}
if (null != context.Request.QueryString["acceptNo"])
{
acceptNo = context.Request.QueryString["acceptNo"].ToString().Trim();
}
if (null != context.Request.QueryString["acceptTime"])
{
acceptTime = context.Request.QueryString["acceptTime"].ToString().Trim();
}
if (null != context.Request.QueryString["des"])
{
des = context.Request.QueryString["des"].ToString().Trim();
}
if (id == "")
{
Model.T_DemandSupplyBalance model = new Model.T_DemandSupplyBalance();
model.name = name;
model.no = no;
model.year = year;
model.administratorArea = administratorAreaId;
if (typeId != "")
{
model.typeId = Convert.ToInt32(typeId);
}
else
{
model.typeId = 0;
}
if (scale != "")
{
model.scale = Convert.ToDecimal(scale);
}
else
{
model.scale = 0;
}
if (agriArea != "")
{
model.agriArea = Convert.ToDecimal(agriArea);
}
else
{
model.agriArea = 0;
}
if (arabArea != "")
{
model.arabArea = Convert.ToDecimal(arabArea);
}
else
{
model.arabArea = 0;
}
if (occupyArea != "")
{
model.occupyArea = Convert.ToDecimal(occupyArea);
}
else
{
model.occupyArea = 0;
}
model.position = position;
model.acceptUnit = acceptUnit;
model.acceptNo = acceptNo;
if (acceptTime != "")
{
model.acceptTime = Convert.ToDateTime(acceptTime);
}
else
{
model.acceptTime = 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;
if (isSubmited != "")
{
model.isSubmited = Convert.ToInt32(isSubmited);
}
else
{
model.isSubmited = 0;
}
model.isDeleted = 0;
model.des = des;
int n = bll_demand_supply_balance.Add(model);
if (n > 0)
{
message.flag = true;
message.msg = "添加成功";
}
else
{
message.flag = false;
message.msg = "添加失败";
}
}
else
{
Model.T_DemandSupplyBalance model = bll_demand_supply_balance.GetModel(Convert.ToInt32(id));
model.no = no;
model.name = name;
model.year = year;
model.administratorArea = administratorAreaId;
if (typeId != "")
{
model.typeId = Convert.ToInt32(typeId);
}
if (scale != "")
{
model.scale = Convert.ToDecimal(scale);
}
else
{
model.scale = 0;
}
if (agriArea != "")
{
model.agriArea = Convert.ToDecimal(agriArea);
}
else
{
model.agriArea = 0;
}
if (arabArea != "")
{
model.arabArea = Convert.ToDecimal(arabArea);
}
else
{
model.arabArea = 0;
}
if (occupyArea != "")
{
model.occupyArea = Convert.ToDecimal(occupyArea);
}
else
{
model.occupyArea = 0;
}
model.position = position;
model.acceptUnit = acceptUnit;
model.acceptNo = acceptNo;
if (acceptTime != "")
{
model.acceptTime = Convert.ToDateTime(acceptTime);
}
else
{
model.acceptTime = 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_demand_supply_balance.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);
}
private void AddOrModify(HttpContext context)
{
//===============================================================
//获取字段:【用户name】
string id,no ,name, year, administratorAreaId, isSubmited, typeId, scale, agriArea, arabArea, occupyArea, position, acceptUnit, acceptNo, acceptTime, des;
id =no= name = year = administratorAreaId =isSubmited= typeId = scale = agriArea = arabArea = occupyArea = position = acceptUnit = acceptNo = acceptTime = 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["no"])
{
no = context.Request.QueryString["no"].ToString().Trim();
}
if (null != context.Request.QueryString["year"])
{
year = context.Request.QueryString["year"].ToString().Trim();
}
if (null != context.Request.QueryString["administratorArea"])
{
administratorAreaId = context.Request.QueryString["administratorArea"].ToString().Trim();
}
if (null != context.Request.QueryString["isSubmited"])
{
isSubmited = context.Request.QueryString["isSubmited"].ToString().Trim();
}
if (null != context.Request.QueryString["typeId"])
{
typeId = context.Request.QueryString["typeId"].ToString().Trim();
}
if (null != context.Request.QueryString["scale"])
{
scale = context.Request.QueryString["scale"].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["occupyArea"])
{
occupyArea = context.Request.QueryString["occupyArea"].ToString().Trim();
}
if (null != context.Request.QueryString["position"])
{
position = context.Request.QueryString["position"].ToString().Trim();
}
if (null != context.Request.QueryString["acceptUnit"])
{
acceptUnit = context.Request.QueryString["acceptUnit"].ToString().Trim();
}
if (null != context.Request.QueryString["acceptNo"])
{
acceptNo = context.Request.QueryString["acceptNo"].ToString().Trim();
}
if (null != context.Request.QueryString["acceptTime"])
{
acceptTime = context.Request.QueryString["acceptTime"].ToString().Trim();
}
if (null != context.Request.QueryString["des"])
{
des = context.Request.QueryString["des"].ToString().Trim();
}
if (id == "")
{
Model.T_DemandSupplyBalance model = new Model.T_DemandSupplyBalance();
model.name = name;
model.no = no;
model.year = year;
model.administratorArea = administratorAreaId;
if (typeId != "")
{
model.typeId = Convert.ToInt32(typeId);
}
else {
model.typeId = 0;
}
if (scale != "")
{
model.scale = Convert.ToDecimal(scale);
}
else {
model.scale = 0;
}
if (agriArea != "")
{
model.agriArea = Convert.ToDecimal(agriArea);
}
else
{
model.agriArea = 0;
}
if (arabArea != "")
{
model.arabArea = Convert.ToDecimal(arabArea);
}
else
{
model.arabArea = 0;
}
if (occupyArea != "")
{
model.occupyArea = Convert.ToDecimal(occupyArea);
}
else
{
model.occupyArea = 0;
}
model.position = position;
model.acceptUnit = acceptUnit;
model.acceptNo = acceptNo;
if (acceptTime != "")
{
model.acceptTime = Convert.ToDateTime(acceptTime);
}
else
{
model.acceptTime = 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;
if (isSubmited != "") { model.isSubmited = Convert.ToInt32(isSubmited); } else { model.isSubmited = 0; }
model.isDeleted = 0;
model.des = des;
int n = bll_demand_supply_balance.Add(model);
if (n > 0)
{
message.flag = true;
message.msg = "添加成功";
}
else
{
message.flag = false;
message.msg = "添加失败";
}
}
else
{
Model.T_DemandSupplyBalance model = bll_demand_supply_balance.GetModel(Convert.ToInt32(id));
model.no = no;
model.name = name;
model.year = year;
model.administratorArea = administratorAreaId;
if (typeId != "")
{
model.typeId = Convert.ToInt32(typeId);
}
if (scale != "")
{
model.scale = Convert.ToDecimal(scale);
}
else
{
model.scale = 0;
}
if (agriArea != "")
{
model.agriArea = Convert.ToDecimal(agriArea);
}
else
{
model.agriArea = 0;
}
if (arabArea != "")
{
model.arabArea = Convert.ToDecimal(arabArea);
}
else
{
model.arabArea = 0;
}
if (occupyArea != "")
{
model.occupyArea = Convert.ToDecimal(occupyArea);
}
else
{
model.occupyArea = 0;
}
model.position = position;
model.acceptUnit = acceptUnit;
model.acceptNo = acceptNo;
if (acceptTime != "")
{
model.acceptTime = Convert.ToDateTime(acceptTime);
}
else
{
model.acceptTime = 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_demand_supply_balance.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);
}
