protected override string btnModify_Click() { decimal money = Convert.ToDecimal(Request.QueryString["money"]); int subid = Convert.ToInt32(Request.QueryString["subid"]); bool result = false; if (!string.IsNullOrEmpty(Request.QueryString["subid"])) { Model.ObjSub model = BLL.ObjSub.GetModel(Convert.ToInt32(Request.QueryString["subid"])); Model.Obj objmodel = BLL.Obj.GetModel(Convert.ToInt32(model.ObjID)); if ((model.ReMoney + money) > model.Money * (1 + model.CZFloat)) { return("支出失败,超出超支限额"); } decimal rmoney = Convert.ToDecimal(BLL.CommonBase.GetSingle("SELECT ISNULL(SUM(CASE WHEN ReMoney>[Money] THEN ReMoney ELSE [Money] END),0) FROM dbo.ObjSub WHERE ID<>" + model.ID + " and OBJID=" + objmodel.ID + ";")); decimal cc = (model.ReMoney + money) > model.Money ? (model.ReMoney + money) : model.Money; if ((rmoney + cc) > objmodel.Money) { return("支出失败,超出项目预算"); } model.ReMoney = model.ReMoney + money; result = BLL.ObjSub.Update(model); } if (result) { return("支出成功"); } return("支出失败"); }
protected override string btnModify_Click() { bool result = false; Model.ObjSub model = new Model.ObjSub(); Model.Obj objmodel = BLL.Obj.GetModel(Convert.ToInt32(Request.Form["objid"])); model.ObjID = objmodel.ID; model.Name = Request.Form["txtSubType"]; model.Remark = Request.Form["txtRemark"]; model.Person = Request.Form["txtPerson"]; model.SubType = Convert.ToInt32(Request.Form["txtSubType"]); model.Money = Convert.ToDecimal(Request.Form["txtMoney"]); model.ReMoney = Convert.ToDecimal(Request.Form["txtReMoney"]); model.CZFloat = Convert.ToDecimal(Request.Form["txtCZFloat"]); model.Money = Convert.ToDecimal(Request.Form["txtMoney"]); if (model.ReMoney > model.Money * (1 + model.CZFloat)) { return("提交失败,超出超支限额"); } decimal rmoney = Convert.ToDecimal(BLL.CommonBase.GetSingle("SELECT ISNULL(SUM(CASE WHEN ReMoney>[Money] THEN ReMoney ELSE [Money] END),0) FROM dbo.ObjSub WHERE OBJID=" + objmodel.ID + ";")); decimal cc = model.ReMoney > model.Money ? model.ReMoney : model.Money; if ((rmoney + cc) > objmodel.Money) { return("提交失败,超出项目预算"); } result = BLL.ObjSub.Add(model); if (result) { return("操作成功"); } return("操作失败"); }
protected override void SetPowerZone() { txtSubType.DataSource = BLL.ObjSubType.GetList(" 1 = 1 order by ID"); txtSubType.DataTextField = "Name"; txtSubType.DataValueField = "ID"; txtSubType.DataBind(); Model.ObjSub model = BLL.ObjSub.GetModel(int.Parse(Request.QueryString["id"])); objid.Value = model.ObjID.ToString(); subid.Value = model.ID.ToString(); txtName.Value = model.Name; txtRemark.Value = model.Remark; txtPerson.Value = model.Person; txtSubType.Value = model.SubType.ToString(); txtMoney.Value = model.Money.ToString("F2"); txtReMoney.Value = model.ReMoney.ToString("F2"); txtCZFloat.Value = model.CZFloat.ToString(); }
protected override string btnModify_Click() { int sid = Convert.ToInt32(Request.QueryString["sid"]); Model.ObjSub os = BLL.ObjSub.GetModel(sid); if (os.SHInt != 0) { return("状态已改变,请重试"); } os.SHInt = 2; if (BLL.ObjSub.Update(os)) { return("审核不合格成功"); } else { return("审核失败"); } }
protected override string btnAdd_Click() { Hashtable MyHs = new Hashtable(); Model.ObjUser OU = BLL.ObjUser.GetModel(Convert.ToInt32(Request.Form["uid"])); Model.OObject objxx = BLL.OObject.GetModel(OU.ObjID); if (Convert.ToInt32(BLL.CommonBase.GetSingle("select COUNT(*) from ObjSubUser where mid='" + TModel.MID + "' AND SpInt='" + OU.ObjID + "' and SState!=3 and sstate!=0;")) > 0) { return("您已提交过结果,请等待审核"); } OU.RState = 1; OU.RImgUrl = Request.Form["uploadurl"]; OU.RUpLoadDate = DateTime.Now; BLL.ObjUser.Update(OU, MyHs); Model.ObjUserApply oA = BLL.ObjUserApply.GetModelOID(OU.BaoMingOID); List <Model.ObjChild> listChild2 = BLL.ObjChild.GetModelList(" ID in(" + oA.SubID + ") "); string suboid = ""; foreach (var item in listChild2) { string childone = Request.Form["ChildOne" + item.ID.ToString()]; string childtwo = Request.Form["ChildTwo" + item.ID.ToString()]; string childavg = Request.Form["ChildAvg" + item.ID.ToString()]; if (string.IsNullOrEmpty(childone) || string.IsNullOrEmpty(childtwo) || string.IsNullOrEmpty(childavg)) { return("请填入结果值"); } Model.ObjSub OSub = new Model.ObjSub(); OSub.MID = TModel.MID; OSub.OID = Guid.NewGuid().ToString("N"); OSub.ResultOne = childone; OSub.ResultTwo = childtwo; OSub.ResultAvg = childavg; OSub.Spare = item.ChildName; OSub.CID = item.ID; OSub.ObjID = objxx.ID; OSub.ObjOID = objxx.ObjOID; OSub.URID = OU.ID; OSub.SpInt = oA.ID; BLL.ObjSub.Add(OSub, MyHs); suboid += OSub.OID + ","; } //如果已有提交结果就修改,未提交过就生成 Model.ObjSubUser reOBJSUB = BLL.ObjSubUser.GetModelList(" mid='" + TModel.MID + "' AND SpInt='" + OU.ObjID + "' and sstate=0;").FirstOrDefault(); if (reOBJSUB == null) { Model.ObjSubUser objapply = new Model.ObjSubUser(); objapply.MID = TModel.MID; objapply.RFangFa = Request.Form["FangFa"]; objapply.RSheBei = Request.Form["YiQi"]; objapply.RYiChang = Request.Form["YiChang"]; objapply.ResultImgUrl = Request.Form["uploadurl"]; objapply.SpInt = Convert.ToInt32(Request.Form["oid"]); objapply.MID = TModel.MID; objapply.SState = 0; objapply.Spare = suboid.Substring(0, suboid.Length - 1); BLL.ObjSubUser.Add(objapply, MyHs); } else { reOBJSUB.MID = TModel.MID; reOBJSUB.RFangFa = Request.Form["FangFa"]; reOBJSUB.RSheBei = Request.Form["YiQi"]; reOBJSUB.RYiChang = Request.Form["YiChang"]; reOBJSUB.ResultImgUrl = Request.Form["uploadurl"]; reOBJSUB.SpInt = Convert.ToInt32(Request.Form["oid"]); reOBJSUB.MID = TModel.MID; reOBJSUB.SState = 0; reOBJSUB.Spare = suboid.Substring(0, suboid.Length - 1); BLL.ObjSubUser.Update(reOBJSUB, MyHs); } if (BLL.CommonBase.RunHashtable(MyHs)) { BLL.OperationRecordBLL.Add(TModel.MID, "结果提交", "项目名称为:" + objxx.ObjName); return("结果提交成功,请等待审核"); } else { return("提交失败"); } }