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("提交失败");
}
}
