protected void Page_Load(object sender, EventArgs e) { int ZhuangXiuID = 0; int.TryParse(Request.QueryString["ID"], out ZhuangXiuID); var zhuangxiu = Foresight.DataAccess.ZhuangXiu.GetZhuangXiu(ZhuangXiuID); if (zhuangxiu != null) { var list = Foresight.DataAccess.ZhuangXiu_XunJian.GetZhuangXiu_XunJianList(zhuangxiu.ID); string op = Request.QueryString["op"]; if (op.Equals("normal")) { list = list.Where(p => p.XunJianStatus.Equals("ZhengChang")).ToArray(); } else if (op.Equals("weigui")) { list = list.Where(p => p.XunJianStatus.Equals("WeiGui")).ToArray(); } else { list = new Foresight.DataAccess.ZhuangXiu_XunJian[] { }; } if (list.Length > 0) { this.rptXunJian.Visible = true; this.rptXunJian.DataSource = list; this.rptXunJian.DataBind(); this.panContent.Visible = false; } else { this.rptXunJian.Visible = false; this.panContent.Visible = true; } } else { Response.Write("ID不合法"); Response.End(); } }
private void savexunjian(HttpContext context) { Foresight.DataAccess.ZhuangXiu zhuangxiu = null; int ID = 0; int.TryParse(context.Request.Params["ID"], out ID); if (ID > 0) { zhuangxiu = Foresight.DataAccess.ZhuangXiu.GetZhuangXiu(ID); } var xunjian = new Foresight.DataAccess.ZhuangXiu_XunJian(); xunjian.AddMan = context.Request.Params["AddMan"]; xunjian.AddTime = DateTime.Now; xunjian.ZhuangXiuID = zhuangxiu.ID; xunjian.XunJianTime = getTimeValue(context, "tdXunJianTime"); xunjian.XunJianMan = getValue(context, "tdXunJianMan"); xunjian.XunJianStatus = getValue(context, "XunJianStatus"); if (xunjian.XunJianStatus.Equals("WeiGui")) { string WeiGuiRuleIDs = context.Request["WeiGuiRuleIDs"]; List <int> WeiGuiRuleIDList = new List <int>(); if (!string.IsNullOrEmpty(WeiGuiRuleIDs)) { WeiGuiRuleIDList = JsonConvert.DeserializeObject <List <int> >(WeiGuiRuleIDs); } if (WeiGuiRuleIDList.Count > 0) { var weigui_list = Foresight.DataAccess.ZhuangXiu_Rule.GetZhuangXiu_RuleList(WeiGuiRuleIDList); xunjian.WeiGuiProject = string.Join(",", weigui_list.Select(p => p.RuleName).ToArray()); xunjian.WeiGuiRuleID = WeiGuiRuleIDs; } xunjian.WeiGuiCost = getDecimalValue(context, "tdWeiGuiCost"); } else { xunjian.WeiGuiCost = 0; } xunjian.Remark = getValue(context, "tdRemark"); List <Foresight.DataAccess.ZhuangXiu_File> attachlist = new List <Foresight.DataAccess.ZhuangXiu_File>(); HttpFileCollection uploadFiles = context.Request.Files; for (int i = 0; i < uploadFiles.Count; i++) { HttpPostedFile postedFile = uploadFiles[i]; string fileOriName = postedFile.FileName; if (fileOriName != "" && fileOriName != null) { string extension = System.IO.Path.GetExtension(fileOriName).ToLower(); string fileName = DateTime.Now.ToFileTime().ToString() + extension; string filepath = "/upload/ZhuangXiu/"; string rootPath = HttpContext.Current.Server.MapPath("~" + filepath); if (!System.IO.Directory.Exists(rootPath)) { System.IO.Directory.CreateDirectory(rootPath); } string Path = rootPath + fileName; postedFile.SaveAs(Path); Foresight.DataAccess.ZhuangXiu_File attach = new Foresight.DataAccess.ZhuangXiu_File(); attach.FileOriName = fileOriName; attach.AttachedFilePath = filepath + fileName; attach.AddTime = DateTime.Now; attach.FileType = Utility.EnumModel.ZhuangXiuFileType.addxunjian.ToString(); attachlist.Add(attach); } } using (SqlHelper helper = new SqlHelper()) { try { helper.BeginTransaction(); xunjian.Save(helper); foreach (var item in attachlist) { item.RelateID = xunjian.ID; item.Save(helper); } helper.Commit(); context.Response.Write("{\"status\":true,\"ID\":" + xunjian.ID + "}"); } catch (Exception ex) { Utility.LogHelper.WriteError(LogModule, "命令: savexunjian", ex); helper.Rollback(); context.Response.Write("{\"status\":false}"); return; } } }