//private void tsmiChuBan_Click(object sender, EventArgs e) //{ // //获取选择到的列和行 // List<int> selectRows= new List<int>(); // // List<int> selectColumns = new List<int>(); // foreach (DataGridViewCell cell in this.dgvJob.SelectedCells) // { // if (!selectRows.Contains(cell.RowIndex)) // { // selectRows.Add(cell.RowIndex); // } // //if (!selectColumns.Contains(cell.ColumnIndex)) // //{ // // selectColumns.Add(cell.ColumnIndex); // //} // } // List <string> sqlList=new List<string>() ; // foreach (int selectRowIndex in selectRows) // { // DataGridViewRow dgvr = this.dgvJob.Rows[selectRowIndex]; // string InsertString = "INSERT INTO [JobPublished]([gdh],[sjjt]," // + "[khjc],[cpmc],[zzcc],[mzcc],[ss1],[ss2],[sbs],[bz],[yk]," // + "[ExcelFile],[Published])VALUES(" // +"'" +this.dgvJob["ColumnGdh", selectRowIndex].Value.ToString() + "'," // + "'" + this.dgvJob["ColumnSjjt", selectRowIndex].Value.ToString() + "'," // + "'" + this.dgvJob["ColumnKhjc", selectRowIndex].Value.ToString() + "'," // + "'" + this.dgvJob["ColumnCpmc", selectRowIndex].Value.ToString() + "'," // + "'" + this.dgvJob["ColumnZzcc", selectRowIndex].Value.ToString() + "'," // + "'" + this.dgvJob["ColumnMzcc", selectRowIndex].Value.ToString() + "'," // + "'" + this.dgvJob["ColumnSs1", selectRowIndex].Value.ToString() + "'," // + "'" + this.dgvJob["ColumnSs2", selectRowIndex].Value.ToString() + "'," // + "'" + this.dgvJob["ColumnSbs", selectRowIndex].Value.ToString() + "'," // + "'" + this.dgvJob["ColumnBz", selectRowIndex].Value.ToString() + "'," // + "'" + this.dgvJob["ColumnYk", selectRowIndex].Value.ToString() + "'," // + "'" + this.dgvJob["ColumnExcelFile", selectRowIndex].Value.ToString() + "'," // + 1+");"; // sqlList.Add(InsertString); // } // SQLiteList.YbfSQLite.ExecuteSqlTran(sqlList); //} private void tsmiStatistics_Click(object sender, EventArgs e) { List <DataTable> dtList = new List <DataTable>(); foreach (TreeNode item in this.treeViewExcel.Nodes) { try { if (item.Checked) { ExcelFileInfo excel = item.Tag as ExcelFileInfo; DataTable dt = Comm_Method.GetPublishDataTableFromExcelFile(excel.FileFullName); if (dt != null && dt.Rows.Count > 0) { dtList.Add(dt); } } } catch (Exception) { continue; } } if (dtList.Count > 0) { DataTable dtAll = dtList[0].Clone(); foreach (DataTable item in dtList) { dtAll.Merge(item); } //分类汇总 Dictionary <string, int> dicCount = new Dictionary <string, int>(); foreach (DataRow row in dtAll.Rows) { try { string jitai = dic_jitai[row["上机机台"].ToString()]; int shuliang = Convert.ToInt32(row["晒版数"]); if (dicCount.ContainsKey(jitai)) { dicCount[jitai] += shuliang; } else { dicCount.Add(jitai, shuliang); } } catch (Exception) { continue; } } //显示数量 StringBuilder sb = new StringBuilder(); int sum = 0; foreach (string key in dicCount.Keys) { sb.AppendLine(key + ":" + dicCount[key]); sum += dicCount[key]; } if (sum > 0 && sb.Length > 0) { sb.AppendLine("------------"); sb.AppendLine(" 共计:" + sum); } MessageBox.Show(sb.ToString()); } else { return; } }
private void tsmiBaoBiao_Click(object sender, EventArgs e) { char[] InvalidFileNameChars = Path.GetInvalidFileNameChars(); string[] pdfFiles = Directory.GetFiles(@"\\128.1.30.144\JobData\pdf\已下单PDF" , "*.pdf", SearchOption.AllDirectories); List <DataTable> dtList = new List <DataTable>(); foreach (TreeNode item in this.treeViewExcel.Nodes) { if (item.Checked) { ExcelFileInfo excel = item.Tag as ExcelFileInfo; DataTable dt = Comm_Method.GetPublishDataTableFromExcelFile(excel.FileFullName); if (dt != null && dt.Rows.Count > 0) { dtList.Add(dt); } } } if (dtList.Count > 0) { DataTable dtAll = dtList[0].Clone(); foreach (DataTable item in dtList) { dtAll.Merge(item); } //剔除旧版 DataTable dt_baobiao = new DataTable(); dt_baobiao.Columns.Add("日期"); dt_baobiao.Columns.Add("产品名称"); dt_baobiao.Columns.Add("制造尺寸"); dt_baobiao.Columns.Add("面纸尺寸"); dt_baobiao.Columns.Add("输出颜色"); dt_baobiao.Columns.Add("网线"); dt_baobiao.Columns.Add("机台"); dt_baobiao.Columns.Add("咬口"); dt_baobiao.Columns.Add("备注"); foreach (DataRow row in dtAll.Select("备注<>'旧版'")) { DataRow newRow = dt_baobiao.NewRow(); newRow["日期"] = DateTime.Now.AddHours(-6).ToString("yyyy-MM-dd"); //newRow["产品名称"] = row["客户简称"].ToString()+row["产品名称"].ToString(); // newRow["产品名称"] = pdfFiles.First<string>(pp => pp.Contains(row["产品名称"].ToString())); newRow["制造尺寸"] = row["制造尺寸"].ToString().Replace('x', '*'); newRow["面纸尺寸"] = row["面纸尺寸"].ToString().Replace('x', '*'); newRow["网线"] = "175"; newRow["机台"] = dic_jitai[row["上机机台"].ToString()]; newRow["咬口"] = ""; newRow["备注"] = ""; //***确认产品名称 string cpmc = row["产品名称"].ToString().Replace('*', 'x'); bool cunzai = false; foreach (string pdffile in pdfFiles) { foreach (char Invalid in InvalidFileNameChars) { cpmc = cpmc.Replace(Invalid, '-'); } if (pdffile.Contains(cpmc)) { cpmc = Path.GetFileNameWithoutExtension(pdffile); cunzai = true; break; } } if (cunzai) { newRow["产品名称"] = cpmc; } else { newRow["产品名称"] = "【【" + cpmc + "】】"; } //输出颜色 string scys = ""; string ss1 = row["色数1"].ToString(); string ss2 = row["色数2"].ToString(); if (ss1 == "4") { scys = "CMYK"; } if (!string.IsNullOrWhiteSpace(ss2)) { if (ss2 == "1") { scys += (string.IsNullOrWhiteSpace(ss1)?"专":"+专"); } else { string zs = string.Format("{0}专", ss2); scys += (string.IsNullOrWhiteSpace(ss1) ? zs : "+" + zs); } } newRow["输出颜色"] = scys; //进行AB面完全一致的判断 bool isAB = false; foreach (DataRow row_Baobiao in dt_baobiao.Rows) { isAB = IsABside(row_Baobiao, newRow); if (isAB) { if (row_Baobiao["输出颜色"].ToString().Contains('+')) { row_Baobiao["输出颜色"] = "(" + row_Baobiao["输出颜色"] + ")*2"; } else { row_Baobiao["输出颜色"] = row_Baobiao["输出颜色"] + "*2"; } row_Baobiao["产品名称"] = row_Baobiao["产品名称"].ToString().Replace("B面", "A面").Replace("b面", "A面"); break; } } if (isAB) { continue; } dt_baobiao.Rows.Add(newRow); } new FormBaoBiao(dt_baobiao).ShowDialog(); } else { return; } }
private void tsmiShow_Click(object sender, EventArgs e) { this.dgvJob.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.None; this.dgvJob.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.None; //this.dgvJob.Rows.Clear(); List <DataTable> dtList = new List <DataTable>(); foreach (TreeNode item in this.treeViewExcel.Nodes) { if (item.Checked) { ExcelFileInfo excel = item.Tag as ExcelFileInfo; DataTable dt = Comm_Method.GetPublishDataTableFromExcelFile(excel.FileFullName); if (dt != null && dt.Rows.Count > 0) { dtList.Add(dt); } } } if (dtList.Count < 1) { return; } // AddToDgv(dtList); //********** DataTable dtAll = dtList[0].Clone(); foreach (DataTable item in dtList) { dtAll.Merge(item); } //删除重复的数据 for (int i = dtAll.Rows.Count - 1; i > 0; i--) { bool isCome = true; foreach (DataRow row in dtAll.Rows) { foreach (DataColumn column in dtAll.Columns) { if (!dtAll.Rows[i][column].ToString().Equals(row[column].ToString())) { isCome = false; break; } } if (isCome) { break; } } if (isCome) { dtAll.Rows.RemoveAt(i); } } this.dgvJob.DataSource = dtAll; this.dgvJob.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; this.dgvJob.RowsDefaultCellStyle.WrapMode = DataGridViewTriState.True; }