/// <summary>
/// 数据操作
/// </summary>
/// <param name="Mess">区别编辑还是新增还是删除</param>
private void OpreationDB(string Mess)
{
BaseDataClass.PersonnelInfoList PersonList = new PersonnelInfoList();
PersonList.PersonName = this.tbx_Name.Text.ToString();
PersonList.PersonID = this.tbx_ID.Text.ToString();
PersonList.PersonNation = this.tbx_Nation.Text.ToString();
PersonList.Post = this.tbx_post.Text.ToString();
PersonList.Unit = this.tbx_Unit.Text.ToString();
PersonList.ContactInfo = this.tbx_contactinfo.Text.ToString();
PersonList.DateOfBirth = this.TimePicker_DateOfBirth.Value.ToString("yyyy-MM-dd");
PersonList.DegreeOfEducation = this.tbx_DegreeOfEducation.Text.ToString();
PersonList.EnlistmentTime = this.TimePicker_Intime.Value.ToString("yyyy-MM-dd");
PersonList.RetiredTime = this.TimePicker_Outtime.Value.ToString("yyyy-MM-dd");
PersonList.NativePlace = this.tbx_place.Text.ToString();
PersonList.Description = this.tbx_descrip.Text.ToString();
deviceInfo PersonInfo = new deviceInfo();
string Error = "";
bool Result = false;
if (Mess == "添加")
{
if (tbx_ID.Text.Trim() != "")
{
deviceInfo device = new deviceInfo();
//string sql = "select * from PersonnelListInfo where PersonID =‘" + tbx_ID.Text.Trim()+"’";
//DataSet result= device.gettablebycondition(sql);
log_tabel log = new log_tabel();
log.addrow("PersonID", tbx_ID.Text.Trim(), log_tabel.operatetype.equal, log_tabel.mark.normal);
int i = device.GetRecordCount(logs.PersonnelInfoList, log);
if (i > 0)
{
MessageBox.Show("用户编号重复 请重新录入！");
}
else
{
Result = PersonInfo.AddBaseList(PersonList, ref Error);
}
}
}
if (Mess == "编辑")
{
Result = PersonInfo.UpdateBaselist(PersonList, ref Error);
}
if (Mess == "删除")
{
Result = PersonInfo.DeleteOneRecord(BaseDataClassNames.PersonnelInfoList, PersonList.PersonID, ref Error);
}
if (Result == true)
{
MessageBox.Show("人员信息" + Mess + "成功");
ClearText(this.Content);
}
else
{
MessageBox.Show("人员信息" + Mess + "失败，请稍后再试！");
ClearText(this.Content);
}
}
/// <summary>
/// 数据操作
/// </summary>
/// <param name="Mess">区别编辑还是新增还是删除</param>
private void OpreationDB(string Mess)
{
BaseDataClass.EquipmentInfoList Equiplist = new EquipmentInfoList();
Equiplist.EquipmentID = this.tbx_ID.Text.Trim();
Equiplist.EquipmentName = this.tbx_Name.Text.Trim();
Equiplist.EquipmentModel = this.tbx_EquipNum.Text.Trim();
Equiplist.EquipmentType = this.tbx_EquipType.Text.Trim();
Equiplist.PersonIncharge = this.tbx_PersonIncharge.Text.Trim();
Equiplist.ReturnDate = this.TimePicker_ReturnDate.Value.ToString("yyyy-MM-dd");
Equiplist.AllottedDate = this.TimePicker_Intime.Value.ToString("yyyy-MM-dd");
Equiplist.Description = this.tbx_descrip.Text;
Equiplist.Unit = this.tbx_Unit.Text;
Equiplist.EquipmentState = this.tbx_EquipmentState.Text;
deviceInfo PersonInfo = new deviceInfo();
string Error = "";
bool Result = false;
if (Mess == "添加")
{
if (tbx_ID.Text.Trim() != "")
{
//deviceInfo device = new deviceInfo();
//string sql = "select * from EquipmentInfoList where EquipmentID =" + tbx_ID.Text.Trim();
//DataSet result= device.gettablebycondition(sql);
deviceInfo device = new deviceInfo();
log_tabel log = new log_tabel();
log.addrow("EquipmentID", tbx_ID.Text.Trim(), log_tabel.operatetype.equal, log_tabel.mark.normal);
int i = device.GetRecordCount(logs.EquipmentInfoList, log);
if (i > 0)
{
MessageBox.Show("设备编号重复 请重新录入！");
}
else
{
Result = PersonInfo.AddBaseList(Equiplist, ref Error);
}
}
}
if (Mess == "编辑")
{
Result = PersonInfo.UpdateBaselist(Equiplist, ref Error);
}
if (Mess == "删除")
{
Result = PersonInfo.DeleteOneRecord(BaseDataClassNames.EquipmentInfoList, Equiplist.EquipmentID, ref Error);
}
if (Result == true)
{
MessageBox.Show("设备信息" + Mess + "成功");
ClearText(this.Content);
}
else
{
MessageBox.Show("设备信息" + Mess + "失败，请稍后再试！");
ClearText(this.Content);
}
}
/// <summary>
/// 数据操作
/// </summary>
/// <param name="Mess">区别编辑还是新增还是删除</param>
private void OpreationDB(string Mess)
{
BaseDataClass.DutyRecordInfoList DutyLIst = new DutyRecordInfoList();
DutyLIst.DutyPerson = tbx_Name.Text.Trim();
DutyLIst.PersonID = tbx_ID.Text.Trim();
DutyLIst.DutyDate = TimePicker_DutyDate.Value.ToString("yyyy-MM-dd HH:mm:ss");
DutyLIst.DutyEvent = tbx_DutyEvent.Text;
if (tbx_DutyEvent.Text == "")
{
DutyLIst.DutyEventTime = "";
}
DutyLIst.DutyEventTime = TimePicker_DutyEventTime.Value.ToString("yyyy-MM-dd HH:mm:ss");
DutyLIst.DutyRoute = tbx_DutyRoute.Text;
DutyLIst.Description = tbx_descrip.Text;
DutyLIst.Mark = cbx_Plan.SelectedText;//预留字段MARK这里用来保存预案处置结果
deviceInfo PersonInfo = new deviceInfo();
string Error = "";
bool Result = false;
if (Mess == "添加")
{
Result = PersonInfo.AddBaseList(DutyLIst, ref Error);
}
if (Mess == "编辑")
{
DutyLIst.ID = Convert.ToInt32(infoList[0].ToString());
Result = PersonInfo.UpdateBaselist(DutyLIst, ref Error);
}
if (Mess == "删除")
{
DutyLIst.ID = Convert.ToInt32(infoList[0].ToString());
Result = PersonInfo.DeleteOneRecord(BaseDataClassNames.DutyRecordInfoList, DutyLIst.ID, ref Error);
}
if (Result == true)
{
MessageBox.Show("设备信息" + Mess + "成功");
ClearText(this.Content);
this.Close();
}
else
{
MessageBox.Show("设备信息" + Mess + "失败，请稍后再试！");
ClearText(this.Content);
}
}
/// <summary>
/// 数据操作
/// </summary>
/// <param name="Mess">区别编辑还是新增还是删除</param>
private void OpreationDB(string Mess)
{
BaseDataClass.PlanManagementInfoList Planlist = new PlanManagementInfoList();
try
{
Planlist.PlanContent = this.tbx_PlanContent.Text;
Planlist.PlanID = this.tbx_PlanID.Text.Trim();
deviceInfo PersonInfo = new deviceInfo();
string Error = "";
bool Result = false;
if (Mess == "添加")
{
if (CheckIDIsrepeat())
{
Result = PersonInfo.AddBaseList(Planlist, ref Error);
}
}
if (Mess == "编辑")
{
Result = PersonInfo.UpdateBaselist(Planlist, ref Error);
}
if (Mess == "删除")
{
Result = PersonInfo.DeleteOneRecord(BaseDataClassNames.PlanManagementInfoList, Planlist.PlanID, ref Error);
}
if (Result == true)
{
MessageBox.Show("预案信息" + Mess + "成功");
ClearText(this.Content);
}
else
{
MessageBox.Show("预案信息" + Mess + "失败，请稍后再试！");
ClearText(this.Content);
}
}
catch (Exception e)
{
throw e;
}
}