private void button1_Click(object sender, EventArgs e) //将不需要显示的样机字段改变
{
PhoneBLL phonebll = new PhoneBLL();
string PhoneNameD = this.cbbPhoneNameD.Text;
string PhoneStageD = this.cbbPhoneStageD.Text;
string PhoneDisplay = this.cbbPhoneDisplay.Text;
if (cbbPhoneNameD.Text == "" || cbbPhoneStageD.Text == "" || cbbPhoneDisplay.Text == "")
{
MessageBox.Show("请通过样机名称 与 样机阶段 进行选择", "提示");
return;
}
if (MessageBox.Show("确定对选中的样机名称与样机阶段进行操作?", "Warning",
MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
{
if (phonebll.updatePhoneDisplay(PhoneNameD, PhoneStageD, PhoneDisplay))
{
MessageBox.Show("更新样机状态成功", "提示");
}
else
{
MessageBox.Show("更新失败，请检查信息是否正确", "提示");
}
}
else
{
//不执行任务
}
phones = phonebll.getAllPhones();
PhoneDataGrid.DataSource = phones; //将数据库中的数据提到列表中，再通过 DataGrid控件显示；
}
public ActionResult Index()
{
ViewBag.Laptops = LaptopBLL.GetLaptops();
ViewBag.Phones = PhoneBLL.GetPhones();
ViewBag.Tablets = TabletBLL.GetTablets();
return(View());
}
MySqlConnection conn = new MySqlConnection(GetConn.connection); //连接对象
private void button1_Click_1(object sender, EventArgs e) //添加样机按钮
{
string PhoneStatus = "在库";
string PhoneCode = this.txtPhoneCode.Text; //PhoneID作为主键，可以在程序中自动生成，此处无需添加
string PhoneName = this.txtPhoneName.Text;
string PhoneStage = this.cbbPhoneStage.Text;
string PhoneNum = this.txtPhoneNum.Value.ToString();
string PhoneOwner = this.cbbPhoneOwner.Text;
string PhoneInf1 = this.cbbInf1.Text;
string PhoneInf2 = this.cbbInf2.Text;
string PhoneInf3 = this.cbbInf3.Text;
string PhoneInf4 = this.cbbInf4.Text;
string PhoneNote = PhoneInf1 + "_" + PhoneInf2 + "_" + PhoneInf3 + "_" + PhoneInf4;
PhoneBLL phonebll = new PhoneBLL(); //建立对象
if (this.txtPhoneName.Text == "" || this.cbbPhoneStage.Text == "" || this.txtPhoneNum.Value.ToString() == "" || this.cbbPhoneOwner.Text == "")
{
MessageBox.Show("样机名称，样机阶段，接口人信息必填", "提示");
return;
}
else if (phonebll.AddPhone(PhoneCode, PhoneName, PhoneStage, PhoneNum, PhoneStatus, PhoneNote, PhoneOwner, LoginForm.usrName))
{
MessageBox.Show("数据上传成功！");
}
phones = phonebll.getAllPhones(); //刷新选项内容
PhoneDataGrid.DataSource = phones;
this.txtPhoneCode.Clear();
}
public GioHangViewModels(int ID, string IDLoaiSanPham)
{
this.ID = ID;
this.IDLoaiSanPham = IDLoaiSanPham;
if (IDLoaiSanPham == "Phone")
{
Phone phone = PhoneBLL.GetSinglePhone(ID, IDLoaiSanPham);
TenSanPham = phone.TenSanPham;
HinhAnh = phone.HinhAnhSanPham;
DonGia = phone.GiaSanPham;
}
else if (IDLoaiSanPham == "Laptop")
{
Laptop laptop = LaptopBLL.GetSingleLaptop(ID, IDLoaiSanPham);
TenSanPham = laptop.TenSanPham;
HinhAnh = laptop.HinhAnhSanPham;
DonGia = laptop.GiaSanPham;
}
else
{
Tablet tablet = TabletBLL.GetSingleTablet(ID, IDLoaiSanPham);
TenSanPham = tablet.TenSanPham;
HinhAnh = tablet.HinhAnhSanPham;
DonGia = tablet.GiaSanPham;
}
}
public ViewResult ChiTietPhone(int ID)
{
var phone = PhoneBLL.GetSinglePhone(ID);
if (phone == null)
{
Response.StatusCode = 404;
return(null);
}
return(View(phone));
}
private void btnQuery_Click(object sender, EventArgs e) //查询可以根据多个条件进行查询
{
sql = "select * from PmPhone where 1=1 and PhoneDisplay = 'TRUE'";
if (txtPhoneNum.Text == "" && cbbPhoneName.Text == "" && cbbPhoneStage.Text == "" && cbbPhoneStatus.Text == "" && txtPhoneCode.Text == "" && txtPhoneNote.Text == "")
{
MessageBox.Show("请选择查询条件", "提示");
return;
}
try
{
if (txtPhoneNum.Text != "")
{
sql = sql + " and PhoneNum = '" + txtPhoneNum.Text + "'";
}
if (cbbPhoneName.Text != "")
{
sql = sql + " and PhoneName like'%" + cbbPhoneName.Text + "%'";
}
if (cbbPhoneStage.Text != "")
{
sql = sql + " and PhoneStage ='" + cbbPhoneStage.Text + "'";
}
if (cbbPhoneStatus.Text != "")
{
sql = sql + " and PhoneStatus ='" + cbbPhoneStatus.Text + "'";
}
if (txtPhoneCode.Text != "")
{
sql = sql + " and PhoneCode ='" + txtPhoneCode.Text + "'";
}
if (txtPhoneNote.Text != "")
{
sql = sql + " and PhoneNote like'%" + txtPhoneNote.Text + "%'";
}
sql = sql + " order by PhoneID DESC";
PhoneBLL Phonebll = new PhoneBLL();
phones = Phonebll.selByCondition(sql);
phoneDataGrid.DataSource = phones;
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message);
}
this.txtPhoneNum.Clear();
this.cbbPhoneName.Text = "";
}
private void button1_Click(object sender, EventArgs e) //显示全部
{
PhoneBLL phonebll = new PhoneBLL();
phones = phonebll.getAllPhones();
phoneDataGrid.DataSource = phones;
this.txtPhoneNum.Clear();
this.cbbPhoneName.Text = "";
this.cbbPhoneStage.Text = "";
this.cbbPhoneStatus.Text = "";
}
public ActionResult SearchResults(FormCollection data)
{
var laptops = LaptopBLL.Search(data["search"].ToString());
var phones = PhoneBLL.Search(data["search"].ToString());
var tablets = TabletBLL.Search(data["search"].ToString());
if (laptops.Count == 0 && phones.Count == 0 & tablets.Count == 0)
{
ViewBag.Message = "Không tìm thấy sản phẩm nào";
}
var products = new ProductViewModels();
products.Laptops = laptops;
products.Phones = phones;
products.Tablets = tablets;
return(View(products));
}
public ActionResult Create(Phone phone, HttpPostedFileBase fileUpload)
{
var fileName = Path.GetFileName(fileUpload.FileName);
var path = Path.Combine(Server.MapPath("~/Images"), fileName);
if (System.IO.File.Exists(path))
{
ViewBag.ThongBao = "Hình ảnh đã tồn tại";
}
else
{
fileUpload.SaveAs(path);
}
phone.HinhAnhSanPham = fileUpload.FileName;
PhoneBLL.InsertIntoPhone(phone);
return(RedirectToAction("Phone"));
}
private void btnDelete_Click(object sender, EventArgs e) //根据样机码删除样机
{
string phoneCode = this.txtPhoneCode.Text;
PhoneBLL phonebll = new PhoneBLL();
if (txtPhoneCode.Text == "")
{
MessageBox.Show("请通过输入样机码进行样机删除", "提示");
return;
}
if (MessageBox.Show("确定要删除该条样机信息吗？", "Warning",
MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
{
if (phonebll.delByPhoneCode(phoneCode))
{
MessageBox.Show("删除成功！", "提示");
}
else
{
MessageBox.Show("删除失败，请检查信息是否正确", "提示");
}
}
else
{
//不执行任务
}
phones = phonebll.getAllPhones();
PhoneDataGrid.DataSource = phones;
this.txtPhoneCode.Clear();
this.txtPhoneName.Clear();
this.cbbPhoneStage.Text = "";
this.cbbInf1.Text = "";
this.cbbInf2.Text = "";
this.cbbInf3.Text = "";
this.cbbInf4.Text = "";
this.cbbPhoneOwner.Text = "";
}
private void 样机输入ToolStripMenuItem_Click(object sender, EventArgs e)
{
string excelFilePath = "";
//excelFilePath = @"C:\Users\user\Desktop\EXCEL\TRY.xlsx";
OpenFileDialog dialog = new OpenFileDialog();
dialog.Title = "请选择文件";
dialog.Filter = "Excel(*.xlsm)|*.xlsm|Excel(*.xlsx)|*.xlsx|Excel(*.xls)|*.xls";
dialog.Multiselect = false; //确定是否可以选择多个文件
//dialog.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);
//dialog.InitialDirectory = Application.StartupPath ;
dialog.InitialDirectory = @"\\version1\测试二所\样机管理系统\样机信息";
if (dialog.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
excelFilePath = dialog.FileName;
}
else
{
return;
}
MExcel.Application app = new MExcel.Application();
MExcel.Sheets sheets;
MExcel.Workbook workbook = null;
object oMissing = System.Reflection.Missing.Value;
//app.Visible = true;
DataTable dt = new DataTable();
try
{
workbook = app.Workbooks.Open(excelFilePath, oMissing, oMissing, oMissing, oMissing, oMissing,
oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing);
sheets = workbook.Worksheets;
MExcel.Worksheet worksheet = (MExcel.Worksheet)sheets.get_Item(1); //用的是 worksheets 这一大类的
//MExcel.Worksheet worksheet = (MExcel.Worksheet)workbook.Worksheets[1];
int iRowCount = worksheet.get_Range("B65535", oMissing).get_End(MExcel.XlDirection.xlUp).Row;
int iColCount = worksheet.UsedRange.Columns.Count;
if (iRowCount < 4)
{
MessageBox.Show("请在文档中输入样机信息！");
return;
}
string PhoneCode; //PhoneID作为主键，可以在程序中自动生成，此处无需添加
string PhoneName;
string PhoneStage;
string PhoneStagePrint;
string PhoneNum;
string PhoneStatus = "在库";
//string PhoneNoteAll;
string PhoneNote;
string PhoneNote1;
string PhoneNote2;
string PhoneNote3;
string PhoneNote4;
string PhoneOwner;
string log1, log2, log3, log4;
MExcel.Range rngName = (MExcel.Range)worksheet.Cells[1, 2];
MExcel.Range rngStage = (MExcel.Range)worksheet.Cells[2, 2];
//MExcel.Range rngNoteAll = (MExcel.Range)worksheet.Cells[3, 2];
PhoneName = Convert.ToString(rngName.Value2); //STRING 用来将内容变为字符串
PhoneStage = Convert.ToString(rngStage.Value2);
//PhoneNoteAll = Convert.ToString(rngNoteAll.Value2);
MExcel.Range log1R = (MExcel.Range)worksheet.Cells[3, 1];
MExcel.Range log2R = (MExcel.Range)worksheet.Cells[3, 5];
MExcel.Range log3R = (MExcel.Range)worksheet.Cells[3, 6];
MExcel.Range log4R = (MExcel.Range)worksheet.Cells[3, 7];
log1 = Convert.ToString(log1R.Value2); //STRING 用来将内容变为字符串
log2 = Convert.ToString(log2R.Value2);
log3 = Convert.ToString(log3R.Value2);
log4 = Convert.ToString(log4R.Value2);
if (PhoneName == null || PhoneStage == null || log1 == null || log2 == null || log3 == null || log4 == null)
{
MessageBox.Show("'型号' 与 '测试阶段' 是必填内容 或 使用最新模板");
return;
}
PhoneBLL phonebll = new PhoneBLL();
for (int i = 4; i <= iRowCount; i++)
{
MExcel.Range rngCode = (MExcel.Range)worksheet.Cells[i, 1];
MExcel.Range rngNum = (MExcel.Range)worksheet.Cells[i, 2];
//MExcel.Range rngNote = (MExcel.Range)worksheet.Cells[i, 4];
MExcel.Range rngOwner = (MExcel.Range)worksheet.Cells[i, 3];
MExcel.Range rngNote1 = (MExcel.Range)worksheet.Cells[i, 4];
MExcel.Range rngNote2 = (MExcel.Range)worksheet.Cells[i, 5];
MExcel.Range rngNote3 = (MExcel.Range)worksheet.Cells[i, 6];
MExcel.Range rngNote4 = (MExcel.Range)worksheet.Cells[i, 7];
PhoneCode = Convert.ToString(rngCode.Value2) + ""; //入库使用，PHONEID
PhoneNum = Convert.ToString(rngNum.Value2) + "";
PhoneOwner = Convert.ToString(rngOwner.Value2) + ""; //入库使用，接口人
PhoneNote1 = Convert.ToString(rngNote1.Value2) + ""; //打印信息使用
PhoneNote2 = Convert.ToString(rngNote2.Value2) + ""; //打印信息使用
PhoneNote3 = Convert.ToString(rngNote3.Value2) + ""; //打印信息使用
PhoneNote4 = Convert.ToString(rngNote4.Value2) + ""; //打印信息使用
PhoneNote = PhoneNote1 + "_" + PhoneNote2 + "_" + PhoneNote3 + "_" + PhoneNote4; //入库使用，备注信息
PhoneStagePrint = PhoneStage + "_" + PhoneNum; //打印信息使用
////打印开始******************************************************************************
////打开打印端口
//TSCLIB_DLL.openport("Deli DL-888F(NEW)");
////设计打印纸的大小与间距
//TSCLIB_DLL.setup("30", "20", "3", "10", "0", "2", "0"); //宽度、高度、速度寸/秒、浓度0-15、。 长度30 20 OK,倒数间距2 OK
////清空下缓存
//TSCLIB_DLL.clearbuffer();
////打印文字
//TSCLIB_DLL.windowsfont(1, 15, 23, 0, 0, 0, "標楷體", PhoneName); //用windowsTTF字型列印文字 X、Y、字体高度、角度、字体外形、有无底线、字体名称、打印内容
//TSCLIB_DLL.windowsfont(1, 40, 23, 0, 0, 0, "標楷體", PhoneStagePrint); //用windowsTTF字型列印文字 X、Y、字体高度、角度、字体外形、有无底线、字体名称、打印内容
//TSCLIB_DLL.windowsfont(1, 65, 23, 0, 0, 0, "標楷體", PhoneNote1); //用windowsTTF字型列印文字 X、Y、字体高度、角度、字体外形、有无底线、字体名称、打印内容
//TSCLIB_DLL.windowsfont(1, 90, 23, 0, 0, 0, "標楷體", PhoneNote2); //用windowsTTF字型列印文字 X、Y、字体高度、角度、字体外形、有无底线、字体名称、打印内容
//TSCLIB_DLL.windowsfont(1, 115, 23, 0, 0, 0, "標楷體", PhoneNote3); //用windowsTTF字型列印文字 X、Y、字体高度、角度、字体外形、有无底线、字体名称、打印内容
//TSCLIB_DLL.windowsfont(1, 138, 23, 0, 0, 0, "標楷體", PhoneNote4); //用windowsTTF字型列印文字 X、Y、字体高度、角度、字体外形、有无底线、字体名称、打印内容
////打印份数
//TSCLIB_DLL.printlabel("1", "1");
////关闭打印端口
//TSCLIB_DLL.closeport();
////打印结束********************************************************************************
if (phonebll.AddPhone(PhoneCode, PhoneName, PhoneStage, PhoneNum, PhoneStatus, PhoneNote, PhoneOwner, LoginForm.usrName))
{
//MessageBox.Show("ok");
}
}
MessageBox.Show("样机信息导入成功^_^");
}
catch (Exception excep)
{
MessageBox.Show(excep.ToString());
}
finally
{
workbook.Close(false, oMissing, oMissing); //关闭 工作表
System.Runtime.InteropServices.Marshal.ReleaseComObject(workbook);
workbook = null;
app.Workbooks.Close(); //关闭应用
app.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject(app);
app = null;
}
//COM组件方式读取 EXCEL中的数值
}
private void eXCEL打印ToolStripMenuItem_Click(object sender, EventArgs e)
{
string excelFilePath = "";
//excelFilePath = @"C:\Users\user\Desktop\EXCEL\TRY.xlsx";
OpenFileDialog dialog = new OpenFileDialog();
dialog.Title = "请选择文件";
dialog.Filter = "Excel(*.xlsm)|*.xlsm|Excel(*.xlsx)|*.xlsx|Excel(*.xls)|*.xls";
dialog.Multiselect = false; //确定是否可以选择多个文件
//dialog.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);
//dialog.InitialDirectory = Application.StartupPath ;
dialog.InitialDirectory = @"\\version1\测试二所\样机管理系统\样机信息";
if (dialog.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
excelFilePath = dialog.FileName;
}
else
{
return;
}
MExcel.Application app = new MExcel.Application();
MExcel.Sheets sheets;
MExcel.Workbook workbook = null;
object oMissing = System.Reflection.Missing.Value;
//app.Visible = true;
DataTable dt = new DataTable();
//查询产线数据库需要
//IMEI信息 无线功检工位数据库
SqlConnection connSql = new SqlConnection(GetConn.sqlConn); //连接对象
List <string> IMEIList = new List <string>(); //IMEI号列表
try
{
workbook = app.Workbooks.Open(excelFilePath, oMissing, oMissing, oMissing, oMissing, oMissing,
oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing);
sheets = workbook.Worksheets;
MExcel.Worksheet worksheet = (MExcel.Worksheet)sheets.get_Item(1); //用的是 worksheets 这一大类的
//MExcel.Worksheet worksheet = (MExcel.Worksheet)workbook.Worksheets[1];
int iRowCount = worksheet.get_Range("B65535", oMissing).get_End(MExcel.XlDirection.xlUp).Row;
int iColCount = worksheet.UsedRange.Columns.Count;
if (iRowCount < 4)
{
MessageBox.Show("请在文档中输入样机信息！");
return;
}
//查询产线数据库，使用的sql命令. IMEI号获取
//string strSqlTest;
//SqlCommand cmdTest = null;
//SqlDataReader dr = null;
string IMEIPrint = "";
string PhoneCode; //PhoneID作为主键，可以在程序中自动生成，此处无需添加
string PhoneName;
string PhoneStage;
string PhoneStagePrint;
string PhoneNum;
//string PhoneStatus = "在库";
//string PhoneNoteAll;
string PhoneNote;
string PhoneNote1;
string PhoneNote2;
string PhoneNote3;
string PhoneNote4;
//string PhoneNote5;
string PhoneOwner;
string log1, log2, log3, log4;
MExcel.Range rngName = (MExcel.Range)worksheet.Cells[1, 2];
MExcel.Range rngStage = (MExcel.Range)worksheet.Cells[2, 2];
//MExcel.Range rngNoteAll = (MExcel.Range)worksheet.Cells[3, 2];
PhoneName = Convert.ToString(rngName.Value2); //STRING 用来将内容变为字符串
PhoneStage = Convert.ToString(rngStage.Value2);
//PhoneNoteAll = Convert.ToString(rngNoteAll.Value2);
MExcel.Range log1R = (MExcel.Range)worksheet.Cells[3, 1];
MExcel.Range log2R = (MExcel.Range)worksheet.Cells[3, 5];
MExcel.Range log3R = (MExcel.Range)worksheet.Cells[3, 6];
MExcel.Range log4R = (MExcel.Range)worksheet.Cells[3, 7];
log1 = Convert.ToString(log1R.Value2); //STRING 用来将内容变为字符串
log2 = Convert.ToString(log2R.Value2);
log3 = Convert.ToString(log3R.Value2);
log4 = Convert.ToString(log4R.Value2);
if (PhoneName == null || PhoneStage == null || log1 == null || log2 == null || log3 == null || log4 == null)
{
MessageBox.Show("'型号' 与 '测试阶段' 是必填内容 或 使用最新模板");
return;
}
PhoneBLL phonebll = new PhoneBLL();
//循环打印开始
for (int i = 4; i <= iRowCount; i++)
{
MExcel.Range rngCode = (MExcel.Range)worksheet.Cells[i, 1];
MExcel.Range rngNum = (MExcel.Range)worksheet.Cells[i, 2];
//MExcel.Range rngNote = (MExcel.Range)worksheet.Cells[i, 4];
MExcel.Range rngOwner = (MExcel.Range)worksheet.Cells[i, 3];
MExcel.Range rngNote1 = (MExcel.Range)worksheet.Cells[i, 4];
MExcel.Range rngNote2 = (MExcel.Range)worksheet.Cells[i, 5];
MExcel.Range rngNote3 = (MExcel.Range)worksheet.Cells[i, 6];
MExcel.Range rngNote4 = (MExcel.Range)worksheet.Cells[i, 7];
//MExcel.Range rngNote5 = (MExcel.Range)worksheet.Cells[i, 8];
PhoneCode = Convert.ToString(rngCode.Value2) + "";
PhoneNum = Convert.ToString(rngNum.Value2) + "";
PhoneOwner = Convert.ToString(rngOwner.Value2) + "";
PhoneNote1 = Convert.ToString(rngNote1.Value2) + "";
PhoneNote2 = Convert.ToString(rngNote2.Value2) + "";
PhoneNote3 = Convert.ToString(rngNote3.Value2) + "";
PhoneNote4 = Convert.ToString(rngNote4.Value2) + "";
//PhoneNote5 = Convert.ToString(rngNote5.Value2) + "";
PhoneNote = PhoneNote1 + PhoneNote2 + PhoneNote3 + PhoneNote4;
PhoneStagePrint = PhoneStage + "_" + PhoneNum;
//如果没有PhoneCode时，就设为myname
//if (PhoneCode=="")
//{
// PhoneCode = "xiechunhui";
//}
////////////////////////////////////////////////////////连接产线数据库，查询是否有IMEI号，暂时不打印了。
//strSqlTest = "SELECT [dbo].[ESNRecord].IMEI FROM [dbo].[ESNRECORD] INNER JOIN [dbo].[TestReport] on [dbo].[TestReport].PhoneId=[dbo].[ESNRecord].PhoneId and [dbo].[TestReport].PhoneId = "
// + "'" + PhoneCode + "'"; //样机名称combobox内容加载
////打开连接
//connSql.Open();
////新建mysql命令
//cmdTest = new SqlCommand(strSqlTest, connSql);
////执行查寻; ExecuteReader() 方法的 CommandBehavior.CloseConnection 参数,会在DataReader对象关闭时也同时关闭Connection对象
//dr = cmdTest.ExecuteReader(CommandBehavior.CloseConnection);
//while (dr.Read())
//{
// IMEIList.Add((dr.IsDBNull(0)) ? "" : dr.GetString(0)); //当PHONEID为NULL时的处理办法
//}
////关闭DataReader对象
//dr.Close();
//dr.Dispose();
////需要打印的IMEI号
////当查询不到此PHONEID对应的IMEI号时列表中的值为空时，设其为空字符串
//if (IMEIList.Count == 0)
//{
// IMEIPrint = "未写号";
//}
//else
//{
// IMEIPrint = IMEIList[0];
//}
//打印开始******************************************************************************
//打开打印端口
TSCLIB_DLL.openport("Deli DL-888F(NEW)");
//设计打印纸的大小与间距
TSCLIB_DLL.setup("30", "20", "3", "10", "0", "2", "0"); //宽度、高度、速度寸/秒、浓度0-15、。 长度30 20 OK,倒数间距2 OK
//清空下缓存
TSCLIB_DLL.clearbuffer();
//打印文字
TSCLIB_DLL.windowsfont(1, 15, 22, 0, 0, 0, "標楷體", PhoneName); //用windowsTTF字型列印文字 X、Y、字体高度、角度、字体外形、有无底线、字体名称、打印内容
TSCLIB_DLL.windowsfont(1, 38, 22, 0, 0, 0, "標楷體", PhoneStagePrint); //用windowsTTF字型列印文字 X、Y、字体高度、角度、字体外形、有无底线、字体名称、打印内容
TSCLIB_DLL.windowsfont(1, 61, 22, 0, 0, 0, "標楷體", PhoneNote1); //用windowsTTF字型列印文字 X、Y、字体高度、角度、字体外形、有无底线、字体名称、打印内容
TSCLIB_DLL.windowsfont(1, 84, 22, 0, 0, 0, "標楷體", PhoneNote2); //用windowsTTF字型列印文字 X、Y、字体高度、角度、字体外形、有无底线、字体名称、打印内容
TSCLIB_DLL.windowsfont(1, 107, 22, 0, 0, 0, "標楷體", PhoneNote3); //用windowsTTF字型列印文字 X、Y、字体高度、角度、字体外形、有无底线、字体名称、打印内容
TSCLIB_DLL.windowsfont(1, 130, 15, 0, 0, 0, "標楷體", PhoneNote4); //用windowsTTF字型列印文字 X、Y、字体高度、角度、字体外形、有无底线、字体名称、打印内容
//TSCLIB_DLL.windowsfont(1, 146, 15, 0, 0, 0, "標楷體", PhoneNote5); //用windowsTTF字型列印文字 X、Y、字体高度、角度、字体外形、有无底线、字体名称、打印内容
//打印份数
TSCLIB_DLL.printlabel("1", "1");
//关闭打印端口
TSCLIB_DLL.closeport();
//打印结束********************************************************************************
//IMEIList.Clear();//IMEI查询时使用，在此不用
}
MessageBox.Show("样机信息打印成功^_^");
}
catch
{
MessageBox.Show("本机电脑可能不能访问产线数据库,有问题请联系 解chunhui");
}
finally
{
workbook.Close(false, oMissing, oMissing); //关闭 工作表
System.Runtime.InteropServices.Marshal.ReleaseComObject(workbook);
workbook = null;
app.Workbooks.Close(); //关闭应用
app.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject(app);
app = null;
//关闭连接
connSql.Close();
}
//COM组件方式读取 EXCEL中的数值
}
public JsonResult Delete(int ID)
{
PhoneBLL.DeleteIntoPhone(ID);
return(Json(ID, JsonRequestBehavior.AllowGet));
}
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 = "";
}
MySqlConnection conn = new MySqlConnection(GetConn.connection); //连接对象
private void PhoneQueryForm_Load(object sender, EventArgs e) //窗体出现时加载所有样机
{
this.Width = 1070;
this.Height = 760;
//通过列表方法获取数据，有点不方便
PhoneBLL phonebll = new PhoneBLL();
phones = phonebll.getAllPhones();
phoneDataGrid.DataSource = phones;
phoneDataGrid.ClearSelection();
phoneDataGrid.ReadOnly = true;
//phoneDataGrid.Width = Fuctions.dataGridViewWidth;
//phoneDataGrid.Height = Fuctions.dataGridViewHeight;
//phoneDataGrid.Location = new Point(43, 12);
phoneDataGrid.Columns[0].HeaderText = "主键"; //修改显示的列名
phoneDataGrid.Columns[0].Visible = false;
phoneDataGrid.Columns[1].HeaderText = "序列号";
phoneDataGrid.Columns[2].HeaderText = "名称";
phoneDataGrid.Columns[3].HeaderText = "阶段";
phoneDataGrid.Columns[4].HeaderText = "编号";
phoneDataGrid.Columns[5].HeaderText = "状态";
phoneDataGrid.Columns[6].HeaderText = "备注";
phoneDataGrid.Columns[7].HeaderText = "接口人";
phoneDataGrid.Columns[8].HeaderText = "显示";
phoneDataGrid.Columns[8].Visible = false;
phoneDataGrid.Columns[9].HeaderText = "主管";
phoneDataGrid.Columns[10].HeaderText = "启用时间";
phoneDataGrid.Columns[1].Width = 80;
phoneDataGrid.Columns[2].Width = Fuctions.dataGridViewPhoneName;
phoneDataGrid.Columns[3].Width = 80;
phoneDataGrid.Columns[4].Width = Fuctions.dataGridViewPhoneNum;
phoneDataGrid.Columns[5].Width = 50;
phoneDataGrid.Columns[6].Width = Fuctions.dataGridViewNote;
phoneDataGrid.Columns[7].Width = 50;
phoneDataGrid.Columns[8].Width = 50;
phoneDataGrid.Columns[9].Width = 50;
phoneDataGrid.Columns[10].Width = 120;
//Fuctions.AutoSize(phoneDataGrid);
//获取数据库中 pmstage表中的 值，但是后来没在用，因为其中的数据不全，测试主管一直在改
//StageBLL stagebll = new StageBLL();
//stages = stagebll.getAllStages();
//cbbPhoneStage.DataSource = stages;
//cbbPhoneStage.DisplayMember = "StageName";
//cbbPhoneStage.ValueMember = "StageName";
//cbbPhoneStage.Text = "";
//说明：一个dataSet中可以放多个dataTable。
string strSql = "select distinct PhoneName from PmPhone where PhoneStatus = '在库' and PhoneDisplay = 'TRUE'"; //样机名称combobox内容加载
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 = "";
/****************************************************************************************************************************
* 目的：显示产线数据库中数据信息
* 方法：将mysql中样机的Phoneid作为条件向产线sql server数据库申请数据，两个数据显示于一个datagridview中
* 结果：失败
* 原因分析：从两个数据库中获取的信息各存放于一个datatable中，这两个datatable无法实现拼接
* try
* {
* //测试用的datagridview 测试用 此数据库使用 mysql
* string strSqlTry = "select PhoneId from PmPhone where PhoneStatus = '在库' and PhoneDisplay = 'TRUE'"; //样机名称combobox内容加载
* MySqlCommand cmdTry = new MySqlCommand(strSqlTry, conn);
*
* MySqlDataAdapter daTry = new MySqlDataAdapter(cmdTry);
* DataSet dsTry = new DataSet();
* conn.Open();
* daTry.Fill(dsTry, "PmPhoneTry");
*
* conn.Close();
*
* DataTable dtsource = new DataTable();
*
* SqlConnection connSql = new SqlConnection(GetConn.sqlConn); //连接对象
* for (int i = 0; i < dsTry.Tables["PmPhoneTry"].Rows.Count; i++)
* {
* string id = dsTry.Tables["PmPhoneTry"].Rows[i]["PhoneId"].ToString();
*
*
* //测试用 sql server数据库 通过datatable获取数据
*
* string strSqlTry1 = "SELECT distinct PhoneID FROM [Hts2007].[dbo].[ESNRecord] where PhoneID= "+ "'"+id+"'"; //样机名称combobox内容加载
* SqlCommand cmdTry1 = new SqlCommand(strSqlTry1, connSql);
*
* SqlDataAdapter daTry1 = new SqlDataAdapter(cmdTry1);
*
* connSql.Open();
* daTry1.Fill(dsTry, "PmPhoneTry1");
* connSql.Close();
*
* dtsource.Merge(dsTry.Tables["PmPhoneTry1"]);
*
* }
*
*
* TryDataGrid.DataSource = dtsource;
*
*
* //测试用的datagridview
* string strSqlTry1 = "select PhoneName from PmPhone where PhoneStatus = '在库' and PhoneDisplay = 'TRUE'"; //样机名称combobox内容加载
* MySqlCommand cmdTry1 = new MySqlCommand(strSqlTry1, conn);
*
* MySqlDataAdapter daTry1 = new MySqlDataAdapter(cmdTry1);
* conn.Open();
*
* daTry1.Fill(dsTry, "PmPhoneTry1");
*
* conn.Close();
*
*
* DataTable dtLast = new DataTable();
* dtLast.Columns.Add("phoneNa", typeof(string));
* dtLast.Columns.Add("PhoneNa1", typeof(string));
*
* var results = (from d1 in dsTry.Tables[0].AsEnumerable()
* join d2 in dsTry.Tables[1].AsEnumerable()
* on d1.Field<string>("PhoneName") equals d2.Field<string>("PhoneName")
* select dtLast.LoadDataRow(new object[] {d1.Field<string>("PhoneName"),d2.Field<string>("PhoneName")},true));
*
* dtLast = results.CopyToDataTable<DataRow>();
*
*
* ////绑定数据源
* TryDataGrid.DataSource = dtLast;
*
*
* //测试用 sql server数据库 通过datatable获取数据
* SqlConnection connSql = new SqlConnection(GetConn.sqlConn); //连接对象
* string strSqlTry1 = "SELECT distinct PhoneID FROM [Hts2007].[dbo].[ESNRecord] "; //样机名称combobox内容加载
* SqlCommand cmdTry1 = new SqlCommand(strSqlTry1, connSql);
*
* SqlDataAdapter daTry1 = new SqlDataAdapter(cmdTry1);
*
* connSql.Open();
* daTry1.Fill(dsTry, "PmPhoneTry1");
* connSql.Close();
*
* TryDataGrid.DataSource = dsTry.Tables["PmPhoneTry1"];
* }
*
* catch (System.Exception ex)
* {
* MessageBox.Show(ex.Message);
* }
*
*/
//方法2：分别将mysql数据库 与 sql server数据库提取的信息放于两个datagridview中。
}
/*
*需求：通过按键实现样机 借还一起，主要是为了记录做过的实验，及实验后的状态
*思路：先借 后还
*/
private void button1_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 (cbbPhoneNum1.Text == "" && cbbPhoneNum2.Text == "" && cbbPhoneNum3.Text == "" && cbbPhoneNum4.Text == "" && cbbPhoneNum.Text == "" & cbbPhoneNum5.Text == "" && cbbPhoneNum6.Text == "" && cbbPhoneNum7.Text == "" && cbbPhoneNum8.Text == "" && cbbPhoneNum9.Text == "")
{
MessageBox.Show("请输入样机编号");
return;
}
if (cbbPhoneName.Text == "" || cbbPhoneStage.Text == "")
{
MessageBox.Show("请输入样机信息");
return;
}
else
{
//判断样机状态是否选择
if (cbbPhoneNum.Text != "")
{
if (cbbIsNormal.Text == "")
{
MessageBox.Show("请输入样机状态");
return;
}
//样机状态是否正常，若是故障时需要输入备注
if (cbbIsNormal.Text == "故障" && txtRemark.Text == "")
{
MessageBox.Show("样机故障，请输入故障信息", "提示");
return;
}
}
if (cbbPhoneNum1.Text != "")
{
if (cbbIsNormal1.Text == "")
{
MessageBox.Show("请输入样机状态");
return;
}
//样机状态是否正常，若是故障时需要输入备注
if (cbbIsNormal1.Text == "故障" && txtRemark1.Text == "")
{
MessageBox.Show("样机故障，请输入故障信息", "提示");
return;
}
}
if (cbbPhoneNum2.Text != "")
{
//样机状态是否正常，若是故障时需要输入备注
if (cbbIsNormal2.Text == "故障" && txtRemark2.Text == "")
{
MessageBox.Show("样机故障，请输入故障信息", "提示");
return;
}
if (cbbIsNormal2.Text == "")
{
MessageBox.Show("请输入样机状态");
return;
}
}
if (cbbPhoneNum3.Text != "")
{
if (cbbIsNormal3.Text == "")
{
MessageBox.Show("请输入样机状态");
return;
}
//样机状态是否正常，若是故障时需要输入备注
if (cbbIsNormal3.Text == "故障" && txtRemark3.Text == "")
{
MessageBox.Show("样机故障，请输入故障信息", "提示");
return;
}
}
if (cbbPhoneNum4.Text != "")
{
if (cbbIsNormal4.Text == "")
{
MessageBox.Show("请输入样机状态");
return;
}
//样机状态是否正常，若是故障时需要输入备注
if (cbbIsNormal4.Text == "故障" && txtRemark4.Text == "")
{
MessageBox.Show("样机故障，请输入故障信息", "提示");
return;
}
}
if (cbbPhoneNum5.Text != "")
{
if (cbbIsNormal5.Text == "")
{
MessageBox.Show("请输入样机状态");
return;
}
//样机状态是否正常，若是故障时需要输入备注
if (cbbIsNormal5.Text == "故障" && txtRemark5.Text == "")
{
MessageBox.Show("样机故障，请输入故障信息", "提示");
return;
}
}
if (cbbPhoneNum6.Text != "")
{
if (cbbIsNormal6.Text == "")
{
MessageBox.Show("请输入样机状态");
return;
}
//样机状态是否正常，若是故障时需要输入备注
if (cbbIsNormal6.Text == "故障" && txtRemark6.Text == "")
{
MessageBox.Show("样机故障，请输入故障信息", "提示");
return;
}
}
if (cbbPhoneNum7.Text != "")
{
if (cbbIsNormal7.Text == "")
{
MessageBox.Show("请输入样机状态");
return;
}
//样机状态是否正常，若是故障时需要输入备注
if (cbbIsNormal7.Text == "故障" && txtRemark7.Text == "")
{
MessageBox.Show("样机故障，请输入故障信息", "提示");
return;
}
}
if (cbbPhoneNum8.Text != "")
{
if (cbbIsNormal8.Text == "")
{
MessageBox.Show("请输入样机状态");
return;
}
//样机状态是否正常，若是故障时需要输入备注
if (cbbIsNormal8.Text == "故障" && txtRemark8.Text == "")
{
MessageBox.Show("样机故障，请输入故障信息", "提示");
return;
}
}
if (cbbPhoneNum9.Text != "")
{
if (cbbIsNormal9.Text == "")
{
MessageBox.Show("请输入样机状态");
return;
}
//样机状态是否正常，若是故障时需要输入备注
if (cbbIsNormal9.Text == "故障" && txtRemark9.Text == "")
{
MessageBox.Show("样机故障，请输入故障信息", "提示");
return;
}
}
//借机操作
if (cbbPhoneNum.Text != "")
{
//借与还操作
if (borrowbll.addBorrow(LoginForm.usrName, this.cbbPhoneName.Text, this.cbbPhoneStage.Text, this.cbbPhoneNum.Text, LoginForm.usrName))
{
}
else
{
MessageBox.Show(this.cbbPhoneNum.Text + "借", "提示");
}
if (borrowbll.returnPhone(LoginForm.usrName, cbbPhoneName.Text, cbbPhoneStage.Text, cbbPhoneNum.Text, cbbHGroupTest.Text, cbbIsNormal.Text, txtRemark.Text))
{
//MessageBox.Show("操作成功", "提示");
}
else
{
MessageBox.Show(this.cbbPhoneNum.Text + "还", "提示");
}
}
//借机操作2
if (cbbPhoneNum1.Text != "")
{
//借与还操作
if (borrowbll.addBorrow(LoginForm.usrName, this.cbbPhoneName.Text, this.cbbPhoneStage.Text, this.cbbPhoneNum1.Text, LoginForm.usrName))
{
}
else
{
MessageBox.Show(this.cbbPhoneNum1.Text + "借错误", "提示");
}
if (borrowbll.returnPhone(LoginForm.usrName, cbbPhoneName.Text, cbbPhoneStage.Text, cbbPhoneNum1.Text, cbbHGroupTest.Text, cbbIsNormal1.Text, txtRemark1.Text))
{
//MessageBox.Show("操作成功", "提示");
}
else
{
MessageBox.Show(this.cbbPhoneNum1.Text + "还错误", "提示");
}
}
//操作3
if (cbbPhoneNum2.Text != "")
{
//借与还操作
if (borrowbll.addBorrow(LoginForm.usrName, this.cbbPhoneName.Text, this.cbbPhoneStage.Text, this.cbbPhoneNum2.Text, LoginForm.usrName))
{
}
else
{
MessageBox.Show(this.cbbPhoneNum2.Text + "借错误", "提示");
}
if (borrowbll.returnPhone(LoginForm.usrName, cbbPhoneName.Text, cbbPhoneStage.Text, cbbPhoneNum2.Text, cbbHGroupTest.Text, cbbIsNormal2.Text, txtRemark2.Text))
{
//MessageBox.Show("操作成功", "提示");
}
else
{
MessageBox.Show(this.cbbPhoneNum2.Text + "还错误", "提示");
}
}
//操作4
if (cbbPhoneNum3.Text != "")
{
//借与还操作
if (borrowbll.addBorrow(LoginForm.usrName, this.cbbPhoneName.Text, this.cbbPhoneStage.Text, this.cbbPhoneNum3.Text, LoginForm.usrName))
{
}
else
{
MessageBox.Show(this.cbbPhoneNum3.Text + "借错误", "提示");
}
if (borrowbll.returnPhone(LoginForm.usrName, cbbPhoneName.Text, cbbPhoneStage.Text, cbbPhoneNum3.Text, cbbHGroupTest.Text, cbbIsNormal3.Text, txtRemark3.Text))
{
//MessageBox.Show("操作成功", "提示");
}
else
{
MessageBox.Show(this.cbbPhoneNum3.Text + "还错误", "提示");
}
}
//操作5
if (cbbPhoneNum4.Text != "")
{
//样机状态是否正常，若是故障时需要输入备注
if (cbbIsNormal4.Text == "故障" && txtRemark4.Text == "")
{
MessageBox.Show("样机故障，请输入故障信息", "提示");
return;
}
//借与还操作
if (borrowbll.addBorrow(LoginForm.usrName, this.cbbPhoneName.Text, this.cbbPhoneStage.Text, this.cbbPhoneNum4.Text, LoginForm.usrName))
{
}
else
{
MessageBox.Show(this.cbbPhoneNum4.Text + "借错误", "提示");
}
if (borrowbll.returnPhone(LoginForm.usrName, cbbPhoneName.Text, cbbPhoneStage.Text, cbbPhoneNum4.Text, cbbHGroupTest.Text, cbbIsNormal4.Text, txtRemark4.Text))
{
//MessageBox.Show("操作成功", "提示");
}
else
{
MessageBox.Show(this.cbbPhoneNum4.Text + "还错误", "提示");
}
}
//操作6
if (cbbPhoneNum5.Text != "")
{
//样机状态是否正常，若是故障时需要输入备注
if (cbbIsNormal5.Text == "故障" && txtRemark5.Text == "")
{
MessageBox.Show("样机故障，请输入故障信息", "提示");
return;
}
//借与还操作
if (borrowbll.addBorrow(LoginForm.usrName, this.cbbPhoneName.Text, this.cbbPhoneStage.Text, this.cbbPhoneNum5.Text, LoginForm.usrName))
{
}
else
{
MessageBox.Show(this.cbbPhoneNum5.Text + "借错误", "提示");
}
if (borrowbll.returnPhone(LoginForm.usrName, cbbPhoneName.Text, cbbPhoneStage.Text, cbbPhoneNum5.Text, cbbHGroupTest.Text, cbbIsNormal5.Text, txtRemark5.Text))
{
//MessageBox.Show("操作成功", "提示");
}
else
{
MessageBox.Show(this.cbbPhoneNum5.Text + "还错误", "提示");
}
}
//操作7
if (cbbPhoneNum6.Text != "")
{
//样机状态是否正常，若是故障时需要输入备注
if (cbbIsNormal6.Text == "故障" && txtRemark6.Text == "")
{
MessageBox.Show("样机故障，请输入故障信息", "提示");
return;
}
//借与还操作
if (borrowbll.addBorrow(LoginForm.usrName, this.cbbPhoneName.Text, this.cbbPhoneStage.Text, this.cbbPhoneNum6.Text, LoginForm.usrName))
{
}
else
{
MessageBox.Show(this.cbbPhoneNum6.Text + "借错误", "提示");
}
if (borrowbll.returnPhone(LoginForm.usrName, cbbPhoneName.Text, cbbPhoneStage.Text, cbbPhoneNum6.Text, cbbHGroupTest.Text, cbbIsNormal6.Text, txtRemark6.Text))
{
//MessageBox.Show("操作成功", "提示");
}
else
{
MessageBox.Show(this.cbbPhoneNum6.Text + "还错误", "提示");
}
}
//操作8
if (cbbPhoneNum7.Text != "")
{
//样机状态是否正常，若是故障时需要输入备注
if (cbbIsNormal7.Text == "故障" && txtRemark7.Text == "")
{
MessageBox.Show("样机故障，请输入故障信息", "提示");
return;
}
//借与还操作
if (borrowbll.addBorrow(LoginForm.usrName, this.cbbPhoneName.Text, this.cbbPhoneStage.Text, this.cbbPhoneNum7.Text, LoginForm.usrName))
{
}
else
{
MessageBox.Show(this.cbbPhoneNum7.Text + "借错误", "提示");
}
if (borrowbll.returnPhone(LoginForm.usrName, cbbPhoneName.Text, cbbPhoneStage.Text, cbbPhoneNum7.Text, cbbHGroupTest.Text, cbbIsNormal7.Text, txtRemark7.Text))
{
//MessageBox.Show("操作成功", "提示");
}
else
{
MessageBox.Show(this.cbbPhoneNum7.Text + "还错误", "提示");
}
}
//操作9
if (cbbPhoneNum8.Text != "")
{
//样机状态是否正常，若是故障时需要输入备注
if (cbbIsNormal8.Text == "故障" && txtRemark8.Text == "")
{
MessageBox.Show("样机故障，请输入故障信息", "提示");
return;
}
//借与还操作
if (borrowbll.addBorrow(LoginForm.usrName, this.cbbPhoneName.Text, this.cbbPhoneStage.Text, this.cbbPhoneNum8.Text, LoginForm.usrName))
{
}
else
{
MessageBox.Show(this.cbbPhoneNum8.Text + "借错误", "提示");
}
if (borrowbll.returnPhone(LoginForm.usrName, cbbPhoneName.Text, cbbPhoneStage.Text, cbbPhoneNum8.Text, cbbHGroupTest.Text, cbbIsNormal8.Text, txtRemark8.Text))
{
//MessageBox.Show("操作成功", "提示");
}
else
{
MessageBox.Show(this.cbbPhoneNum8.Text + "还错误", "提示");
}
}
//操作10
if (cbbPhoneNum9.Text != "")
{
//样机状态是否正常，若是故障时需要输入备注
if (cbbIsNormal9.Text == "故障" && txtRemark9.Text == "")
{
MessageBox.Show("样机故障，请输入故障信息", "提示");
return;
}
//借与还操作
if (borrowbll.addBorrow(LoginForm.usrName, this.cbbPhoneName.Text, this.cbbPhoneStage.Text, this.cbbPhoneNum9.Text, LoginForm.usrName))
{
}
else
{
MessageBox.Show(this.cbbPhoneNum9.Text + "借错误", "提示");
}
if (borrowbll.returnPhone(LoginForm.usrName, cbbPhoneName.Text, cbbPhoneStage.Text, cbbPhoneNum9.Text, cbbHGroupTest.Text, cbbIsNormal9.Text, txtRemark9.Text))
{
//MessageBox.Show("操作成功", "提示");
}
else
{
MessageBox.Show(this.cbbPhoneNum9.Text + "还错误", "提示");
}
}
MessageBox.Show("操作成功");
}
string strSql = "select * from PmBorrow where StaffName = '" + LoginForm.usrName + "' 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 = "";
//收尾工作：清空无关信息
txtRemark.Text = "";
txtRemark1.Text = "";
txtRemark2.Text = "";
txtRemark3.Text = "";
txtRemark4.Text = "";
txtRemark5.Text = "";
txtRemark6.Text = "";
txtRemark7.Text = "";
txtRemark8.Text = "";
txtRemark9.Text = "";
//默认正常
cbbIsNormal.Text = "正常";
cbbIsNormal1.Text = "正常";
cbbIsNormal2.Text = "正常";
cbbIsNormal3.Text = "正常";
cbbIsNormal4.Text = "正常";
cbbIsNormal5.Text = "正常";
cbbIsNormal6.Text = "正常";
cbbIsNormal7.Text = "正常";
cbbIsNormal8.Text = "正常";
cbbIsNormal9.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 = "";
}
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 button1_Click(object sender, EventArgs e) //借样机按钮
{
string ip = Fuctions.GetIpAddress();
if (LoginForm.admin == 0)
{
if (ip != IPADRESS && ip != IPADDRESS1 && ip != IPADRESS2 && ip != IPADRESS3)
{
MessageBox.Show("请去指定电脑进行样机借阅", "提示");
return;
}
}
//MySqlConnection conn = new MySqlConnection(GetConn.connection); //连接对象
BorrowBLL borrowbll = new BorrowBLL();
PhoneBLL phonebll = new PhoneBLL();
if (cbbStaffName.Text == "" || cbbPhoneName.Text == "" || cbbPhoneStage.Text == "" || ((cbbPhoneNum.Text == "") && (cbbPhoneNumL1.Text == "") && (cbbPhoneNumL2.Text == "") && (cbbPhoneNumL3.Text == "") && (cbbPhoneNumL4.Text == "")))
{
MessageBox.Show("请输入样机信息");
return;
}
else
{
if (cbbPhoneNum.Text != "")
{
if (cbbPhoneNum.Text == cbbPhoneNumL1.Text || cbbPhoneNum.Text == cbbPhoneNumL2.Text || cbbPhoneNum.Text == cbbPhoneNumL3.Text || cbbPhoneNum.Text == cbbPhoneNumL4.Text)
{
MessageBox.Show("借阅样机编号重复，请检查编号");
return;
}
if (borrowbll.addBorrow(this.cbbStaffName.Text, this.cbbPhoneName.Text, this.cbbPhoneStage.Text, this.cbbPhoneNum.Text, LoginForm.usrName))
{
//MessageBox.Show("借阅成功");
}
if (phonebll.updatePhoneStatusOut(cbbPhoneName.Text, cbbPhoneStage.Text, cbbPhoneNum.Text)) //更新数据库 PmPhone 中的信息
{
//MessageBox.Show("借阅成功");
}
}
if (cbbPhoneNumL1.Text != "")
{
if (cbbPhoneNumL1.Text == cbbPhoneNum.Text || cbbPhoneNumL1.Text == cbbPhoneNumL2.Text || cbbPhoneNumL1.Text == cbbPhoneNumL3.Text || cbbPhoneNumL1.Text == cbbPhoneNumL4.Text)
{
MessageBox.Show("借阅样机编号重复，请检查编号");
return;
}
if (borrowbll.addBorrow(this.cbbStaffName.Text, this.cbbPhoneName.Text, this.cbbPhoneStage.Text, this.cbbPhoneNumL1.Text, LoginForm.usrName))
{
//MessageBox.Show("借阅成功");
}
if (phonebll.updatePhoneStatusOut(cbbPhoneName.Text, cbbPhoneStage.Text, cbbPhoneNumL1.Text)) //更新数据库 PmPhone 中的信息
{
//MessageBox.Show("借阅成功");
}
}
if (cbbPhoneNumL2.Text != "")
{
if (cbbPhoneNumL2.Text == cbbPhoneNum.Text || cbbPhoneNumL2.Text == cbbPhoneNumL1.Text || cbbPhoneNumL2.Text == cbbPhoneNumL3.Text || cbbPhoneNumL2.Text == cbbPhoneNumL4.Text)
{
MessageBox.Show("借阅样机编号重复，请检查编号");
return;
}
if (borrowbll.addBorrow(this.cbbStaffName.Text, this.cbbPhoneName.Text, this.cbbPhoneStage.Text, this.cbbPhoneNumL2.Text, LoginForm.usrName))
{
//MessageBox.Show("借阅成功");
}
if (phonebll.updatePhoneStatusOut(cbbPhoneName.Text, cbbPhoneStage.Text, cbbPhoneNumL2.Text)) //更新数据库 PmPhone 中的信息
{
//MessageBox.Show("借阅成功");
}
}
if (cbbPhoneNumL3.Text != "")
{
if (cbbPhoneNumL3.Text == cbbPhoneNum.Text || cbbPhoneNumL3.Text == cbbPhoneNumL1.Text || cbbPhoneNumL3.Text == cbbPhoneNumL2.Text || cbbPhoneNumL3.Text == cbbPhoneNumL4.Text)
{
MessageBox.Show("借阅样机编号重复，请检查编号");
return;
}
if (borrowbll.addBorrow(this.cbbStaffName.Text, this.cbbPhoneName.Text, this.cbbPhoneStage.Text, this.cbbPhoneNumL3.Text, LoginForm.usrName))
{
//MessageBox.Show("借阅成功");
}
if (phonebll.updatePhoneStatusOut(cbbPhoneName.Text, cbbPhoneStage.Text, cbbPhoneNumL3.Text)) //更新数据库 PmPhone 中的信息
{
//MessageBox.Show("借阅成功");
}
}
if (cbbPhoneNumL4.Text != "")
{
if (cbbPhoneNumL4.Text == cbbPhoneNum.Text || cbbPhoneNumL4.Text == cbbPhoneNumL1.Text || cbbPhoneNumL4.Text == cbbPhoneNumL2.Text || cbbPhoneNumL4.Text == cbbPhoneNumL3.Text)
{
MessageBox.Show("借阅样机编号重复，请检查编号");
return;
}
if (borrowbll.addBorrow(this.cbbStaffName.Text, this.cbbPhoneName.Text, this.cbbPhoneStage.Text, this.cbbPhoneNumL4.Text, LoginForm.usrName))
{
//MessageBox.Show("借阅成功");
}
if (phonebll.updatePhoneStatusOut(cbbPhoneName.Text, cbbPhoneStage.Text, cbbPhoneNumL4.Text)) //更新数据库 PmPhone 中的信息
{
//MessageBox.Show("借阅成功");
}
}
MessageBox.Show("借阅成功");
}
borrows = borrowbll.GetAllBorrow(); //DataGridView显示所借样机
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 PmStaff"; //还员工姓名combobox内容加载--cbbPhoneName1--cbbPhoneStage1--cbbPhoneNum1
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, "PmStaff");
conn.Close();
cbbStaffName1.DisplayMember = "StaffName";
cbbStaffName1.ValueMember = "StaffName";
cbbStaffName1.DataSource = ds.Tables["PmStaff"];
cbbStaffName1.Text = "";
}
private void PhoneInfoForm_Load(object sender, EventArgs e)
{
cbbPhoneDisplay.DropDownStyle = ComboBoxStyle.DropDownList;
cbbPhoneNameD.DropDownStyle = ComboBoxStyle.DropDownList;
cbbPhoneStageD.DropDownStyle = ComboBoxStyle.DropDownList;
cbbPhoneOwner.DropDownStyle = ComboBoxStyle.DropDown;
cbbPhoneStage.DropDownStyle = ComboBoxStyle.DropDown;
this.Width = Fuctions.winFormWidth;
this.Height = Fuctions.winFormHeight;
PhoneBLL phonebll = new PhoneBLL();
phones = phonebll.getAllPhones();
PhoneDataGrid.DataSource = phones; //将数据库中的数据提到列表中，再通过 DataGrid控件显示；
PhoneDataGrid.ReadOnly = true;
PhoneDataGrid.Width = Fuctions.dataGridViewWidth;
//PhoneDataGrid.Height = 300;
PhoneDataGrid.Location = new Point(Fuctions.dataGridViewLocationX, Fuctions.dataGridViewLocationY);
PhoneDataGrid.Columns[0].HeaderText = "主键"; //修改显示的列名
PhoneDataGrid.Columns[0].Visible = false;
PhoneDataGrid.Columns[1].HeaderText = "Phone ID";
PhoneDataGrid.Columns[2].HeaderText = "名称";
PhoneDataGrid.Columns[3].HeaderText = "阶段";
PhoneDataGrid.Columns[4].HeaderText = "编号";
PhoneDataGrid.Columns[5].HeaderText = "状态";
PhoneDataGrid.Columns[6].HeaderText = "备注";
PhoneDataGrid.Columns[7].HeaderText = "接口人";
PhoneDataGrid.Columns[8].HeaderText = "显示";
PhoneDataGrid.Columns[8].Visible = false;
PhoneDataGrid.Columns[9].HeaderText = "主管";
PhoneDataGrid.Columns[10].HeaderText = "启用时间";
PhoneDataGrid.Columns[1].Width = 80;
PhoneDataGrid.Columns[2].Width = Fuctions.dataGridViewPhoneName;
PhoneDataGrid.Columns[3].Width = 80;
PhoneDataGrid.Columns[4].Width = Fuctions.dataGridViewPhoneNum;;
PhoneDataGrid.Columns[5].Width = 50;
PhoneDataGrid.Columns[6].Width = Fuctions.dataGridViewNote;
PhoneDataGrid.Columns[7].Width = 50;
PhoneDataGrid.Columns[8].Width = 50;
PhoneDataGrid.Columns[9].Width = 50;
PhoneDataGrid.Columns[10].Width = 120;
Fuctions.AutoSize(PhoneDataGrid);
//StageBLL stagebll = new StageBLL(); //从数据库中读出状态信息，显示于CBB中。
//stages = stagebll.getAllStages();
//cbbPhoneStage.DataSource = stages;
//cbbPhoneStage.DisplayMember = "StageName";
//cbbPhoneStage.ValueMember = "StageName";
//cbbPhoneStage.SelectedIndex = -1;
//cbbPhoneStage.Text = "";
//***********************************************样机是否显示 cbb内容更新
string strSql = "select distinct PhoneName from PmPhone order by PhoneName asc"; //样机名称cbbD内容加载
MySqlCommand cmd = new MySqlCommand(strSql, conn);
MySqlDataAdapter da = new MySqlDataAdapter(cmd);
DataSet ds = new DataSet();
conn.Open();
da.Fill(ds, "PmPhone");
conn.Close();
cbbPhoneNameD.DisplayMember = "PhoneName";
cbbPhoneNameD.ValueMember = "PhoneName";
cbbPhoneNameD.DataSource = ds.Tables["PmPhone"];
cbbPhoneNameD.SelectedIndex = -1;
//cbbPhoneNameD.Text = "";
}
public ActionResult Edit(Phone phone)
{
PhoneBLL.UpdateIntoPhone(phone);
return(RedirectToAction("Phone"));
}
private void btnOk_Click(object sender, EventArgs e)
{
string strSql = "select * from PmBorrow where 1=1";
string strSqlNum = "select * from PmPhone where 1 = 1";
string strSqlNumOut = "select * from PmPhone where 1 = 1 and PhoneStatus = '借出'";
string num = "";
string numOut = "";
txtNum.Text = "";
txtNumOut.Text = "";
if (cbbStaffName.Text == "" && cbbPhoneName.Text == "" && cbbPhoneStage.Text == "" && cbbPhoneNum.Text == "" &&
cbbHGroupTest.Text == "" && cbbIsNormal.Text == "" && cbbIsReturn.Text == "")
{
MessageBox.Show("请选择查询条件", "提示");
return;
}
if (cbbStaffName.Text != "")
{
strSql = strSql + " and StaffName ='" + cbbStaffName.Text + "'";
}
if (cbbPhoneName.Text != "")
{
strSql = strSql + " and PhoneName ='" + cbbPhoneName.Text + "'";
}
if (cbbPhoneStage.Text != "")
{
strSql = strSql + " and PhoneStage ='" + cbbPhoneStage.Text + "'";
}
if (cbbPhoneNum.Text != "")
{
strSql = strSql + " and PhoneNum ='" + cbbPhoneNum.Text + "'";
}
if (cbbHGroupTest.Text != "")
{
strSql = strSql + " and Test ='" + cbbHGroupTest.Text + "'";
}
if (cbbIsNormal.Text != "")
{
strSql = strSql + " and IsNormal ='" + cbbIsNormal.Text + "'";
}
if (cbbIsReturn.Text != "")
{
strSql = strSql + " and IsReturn ='" + cbbIsReturn.Text + "'";
}
strSql = strSql + " order by BorrowID desc";
BorrowBLL borrowbll = new BorrowBLL();
borrows = borrowbll.selByCondition(strSql);
borrowQDataGrid.DataSource = borrows;
PhoneBLL phonebll = new PhoneBLL();
if (cbbPhoneName.Text != "")
{
strSqlNum = strSqlNum + " and PhoneName ='" + cbbPhoneName.Text + "'";
strSqlNumOut = strSqlNumOut + " and PhoneName ='" + cbbPhoneName.Text + "'";
if (cbbPhoneStage.Text != "")
{
strSqlNum = strSqlNum + " and PhoneStage ='" + cbbPhoneStage.Text + "'";
strSqlNumOut = strSqlNumOut + " and PhoneStage ='" + cbbPhoneStage.Text + "'";
}
num = phonebll.selByConditionNum(strSqlNum);
numOut = phonebll.selByConditionNum(strSqlNumOut);
txtNum.Text = num;
txtNumOut.Text = numOut;
}
}
public ActionResult Details(int ID)
{
return(View(PhoneBLL.GetSinglePhone(ID)));
}
// GET: Phone
public ActionResult Phone()
{
return(View(PhoneBLL.GetAllPhone()));
}
private void button1_Click(object sender, EventArgs e) //借样机按钮
{
string ip = Fuctions.GetIpAddress();
if (LoginForm.admin == 0)
{
if (ip != IPADRESS && ip != IPADDRESS1 && ip != IPADRESS2 && ip != IPADRESS3)
{
MessageBox.Show("请去指定电脑进行样机借阅", "提示");
return;
}
}
BorrowBLL borrowbll = new BorrowBLL();
PhoneBLL phonebll = new PhoneBLL();
if (cbbPhoneName.Text == "" || cbbPhoneStage.Text == "" || ((cbbPhoneNum.Text == "") && (cbbPhoneNumL1.Text == "") && (cbbPhoneNumL2.Text == "") && (cbbPhoneNumL3.Text == "") && (cbbPhoneNumL4.Text == "")))
{
MessageBox.Show("请输入样机信息");
return;
}
else
{
if (cbbPhoneNum.Text != "")
{
if (cbbPhoneNum.Text == cbbPhoneNumL1.Text || cbbPhoneNum.Text == cbbPhoneNumL2.Text || cbbPhoneNum.Text == cbbPhoneNumL3.Text || cbbPhoneNum.Text == cbbPhoneNumL4.Text)
{
MessageBox.Show("借阅样机编号重复，请检查编号");
return;
}
if (borrowbll.addBorrow(LoginForm.usrName, this.cbbPhoneName.Text, this.cbbPhoneStage.Text, this.cbbPhoneNum.Text, LoginForm.usrName))
{
//MessageBox.Show("借阅成功");
}
if (phonebll.updatePhoneStatusOut(cbbPhoneName.Text, cbbPhoneStage.Text, cbbPhoneNum.Text)) //更新数据库 PmPhone 中的信息
{
//MessageBox.Show("借阅成功");
}
}
if (cbbPhoneNumL1.Text != "")
{
if (cbbPhoneNumL1.Text == cbbPhoneNum.Text || cbbPhoneNumL1.Text == cbbPhoneNumL2.Text || cbbPhoneNumL1.Text == cbbPhoneNumL3.Text || cbbPhoneNumL1.Text == cbbPhoneNumL4.Text)
{
MessageBox.Show("借阅样机编号重复，请检查编号");
return;
}
if (borrowbll.addBorrow(LoginForm.usrName, this.cbbPhoneName.Text, this.cbbPhoneStage.Text, this.cbbPhoneNumL1.Text, LoginForm.usrName))
{
//MessageBox.Show("借阅成功");
}
if (phonebll.updatePhoneStatusOut(cbbPhoneName.Text, cbbPhoneStage.Text, cbbPhoneNumL1.Text)) //更新数据库 PmPhone 中的信息
{
//MessageBox.Show("借阅成功");
}
}
if (cbbPhoneNumL2.Text != "")
{
if (cbbPhoneNumL2.Text == cbbPhoneNum.Text || cbbPhoneNumL2.Text == cbbPhoneNumL1.Text || cbbPhoneNumL2.Text == cbbPhoneNumL3.Text || cbbPhoneNumL2.Text == cbbPhoneNumL4.Text)
{
MessageBox.Show("借阅样机编号重复，请检查编号");
return;
}
if (borrowbll.addBorrow(LoginForm.usrName, this.cbbPhoneName.Text, this.cbbPhoneStage.Text, this.cbbPhoneNumL2.Text, LoginForm.usrName))
{
//MessageBox.Show("借阅成功");
}
if (phonebll.updatePhoneStatusOut(cbbPhoneName.Text, cbbPhoneStage.Text, cbbPhoneNumL2.Text)) //更新数据库 PmPhone 中的信息
{
//MessageBox.Show("借阅成功");
}
}
if (cbbPhoneNumL3.Text != "")
{
if (cbbPhoneNumL3.Text == cbbPhoneNum.Text || cbbPhoneNumL3.Text == cbbPhoneNumL1.Text || cbbPhoneNumL3.Text == cbbPhoneNumL2.Text || cbbPhoneNumL3.Text == cbbPhoneNumL4.Text)
{
MessageBox.Show("借阅样机编号重复，请检查编号");
return;
}
if (borrowbll.addBorrow(LoginForm.usrName, this.cbbPhoneName.Text, this.cbbPhoneStage.Text, this.cbbPhoneNumL3.Text, LoginForm.usrName))
{
//MessageBox.Show("借阅成功");
}
if (phonebll.updatePhoneStatusOut(cbbPhoneName.Text, cbbPhoneStage.Text, cbbPhoneNumL3.Text)) //更新数据库 PmPhone 中的信息
{
//MessageBox.Show("借阅成功");
}
}
if (cbbPhoneNumL4.Text != "")
{
if (cbbPhoneNumL4.Text == cbbPhoneNum.Text || cbbPhoneNumL4.Text == cbbPhoneNumL1.Text || cbbPhoneNumL4.Text == cbbPhoneNumL2.Text || cbbPhoneNumL4.Text == cbbPhoneNumL3.Text)
{
MessageBox.Show("借阅样机编号重复，请检查编号");
return;
}
if (borrowbll.addBorrow(LoginForm.usrName, this.cbbPhoneName.Text, this.cbbPhoneStage.Text, this.cbbPhoneNumL4.Text, LoginForm.usrName))
{
//MessageBox.Show("借阅成功");
}
if (phonebll.updatePhoneStatusOut(cbbPhoneName.Text, cbbPhoneStage.Text, cbbPhoneNumL4.Text)) //更新数据库 PmPhone 中的信息
{
//MessageBox.Show("借阅成功");
}
}
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 = "";
}
