protected override string btnAdd_Click() { Hashtable HS = new Hashtable(); Model.OObject obj = BLL.OObject.GetModel(Convert.ToInt32(Request.Form["xxid"])); obj.ObjName = Request.Form["ObjName"]; obj.Remark = Request.Form["Remark"]; obj.ObjExcel = ""; obj.ObjChild = ""; //如果是被打回的项目 if (obj.OState == 2) { obj.ReSpare = ""; obj.OState = 0; } if (TModel.Role.IsAdmin) { obj.SState = Convert.ToInt32(Request.Form["txtJSStatus"]); } obj.BMDate = Convert.ToDateTime(Request.Form["BMstateDate"]); obj.JGDate = Convert.ToDateTime(Request.Form["ComDate"]); if (BLL.OObject.Update(obj)) { BLL.OperationRecordBLL.Add(TModel.MID, "修改项目", "OID为:" + obj.ObjOID); return("修改项目成功"); } else { return("修改项目失败"); } }
protected override void SetPowerZone() { int pid = Convert.ToInt32(Request.QueryString["xxid"]); oid.Value = pid.ToString(); int bm = Convert.ToInt32(Request.QueryString["bmid"]); bmid.Value = bm.ToString(); oua = BLL.ObjUserApply.GetModel(bm); uploadurl.Value = oua.BaoMingImgUrl; uploadurl2.Value = oua.FeiYongImgUrl; obj = BLL.OObject.GetModel(pid); listExcel = BLL.ObjExcel.GetModelList(" ObjOID='" + obj.ObjOID + "' "); listChild = BLL.ObjChild.GetModelList(" ObjOID='" + obj.ObjOID + "' "); Random rd = new Random(); int cc = rd.Next(1000, 9999); roam.Value = cc.ToString(); roam2.Value = cc.ToString(); rdstr = cc.ToString(); }
protected override string btnModify_Click() { string xx = Request.Form["remsg"]; Hashtable MyHs = new Hashtable(); Model.OObject oamodel = BLL.OObject.GetModel(Convert.ToInt32(Request.Form["oid"])); if (oamodel.OState != 0) { return("此状态不能打回"); } oamodel.OState = 2; oamodel.ReSpare = xx; oamodel.ObjExcel = ""; oamodel.ObjChild = ""; if (BLL.OObject.Update(oamodel)) { BLL.OperationRecordBLL.Add(TModel.MID, "验证项目打回", "OID为:" + oamodel.ObjOID); return("打回成功"); } else { return("验证项目审核打回失败"); } }
public List <Model.ObjSub> objsublist = null; //结果值 protected override void SetPowerZone() { int id = Convert.ToInt32(Request.QueryString["xxid"]); uid.Value = id.ToString(); objuser = BLL.ObjUser.GetModel(id); obj = BLL.OObject.GetModel(objuser.ObjID); oapply = BLL.ObjUserApply.GetModelOID(objuser.BaoMingOID); listChild = BLL.ObjChild.GetModelList(" ID IN(" + oapply.SubID + ") "); listExcel = BLL.ObjExcel.GetModelList(" ObjOID='" + obj.ObjOID + "' "); objsample = BLL.ObjSample.GetModelOID(objuser.YangPinOID); obj = BLL.OObject.GetModel(oapply.ObjID); tmember = BLL.Member.GetModelByMID(oapply.MID); objsubuser = BLL.ObjSubUser.GetModelList(" SpInt=" + obj.ID + " AND MID='" + tmember.MID + "'").FirstOrDefault(); if (objsubuser != null) { string[] sublist = objsubuser.Spare.Split(','); string substr = ""; foreach (var item in sublist) { if (string.IsNullOrEmpty(item)) { continue; } substr += "'" + item + "',"; } objsublist = BLL.ObjSub.GetModelList(" OID in(" + substr.Substring(0, substr.Length - 1) + ") "); } }
protected override void SetPowerZone() { int oid = Convert.ToInt32(Request.QueryString["xxid"]); oaid.Value = oid.ToString(); oapply = BLL.ObjUserApply.GetModel(oid); listChild = BLL.ObjChild.GetModelList(" ID IN(" + oapply.SubID + ") "); obj = BLL.OObject.GetModel(oapply.ObjID); tmember = BLL.Member.GetModelByMID(oapply.MID); }
public override void ProcessRequest(HttpContext context) { base.ProcessRequest(context); string strWhere = "'1'='1'"; if (!string.IsNullOrEmpty(context.Request["nTitle"])) { strWhere += " and objID IN(SELECT ID FROM OObject WHERE OBJNAME='" + context.Request["nTitle"] + "') "; } if (!string.IsNullOrEmpty(context.Request["bmoid"])) { strWhere += " and OBJID=" + context.Request["bmoid"] + ""; } //如果是单位部门的话 能管理自己发布的项目 if (!TModel.Role.IsAdmin) { strWhere += " and objID IN(SELECT ID FROM OObject WHERE ReObjMID='" + TModel.MID + "') "; } int count; List <Model.ObjUserApply> ListO = BLL.ObjUserApply.GetList(strWhere, pageIndex, pageSize, out count); StringBuilder sb = new StringBuilder(); for (int i = 0; i < ListO.Count; i++) { Model.OObject obj = BLL.OObject.GetModel(ListO[i].ObjID); sb.Append(ListO[i].ID + "~"); sb.Append((i + 1) + (pageIndex - 1) * pageSize + "~"); sb.Append(obj.ObjOID + "~"); sb.Append(obj.ObjName + "~"); sb.Append(ListO[i].BaoMingCode + "~"); sb.Append(ListO[i].DanWeiName + "~"); sb.Append(ListO[i].MID + "~"); sb.Append(ListO[i].CreateDate.ToString("yyyy-MM-dd HH:mm") + "~"); sb.Append("<a href='" + ListO[i].FeiYongImgUrl + "' target='_blank'><img width='80' height='80' src='" + ListO[i].FeiYongImgUrl + "' /></a>" + "~"); sb.Append("<a href='" + ListO[i].BaoMingImgUrl + "' target='_blank'><img width='80' height='80' src='" + ListO[i].BaoMingImgUrl + "' /></a>" + "~"); sb.Append(ListO[i].ReSpare + "~"); sb.Append(ListO[i].SState.ToString().Replace("0", "未审核").Replace("1", "审核不通过").Replace("3", "审核通过") + "~"); sb.Append((ListO[i].SState == 0 ? "<div class=\"pay btn btn-success\" onclick=\"callhtml('/ProjectManage/SHSignProject.aspx?xxid=" + ListO[i].ID + "','审核报名信息')\">审核报名</ div > " : "")); sb.Append("≌"); } var info = new { PageData = Traditionalized(sb), TotalCount = count }; //var json = new { PageData = sb.ToString(), TotalCount = count };匿名类 context.Response.Write(JavaScriptConvert.SerializeObject(info)); }
protected override void SetPowerZone() { int pid = Convert.ToInt32(Request.QueryString["xxid"]); oid.Value = pid.ToString(); obj = BLL.OObject.GetModel(pid); listExcel = BLL.ObjExcel.GetModelList(" ObjOID='" + obj.ObjOID + "' "); listChild = BLL.ObjChild.GetModelList(" ObjOID='" + obj.ObjOID + "' "); Random rd = new Random(); int cc = rd.Next(1000, 9999); roam.Value = cc.ToString(); roam2.Value = cc.ToString(); rdstr = cc.ToString(); }
public override void ProcessRequest(HttpContext context) { base.ProcessRequest(context); string strWhere = "'1'='1'"; if (!string.IsNullOrEmpty(context.Request["IsState"])) { strWhere += " and SState in(" + HttpUtility.UrlDecode(context.Request["IsState"]) + ")"; } if (!string.IsNullOrEmpty(context.Request["bmoid"])) { strWhere += " and OBJID=" + context.Request["bmoid"] + ""; } //如果是单位部门的话 能管理自己发布的项目 if (!TModel.Role.IsAdmin) { strWhere += " and objID IN(SELECT ID FROM OObject WHERE ReObjMID='" + TModel.MID + "') "; } int count; List <Model.ObjSample> ListO = BLL.ObjSample.GetList(strWhere, pageIndex, pageSize, out count); StringBuilder sb = new StringBuilder(); for (int i = 0; i < ListO.Count; i++) { Model.OObject obj = BLL.OObject.GetModel(ListO[i].ObjID); Model.ObjUser ouser = BLL.ObjUser.GetModel(ListO[i].SpInt); Model.ObjUserApply oapply = BLL.ObjUserApply.GetModelOID(ouser.BaoMingOID); sb.Append(ListO[i].ID + "~"); sb.Append((i + 1) + (pageIndex - 1) * pageSize + "~"); sb.Append(obj.ObjOID + "~"); sb.Append(obj.ObjName + "~"); sb.Append(ouser.DanWeiName + "~"); sb.Append(ListO[i].Spare + "~"); sb.Append("<a href='" + ListO[i].YangPinImgUrl + "' target='_blank'><img width='80' height='80' src='" + ListO[i].YangPinImgUrl + "' /></a>" + "~"); sb.Append(oapply.CreateDate.ToString("yyyy-MM-dd HH:mm") + "~"); sb.Append(ListO[i].SState.ToString().Replace("0", "未寄送").Replace("1", "已寄送,未确认").Replace("2", "损坏,待重新寄送").Replace("3", "寄送完成") + "~"); sb.Append(((ListO[i].SState == 0 || ListO[i].SState == 2) ? "<div class=\"pay btn btn-success\" onclick=\"callhtml('/ProjectManage/SampleJS.aspx?xxid=" + ListO[i].ID + "','样品寄送')\">样品寄送</ div > " : "")); sb.Append("≌"); } var info = new { PageData = Traditionalized(sb), TotalCount = count }; //var json = new { PageData = sb.ToString(), TotalCount = count };匿名类 context.Response.Write(JavaScriptConvert.SerializeObject(info)); }
protected override void SetPowerZone() { int oid = Convert.ToInt32(Request.QueryString["xxid"]); oaid.Value = oid.ToString(); objS = BLL.ObjSample.GetModel(oid); Model.OObject oobject = BLL.OObject.GetModel(objS.ObjID); objU = BLL.ObjUser.GetModelOID(objS.OjbOID); objA = BLL.ObjUserApply.GetModelOID(objU.BaoMingOID); YangPinCode.Value = oobject.ObjOID + "_" + objA.BMInt; listChild = BLL.ObjChild.GetModelList(" ID IN(" + objA.SubID + ") "); BMMember = BLL.Member.GetModelByMID(objA.MID); }
protected override void SetPowerZone() { base.SetPowerZone(); Random rd = new Random(); //int dd=rd.Next(100000,999999); ObjCode.Value = Guid.NewGuid().ToString("N"); xxid.Value = Request.QueryString["xxid"]; Model.OObject objModel = BLL.OObject.GetModel(Convert.ToInt32(Request.QueryString["xxid"])); listChild = BLL.ObjChild.GetModelList(" OBJOID = '" + objModel.ObjOID + "' "); listExcel = BLL.ObjExcel.GetModelList(" OBJOID = '" + objModel.ObjOID + "' "); Remark.Value = objModel.Remark; BMstateDate.Value = objModel.BMDate.ToString(); ComDate.Value = objModel.JGDate.ToString(); ObjName.Value = objModel.ObjName; ObjCode.Value = objModel.ObjOID; txtJSStatus.Value = objModel.SState.ToString(); }
protected override void SetPowerZone() { int pid = Convert.ToInt32(Request.QueryString["xxid"]); OUSER = BLL.ObjUser.GetModel(pid); uid.Value = pid.ToString(); oid.Value = OUSER.ObjID.ToString(); obj = BLL.OObject.GetModel(OUSER.ObjID); Model.ObjUserApply oA = BLL.ObjUserApply.GetModelOID(OUSER.BaoMingOID); listExcel = BLL.ObjExcel.GetModelList(" ObjOID='" + obj.ObjOID + "' "); listChild = BLL.ObjChild.GetModelList(" ID in(" + oA.SubID + ") "); Random rd = new Random(); int cc = rd.Next(1000, 9999); roam.Value = cc.ToString(); rdstr = cc.ToString(); }
protected override string btnAdd_Click() { Model.OObject oamodel = BLL.OObject.GetModel(Convert.ToInt32(Request.Form["oid"])); if (oamodel.OState != 0) { return("此状态不能通过"); } oamodel.OState = 3; oamodel.ObjExcel = ""; oamodel.ObjChild = ""; if (BLL.OObject.Update(oamodel)) { BLL.OperationRecordBLL.Add(TModel.MID, "验证项目通过", "OID为:" + oamodel.ObjOID); return("审核通过"); } else { return("验证项目审核失败"); } }
protected override void SetPowerZone() { int oid = Convert.ToInt32(Request.QueryString["xxid"]); oaid.Value = oid.ToString(); objS = BLL.ObjSample.GetModel(oid); objU = BLL.ObjUser.GetModelOID(objS.OjbOID); objA = BLL.ObjUserApply.GetModelOID(objU.BaoMingOID); listChild = BLL.ObjChild.GetModelList(" ID IN(" + objA.SubID + ") "); BMMember = BLL.Member.GetModelByMID(objA.MID); Model.OObject objO = BLL.OObject.GetModel(objS.ObjID); listExcel = BLL.ObjExcel.GetModelList(" ObjOID='" + objO.ObjOID + "' "); Random rd = new Random(); int cc = rd.Next(1000, 9999); roam.Value = cc.ToString(); rdstr = cc.ToString(); }
protected override void SetPowerZone() { int id = Convert.ToInt32(Request.QueryString["xxid"]); oid.Value = id.ToString(); objuser = BLL.ObjUser.GetModel(id); obj = BLL.OObject.GetModel(objuser.ObjID); if (!string.IsNullOrEmpty(objuser.Spare)) { listDown = objuser.Spare.Split(';').ToList(); //foreach (var item in xx) //{ // if (!string.IsNullOrEmpty(item)) // { // listDown.Add(item); // } //} } }
protected override string btnAdd_Click() { Model.ObjUserApply oua = BLL.ObjUserApply.GetModel(Convert.ToInt32(Request.Form["bmid"])); if (oua.SState != 1) { return("此状态不能修改报名信息"); } Model.OObject obj = BLL.OObject.GetModel(Convert.ToInt32(Request.Form["oid"])); if (obj.BMDate < DateTime.Now) { return("已超出报名时间,不能修改"); } Hashtable MyHs = new Hashtable(); oua.CreateDate = DateTime.Now; oua.ComDate = DateTime.MaxValue; oua.SubID = Request.Form["ChildValue"]; oua.BaoMingImgUrl = Request.Form["uploadurl"]; oua.FeiYongImgUrl = Request.Form["uploadurl2"]; oua.SState = 0; oua.ReSpare = ""; BLL.ObjUserApply.Update(oua, MyHs); Model.ObjUser oumodel = BLL.ObjUser.GetModelBaoMingOID(oua.BaoMingCode); oumodel.BState = 0; BLL.ObjUser.Update(oumodel, MyHs); if (BLL.CommonBase.RunHashtable(MyHs)) { BLL.OperationRecordBLL.Add(TModel.MID, "修改报名信息", "报名编号为:" + oua.BaoMingCode); return("报名修改成功"); } else { return("报名修改失败"); } }
protected override void SetPowerZone() { int pid = Convert.ToInt32(Request.QueryString["xxid"]); OUSER = BLL.ObjUser.GetModel(pid); uid.Value = pid.ToString(); // ObjUser ID oid.Value = OUSER.ObjID.ToString(); //OObject ID obj = BLL.OObject.GetModel(OUSER.ObjID); Model.ObjUserApply oA = BLL.ObjUserApply.GetModelOID(OUSER.BaoMingOID); listExcel = BLL.ObjExcel.GetModelList(" ObjOID='" + obj.ObjOID + "' "); OSU = BLL.ObjSubUser.GetModelList(" MID='" + OUSER.MID + "' AND SpInt=" + obj.ID + " and SState!=3 ").FirstOrDefault(); osuid.Value = OSU.ID.ToString(); FangFa.Value = OSU.RFangFa; YiQi.Value = OSU.RSheBei; YiChang.Value = OSU.RYiChang; string[] sublist = OSU.Spare.Split(','); string substr = ""; foreach (var item in sublist) { if (string.IsNullOrEmpty(item)) { continue; } substr += "'" + item + "',"; } listChild = BLL.ObjSub.GetModelList(" OID in(" + substr.Substring(0, substr.Length - 1) + ") "); Random rd = new Random(); int cc = rd.Next(1000, 9999); rdstr = cc.ToString(); }
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("提交失败"); } }
protected override string btnAdd_Click() { Hashtable HS = new Hashtable(); Model.OObject obj = new Model.OObject(); obj.ObjName = Request.Form["ObjName"]; obj.ObjOID = Request.Form["ObjCode"]; obj.ReObjMID = TModel.MID; obj.SState = 0; obj.ObjChild = ""; obj.ObjExcel = ""; obj.CreateDate = DateTime.Now; obj.ReObjNiName = TModel.MName; obj.Remark = Request.Form["Remark"]; obj.BMDate = Convert.ToDateTime(Request.Form["BMstateDate"]); obj.JGDate = Convert.ToDateTime(Request.Form["ComDate"]); BLL.OObject.Add(obj, HS); int subcount = Convert.ToInt32(Request.Form["SubAddIndex"]); int count = 0; for (int i = 1; i <= subcount; i++) { int ix = i; if (string.IsNullOrEmpty(Request.Form["SubTitle" + i])) { continue; } else { count += 1; Model.ObjChild sub = new Model.ObjChild(); sub.OID = Guid.NewGuid().ToString("N"); sub.ObjOID = obj.ObjOID; sub.ChildName = Request.Form["SubTitle" + i]; sub.ChildValue = Request.Form["SubDetails" + i]; BLL.ObjChild.Add(sub, HS); } } if (count <= 0) { return("请至少填写一项检测子项"); } if (string.IsNullOrEmpty(Request.Form["excelValue"])) { return("请上传文档"); } string[] xx = Request.Form["excelValue"].Split(';'); foreach (var item in xx) { if (string.IsNullOrEmpty(item)) { continue; } Model.ObjExcel excel = new Model.ObjExcel(); excel.OID = Guid.NewGuid().ToString("N"); excel.ObjOID = obj.ObjOID; excel.ExcelName = item.Substring(33, item.Length - 33); excel.ExcelUrl = item; BLL.ObjExcel.Add(excel, HS); } if (BLL.CommonBase.RunHashtable(HS)) { BLL.OperationRecordBLL.Add(TModel.MID, "添加项目", "OID为:" + obj.ObjOID); return("添加项目成功"); } else { return("添加项目失败"); } }
protected override string btnAdd_Click() { if (!TModel.MState) { return("您的账号未审核,不能报名"); } Model.OObject obj = BLL.OObject.GetModel(Convert.ToInt32(Request.Form["oid"])); if (Convert.ToInt32(BLL.CommonBase.GetSingle("select COUNT(*) from ObjUserApply where MID='" + TModel.MID + "' and [OBJID]=" + obj.ID + " and YZState=0;")) > 0) { return("您已报名该项目,请自行查看进度"); } if (obj.SState == 1) { return("该项目已结束,不能报名"); } if (obj.BMDate < DateTime.Now) { return("已超出报名时间,不能报名"); } Hashtable MyHs = new Hashtable(); Model.ObjUserApply oua = new Model.ObjUserApply(); oua.ObjID = obj.ID; oua.MID = TModel.MID; oua.BaoMingCode = Guid.NewGuid().ToString("N"); oua.DanWeiName = TModel.MName; oua.ZiGeZhengShu = TModel.FMID.Replace("0", "检测机构证书").Replace("1", "个人身份证").Replace("2", "其他"); oua.ZhengShuCode = TModel.NumID; oua.CreateDate = DateTime.Now; oua.ComDate = DateTime.MaxValue; oua.SubID = Request.Form["ChildValue"]; oua.BaoMingImgUrl = Request.Form["uploadurl"]; oua.FeiYongImgUrl = Request.Form["uploadurl2"]; oua.SState = 0; BLL.ObjUserApply.Add(oua, MyHs); Model.ObjUser user = new Model.ObjUser(); user.OID = Guid.NewGuid().ToString("N"); user.BaoMingOID = oua.BaoMingCode; user.ObjID = obj.ID; user.ObjName = obj.ObjName; user.USState = 0; user.CreateDate = DateTime.Now; user.DanWeiName = TModel.MName; user.RState = 0; user.BState = 0; user.YState = 0; user.YangPinOID = ""; user.MID = TModel.MID; BLL.ObjUser.Add(user, MyHs); if (BLL.CommonBase.RunHashtable(MyHs)) { BLL.OperationRecordBLL.Add(TModel.MID, "报名成功", "项目名称为:" + obj.ObjName + ",报名编号为:" + oua.BaoMingCode); return("报名成功"); } else { return("报名失败"); } }
protected void Page_Load(object sender, EventArgs e) { obj = BLL.OObject.GetModel(Convert.ToInt32(Request.QueryString["oid"])); listChild = BLL.ObjChild.GetModelList(" OBJOID = '" + obj.ObjOID + "' "); listExcel = BLL.ObjExcel.GetModelList(" OBJOID = '" + obj.ObjOID + "' "); }
public override void ProcessRequest(HttpContext context) { base.ProcessRequest(context); string strWhere = "'1'='1' "; if (!string.IsNullOrEmpty(context.Request["nBMTitle"])) { strWhere += " and DanWeiName like '%" + HttpUtility.UrlDecode(context.Request["nBMTitle"]) + "%'"; } if (!string.IsNullOrEmpty(context.Request["nTitle"])) { strWhere += " and ObjName like '%" + HttpUtility.UrlDecode(context.Request["nTitle"]) + "%'"; } if (!string.IsNullOrEmpty(context.Request["IsBMState"])) { strWhere += " and BState in(" + HttpUtility.UrlDecode(context.Request["IsBMState"]) + ")"; } if (!string.IsNullOrEmpty(context.Request["IsYangPin"])) { strWhere += " and YState in(" + HttpUtility.UrlDecode(context.Request["IsYangPin"]) + ")"; } if (!string.IsNullOrEmpty(context.Request["IsRState"])) { strWhere += " and RState in(" + HttpUtility.UrlDecode(context.Request["IsRState"]) + ")"; } if (!string.IsNullOrEmpty(context.Request["bmoid"])) { strWhere += " and OBJID=" + context.Request["bmoid"] + ""; } if (!string.IsNullOrEmpty(context.Request["mid"])) { strWhere += " and MID='" + context.Request["mid"] + "'"; } if (!string.IsNullOrEmpty(context.Request["nBMDW"])) { strWhere += " and MID='" + context.Request["nBMDW"] + "'"; } //如果是单位部门的话 能管理自己发布的项目 if (!TModel.Role.IsAdmin) { strWhere += " and objID IN(SELECT ID FROM OObject WHERE ReObjMID='" + TModel.MID + "') "; } if (!string.IsNullOrEmpty(context.Request["IsSState"])) { strWhere += " and objID IN(SELECT ID FROM OObject WHERE SState='" + context.Request["IsSState"] + "') "; } int count; List <Model.ObjUser> ListO = BLL.ObjUser.GetList(strWhere, pageIndex, pageSize, out count); StringBuilder sb = new StringBuilder(); for (int i = 0; i < ListO.Count; i++) { Model.OObject obj = BLL.OObject.GetModel(ListO[i].ObjID); //Model.ObjSubUser objsub = BLL.ObjSubUser.GetModelList(" SpInt=" + obj.ID + " and MID='" + TModel.MID + "' ").FirstOrDefault(); sb.Append(ListO[i].ID + "~"); sb.Append((i + 1) + (pageIndex - 1) * pageSize + "~"); sb.Append(ListO[i].DanWeiName + "~"); sb.Append(ListO[i].MID + "~"); sb.Append(ListO[i].ObjName + "~"); sb.Append(obj.JGDate + "~"); //sb.Append((objsub != null ? objsub.ResultOne : "") + "~"); //sb.Append((objsub != null ? objsub.ResultTwo : "") + "~"); //sb.Append((objsub != null ? objsub.ResultAvg : "") + "~"); sb.Append((ListO[i].BState.ToString().Replace("0", "未审核").Replace("1", "打回").Replace("3", "<span style='color:green;'>已审核</span>")) + "~"); sb.Append((ListO[i].YState.ToString().Replace("0", "未寄送").Replace("1", "已寄送").Replace("2", "样品损坏").Replace("3", "<span style='color:green;'>样品确认</span>")) + "~"); sb.Append((ListO[i].YState.ToString() == "3" ? "<span style='color:green;'>样品已确认</span>" : "未确认") + "~"); string isSubResult = ""; if (ListO[i].RState == 1) { isSubResult = "<div class=\"pay btn btn-success\" onclick=\"callhtml('/ProjectManage/SHValidationResult.aspx?xxid=" + ListO[i].ID + "','审核结果')\">审核结果</div>"; } sb.Append((ListO[i].RState.ToString().Replace("0", "等待提交").Replace("1", "等待审核").Replace("2", "审核失败").Replace("3", "<span style='color:green;'>审核通过</span>") + isSubResult) + "~"); sb.Append((ListO[i].USState.ToString().Replace("0", "待审核").Replace("2", "打回").Replace("3", "审核通过")) + "~"); sb.Append((string.IsNullOrEmpty(ListO[i].Spare)? "<div class=\"pay btn btn-success\" onclick=\"callhtml('/ProjectManage/AddResultDown.aspx?xxid=" + ListO[i].ID + "','上传报告')\">上传报告</div>" : "<div class=\"pay btn btn-success\" onclick=\"callhtml('/ProjectManage/AddResultDown.aspx?xxid=" + ListO[i].ID + "','报告下载')\">报告下载</div>") + "~"); int shcount = Convert.ToInt32(BLL.CommonBase.GetSingle("select COUNT(*) from ObjSub where MID='" + ListO[i].MID + "' and [objid]=" + ListO[i].ObjID + " and URID=" + ListO[i].ID + " and (SHInt=0 or SHInt=2)")); if (shcount <= 0) { sb.Append((ListO[i].USState == 3 ? "<span style='color:green;'><a href='javascript:void(0)' style='color:green;' onclick=\"callhtml('/ProjectManage/PutZhengShu.aspx?xxid=" + ListO[i].ID + "','打印证书')\" >打印证书</a></span>" : "未通过") + "~"); } else { sb.Append("未通过~"); } sb.Append("<div class=\"pay btn btn-success\" onclick=\"callhtml('/ProjectManage/ObjectView.aspx?xxid=" + ListO[i].ID + "','流程')\">流程</div>"); sb.Append("≌"); } var info = new { PageData = Traditionalized(sb), TotalCount = count }; //var json = new { PageData = sb.ToString(), TotalCount = count };匿名类 context.Response.Write(JavaScriptConvert.SerializeObject(info)); }
public override void ProcessRequest(HttpContext context) { base.ProcessRequest(context); string strWhere = "'1'='1' and MID='" + TModel.MID + "' "; if (!string.IsNullOrEmpty(context.Request["nTitle"])) { strWhere += " and ObjName like '%" + HttpUtility.UrlDecode(context.Request["nTitle"]) + "%'"; } if (!string.IsNullOrEmpty(context.Request["IsBMState"])) { strWhere += " and BState in(" + HttpUtility.UrlDecode(context.Request["IsBMState"]) + ")"; } if (!string.IsNullOrEmpty(context.Request["IsYangPin"])) { strWhere += " and YState in(" + HttpUtility.UrlDecode(context.Request["IsYangPin"]) + ")"; } if (!string.IsNullOrEmpty(context.Request["IsRState"])) { strWhere += " and RState in(" + HttpUtility.UrlDecode(context.Request["IsRState"]) + ")"; } int count; List <Model.ObjUser> ListO = BLL.ObjUser.GetList(strWhere, pageIndex, pageSize, out count); StringBuilder sb = new StringBuilder(); for (int i = 0; i < ListO.Count; i++) { Model.OObject obj = BLL.OObject.GetModel(ListO[i].ObjID); sb.Append(ListO[i].ID + "~"); sb.Append((i + 1) + (pageIndex - 1) * pageSize + "~"); sb.Append(ListO[i].DanWeiName + "~"); sb.Append(ListO[i].ObjName + "~"); sb.Append(obj.JGDate + "~"); //sb.Append((objsub!=null?objsub.ResultOne:"") + "~"); //sb.Append((objsub != null ? objsub.ResultTwo : "") + "~"); //sb.Append((objsub != null ? objsub.ResultAvg : "") + "~"); sb.Append((ListO[i].BState == 0?"待审核": "<span style='color:green;'>已通过</span>") + "~"); sb.Append((ListO[i].YState.ToString().Replace("0", "未寄送").Replace("1", "已寄送").Replace("2", "样品损坏").Replace("3", "<span style='color:green;'>样品确认</span>")) + "~"); sb.Append((ListO[i].YState.ToString() == "3"? "<span style='color:green;'>样品已确认</span>" : "未确认") + "~"); string isSubResult = ""; if (ListO[i].YState == 3 && ListO[i].RState == 0) { isSubResult = "<div class=\"pay btn btn-success\" onclick=\"callhtml('/ProjectManage/ValidationResult.aspx?xxid=" + ListO[i].ID + "','提交结果')\">提交结果</div>"; } sb.Append((ListO[i].RState.ToString().Replace("0", "等待提交").Replace("1", "等待审核").Replace("2", "审核失败").Replace("3", "<span style='color:green;'>审核通过</span>") + isSubResult) + "~"); sb.Append((ListO[i].RState == 3? "<div class=\"pay btn btn-success\" onclick=\"callhtml('/ProjectManage/AddResultDown.aspx?xxid=" + ListO[i].ID + "','报告下载')\">报告下载</div>" : "") + "~"); sb.Append((ListO[i].USState == 0 ? "待审核" : "<span style='color:green;'>已通过</span>") + "~"); sb.Append((ListO[i].USState == 3 ? "<span style='color:green;'><a href='javascript:void(0)' style='color:green;' onclick=\"callhtml('/ProjectManage/PutZhengShu.aspx?xxid=" + ListO[i].ID + "','打印证书')\" >打印证书</a></span>" : "未通过") + "~"); sb.Append("<div class=\"pay btn btn-success\" onclick=\"callhtml('/ProjectManage/ObjectView.aspx?xxid=" + ListO[i].ID + "','流程')\">流程</div>"); sb.Append("≌"); } var info = new { PageData = Traditionalized(sb), TotalCount = count }; //var json = new { PageData = sb.ToString(), TotalCount = count };匿名类 context.Response.Write(JavaScriptConvert.SerializeObject(info)); }
public override void ProcessRequest(HttpContext context) { base.ProcessRequest(context); string strWhere = "'1'='1' "; //if (!string.IsNullOrEmpty(context.Request["nBMTitle"])) //{ // strWhere += " and DanWeiName like '%" + HttpUtility.UrlDecode(context.Request["nBMTitle"]) + "%'"; //} if (!string.IsNullOrEmpty(context.Request["HYmid"])) { strWhere += " and MID like '%" + context.Request["HYmid"] + "%'"; } //if (!string.IsNullOrEmpty(context.Request["IsBMState"])) //{ // strWhere += " and BState in(" + HttpUtility.UrlDecode(context.Request["IsBMState"]) + ")"; //} //if (!string.IsNullOrEmpty(context.Request["IsYangPin"])) //{ // strWhere += " and YState in(" + HttpUtility.UrlDecode(context.Request["IsYangPin"]) + ")"; //} if (!string.IsNullOrEmpty(context.Request["SHState"])) { strWhere += " and SHInt =" + context.Request["SHState"] + " "; } if (!string.IsNullOrEmpty(context.Request["ObjCode"])) { strWhere += " and objOID = '" + context.Request["ObjCode"].Trim() + "' "; } if (!string.IsNullOrEmpty(context.Request["Grouping"])) { strWhere += " and Grouping = '" + context.Request["Grouping"].Trim() + "' "; } if (!string.IsNullOrEmpty(context.Request["ObjName"])) { strWhere += " and objID IN(SELECT ID FROM OObject WHERE ObjName like '%" + context.Request["ObjName"].Trim() + "%') "; } if (!string.IsNullOrEmpty(context.Request["ObjReMID"])) { strWhere += " and objID IN(SELECT ID FROM OObject WHERE ReObjMID = '" + context.Request["ObjReMID"].Trim() + "') "; } if (!string.IsNullOrEmpty(context.Request["JGWhere"]) && !string.IsNullOrEmpty(context.Request["JGType"]) && !string.IsNullOrEmpty(context.Request["JGValue"])) { strWhere += " and " + context.Request["JGWhere"] + context.Request["JGType"] + context.Request["JGValue"] + " "; } //如果是单位部门的话 能管理自己发布的项目 if (!TModel.Role.IsAdmin) { strWhere += " and objID IN(SELECT ID FROM OObject WHERE ReObjMID='" + TModel.MID + "') "; } if (!string.IsNullOrEmpty(context.Request["IsSState"])) { strWhere += " and objID IN(SELECT ID FROM OObject WHERE SState='" + context.Request["IsSState"] + "') "; } int count; List <Model.ObjSub> ListO = BLL.ObjSub.GetList(strWhere, pageIndex, pageSize, out count); StringBuilder sb = new StringBuilder(); for (int i = 0; i < ListO.Count; i++) { Model.OObject obj = BLL.OObject.GetModel(ListO[i].ObjID); Model.ObjUserApply oua = BLL.ObjUserApply.GetModel(ListO[i].SpInt); Model.ObjUser ou = BLL.ObjUser.GetModel(ListO[i].URID); //Model.ObjSubUser objsub = BLL.ObjSubUser.GetModelList(" SpInt=" + obj.ID + " and MID='" + TModel.MID + "' ").FirstOrDefault(); sb.Append(ListO[i].ID + "~"); sb.Append((i + 1) + (pageIndex - 1) * pageSize + "~"); sb.Append(obj.ObjOID + "~"); sb.Append(obj.ObjName + "~"); sb.Append(oua.DanWeiName + "~"); sb.Append(oua.CreateDate + "~"); sb.Append(ListO[i].Spare + "~"); sb.Append((ou.USState.ToString().Replace("0", "待审核").Replace("2", "打回").Replace("3", "审核通过")) + "~"); sb.Append((ListO[i].ResultOne) + "~"); sb.Append((ListO[i].ResultTwo) + "~"); sb.Append((ListO[i].ResultAvg) + "~"); sb.Append((ListO[i].Serial) + "~"); sb.Append((ListO[i].Grouping) + "~"); sb.Append((ListO[i].ZB) + "~"); sb.Append((ListO[i].Q1) + "~"); sb.Append((ListO[i].Q2) + "~"); sb.Append((ListO[i].IRQ) + "~"); sb.Append((ListO[i].M) + "~"); sb.Append((ListO[i].NIRQ) + "~"); sb.Append((ListO[i].ResultStatus) + "~"); sb.Append((ListO[i].SHInt.ToString().Replace("0", "待审核").Replace("2", "不合格").Replace("1", "合格")) + "~"); if (ListO[i].SHInt == 0) { sb.Append("<div class=\"pay btn btn-success\" onclick=\"SHChange('" + ListO[i].ID + "')\">合格</div>"); sb.Append("<div class=\"pay btn btn-warning\" onclick=\"DHChange('" + ListO[i].ID + "')\">不合格</div>"); } sb.Append("<div class=\"pay btn btn-warning\" onclick=\"subModify('" + ListO[i].ID + "')\">修改</div>"); sb.Append("≌"); } var info = new { PageData = Traditionalized(sb), TotalCount = count }; //var json = new { PageData = sb.ToString(), TotalCount = count };匿名类 context.Response.Write(JavaScriptConvert.SerializeObject(info)); }