/// <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);
}
