/// <summary> /// 得到一个对象实体 /// </summary> public tb_settings Find() { StringBuilder strSql = new StringBuilder(); strSql.Append("select id, PicSaveStyle, PicPath,isNeedRate"); strSql.Append(" from tb_Settings "); tb_settings model = new tb_settings(); DataSet ds = dbl.ds(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } if (ds.Tables[0].Rows[0]["PicSaveStyle"].ToString() != "") { model.PicSaveStyle = int.Parse(ds.Tables[0].Rows[0]["PicSaveStyle"].ToString()); } model.PicPath = ds.Tables[0].Rows[0]["PicPath"].ToString(); if (ds.Tables[0].Rows[0]["isNeedRate"].ToString() != "") { model.IsNeedRate = int.Parse(ds.Tables[0].Rows[0]["isNeedRate"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(tb_settings model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_Settings set "); strSql.Append(" id = @id , "); strSql.Append(" PicSaveStyle = @PicSaveStyle , "); strSql.Append(" PicPath = @PicPath "); strSql.Append(" isNeedRate = @isNeedRate "); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@PicSaveStyle", SqlDbType.Int, 4), new SqlParameter("@PicPath", SqlDbType.VarChar, 2000), new SqlParameter("@isNeedRate", SqlDbType.Int, 4) }; parameters[0].Value = model.id; parameters[1].Value = model.PicSaveStyle; parameters[2].Value = model.PicPath; parameters[3].Value = model.IsNeedRate; int rows = dbl.ExeInfochange(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
private void frmSelpainSumRpt_Load(object sender, EventArgs e) { setting = settingmethod.Find(); isNeedRate = setting.IsNeedRate == 1; //BindGood(); BindColor(); BindModel(); tb_BaseMgr.SetCombox("material", cmbMaterial); tb_BaseMgr.SetCombox("KilnNO", cmbkilnno); tb_BaseMgr.SetCombox("worknum", cbworknum); cmbMaterial.SelectedValue = ""; //cmbgoodid.Text = ""; cmbmodelrpt.Text = ""; cmbcolorrpt.Text = ""; cbworknum.SelectedValue = ""; cmbkilnno.SelectedValue = ""; Boolean IsGm = frmLogin.isGm || frmLogin.isSuperGm; string username = frmLogin.userName; string usercode = frmLogin.userCode; tb_EmpInfoMenthod.SetCombox(cmbOpr); if (!IsGm) { cmbOpr.Enabled = false; cmbOpr.SelectedValue = usercode; } else { cmbOpr.SelectedValue = ""; } InitializeRptGrid(); //asc.controllInitializeSize(this); }
private void LoadSettings() { setting = settingMethod.Find(); switch (setting.PicSaveStyle) { case 0: rdbLocal.Checked = true; break; case 1: rdbServer.Checked = true; break; } tbPath.Text = setting.PicPath; ckbIsNeedRate.Checked = setting.IsNeedRate == 1; }
private void btnSaveClick(object sender, EventArgs e) { try { if (CheckValidate()) { setting = settingMethod.Find(); if (toolbar1.flag == 0)//新增 { good.strGoodsId = tbgoodid.Text.Trim(); good.strGoodsName = tbgoodname.Text.Trim(); //good.strItemNO = good.strModelNO = tbmono.Text.Trim(); good.strFColor = cmbColor.SelectedValue.ToString(); good.strFTypeSteps1 = tbftypestep1.Text != "" ? tbftypestep1.SelectedValue.ToString() : ""; good.strFTypeSteps2 = tbftypestep2.Text != "" ? tbftypestep2.SelectedValue.ToString() : ""; good.strFTypeSteps3 = tbftypestep3.Text != "" ? tbftypestep3.SelectedValue.ToString() : ""; good.strFColorSteps = tbfcolorsteps.Text != "" ? tbfcolorsteps.SelectedValue.ToString() : ""; good.iFIsStop = ckbifstop.Checked ? 1 : 0; good.strGoodMaterial = cmbMaterial.Text != "" ? cmbMaterial.SelectedValue.ToString() : ""; good.strFMaterialQty = tbmqty.Text.Trim(); good.strFCreater = frmLogin1.userName; good.dFCreateDate = System.DateTime.Now; System.IO.MemoryStream Ms = new MemoryStream(); if (setting.PicSaveStyle == 0) { if (pathName != "") { good.strFImagePath = UploadImage(); } } else { good.strFImagePath = setting.PicPath + good.strGoodsId + ".jpg"; } //Ms.Close(); if (goodmethod.tb_SpGoodsInfoAdd(good) == 1) { MessageUtil.ShowTips("保存成功!"); } if (toolbar1.cbcontinue.Checked) { ClearControls(); ClearBindings(); tbgoodid.Focus(); } //FreshGoods(); } else { good.strGoodsId = tbgoodid.Text.Trim(); good.strGoodsName = tbgoodname.Text.Trim(); //good.strItemNO = good.strModelNO = tbmono.Text.Trim(); good.strFColor = cmbColor.SelectedValue.ToString(); good.strFTypeSteps1 = tbftypestep1.Text != "" ? tbftypestep1.SelectedValue.ToString() : ""; good.strFTypeSteps2 = tbftypestep2.Text != "" ? tbftypestep2.SelectedValue.ToString() : ""; good.strFTypeSteps3 = tbftypestep3.Text != "" ? tbftypestep3.SelectedValue.ToString() : ""; good.strFColorSteps = tbfcolorsteps.Text != "" ? tbfcolorsteps.SelectedValue.ToString() : ""; good.iFIsStop = ckbifstop.Checked ? 1 : 0; good.strGoodMaterial = cmbMaterial.Text != "" ? cmbMaterial.SelectedValue.ToString() : ""; good.strFCreater = frmLogin1.userName; good.dFCreateDate = System.DateTime.Now; good.strFMaterialQty = tbmqty.Text.Trim(); if (setting.PicSaveStyle == 0) { if (pathName != "") { good.strFImagePath = UploadImage(); } } else { good.strFImagePath = setting.PicPath + good.strGoodsId + ".jpg"; } if (!string.IsNullOrEmpty(editGoodID)) { if (goodmethod.tb_SpgoodUpdate(good, editGoodID) == 1) { MessageUtil.ShowTips("保存成功!"); } } else if (goodmethod.tb_SpgoodUpdate(good) == 1) { MessageUtil.ShowTips("保存成功!"); } SetControlsReadOnly(true); } FreshGoods(); } } catch (Exception) { MessageUtil.ShowWarning("保存失败!"); } }
private void buttonX1_Click(object sender, EventArgs e) { string fileName = "";//保存的excel文件名 SaveFileDialog sfd = new SaveFileDialog(); sfd.Filter = "导出Excel(*.xls)|*.xls"; sfd.FileName = "质量分析日报表"; string[] faltsArray = { "加工斑点", "针孔", "斑点", "阴裂", "凹凸", "泥渣", "缺泥", "粗糙", "开裂", "裂耳", "变形", "其他", "小计", "色不均", "色脏", "缺釉", "釉彩斑点", "缩釉", "釉缕", "毛孔", "落渣", "粘疤", "粘渣脚", "伤裂", "薄釉", "其他","小计", "欠火", "过火", "釉泡", "出损", "其他", "小计" }; setting = settingMethod.Find(); isNeedRate = setting.IsNeedRate == 0 ? false : true; DataSet ds = (DataSet)rptGrid.PrimaryGrid.DataSource; if (ds != null) { if (sfd.ShowDialog() == DialogResult.OK) { fileName = sfd.FileName; int columnNums = rptGrid.PrimaryGrid.Columns.Count; //列数; int rowNums = rptGrid.PrimaryGrid.Rows.Count; //行数 HSSFWorkbook book = new HSSFWorkbook(); ISheet sheet = book.CreateSheet("sheet1"); IRow row = sheet.CreateRow(0); ICellStyle style = book.CreateCellStyle(); style.FillForegroundColor = NPOI.HSSF.Util.HSSFColor.Red.Index; style.FillPattern = FillPattern.SolidForeground; NpoiExcelHelper.setMergedRegion(sheet, row, 0, "产品编号", 0, 2, 0, 0); NpoiExcelHelper.setMergedRegion(sheet, row, 1, "器型名称", 0, 2, 1, 1); NpoiExcelHelper.setMergedRegion(sheet, row, 2, "花色名称", 0, 2, 2, 2); NpoiExcelHelper.setMergedRegion(sheet, row, 3, "窑炉编号", 0, 2, 3, 3); NpoiExcelHelper.setMergedRegion(sheet, row, 4, "瓷质", 0, 2, 4, 4); NpoiExcelHelper.setMergedRegion(sheet, row, 5, "班次", 0, 2, 5, 5); NpoiExcelHelper.setMergedRegion(sheet, row, 6, "成型工艺", 0, 2, 6, 6); NpoiExcelHelper.setMergedRegion(sheet, row, 7, "瓷重", 0, 2, 7, 7); NpoiExcelHelper.setMergedRegion(sheet, row, 8, "总数", 0, 2, 8, 8); //NpoiExcelHelper.setMergedRegion(sheet, row, 8, "合计", 0, 2, 8, 8); NpoiExcelHelper.setMergedRegion(sheet, row, 9, "A等品", 0, 0, 9, 12); NpoiExcelHelper.setMergedRegion(sheet, row, 13, "B等品", 0, 0, 13, 16); NpoiExcelHelper.setMergedRegion(sheet, row, 17, "C等品", 0, 1, 17, 18); NpoiExcelHelper.setMergedRegion(sheet, row, 19, "补釉", 0, 1, 19, 20); NpoiExcelHelper.setMergedRegion(sheet, row, 21, "废品", 0, 1, 21, 22); NpoiExcelHelper.setMergedRegion(sheet, row, 23, "小计", 0, 1, 23, 24); NpoiExcelHelper.setMergedRegion(sheet, row, 25, "成型缺陷", 0, 0, 25, 50); NpoiExcelHelper.setMergedRegion(sheet, row, 51, "釉彩缺陷", 0, 0, 51, 78); NpoiExcelHelper.setMergedRegion(sheet, row, 79, "看火缺陷", 0, 0, 79, 88); IRow row2 = sheet.CreateRow(1); NpoiExcelHelper.setMergedRegion(sheet, row2, 9, "外销", 1, 1, 9, 10); NpoiExcelHelper.setMergedRegion(sheet, row2, 11, "内销", 1, 1, 11, 12); NpoiExcelHelper.setMergedRegion(sheet, row2, 13, "B甲", 1, 1, 13, 14); NpoiExcelHelper.setMergedRegion(sheet, row2, 15, "B等", 1, 1, 15, 16); for (int i = 0; i < faltsArray.Length; i++) { int j = i * 2 + 25; NpoiExcelHelper.setMergedRegion(sheet, row2, j, faltsArray[i], 1, 1, j, j + 1); } IRow row3 = sheet.CreateRow(2); NpoiExcelHelper.setQtyAndRate(row3, 9, 88, isNeedRate); for (int i = 3; i < rowNums + 3; i++)// { IRow r = sheet.CreateRow(i); if (isNeedRate) { for (int j = 0; j < columnNums; j++) { ICell c = r.CreateCell(j); GridRow gr = (GridRow)rptGrid.PrimaryGrid.Rows[i - 3]; //瓷质 if (gr[j].FormattedValue != "")// gc.DataPropertyName == "FMaterial") { c.SetCellValue(gr[j].FormattedValue.ToString()); } else { c.SetCellValue(gr[j].Value == null ? "" : gr[j].Value.ToString()); } string columnname = gr[j].GridColumn.Name; if (columnname.ToUpper().Contains("RATE")) { if (!Convert.IsDBNull(gr[j].Value) && Convert.ToDouble(gr[j].Value) >= 5) { c.CellStyle = style; } } } } else { for (int j = 0; j < 9; j++) { ICell c = r.CreateCell(j); GridRow gr = (GridRow)rptGrid.PrimaryGrid.Rows[i - 3]; //瓷质 if (gr[j].FormattedValue != "")// gc.DataPropertyName == "FMaterial") { c.SetCellValue(gr[j].FormattedValue.ToString()); } else { c.SetCellValue(gr[j].Value == null ? "" : gr[j].Value.ToString()); } } for (int j = 9; j < columnNums; j = j + 2) { ICell c = r.CreateCell(j); CellRangeAddress region = new CellRangeAddress(i, i, j, j + 1); sheet.AddMergedRegion(region); GridRow gr = (GridRow)rptGrid.PrimaryGrid.Rows[i - 3]; //瓷质 if (gr[j].FormattedValue != "")// gc.DataPropertyName == "FMaterial") { c.SetCellValue(gr[j].FormattedValue.ToString()); } else { c.SetCellValue(gr[j].Value == null ? "" : gr[j].Value.ToString()); } } } } FileStream file = new FileStream(fileName, FileMode.OpenOrCreate); book.Write(file); file.Flush(); file.Close(); MessageUtil.ShowTips("导出成功!"); } } }