public async Task <IActionResult> Edit(int id, [Bind("MainPlanId,SelectionСommitteeId,UserId,DateTime")] MainPlan mainPlan) { if (id != mainPlan.MainPlanId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(mainPlan); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!MainPlanExists(mainPlan.MainPlanId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["SelectionСommitteeId"] = new SelectList(_context.SelectionСommitties, "SelectionСommitteeId", "Name", mainPlan.SelectionСommitteeId); ViewData["UserId"] = new SelectList(_context.Users, "Id", "Id", mainPlan.UserId); return(View(mainPlan)); }
public bool UpdateResult(string wkpid, MainPlan model) { StringBuilder builder = new StringBuilder(); builder.AppendFormat("update pm_workplan_weekplan set WkpDeptId='" + model.WkpDeptId + "',WkpRegisterUser='******',WkpReportUser='******',WkpCheckerUser='******',", new object[0]); builder.AppendFormat(string.Concat(new object[] { "WkpReportType=", model.WkpReportType, ",WkpRecordDate='", model.WkpRecordDate, "',WkpIstrue=", model.WkpIstrue, ",WkpIsReport=", model.WkpIsReport }), new object[0]); builder.AppendFormat(" where WkpId='" + wkpid + "'", new object[0]); return(publicDbOpClass.NonQuerySqlString(builder.ToString())); }
public static string GetUpdateStr(string wkpid, MainPlan model) { StringBuilder builder = new StringBuilder(); builder.AppendFormat("update pm_workplan_weekplan set WkpDeptId='" + model.WkpDeptId + "',WkpRegisterUser='******',WkpReportUser='******',WkpCheckerUser='******',", new object[0]); builder.AppendFormat(string.Concat(new object[] { "WkpReportType=", model.WkpReportType, ",WkpRecordDate='", model.WkpRecordDate, "',WkpIstrue=", model.WkpIstrue, ",WkpIsReport=", model.WkpIsReport, ",InputTime='", model.InputTime, "'" }), new object[0]); builder.AppendFormat(" where WkpId='" + wkpid + "'", new object[0]); return(builder.ToString()); }
public bool InsertIntoBase(MainPlan model) { StringBuilder builder = new StringBuilder(); builder.AppendFormat("insert into Pm_WorkPlan_WeekPlan (", new object[0]); builder.AppendFormat("WkpId,Wkpusercode,wkpdeptid,wkprecorddate,wkpreportuser,wkpcheckeruser,wkpisreport,wkpreporttype,wkpistrue,wkpregisteruser,InputTime) values ('", new object[0]); builder.AppendFormat(string.Concat(new object[] { model.WkpId, "','", model.WkpUserCode, "','", model.WkpDeptId, "','", model.WkpRecordDate, "','", model.WkpReportUser, "','" }), new object[0]); builder.AppendFormat(string.Concat(new object[] { model.WkpCheckerUser, "',", model.WkpIsReport, ",", model.WkpReportType, ",", model.WkpIstrue, ",'", model.WkpRegisterUser, "','", model.InputTime, "')" }), new object[0]); return(publicDbOpClass.ExecSqlString(builder.ToString()) > 0); }
public static string GetInsertStr(MainPlan model) { StringBuilder builder = new StringBuilder(); builder.AppendFormat("insert into Pm_WorkPlan_WeekPlan (", new object[0]); builder.AppendFormat("WkpId,Wkpusercode,wkpdeptid,wkprecorddate,wkpreportuser,wkpcheckeruser,wkpisreport,wkpreporttype,wkpistrue,wkpregisteruser) values ('", new object[0]); builder.AppendFormat(string.Concat(new object[] { model.WkpId, "','", model.WkpUserCode, "','", model.WkpDeptId, "','", model.WkpRecordDate, "','", model.WkpReportUser, "','" }), new object[0]); builder.AppendFormat(string.Concat(new object[] { model.WkpCheckerUser, "',", model.WkpIsReport, ",", model.WkpReportType, ",", model.WkpIstrue, ",'", model.WkpRegisterUser, "')" }), new object[0]); return(builder.ToString()); }
public async Task <IActionResult> Create([Bind("MainPlanId,SelectionСommitteeId,UserId,DateTime")] MainPlan mainPlan) { if (ModelState.IsValid) { _context.Add(mainPlan); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["SelectionСommitteeId"] = new SelectList(_context.SelectionСommitties, "SelectionСommitteeId", "Name", mainPlan.SelectionСommitteeId); ViewData["UserId"] = new SelectList(_context.Users, "Id", "Id", mainPlan.UserId); return(View(mainPlan)); }
public async Task <IActionResult> AddOrEdit(int id, [Bind("MainPlanId,SelectionСommitteeId,UserId,DateTime")] MainPlan model) { if (ModelState.IsValid) { if (id == 0) { var user = await _userManager.FindByNameAsync(User.Identity.Name); if (user == null) { return(NotFound("Пользователь не найден")); } await _context.MainPlans.AddAsync(model); await _context.SaveChangesAsync(); } else { try { _context.MainPlans.Update(model); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!MainPlanExists(model.MainPlanId)) { return(NotFound()); } else { throw; } } } return(RedirectToAction("Index", "Home")); } //ViewData["GroupId"] = new SelectList(_context.Groups.OrderBy(i => i.GroupName), "GroupId", "GroupName"); //ViewData["TypeOfSpravkaId"] = new SelectList(_context.TypeOfSpravkas, "TypeOfSpravkaId", "TypeOfSpravkaName"); ViewData["SelectionСommitteeId"] = new SelectList(_context.SelectionСommitties, "SelectionСommitteeId", "Name", model.SelectionСommitteeId); ViewData["UserId"] = new SelectList(_context.Users, "Id", "UserName", model.UserId); return(View(model)); }
protected string GetNames(MainPlan mplan) { if (mplan.WkpCheckerUser != "") { string[] array = mplan.WkpCheckerUser.Split(new char[] { ',' }); string text = ""; for (int i = 0; i < array.Length - 1; i++) { if (array[i] != "") { text = text + new MainPlanAndAction().BackUserName(array[i]) + ","; } } return(text); } return(""); }
public async Task <IActionResult> AddOrEdit() { var user = await _userManager.Users.Include(i => i.Anketa).ThenInclude(i => i.Specialty).ThenInclude(i => i.Specialization).Include(i => i.MainPlans).FirstOrDefaultAsync(i => i.UserName == User.Identity.Name); if (user?.Anketa == null) { return(Content("Пожалуйста заполните анкету абитуриента")); } if (user?.MainPlans?.OrderByDescending(i => i.MainPlanId).FirstOrDefault() == null) { ViewData["SelectionСommitteeId"] = new SelectList(_context.SelectionСommitties, "SelectionСommitteeId", "Name"); MainPlan mainPlan = new MainPlan(); if (user?.Anketa != null) { mainPlan.UserId = user.Id; mainPlan.User = user; } var selectionСommittee = await _context.SelectionСommitties.OrderByDescending(i => i.SelectionСommitteeId).FirstOrDefaultAsync(); if (selectionСommittee == null) { return(NotFound("Комиссия не найдена")); } mainPlan.SelectionСommitteeId = selectionСommittee.SelectionСommitteeId; mainPlan.GetSelectionСommittee = selectionСommittee; return(View(mainPlan)); } else { var mainplanid = user.MainPlans.OrderByDescending(i => i.MainPlanId).FirstOrDefault().MainPlanId; MainPlan mainPlan = _context.MainPlans.Include(i => i.User).Include(i => i.GetSelectionСommittee).FirstOrDefault(i => i.MainPlanId == mainplanid); if (mainPlan == null) { return(NotFound("План приема не найден")); } return(View(mainPlan)); } }
public MainPlan GetModel(string WkpUserCode) { DataTable table = this.GetTable(WkpUserCode); MainPlan plan = new MainPlan(); if (table.Rows.Count > 0) { plan.WkpRegisterUser = table.Rows[0]["WkpRegisterUser"].ToString(); plan.WkpId = (Guid)table.Rows[0]["WkpId"]; plan.WkpUserCode = table.Rows[0]["WkpUserCode"].ToString(); plan.WkpDeptId = table.Rows[0]["WkpDeptId"].ToString(); plan.WkpReportUser = table.Rows[0]["WkpReportUser"].ToString(); plan.WkpReportType = Convert.ToInt32(table.Rows[0]["WkpReportType"]); plan.WkpRecordDate = DateTime.Parse(table.Rows[0]["WkpRecordDate"].ToString()); plan.WkpIstrue = Convert.ToInt32(table.Rows[0]["WkpIstrue"]); plan.WkpIsReport = Convert.ToInt32(table.Rows[0]["WkpIsReport"]); plan.WkpCheckerUser = table.Rows[0]["WkpCheckerUser"].ToString(); return(plan); } return(null); }
protected void btnSave_Click(object sender, EventArgs e) { bool flag = false; if (base.Request.QueryString["Action"] == "Add") { string sqlString = string.Concat(new string[] { "select 1 from pm_workplan_weekplan where wkpreporttype=", base.Request.QueryString["planType"].ToString(), " and WkpUserCode='", this.txtWPcode.Text, "'and wkpreportuser='******'" }); DataTable dataTable = publicDbOpClass.DataTableQuary(sqlString); if (dataTable.Rows.Count > 0) { base.RegisterScript("top.ui.alert('该单号已经被使用!请更换填写!')"); return; } MainPlan mainPlan = new MainPlan(); mainPlan.WkpId = Guid.NewGuid(); mainPlan.WkpDeptId = ((this.thisDeptId.Value == "") ? MainPlanAndAction.BackDeptOrID(base.UserCode)[0] : this.thisDeptId.Value); mainPlan.WkpIsReport = 0; mainPlan.WkpIstrue = 0; mainPlan.WkpRecordDate = Convert.ToDateTime(this.txtWPlanDate.Text.Trim()); mainPlan.WkpRegisterUser = base.UserCode; mainPlan.WkpReportType = int.Parse(base.Request.QueryString["planType"]); mainPlan.WkpReportUser = ((this.hdnReportUser.Value == "") ? base.UserCode : this.hdnReportUser.Value); mainPlan.WkpUserCode = this.txtWPcode.Text.Trim(); mainPlan.WkpIstrue = -1; mainPlan.InputTime = DateTime.Now; bool flag2 = new MainPlanAndAction().InsertIntoBase(mainPlan); string text = "insert into pm_workplan_plansummary (wkppsid,wkpid,wkpremarks,wkpsummary,wkpselfscore,wkpsummarydate)"; object obj = text; text = string.Concat(new object[] { obj, " values ('", Guid.NewGuid(), "','", mainPlan.WkpId, "','", PlanDetailAction.EncodeStr(this.txtProduce.Text.Trim()), "','',NULL,'", DateTime.Now.Date, "')" }); publicDbOpClass.ExecSqlString(text); PlanDetail planDetail = new PlanDetail(); if (this.txtDuty.Text.Trim().Length > 10) { planDetail.WkpChief = this.txtDuty.Text.Trim().Substring(0, 10); } else { planDetail.WkpChief = this.txtDuty.Text.Trim(); } planDetail.WkpContents = PlanDetailAction.EncodeStr(this.txtContent.Text); planDetail.WkpDetailsId = Guid.NewGuid(); planDetail.WkpEndTime = DateTime.Parse(this.EndDate.Text + " 0:00:00"); planDetail.WkpId = mainPlan.WkpId; if (this.txtResponsibility.Text.Trim().Length > 10) { planDetail.WkpPersons = this.txtResponsibility.Text.Trim().Substring(0, 10); } else { planDetail.WkpPersons = this.txtResponsibility.Text.Trim(); } planDetail.WkpStartTime = DateTime.Parse(this.BeginDate.Text + " 0:00:00"); bool flag3 = new PlanDetailAction().AddModelIntoBaseData(planDetail); string value = this.hdnNums.Value; if (value != "") { string[] array = value.Split(new char[] { '?' }); int num = array.Length; for (int i = 0; i < num - 1; i++) { string str = array[i].Substring(2).ToString(); PlanDetail planDetail2 = new PlanDetail(); planDetail2.WkpDetailsId = Guid.NewGuid(); planDetail2.WkpEndTime = DateTime.Parse(base.Request.Form["endedDate" + str] + " 0:00:00"); planDetail2.WkpContents = PlanDetailAction.EncodeStr(base.Request.Form["txtConten" + str]); planDetail2.WkpId = mainPlan.WkpId; if (base.Request.Form["txtPerson" + str].Length > 10) { planDetail2.WkpPersons = base.Request.Form["txtPerson" + str].Substring(0, 10); } else { planDetail2.WkpPersons = base.Request.Form["txtPerson" + str]; } planDetail2.WkpStartTime = DateTime.Parse(base.Request.Form["beginDate" + str] + " 0:00:00"); if (base.Request.Form["txtCheify" + str].Length > 10) { planDetail2.WkpChief = base.Request.Form["txtCheify" + str].Substring(0, 10); } else { planDetail2.WkpChief = base.Request.Form["txtCheify" + str]; } flag = new PlanDetailAction().AddModelIntoBaseData(planDetail2); } if (flag2 && flag3 && flag) { base.RegisterScript("top.ui.tabSuccess({ parentName: '_WorkPlanMange'})"); } } else { base.RegisterScript("top.ui.tabSuccess({ parentName: '_WorkPlanMange'})"); } } if (base.Request.QueryString["Action"] == "Edit") { string sqlString2 = string.Concat(new string[] { "update pm_workplan_plansummary set wkpremarks='", PlanDetailAction.EncodeStr(this.txtProduce.Text.Trim()), "' where wkpid='", base.Request.QueryString["wkpid"], "'" }); publicDbOpClass.NonQuerySqlString(sqlString2); MainPlan model = new MainPlanAndAction().GetModel(new Guid(base.Request.QueryString["wkpId"])); model.WkpDeptId = ((this.thisDeptId.Value == "") ? new MainPlanAndAction().BackDeptAndID(this.txtReportUser.Text)[0] : this.thisDeptId.Value); model.WkpReportType = int.Parse(base.Request.QueryString["planType"]); model.WkpReportUser = ((this.hdnReportUser.Value == "") ? new MainPlanAndAction().BackUserCode(this.txtReportUser.Text) : this.hdnReportUser.Value); model.WkpRecordDate = Convert.ToDateTime(this.txtWPlanDate.Text.Trim()); model.InputTime = DateTime.Now; string text2 = "begin "; string text3 = "begin "; text2 += MainPlanAndAction.GetUpdateStr(model.WkpId.ToString(), model); string sqlString3 = "select 1 from pm_workplan_weekplandetails where WkpId='" + base.Request.QueryString["wkpid"].ToString() + "'"; int count = publicDbOpClass.DataTableQuary(sqlString3).Rows.Count; if (count > 0) { List <PlanDetail> planDemos = new PlanDetailAction().GetPlanDemos(new Guid(base.Request.QueryString["wkpId"])); if (this.txtDuty.Text.Trim().Length > 10) { planDemos[0].WkpChief = this.txtDuty.Text.Trim().Substring(0, 10); } else { planDemos[0].WkpChief = this.txtDuty.Text.Trim(); } planDemos[0].WkpContents = PlanDetailAction.EncodeStr(this.txtContent.Text.Trim()); planDemos[0].WkpEndTime = DateTime.Parse(this.EndDate.Text + " 0:00:00"); if (this.txtResponsibility.Text.Trim().Length > 10) { planDemos[0].WkpPersons = this.txtResponsibility.Text.Trim().Substring(0, 10); } else { planDemos[0].WkpPersons = this.txtResponsibility.Text.Trim(); } planDemos[0].WkpStartTime = DateTime.Parse(this.BeginDate.Text.Trim() + " 0:00:00"); text2 = text2 + " " + PlanDetailAction.GetUpdateStr(planDemos[0], planDemos[0].WkpDetailsId); string text4 = this.hdnNums.Value; if (text4 != "") { string value2 = this.hdnDelPlanId.Value; if (value2 != "") { string[] array2 = value2.Split(new char[] { '?' }); for (int j = 0; j < array2.Length - 1; j++) { text3 = text3 + "delete from Pm_WorkPlan_WeekPlanDetails where WkpDetailsId='" + array2[j] + "' "; } text3 += " end"; string value3 = this.hdnDelTableId.Value; string[] array3 = value3.Split(new char[] { ',' }); for (int k = 0; k < array3.Length - 1; k++) { text4 = text4.Replace(array3[k], ""); } } else { text3 = " "; } if (text4 != "") { string[] array4 = text4.Split(new char[] { '?' }); int num2 = array4.Length; for (int l = 1; l < count + 1 - value2.Split(new char[] { '?' }).Length; l++) { string str2 = array4[l - 1].Substring(2).ToString(); planDemos[l].WkpEndTime = DateTime.Parse(base.Request.Form["endedDate" + str2] + " 0:00:00"); planDemos[l].WkpContents = PlanDetailAction.EncodeStr(base.Request.Form["txtConten" + str2]); if (base.Request.Form["txtPerson" + str2].Length > 10) { planDemos[l].WkpPersons = base.Request.Form["txtPerson" + str2].Substring(0, 10); } else { planDemos[l].WkpPersons = base.Request.Form["txtPerson" + str2]; } planDemos[l].WkpStartTime = DateTime.Parse(base.Request.Form["beginDate" + str2].ToString() + " 0:00:00"); if (base.Request.Form["txtCheify" + str2].Length > 10) { planDemos[l].WkpChief = base.Request.Form["txtCheify" + str2].Substring(0, 10); } else { planDemos[l].WkpChief = base.Request.Form["txtCheify" + str2]; } text2 = text2 + " " + PlanDetailAction.GetUpdateStr(planDemos[l], planDemos[l].WkpDetailsId); } if (num2 - 1 < count) { text2 += " end"; } else { for (int m = count; m <= num2 - 1; m++) { string str3 = array4[m - 1].Substring(2).ToString(); PlanDetail planDetail3 = new PlanDetail(); planDetail3.WkpDetailsId = Guid.NewGuid(); planDetail3.WkpEndTime = DateTime.Parse(base.Request.Form["endedDate" + str3] + " 0:00:00"); planDetail3.WkpContents = PlanDetailAction.EncodeStr(base.Request.Form["txtConten" + str3]); planDetail3.WkpId = model.WkpId; if (base.Request.Form["txtPerson" + str3].Length > 10) { planDetail3.WkpPersons = base.Request.Form["txtPerson" + str3].Substring(0, 10); } else { planDetail3.WkpPersons = base.Request.Form["txtPerson" + str3]; } planDetail3.WkpStartTime = Convert.ToDateTime(base.Request.Form["beginDate" + str3]); if (base.Request.Form["txtChiefy" + str3] != null && base.Request.Form["txtChiefy" + str3].Length > 10) { planDetail3.WkpChief = base.Request.Form["txtChiefy" + str3].Substring(0, 10); } else { planDetail3.WkpChief = ((base.Request.Form["txtChiefy" + str3] == null) ? new MainPlanAndAction().BackUserName(base.UserCode) : base.Request.Form["txtChiefy" + str3]); } text2 = text2 + " " + PlanDetailAction.GetInsertStr(planDetail3); } text2 += " end"; } } else { text2 += " end"; } } else { text3 = " "; text2 += " end"; } } else { PlanDetail planDetail4 = new PlanDetail(); if (this.txtResponsibility.Text.Trim().Length > 10) { planDetail4.WkpChief = this.txtResponsibility.Text.Trim().Substring(0, 10); } else { planDetail4.WkpChief = this.txtResponsibility.Text.Trim(); } planDetail4.WkpContents = PlanDetailAction.EncodeStr(this.txtContent.Text.Trim()); planDetail4.WkpDetailsId = Guid.NewGuid(); planDetail4.WkpEndTime = DateTime.Parse(this.EndDate.Text + " 0:00:00"); planDetail4.WkpId = model.WkpId; if (this.txtDuty.Text.Trim().Length > 10) { planDetail4.WkpPersons = this.txtDuty.Text.Trim().Substring(0, 10); } else { planDetail4.WkpPersons = this.txtDuty.Text.Trim(); } planDetail4.WkpStartTime = DateTime.Parse(this.BeginDate.Text + " 0:00:00"); bool flag3 = new PlanDetailAction().AddModelIntoBaseData(planDetail4); string value4 = this.hdnNums.Value; if (value4 != "") { string[] array5 = value4.Split(new char[] { '?' }); int num3 = array5.Length; for (int n = 0; n < num3 - 1; n++) { string str4 = array5[n].Substring(2).ToString(); PlanDetail planDetail5 = new PlanDetail(); planDetail5.WkpDetailsId = Guid.NewGuid(); planDetail5.WkpEndTime = DateTime.Parse(base.Request.Form["endedDate" + str4] + " 0:00:00"); planDetail5.WkpContents = PlanDetailAction.EncodeStr(base.Request.Form["txtConten" + str4]); planDetail5.WkpId = model.WkpId; if (base.Request.Form["txtPerson" + str4].Length > 10) { planDetail5.WkpPersons = base.Request.Form["txtPerson" + str4].Substring(0, 10); } else { planDetail5.WkpPersons = base.Request.Form["txtPerson" + str4]; } planDetail5.WkpStartTime = DateTime.Parse(base.Request.Form["beginDate" + str4] + " 0:00:00"); if (base.Request.Form["txtCheify" + str4].Length > 10) { planDetail5.WkpChief = base.Request.Form["txtCheify" + str4].Substring(0, 10); } else { planDetail5.WkpChief = base.Request.Form["txtCheify" + str4]; } flag = new PlanDetailAction().AddModelIntoBaseData(planDetail5); } if (flag3 && flag) { base.RegisterScript("top.ui.tabSuccess({ parentName: '_WorkPlanMange'})"); } } text2 = " "; text3 = " "; } if (PlanDetailAction.ExecuteResult(text2) && PlanDetailAction.ExecuteResult(text3)) { base.RegisterScript("top.ui.tabSuccess({ parentName: '_WorkPlanMange'})"); return; } base.RegisterScript("top.ui.alert('保存失败!')"); } }