/// <summary> /// 更新 /// </summary> /// <param name="data"></param> /// <param name="SQLCommand"></param> /// <returns></returns> public int updateTimeAttendance_DepartmentDal(TimeAttendance_Department data, string SQLCommand) { string sql = SQLhelp.GetSQLCommand(SQLCommand); SqlParameter[] pms = new SqlParameter[] { new SqlParameter("@DepartmentNo", SqlDbType.VarChar, 50) { Value = data.DepartmentNo }, new SqlParameter("@DepartmentName", SqlDbType.VarChar, 80) { Value = data.DepartmentName }, new SqlParameter("@NumberOfStaff", SqlDbType.Int) { Value = data.NumberOfStaff }, new SqlParameter("@InTheNumberOfStaff", SqlDbType.Int) { Value = data.InTheNumberOfStaff }, new SqlParameter("@ExceedNumberOfStaff", SqlDbType.Int) { Value = data.ExceedNumberOfStaff }, new SqlParameter("@note", SqlDbType.VarChar, 255) { Value = data.note } }; return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms)); }
private void btni_DataInput_Click(object sender, EventArgs e) { OpenFileDialog ofd = new OpenFileDialog(); ofd.Filter = "Excel文件(*.xls;*.xlsx)|*.xls;*.xlsx|所有文件|*.*"; ofd.ValidateNames = true; ofd.CheckPathExists = true; ofd.CheckFileExists = true; G.Setlb_QueryState("正在导入数据..."); if (ofd.ShowDialog() == DialogResult.OK) { string fileName = ofd.FileName; try { DataTable dt = ExcelHelperForCs.ImportFromExcel(fileName, "部门结构", 0); foreach (DataRow item in dt.Rows) { TimeAttendance_Department tad = new TimeAttendance_Department() { DepartmentNo = item["组别编号"].ToString(), DepartmentName = item["组别名称"].ToString(), ParentDepartmentNo = item["上级部门编号"].ToString(), ParentDepartmentName = item["上级部门名称"].ToString(), NumberOfStaff = Convert.ToInt32(item["编制人数"]), InTheNumberOfStaff = Convert.ToInt32(item["在编人数"]), ExceedNumberOfStaff = Convert.ToInt32(item["超编人数"]), note = item["备注"].ToString() }; try { if (TadBll.insertTimeAttendance_DepartmentBll(tad, "insertTimeAttendance_Department")) { G.Setlb_QueryState("保存完成"); this.treeView1.Nodes.Clear(); } else { G.Setlb_QueryState("保存失败"); } } catch { G.Setlb_QueryState("保存异常,请检查网络连接情况"); } } SetTreeeview(); G.Setlb_QueryState("导入完成"); } catch (Exception ex) { G.Setlb_QueryState("可能导入的Excle文件无法识别"); MessageBox.Show(ex.Message); } } }
TimeAttendance_Department GetTimeAttendance_Department1() { TimeAttendance_Department tad = new TimeAttendance_Department() { DepartmentNo = treeView1.SelectedNode.Name.Trim() }; return(tad); }
/// <summary> /// 删除 /// </summary> /// <param name="data"></param> /// <param name="SQLCommand"></param> /// <returns></returns> public bool deleteTimeAttendance_DepartmentDal(TimeAttendance_Department data, string SQLCommand) { if (TadDal.deleteTimeAttendance_DepartmentDal(data, SQLCommand) > 0) { return(true); } else { return(false); } }
/// <summary> /// 删除 /// </summary> /// <param name="data"></param> /// <param name="SQLCommand"></param> /// <returns></returns> public int deleteTimeAttendance_DepartmentDal(TimeAttendance_Department data, string SQLCommand) { string sql = SQLhelp.GetSQLCommand(SQLCommand); SqlParameter[] pms = new SqlParameter[] { new SqlParameter("@DepartmentNo", SqlDbType.VarChar, 50) { Value = data.DepartmentNo } }; return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms)); }
void SetTextBox(TimeAttendance_Department data) { txt_DepartmentNo.Text = data.DepartmentNo; txt_DepartmentName.Text = data.DepartmentName; txt_ParentDepartmentNo.Text = data.ParentDepartmentNo; txt_ParentDepartmentName.Text = data.ParentDepartmentName; ip_NumberOfStaff.Value = data.NumberOfStaff; ip_InTheNumberOfStaff.Value = data.InTheNumberOfStaff; ip_ExceedNumberOfStaff.Value = data.ExceedNumberOfStaff; txt_note.Text = data.note; List <TimeAttendance_Department> list = new List <TimeAttendance_Department>(); list.Add(data); SetDataGrid(list, data.DepartmentNo); }
/// <summary> /// 获得编辑数据 /// </summary> /// <returns></returns> TimeAttendance_Department GetTimeAttendance_Department() { TimeAttendance_Department tad = new TimeAttendance_Department() { DepartmentNo = txt_DepartmentNo.Text.Trim(), DepartmentName = txt_DepartmentName.Text.Trim(), ParentDepartmentNo = txt_ParentDepartmentNo.Text.Trim(), ParentDepartmentName = txt_ParentDepartmentName.Text.Trim(), NumberOfStaff = ip_NumberOfStaff.Value, InTheNumberOfStaff = ip_InTheNumberOfStaff.Value, ExceedNumberOfStaff = ip_ExceedNumberOfStaff.Value, note = txt_note.Text }; return(tad); }