Beispiel #1
0
 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;
     }
 }
Beispiel #2
0
        /// <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);
            }
        }
Beispiel #3
0
        /// <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);
            }
        }
Beispiel #4
0
 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;
     }
 }
Beispiel #5
0
        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;
                }
            }
        }