/// <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); }