/// <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("导出成功!");
}
}
}
