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('保存失败!')");
}
}
