private void btn_Ok_Click(object sender, EventArgs e)
{
try
{
deviceInfo device = new deviceInfo();
log_tabel condition = new log_tabel();
if (tbx_Name.Text.Trim() != "")
{
condition.addrow("PersonName", tbx_Name.Text.Trim(), log_tabel.operatetype.equal, log_tabel.mark.normal);
}
if (dtp_Intime.Text != "")
{
condition.addrow("EnlistmentTime", dtp_Intime.Value.ToString("yyyy-MM-dd"), log_tabel.operatetype.equal, log_tabel.mark.Date);
}
int Recordcount = device.GetRecordCount(logs.PersonnelInfoList, condition);
if (Recordcount > 0)
{
myPageControl1.PageRecordCount = Recordcount;
DataTable dt = device.getpage(logs.PersonnelInfoList, condition, myPageControl1.DataStart, myPageControl1.PageRecordNumber);
DataView.DataSource = dt;
bindingColName(dt);
}
else
{
MessageBox.Show("无匹配数据，请重新更改查询条件！");
}
tbx_Name.Text = "";
dtp_Intime.Text = "";
}
catch (Exception)
{
throw;
}
}
/// <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);
}
}
private void btn_Search_Click(object sender, EventArgs e)
{
try
{
//if (SearchText.Text.Trim() != "")
//{
// string Condition = SearchText.Text.Trim();
// deviceInfo device = new deviceInfo();
// string sql = "select * from PersonnelInfoList where PersonName like '%" + Condition + "%'";
// DataSet ds = device.gettablebycondition(sql);
// DataTable dt = ds.Tables[0];
// if (dt.Rows.Count > 0 && dt != null)
// {
// DataView.DataSource = dt;
// PersonResult = dt;
// }
// else
// {
// MessageBox.Show("找不到符合条件的人员相关信息，请重新输入！");
// }
//}
if (SearchText.Text.Trim() != "")
{
string name = "%" + SearchText.Text.Trim() + "%";
deviceInfo PersonInfo = new deviceInfo();
log_tabel log = new log_tabel();
log.addrow("EquipmentName", name, log_tabel.operatetype.like, log_tabel.mark.normal);
int i = PersonInfo.GetRecordCount(logs.EquipmentInfoList, log);
if (i > 0)
{
DataTable dt = PersonInfo.getpage(logs.PersonnelInfoList, log, myPageControl1.DataStart, myPageControl1.PageRecordNumber);
DataView.DataSource = dt;
bindingColName(dt);
}
else
{
MessageBox.Show("无匹配条件数据，请重新查询");
}
}
}
catch (Exception)
{
throw;
}
}
private void btn_Ok_Click(object sender, EventArgs e)
{
if (this.InvokeRequired)
{
this.Invoke(new Action <object, EventArgs>(btn_Ok_Click), sender, e);
}
else
{
try
{
deviceInfo device = new deviceInfo();
log_tabel condition = new log_tabel();
if (tbx_Name.Text.Trim() != "")
{
condition.addrow("PersonName", tbx_Name.Text.Trim(), log_tabel.operatetype.equal, log_tabel.mark.normal);
}
if (dtp_Intime.Text != "")
{
condition.addrow("DutyEventTime", dtp_Intime.Value.ToString("yyyy-MM-dd"), log_tabel.operatetype.lessAndEqual, log_tabel.mark.Date);
//condition.addrow("DutyEventTime", "2019-04-06", log_tabel.operatetype.lessAndEqual, log_tabel.mark.Date);
}
int Recordcount = device.GetRecordCount(logs.DutyRecordInfoList, condition);
if (Recordcount > 0)
{
myPageControl1.PageRecordCount = Recordcount;
myPageControl1.PageRecordNumber = 100;
DataTable dt = device.getpage(logs.DutyRecordInfoList, condition, myPageControl1.DataStart, myPageControl1.PageRecordNumber);
DataView.DataSource = dt;
bindingColName(dt);
}
else
{
MessageBox.Show("无匹配数据，请重新更改查询条件！");
}
tbx_Name.Text = "";
dtp_Intime.Text = "";
}
catch (Exception ex)
{
throw ex;
}
}
}