private void btnReturn_Click(object sender, EventArgs e) //还样机按钮 { string ip = Fuctions.GetIpAddress(); //if (LoginForm.admin == 0) //{ // if (ip != IPADRESS && ip != IPADDRESS1 && ip != IPADRESS2) // { // MessageBox.Show("请去指定电脑进行样机借阅"); // return; // } //} BorrowBLL borrowbll = new BorrowBLL(); PhoneBLL phonebll = new PhoneBLL(); // 若是第一行的四个中有一个为空,则给出提示 if (cbbPhoneName1.Text == "" || cbbPhoneStage1.Text == "" || cbbHGroupName1.Text == "" || cbbHGroupTest1.Text == "") { MessageBox.Show("请输入除备注以外的所有信息", "提示"); return; } //若是五行中的 样机编号没有选,给出提示 if (cbbPhoneNum1.Text == "" && cbbPhoneNum2.Text == "" && cbbPhoneNum3.Text == "" && cbbPhoneNum4.Text == "" && cbbPhoneNum5.Text == "") { MessageBox.Show("请输入归还的样机编号"); } //样机归还时第一行的信息是否完整 if (cbbPhoneNum1.Text != "") { if (cbbPhoneNum1.Text == cbbPhoneNum2.Text || cbbPhoneNum1.Text == cbbPhoneNum3.Text || cbbPhoneNum1.Text == cbbPhoneNum4.Text || cbbPhoneNum1.Text == cbbPhoneNum5.Text) { MessageBox.Show("归还样机编号重复,请检查编号"); return; } if (cbbIsNormal1.Text == "") { MessageBox.Show("请输入样机状态"); return; } if (cbbIsNormal1.Text == "故障" && txtRemark1.Text == "") { MessageBox.Show("样机故障,请输入故障信息", "提示"); return; } else { if (borrowbll.returnPhone(LoginForm.usrName, cbbPhoneName1.Text, cbbPhoneStage1.Text, cbbPhoneNum1.Text, cbbHGroupTest1.Text + "|" + cbbHGroupTest2.Text + "|" + cbbHGroupTest3.Text, cbbIsNormal1.Text, txtRemark1.Text) && phonebll.updatePhoneStatusIn(cbbPhoneName1.Text, cbbPhoneStage1.Text, cbbPhoneNum1.Text)) { MessageBox.Show("样机归还成功", "提示"); } else { MessageBox.Show("样机状态未成功更新,请检查信息是否输入正确", "提示"); } } } //样机归还时第二行的信息是否完整 if (cbbPhoneNum2.Text != "") { if (cbbPhoneNum2.Text == cbbPhoneNum1.Text || cbbPhoneNum2.Text == cbbPhoneNum3.Text || cbbPhoneNum2.Text == cbbPhoneNum4.Text || cbbPhoneNum2.Text == cbbPhoneNum5.Text) { MessageBox.Show("归还样机编号重复,请检查编号"); return; } if (cbbIsNormal2.Text == "") { MessageBox.Show("请输入样机状态"); return; } if (cbbIsNormal2.Text == "故障" && txtRemark2.Text == "") { MessageBox.Show("样机故障,请输入故障信息", "提示"); return; } else { if (borrowbll.returnPhone(LoginForm.usrName, cbbPhoneName1.Text, cbbPhoneStage1.Text, cbbPhoneNum2.Text, cbbHGroupTest1.Text + "|" + cbbHGroupTest2.Text + "|" + cbbHGroupTest3.Text, cbbIsNormal2.Text, txtRemark2.Text) && phonebll.updatePhoneStatusIn(cbbPhoneName1.Text, cbbPhoneStage1.Text, cbbPhoneNum2.Text)) { // MessageBox.Show("样机归还成功", "提示"); } else { MessageBox.Show("样机状态未成功更新,请检查信息是否输入正确", "提示"); } } } //样机归还时第三行的信息是否完整 if (cbbPhoneNum3.Text != "") { if (cbbPhoneNum3.Text == cbbPhoneNum1.Text || cbbPhoneNum3.Text == cbbPhoneNum2.Text || cbbPhoneNum3.Text == cbbPhoneNum4.Text || cbbPhoneNum3.Text == cbbPhoneNum5.Text) { MessageBox.Show("归还样机编号重复,请检查编号"); return; } if (cbbIsNormal3.Text == "") { MessageBox.Show("请输入样机状态"); return; } if (cbbIsNormal3.Text == "故障" && txtRemark3.Text == "") { MessageBox.Show("样机故障,请输入故障信息", "提示"); return; } else { if (borrowbll.returnPhone(LoginForm.usrName, cbbPhoneName1.Text, cbbPhoneStage1.Text, cbbPhoneNum3.Text, cbbHGroupTest1.Text + "|" + cbbHGroupTest2.Text + "|" + cbbHGroupTest3.Text, cbbIsNormal3.Text, txtRemark3.Text) && phonebll.updatePhoneStatusIn(cbbPhoneName1.Text, cbbPhoneStage1.Text, cbbPhoneNum3.Text)) { //MessageBox.Show("样机归还成功", "提示"); } else { MessageBox.Show("样机状态未成功更新,请检查信息是否输入正确", "提示"); } } } //样机归还时第四行的信息是否完整 if (cbbPhoneNum4.Text != "") { if (cbbPhoneNum4.Text == cbbPhoneNum1.Text || cbbPhoneNum4.Text == cbbPhoneNum2.Text || cbbPhoneNum4.Text == cbbPhoneNum3.Text || cbbPhoneNum4.Text == cbbPhoneNum5.Text) { MessageBox.Show("归还样机编号重复,请检查编号"); return; } if (cbbIsNormal4.Text == "") { MessageBox.Show("请输入样机状态"); return; } if (cbbIsNormal4.Text == "故障" && txtRemark4.Text == "") { MessageBox.Show("样机故障,请输入故障信息", "提示"); return; } else { if (borrowbll.returnPhone(LoginForm.usrName, cbbPhoneName1.Text, cbbPhoneStage1.Text, cbbPhoneNum4.Text, cbbHGroupTest1.Text + "|" + cbbHGroupTest2.Text + "|" + cbbHGroupTest3.Text, cbbIsNormal4.Text, txtRemark4.Text) && phonebll.updatePhoneStatusIn(cbbPhoneName1.Text, cbbPhoneStage1.Text, cbbPhoneNum4.Text)) { //MessageBox.Show("样机归还成功", "提示"); } else { MessageBox.Show("样机状态未成功更新,请检查信息是否输入正确", "提示"); } } } //样机归还时第五行的信息是否完整 if (cbbPhoneNum5.Text != "") { if (cbbPhoneNum5.Text == cbbPhoneNum1.Text || cbbPhoneNum5.Text == cbbPhoneNum2.Text || cbbPhoneNum5.Text == cbbPhoneNum3.Text || cbbPhoneNum5.Text == cbbPhoneNum4.Text) { MessageBox.Show("归还样机编号重复,请检查编号"); return; } if (cbbIsNormal5.Text == "") { MessageBox.Show("请输入样机状态"); return; } if (cbbIsNormal5.Text == "故障" && txtRemark5.Text == "") { MessageBox.Show("样机故障,请输入故障信息", "提示"); return; } else { if (borrowbll.returnPhone(LoginForm.usrName, cbbPhoneName1.Text, cbbPhoneStage1.Text, cbbPhoneNum5.Text, cbbHGroupTest1.Text + "|" + cbbHGroupTest2.Text + "|" + cbbHGroupTest3.Text, cbbIsNormal5.Text, txtRemark5.Text) && phonebll.updatePhoneStatusIn(cbbPhoneName1.Text, cbbPhoneStage1.Text, cbbPhoneNum5.Text)) { //MessageBox.Show("样机归还成功", "提示"); } else { MessageBox.Show("样机状态未成功更新,请检查信息是否输入正确", "提示"); } } } string strSql = "select * from PmBorrow where StaffName = '" + LoginForm.usrName + "' and IsReturn = 'false' order by BorrowID DESC"; //样机名称combobox内容加载 borrows = borrowbll.selByCondition(strSql); //DataGrid 内容加载 borrowDataGrid.DataSource = borrows; //借机相关内容更新********************************************************** strSql = "select distinct PhoneName from PmPhone where PhoneStatus = '在库' and PhoneDisplay = 'TRUE'"; //更新样机cbb信息 MySqlCommand cmd = new MySqlCommand(strSql, conn); MySqlDataAdapter da = new MySqlDataAdapter(cmd); DataSet ds = new DataSet(); conn.Open(); da.Fill(ds, "PmPhone"); conn.Close(); cbbPhoneName.DisplayMember = "PhoneName"; cbbPhoneName.ValueMember = "PhoneName"; cbbPhoneName.DataSource = ds.Tables["PmPhone"]; cbbPhoneName.Text = ""; //**********************************************************还机相关内容更新 strSql = "select distinct PhoneName from PmBorrow where IsReturn = 'false' and StaffName = '" + LoginForm.usrName + "'"; //还样机名称combobox内容加载 cmd = new MySqlCommand(strSql, conn); da = new MySqlDataAdapter(cmd); ds = new DataSet(); conn.Open(); da.Fill(ds, "PmBorrow"); conn.Close(); cbbPhoneName1.DisplayMember = "PhoneName"; cbbPhoneName1.ValueMember = "PhoneName"; cbbPhoneName1.DataSource = ds.Tables["PmBorrow"]; cbbPhoneName1.Text = ""; //--其余的清空 cbbHGroupName1.Text = ""; cbbHGroupTest1.Text = ""; cbbHGroupName2.Text = ""; cbbHGroupTest2.Text = ""; cbbHGroupName3.Text = ""; cbbHGroupTest3.Text = ""; cbbIsNormal1.Text = ""; txtRemark1.Text = ""; cbbIsNormal2.Text = ""; txtRemark2.Text = ""; cbbIsNormal3.Text = ""; txtRemark3.Text = ""; cbbIsNormal4.Text = ""; txtRemark4.Text = ""; cbbIsNormal5.Text = ""; txtRemark5.Text = ""; }
private void btnReturn_Click(object sender, EventArgs e) //还样机按钮 { string ip = Fuctions.GetIpAddress(); if (LoginForm.admin == 0) { if (ip != IPADRESS && ip != IPADDRESS1 && ip != IPADRESS2) { MessageBox.Show("请去指定电脑进行样机借阅"); return; } } //MySqlConnection conn = new MySqlConnection(GetConn.connection); //连接对象 BorrowBLL borrowbll = new BorrowBLL(); PhoneBLL phonebll = new PhoneBLL(); // 若是第一行的五个中有一个为空,则给出提示 if (cbbStaffName1.Text == "" || cbbPhoneName1.Text == "" || cbbPhoneStage1.Text == "" || cbbHGroupName1.Text == "" || cbbHGroupTest1.Text == "") { MessageBox.Show("请输入除备注以外的所有信息", "提示"); return; } //若是五行中的 样机编号没有选,给出提示 if (cbbPhoneNum1.Text == "" && cbbPhoneNum2.Text == "" && cbbPhoneNum3.Text == "" && cbbPhoneNum4.Text == "" && cbbPhoneNum5.Text == "") { MessageBox.Show("请输入归还的样机编号"); } //样机归还时第一行的信息是否完整 if (cbbPhoneNum1.Text != "") { if (cbbPhoneNum1.Text == cbbPhoneNum2.Text || cbbPhoneNum1.Text == cbbPhoneNum3.Text || cbbPhoneNum1.Text == cbbPhoneNum4.Text || cbbPhoneNum1.Text == cbbPhoneNum5.Text) { MessageBox.Show("归还样机编号重复,请检查编号"); return; } if (cbbIsNormal1.Text == "") { MessageBox.Show("请输入样机状态"); return; } if (cbbIsNormal1.Text == "故障" && txtRemark1.Text == "") { MessageBox.Show("样机故障,请输入故障信息", "提示"); return; } else { if (borrowbll.returnPhone(cbbStaffName1.Text, cbbPhoneName1.Text, cbbPhoneStage1.Text, cbbPhoneNum1.Text, cbbHGroupTest1.Text, cbbIsNormal1.Text, txtRemark1.Text) && phonebll.updatePhoneStatusIn(cbbPhoneName1.Text, cbbPhoneStage1.Text, cbbPhoneNum1.Text)) { // MessageBox.Show("样机归还成功", "提示"); } else { MessageBox.Show("样机状态未成功更新,请检查信息是否输入正确", "提示"); } } } //样机归还时第二行的信息是否完整 if (cbbPhoneNum2.Text != "") { if (cbbPhoneNum2.Text == cbbPhoneNum1.Text || cbbPhoneNum2.Text == cbbPhoneNum3.Text || cbbPhoneNum2.Text == cbbPhoneNum4.Text || cbbPhoneNum2.Text == cbbPhoneNum5.Text) { MessageBox.Show("归还样机编号重复,请检查编号"); return; } if (cbbIsNormal2.Text == "") { MessageBox.Show("请输入样机状态"); return; } if (cbbIsNormal2.Text == "故障" && txtRemark2.Text == "") { MessageBox.Show("样机故障,请输入故障信息", "提示"); return; } else { if (borrowbll.returnPhone(cbbStaffName1.Text, cbbPhoneName1.Text, cbbPhoneStage1.Text, cbbPhoneNum2.Text, cbbHGroupTest1.Text, cbbIsNormal2.Text, txtRemark2.Text) && phonebll.updatePhoneStatusIn(cbbPhoneName1.Text, cbbPhoneStage1.Text, cbbPhoneNum2.Text)) { // MessageBox.Show("样机归还成功", "提示"); } else { MessageBox.Show("样机状态未成功更新,请检查信息是否输入正确", "提示"); } } } //样机归还时第三行的信息是否完整 if (cbbPhoneNum3.Text != "") { if (cbbPhoneNum3.Text == cbbPhoneNum1.Text || cbbPhoneNum3.Text == cbbPhoneNum2.Text || cbbPhoneNum3.Text == cbbPhoneNum4.Text || cbbPhoneNum3.Text == cbbPhoneNum5.Text) { MessageBox.Show("归还样机编号重复,请检查编号"); return; } if (cbbIsNormal3.Text == "") { MessageBox.Show("请输入样机状态"); return; } if (cbbIsNormal3.Text == "故障" && txtRemark3.Text == "") { MessageBox.Show("样机故障,请输入故障信息", "提示"); return; } else { if (borrowbll.returnPhone(cbbStaffName1.Text, cbbPhoneName1.Text, cbbPhoneStage1.Text, cbbPhoneNum3.Text, cbbHGroupTest1.Text, cbbIsNormal3.Text, txtRemark3.Text) && phonebll.updatePhoneStatusIn(cbbPhoneName1.Text, cbbPhoneStage1.Text, cbbPhoneNum3.Text)) { //MessageBox.Show("样机归还成功", "提示"); } else { MessageBox.Show("样机状态未成功更新,请检查信息是否输入正确", "提示"); } } } //样机归还时第四行的信息是否完整 if (cbbPhoneNum4.Text != "") { if (cbbPhoneNum4.Text == cbbPhoneNum1.Text || cbbPhoneNum4.Text == cbbPhoneNum2.Text || cbbPhoneNum4.Text == cbbPhoneNum3.Text || cbbPhoneNum4.Text == cbbPhoneNum5.Text) { MessageBox.Show("归还样机编号重复,请检查编号"); return; } if (cbbIsNormal4.Text == "") { MessageBox.Show("请输入样机状态"); return; } if (cbbIsNormal4.Text == "故障" && txtRemark4.Text == "") { MessageBox.Show("样机故障,请输入故障信息", "提示"); return; } else { if (borrowbll.returnPhone(cbbStaffName1.Text, cbbPhoneName1.Text, cbbPhoneStage1.Text, cbbPhoneNum4.Text, cbbHGroupTest1.Text, cbbIsNormal4.Text, txtRemark4.Text) && phonebll.updatePhoneStatusIn(cbbPhoneName1.Text, cbbPhoneStage1.Text, cbbPhoneNum4.Text)) { //MessageBox.Show("样机归还成功", "提示"); } else { MessageBox.Show("样机状态未成功更新,请检查信息是否输入正确", "提示"); } } } //样机归还时第五行的信息是否完整 if (cbbPhoneNum5.Text != "") { if (cbbPhoneNum5.Text == cbbPhoneNum1.Text || cbbPhoneNum5.Text == cbbPhoneNum2.Text || cbbPhoneNum5.Text == cbbPhoneNum3.Text || cbbPhoneNum5.Text == cbbPhoneNum4.Text) { MessageBox.Show("归还样机编号重复,请检查编号"); return; } if (cbbIsNormal5.Text == "") { MessageBox.Show("请输入样机状态"); return; } if (cbbIsNormal5.Text == "故障" && txtRemark5.Text == "") { MessageBox.Show("样机故障,请输入故障信息", "提示"); return; } else { if (borrowbll.returnPhone(cbbStaffName1.Text, cbbPhoneName1.Text, cbbPhoneStage1.Text, cbbPhoneNum5.Text, cbbHGroupTest1.Text, cbbIsNormal5.Text, txtRemark5.Text) && phonebll.updatePhoneStatusIn(cbbPhoneName1.Text, cbbPhoneStage1.Text, cbbPhoneNum5.Text)) { //MessageBox.Show("样机归还成功", "提示"); } else { MessageBox.Show("样机状态未成功更新,请检查信息是否输入正确", "提示"); } } } borrows = borrowbll.GetAllBorrow(); borrowDataGrid.DataSource = borrows; //**********************************************************借机相关内容更新 string strSql = "select distinct PhoneName from PmPhone where PhoneStatus = '在库' and PhoneDisplay = 'TRUE'"; //更新cbb中样机信息 MySqlCommand cmd = new MySqlCommand(strSql, conn); MySqlDataAdapter da = new MySqlDataAdapter(cmd); DataSet ds = new DataSet(); conn.Open(); da.Fill(ds, "PmPhone"); conn.Close(); cbbPhoneName.DisplayMember = "PhoneName"; cbbPhoneName.ValueMember = "PhoneName"; cbbPhoneName.DataSource = ds.Tables["PmPhone"]; cbbPhoneName.Text = ""; //**********************************************************还机相关内容更新 //strSql = "select distinct StaffName from PmBorrow"; //--还员工姓名combobox内容更新 strSql = "select distinct StaffName from PmBorrow where IsReturn='false' order by convert(StaffName USING gbk) asc"; cmd = new MySqlCommand(strSql, conn); da = new MySqlDataAdapter(cmd); ds = new DataSet(); conn.Open(); da.Fill(ds, "PmBorrow"); conn.Close(); cbbStaffName1.DisplayMember = "StaffName"; cbbStaffName1.ValueMember = "StaffName"; cbbStaffName1.DataSource = ds.Tables["PmBorrow"]; cbbStaffName1.Text = ""; //cbbHGroupName1.Text = ""; //--其余的清空 //cbbHGroupTest1.Text = ""; cbbIsNormal1.Text = ""; txtRemark1.Text = ""; cbbIsNormal2.Text = ""; txtRemark2.Text = ""; cbbIsNormal3.Text = ""; txtRemark3.Text = ""; cbbIsNormal4.Text = ""; txtRemark4.Text = ""; cbbIsNormal5.Text = ""; txtRemark5.Text = ""; }
private void btnReturn_Click(object sender, EventArgs e) //还样机按钮 { string ip = Fuctions.GetIpAddress(); if (LoginForm.admin == 0) { if (ip != IPADRESS) { MessageBox.Show("请去指定电脑进行样机借阅"); return; } } BorrowBLL borrowbll = new BorrowBLL(); PhoneBLL phonebll = new PhoneBLL(); if (cbbPhoneName1.Text == "" || cbbPhoneStage1.Text == "" || cbbPhoneNum1.Text == "" || cbbHGroupName1.Text == "" || cbbHGroupTest1.Text == "" || cbbIsNormal1.Text == "") { MessageBox.Show("请输入除备注以外的所有信息", "提示"); return; } else if (cbbIsNormal1.Text == "故障" && txtRemark.Text == "") { MessageBox.Show("样机故障,请输入故障信息", "提示"); return; } else { if (borrowbll.returnPhone(LoginForm.usrName, cbbPhoneName1.Text, cbbPhoneStage1.Text, cbbPhoneNum1.Text, cbbHGroupTest1.Text, cbbIsNormal1.Text, txtRemark.Text)) { MessageBox.Show("样机归还成功", "提示"); } if (phonebll.updatePhoneStatusIn(cbbPhoneName1.Text, cbbPhoneStage1.Text, cbbPhoneNum1.Text)) { MessageBox.Show("样机状态更新成功", "提示"); } else { MessageBox.Show("样机状态未成功更新,请检查信息是否输入正确", "提示"); } } borrows = borrowbll.GetAllBorrow(); borrowDataGrid.DataSource = borrows; //借机相关内容更新********************************************************** string strSql = "select distinct PhoneName from PmPhone where PhoneStatus = '在库' and PhoneDisplay = 'TRUE'"; //更新样机cbb信息 MySqlCommand cmd = new MySqlCommand(strSql, conn); MySqlDataAdapter da = new MySqlDataAdapter(cmd); DataSet ds = new DataSet(); conn.Open(); da.Fill(ds, "PmPhone"); conn.Close(); cbbPhoneName.DisplayMember = "PhoneName"; cbbPhoneName.ValueMember = "PhoneName"; cbbPhoneName.DataSource = ds.Tables["PmPhone"]; cbbPhoneName.Text = ""; //**********************************************************还机相关内容更新 strSql = "select distinct PhoneName from PmBorrow where IsReturn = 'false' and StaffName = '" + LoginForm.usrName + "'"; //还样机名称combobox内容加载 cmd = new MySqlCommand(strSql, conn); da = new MySqlDataAdapter(cmd); ds = new DataSet(); conn.Open(); da.Fill(ds, "PmBorrow"); conn.Close(); cbbPhoneName1.DisplayMember = "PhoneName"; cbbPhoneName1.ValueMember = "PhoneName"; cbbPhoneName1.DataSource = ds.Tables["PmBorrow"]; cbbPhoneName1.Text = ""; cbbHGroupName1.Text = ""; //--其余的清空 cbbHGroupTest1.Text = ""; cbbIsNormal1.Text = ""; txtRemark.Text = ""; }