//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;
}
