/// <summary> /// 根据条件返回单个Cutlist对象 /// </summary> /// <param name="whereSql"></param> /// <returns></returns> public DXFCutList GetDXFCutListByWhereSql(string whereSql) { string sql = "select CutListId,CategoryId,PartDescription,Length,Width,Thickness,Quantity,Materials,PartNo from DXFCutList"; sql += whereSql; SqlDataReader objReader = SQLHelper.GetReader(sql); DXFCutList objDXFCutList = null; if (objReader.Read()) { objDXFCutList = new DXFCutList() { CutListId = Convert.ToInt32(objReader["CutListId"]), CategoryId = Convert.ToInt32(objReader["CategoryId"]), PartDescription = objReader["PartDescription"].ToString(), Length = Convert.ToDecimal(objReader["Length"].ToString()), Width = Convert.ToDecimal(objReader["Width"].ToString()), Thickness = Convert.ToDecimal(objReader["Thickness"].ToString()), Quantity = Convert.ToInt32(objReader["Quantity"]), Materials = objReader["Materials"].ToString(), PartNo = objReader["PartNo"].ToString() }; } objReader.Close(); return(objDXFCutList); }
/// <summary> /// 添加配件信息 /// </summary> /// <param name="objDXFCutList"></param> /// <returns></returns> public bool AddDXFCutList(DXFCutList objDXFCutList) { string sql = "insert into DXFCutList (CategoryId,PartDescription,Length,Width,Thickness,Quantity,Materials,PartNo)"; sql += " values({0},'{1}','{2}','{3}','{4}',{5},'{6}','{7}')"; sql = string.Format(sql, objDXFCutList.CategoryId, objDXFCutList.PartDescription, objDXFCutList.Length, objDXFCutList.Width, objDXFCutList.Thickness, objDXFCutList.Quantity, objDXFCutList.Materials, objDXFCutList.PartNo); try { SQLHelper.GetSingleResult(sql); return(true); } catch (SqlException ex) { //2627 if (ex.Number == 2627) { throw new Exception("信息重复,不能添加重复的项目信息"); } else { throw new Exception("添加配件信息时数据库访问异常" + ex.Message); } } catch (Exception ex) { throw ex; } }
/// <summary> /// 修改配件信息 /// </summary> /// <param name="objDXFCutList"></param> /// <returns></returns> public int EditDXFCutList(DXFCutList objDXFCutList) { string sql = "update DXFCutList set CategoryId={0},PartDescription='{1}',Length='{2}',Width='{3}',"; sql += "Thickness='{4}',Quantity={5},Materials='{6}',PartNo='{7}' where CutListId={8}"; sql = string.Format(sql, objDXFCutList.CategoryId, objDXFCutList.PartDescription, objDXFCutList.Length, objDXFCutList.Width, objDXFCutList.Thickness, objDXFCutList.Quantity, objDXFCutList.Materials, objDXFCutList.PartNo, objDXFCutList.CutListId); try { return(SQLHelper.Update(sql)); } catch (SqlException ex) { throw new Exception("数据库操作出现异常:" + ex.Message); } catch (Exception ex) { throw ex; } }
private void tsmiEditDXFCutList_Click(object sender, EventArgs e) { if (dgvDXFCutList.RowCount == 0) { return; } if (dgvDXFCutList.CurrentRow == null) { return; } string id = dgvDXFCutList.CurrentRow.Cells["CutListId"].Value.ToString(); DXFCutList objDxfCutList = objDxfCutListService.GetDXFCutListById(id); cobCategoryId.Text = objDxfCutList.CategoryId.ToString(); txtPartDescription.Text = objDxfCutList.PartDescription; txtLength.Text = objDxfCutList.Length.ToString(); txtWidth.Text = objDxfCutList.Width.ToString(); txtThickness.Text = objDxfCutList.Thickness.ToString(); txtQuantity.Text = objDxfCutList.Quantity.ToString(); txtMaterials.Text = objDxfCutList.Materials; txtPartNo.Text = objDxfCutList.PartNo; btnDXFCutlist.Text = "修改行"; btnDXFCutlist.Tag = id; }
/// <summary> /// 添加和修改条目 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnDXFCutlist_Click(object sender, EventArgs e) { #region 数据验证 if (cobCategoryId.SelectedIndex == -1) { MessageBox.Show("请选择分类编号", "验证信息"); cobCategoryId.Focus(); return; } if (txtPartDescription.Text.Trim().Length == 0) { MessageBox.Show("请输入部件描述", "验证信息"); txtPartDescription.Focus(); return; } if (txtLength.Text.Trim().Length == 0) { MessageBox.Show("请输入长", "验证信息"); txtLength.Focus(); return; } if (txtWidth.Text.Trim().Length == 0) { MessageBox.Show("请输入宽", "验证信息"); txtWidth.Focus(); return; } if (txtThickness.Text.Trim().Length == 0) { MessageBox.Show("请输入厚度", "验证信息"); txtThickness.Focus(); return; } if (txtQuantity.Text.Trim().Length == 0) { MessageBox.Show("请输入数量", "验证信息"); txtQuantity.Focus(); return; } if (txtMaterials.Text.Trim().Length == 0) { MessageBox.Show("请输入材料", "验证信息"); txtMaterials.Focus(); return; } if (txtPartNo.Text.Trim().Length == 0) { MessageBox.Show("请输入零件号", "验证信息"); txtPartNo.Focus(); return; } #endregion if (btnDXFCutlist.Tag.Equals(0)) { //提交添加 //封装对象 DXFCutList objDxfCutList = new DXFCutList() { CategoryId = Convert.ToInt32(cobCategoryId.Text), PartDescription = txtPartDescription.Text.Trim(), Length = Convert.ToDecimal(txtLength.Text), Width = Convert.ToDecimal(txtWidth.Text), Thickness = Convert.ToDecimal(txtThickness.Text), Quantity = Convert.ToInt32(txtQuantity.Text), Materials = txtMaterials.Text.ToUpper(), PartNo = txtPartNo.Text.ToUpper() }; //提交添加 try { if (objDxfCutListService.AddDXFCutList(objDxfCutList)) { //提示添加成功 MessageBox.Show("配件信息添加成功", "提示信息"); //刷新显示 dgvDXFCutList.DataSource = objDxfCutListService.GetDXFCutListsByCategoryId(cobCategoryId.Text); //清空内容 foreach (Control item in Controls) { if (item is TextBox) { item.Text = ""; } } } } catch (Exception ex) { MessageBox.Show(ex.Message); } } else { //封装对象 DXFCutList objDxfCutList = new DXFCutList() { CutListId = Convert.ToInt32(btnDXFCutlist.Tag), CategoryId = Convert.ToInt32(cobCategoryId.Text), PartDescription = txtPartDescription.Text.Trim(), Length = Convert.ToDecimal(txtLength.Text), Width = Convert.ToDecimal(txtWidth.Text), Thickness = Convert.ToDecimal(txtThickness.Text), Quantity = Convert.ToInt32(txtQuantity.Text), Materials = txtMaterials.Text.ToUpper(), PartNo = txtPartNo.Text.ToUpper() }; //提交修改 //调用后台方法修改对象 try { if (objDxfCutListService.EditDXFCutList(objDxfCutList) == 1) { //提示添加成功 MessageBox.Show("配件信息修改成功", "提示信息"); //刷新显示 dgvDXFCutList.DataSource = objDxfCutListService.GetDXFCutListsByCategoryId(cobCategoryId.Text); //清空内容 foreach (Control item in Controls) { if (item is TextBox) { item.Text = ""; } } btnDXFCutlist.Text = "添加行"; btnDXFCutlist.Tag = 0; } } catch (Exception ex) { MessageBox.Show(ex.Message); } } }