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 = "";
}
