/// <summary>
/// конструктор с передачей уникального номера выбранного из списка
/// </summary>
/// <param name="Id">уникальный номер из списка</param>
public EditDeportmant(int Id)
{
InitializeComponent();
Loaded += (s, e) => {
string url = host + $@"getDepartmentId/{Id}";
HttpClient httpClient = new HttpClient();
DataContractJsonSerializer jsonCompanyFormatter = new DataContractJsonSerializer(typeof(DepartmentTable));
DepartmentTable ct = (DepartmentTable)jsonCompanyFormatter.ReadObject(new MemoryStream(Encoding.UTF8.GetBytes(httpClient.GetStringAsync(url).Result)));
TextBoxDepartment.Text = ct.Name;
string urlDep = host + $@"getEmployeeListForDepartment/{ct.ID}";
DataContractJsonSerializer jsonDepartmentFormatter = new DataContractJsonSerializer(typeof(EmployeeTable[]));
EmployeeTable[] dt = (EmployeeTable[])jsonDepartmentFormatter.ReadObject(new MemoryStream(Encoding.UTF8.GetBytes(httpClient.GetStringAsync(urlDep).Result)));
EmployeesDataGrid.ItemsSource = dt;
};
Closing += (s, e) => {
};
btnShowEmployee.Click += (s, e) => {
if (EmployeesDataGrid.SelectedItem != null)
{
EditEmpoyee editWindow = new EditEmpoyee(((EmployeeTable)EmployeesDataGrid.SelectedItem).ID);
editWindow.Show();
}
};
}
public async Task <IActionResult> Edit(int id, [Bind("id,Department")] DepartmentTable departmentTable)
{
if (id != departmentTable.id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(departmentTable);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!DepartmentTableExists(departmentTable.id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(departmentTable));
}
private bool FillFilterCombos()
{
// Reset
listCity.Items.Clear();
listDepartment.Items.Clear();
// First item is empty
listCity.Items.Add("");
listDepartment.Items.Add("");
// Read items from DB
try
{
CityTable tableCities = new CityTable(_connectionDb);
foreach (CityRecord cr in tableCities.GetRecords())
{
listCity.Items.Add(cr.Name);
}
DepartmentTable tableDepartments = new DepartmentTable(_connectionDb);
foreach (DepartmentRecord dr in tableDepartments.GetRecords())
{
listDepartment.Items.Add(dr.Name);
}
}
catch (Exception ex)
{
ShowErrorMessage("The error was occured while filling filter combo boxes: <br/>" + ex.Message);
return(false);
}
return(true);
}
public ActionResult DeleteConfirmed(int id)
{
DepartmentTable departmentTable = db.DepartmentTables.Find(id);
db.DepartmentTables.Remove(departmentTable);
db.SaveChanges();
return(RedirectToAction("Index"));
}
protected void DepartmentTable_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string ID = ((Label)DepartmentTable.Rows[e.RowIndex].Cells[0].FindControl("Label1")).Text;
client.RemoveDepartment(ID);
DepartmentTable.DataSource = client.GetAllDepartments();
DepartmentTable.DataBind();
}
protected void DepartmentTable_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string ID = ((Label)DepartmentTable.Rows[e.RowIndex].Cells[0].FindControl("Label1")).Text;
string Name = ((TextBox)DepartmentTable.Rows[e.RowIndex].Cells[0].FindControl("TextBox1")).Text;
client.UpdateDepartment(ID, Name);
DepartmentTable.EditIndex = -1;
DepartmentTable.DataSource = client.GetAllDepartments();
DepartmentTable.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
EmployeeTable.DataSource = client.GetAllEmployees();
EmployeeTable.DataBind();
DepartmentTable.DataSource = client.GetAllDepartments();
DepartmentTable.DataBind();
}
}
public ActionResult Edit([Bind(Include = "ID,DepertmantName,CompanyName")] DepartmentTable departmentTable)
{
if (ModelState.IsValid)
{
db.Entry(departmentTable).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(departmentTable));
}
private void InitDepartmentTable()
{
DepartmentTable.InitTableHeightWidth(420, 458);
DepartmentTable.SetCanUserAddRows(false);
DepartmentTable.SetCanUserDeletRows(true);
DepartmentTable.AddColumns("DepId", "部门编号", 100);
DepartmentTable.AddColumns("DepName", "名称", 100);
DepartmentTable.AddColumns("Describes", "职能描述", 100);
DepartmentTable.AddColumns("UpperId", "上级部门编号", 140);
}
public ActionResult Edit([Bind(Include = "DepartmentID,Name,Establish_Date,Description")] DepartmentTable departmentTable)
{
if (ModelState.IsValid)
{
db.Entry(departmentTable).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(departmentTable));
}
public DepartmentStaff()
{
InitializeComponent();
InitDepartmentTable();
InitStaffTable();
DepartmentTable.DataTableSelect("select * from Departments", "更新");
DepartmentsNum.Content = infnum.InfTotalSet("Departments");
StaffTable.DataTableSelect("select * from ArmsPerson", "更新");
RyNum.Content = infnum.InfTotalSet("ArmsPerson");
InitRightBm();
}
public ActionResult CreateDepartment([Bind(Include = "ID,DepertmantName,CompanyName")] DepartmentTable departmentTable)
{
if (ModelState.IsValid)
{
db.DepartmentTable.Add(departmentTable);
db.SaveChanges();
return(Redirect(HttpContext.Request.UrlReferrer.AbsoluteUri));
}
return(Redirect(HttpContext.Request.UrlReferrer.AbsoluteUri));
}
public async Task <IActionResult> Create([Bind("id,Department")] DepartmentTable departmentTable)
{
if (ModelState.IsValid)
{
_context.Add(departmentTable);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(departmentTable));
}
public ActionResult Create([Bind(Include = "DepartmentID,Name,Establish_Date,Description")] DepartmentTable departmentTable)
{
if (ModelState.IsValid)
{
db.DepartmentTables.Add(departmentTable);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(departmentTable));
}
public ActionResult Create([Bind(Include = "ID,DepertmantName,CompanyName")] DepartmentTable departmentTable)
{
if (ModelState.IsValid)
{
db.DepartmentTable.Add(departmentTable);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(departmentTable));
}
public ActionResult DeleteConfirmed(int id)
{
if (string.IsNullOrEmpty(Convert.ToString(Session["UserID"])))
{
return(RedirectToAction("Login", "Home"));
}
DepartmentTable departmentTable = db.DepartmentTables.Find(id);
db.DepartmentTables.Remove(departmentTable);
db.SaveChanges();
return(RedirectToAction("Index"));
}
protected void Add_Dept(object sender, EventArgs e)
{
string ID = ((Label)DepartmentTable.FooterRow.Cells[0].FindControl("Label1")).Text;
ProjRef.Department temp_dept = new ProjRef.Department
{
ID = int.Parse(ID),
Name = ((TextBox)DepartmentTable.FooterRow.Cells[0].FindControl("TextBox1")).Text
};
client.AddDepartment(temp_dept);
DepartmentTable.DataSource = client.GetAllDepartments();
DepartmentTable.DataBind();
}
// GET: DepartmentTables/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DepartmentTable departmentTable = db.DepartmentTables.Find(id);
if (departmentTable == null)
{
return(HttpNotFound());
}
return(View(departmentTable));
}
public void DepartmentEventContent(object sender, RoutedEventArgs e)
{
Demoinf = new MoreInf();
string[] Table_Str = { "DepId", "DepName", "Describes", "UpperId" };
if (DepartmentTable.dataGrid.SelectedIndex != -1)
{
Demoinf.SetValues(DepartmentTable.Getdt(), DepartmentTable.dataGrid.SelectedIndex, DepartmentTable.Rows, Table_Str, StrDe, 4);
Demoinf.Show();
}
else
{
MessageBox.Show("当前未选中任何行！");
}
}
public void Save(DepartmentView viewTable)
{
if (viewTable.Id == null)
{
var domainTable = new DepartmentTable();
Mapper.Map(viewTable, domainTable);
SaveDomain(domainTable);
}
else
{
var domainTable = Find(viewTable.Id);
Mapper.Map(viewTable, domainTable);
SaveDomain(domainTable);
}
}
public void InitRightBm()
{
MenuItem DepartmentMenu = DepartmentTable.AddMenuItem("更多信息");
MenuItem StaffMenu = StaffTable.AddMenuItem("更多信息");
MenuItem DeletRowMenu1 = DepartmentTable.AddMenuItem("删除选中的行");
MenuItem DeletRowMenu2 = DepartmentTable.AddMenuItem("删除选中的行");
DepartmentMenu.Click += DepartmentEventContent;
StaffMenu.Click += StaffEventContent;
DeletRowMenu1.Click += DeletRows1;
DeletRowMenu2.Click += DeletRows2;
DepartmentTable.dgMenu.Items.Add(DepartmentMenu);
DepartmentTable.dgMenu.Items.Add(DeletRowMenu1);
StaffTable.dgMenu.Items.Add(StaffMenu);
StaffTable.dgMenu.Items.Add(DeletRowMenu2);
}
// GET: DepartmentTables/Details/5
public ActionResult Details(int?id)
{
if (string.IsNullOrEmpty(Convert.ToString(Session["UserID"])))
{
return(RedirectToAction("Login", "Home"));
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DepartmentTable departmentTable = db.DepartmentTables.Find(id);
if (departmentTable == null)
{
return(HttpNotFound());
}
return(View(departmentTable));
}
public ActionResult Edit(DepartmentTable departmentTable)
{
if (string.IsNullOrEmpty(Convert.ToString(Session["UserID"])))
{
return(RedirectToAction("Login", "Home"));
}
int userid = Convert.ToInt32(Convert.ToString(Session["UserID"]));
departmentTable.UserID = userid;
if (ModelState.IsValid)
{
db.Entry(departmentTable).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.UserID = new SelectList(db.UserTables, "UserID", "UserName", departmentTable.UserID);
return(View(departmentTable));
}
// GET: DepartmentTables/Edit/5
public ActionResult Edit(int?id)
{
if (string.IsNullOrEmpty(Convert.ToString(Session["UserID"])))
{
return(RedirectToAction("Login", "Home"));
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DepartmentTable departmentTable = db.DepartmentTables.Find(id);
if (departmentTable == null)
{
return(HttpNotFound());
}
ViewBag.UserID = new SelectList(db.UserTables, "UserID", "UserName", departmentTable.UserID);
return(View(departmentTable));
}
public void SaveDomain(DepartmentTable domainTable, string currentUserName = "")
{
string localUserName = getCurrentUserName(currentUserName);
if (domainTable.Id == Guid.Empty)
{
domainTable.Id = Guid.NewGuid();
domainTable.CreatedDate = DateTime.UtcNow;
domainTable.ModifiedDate = domainTable.CreatedDate;
ApplicationUser user = _AccountService.FirstOrDefault(x => x.UserName == localUserName);
domainTable.CompanyTableId = user.CompanyTableId;
repo.Add(domainTable);
}
else
{
domainTable.ModifiedDate = DateTime.UtcNow;
repo.Update(domainTable);
}
_uow.Save();
}
protected void DepartmentTable_RowEditing(object sender, GridViewEditEventArgs e)
{
DepartmentTable.EditIndex = e.NewEditIndex;
DepartmentTable.DataSource = client.GetAllDepartments();
DepartmentTable.DataBind();
}
private void DepartmentExport_Click(object sender, RoutedEventArgs e)
{
DepartmentTable.ExportExcel("select * from Departments", StrDe, "部门信息表格.xlsx");
}
protected void DepartmentTable_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
DepartmentTable.EditIndex = -1;
DepartmentTable.DataSource = client.GetAllDepartments();
DepartmentTable.DataBind();
}
