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