private void button10_Click(object sender, EventArgs e)
{
OFDScript.Title = "数据库概要设计文档模板";
OFDScript.FileName = "";
//为了获取特定的系统文件夹，可以使用System.Environment类的静态方法GetFolderPath()。该方法接受一个Environment.SpecialFolder枚举，其中可以定义要返回路径的哪个系统目录
OFDScript.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);
OFDScript.Filter = "EXCEL文件(*.xls)|*.xls";
OFDScript.ValidateNames = true; //文件有效性验证ValidateNames，验证用户输入是否是一个有效的Windows文件名
OFDScript.CheckFileExists = true; //验证路径有效性
OFDScript.CheckPathExists = true; //验证文件有效性
try
{
//生成功能外部设计文档
if (OFDScript.ShowDialog() == DialogResult.OK)
{
//MyEXCEL.数据库概要设计文档(dtTableExtendedPropert, OFDScript.FileName, 概要设计字段DT());//FiledDt);
MyEXCEL.f_barcode(OFDScript.FileName);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
private void button12_Click(object sender, EventArgs e)
{
OFDScript.Title = "数据库概要设计文档模板";
OFDScript.FileName = "";
//为了获取特定的系统文件夹，可以使用System.Environment类的静态方法GetFolderPath()。该方法接受一个Environment.SpecialFolder枚举，其中可以定义要返回路径的哪个系统目录
OFDScript.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);
OFDScript.Filter = "EXCEL文件(*.xls)|*.xls";
OFDScript.ValidateNames = true; //文件有效性验证ValidateNames，验证用户输入是否是一个有效的Windows文件名
OFDScript.CheckFileExists = true; //验证路径有效性
OFDScript.CheckPathExists = true; //验证文件有效性
//try
//{
//生成功能外部设计文档
if (OFDScript.ShowDialog() == DialogResult.OK)
{
Excel.Application app = new Excel.ApplicationClass();
Excel.Workbook workBook = app.Workbooks.Open(OFDScript.FileName, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
Excel.Worksheet ws_bc1 = (Excel.Worksheet)workBook.Sheets[1];
app.Visible = true;
ws_bc1.Select(Type.Missing);
//复制模板区域
int rowIndex = 0;
while (rowIndex < 17)
{
指定位置插入行(ws_bc1.get_Range("A18", Type.Missing));
rowIndex++;
}
Excel.Range range1 = ws_bc1.get_Range("A1:M17", Type.Missing);
Excel.Range range = ws_bc1.get_Range("A18:M34", Type.Missing);
制单元格(range1, range);
string ls_sql = "select id,barcode,style,color,size,qty,ln from t_url_barcode";
DataGroup group_INV3 = new DataGroup();
group_INV3 = null;
group_INV3 = DB.GetDataGroup(ls_sql);
int bc_qty = 0;
int i_base_id = 18;
if (group_INV3.Table.Rows.Count > 0)
{
for (int INV3 = 0; INV3 < group_INV3.Table.Rows.Count; INV3++)
{
string ls_size = group_INV3.Table.Rows[INV3]["size"].ToString();
string ls_code = "*" + group_INV3.Table.Rows[INV3]["barcode"].ToString() + "*";
string ls_code_num = group_INV3.Table.Rows[INV3]["barcode"].ToString() + "\n " + ls_size;
string ls_lab = group_INV3.Table.Rows[INV3]["style"].ToString().Replace("THIGH", "").Trim() + " " + group_INV3.Table.Rows[INV3]["color"].ToString();
ls_size = "";
string ls_ln = group_INV3.Table.Rows[INV3]["ln"].ToString();
ls_lab = ls_lab.Replace(" ", " ").Trim();
string ls_qty = group_INV3.Table.Rows[INV3]["qty"].ToString();
int i_qty = int.Parse(ls_qty);
for (int i_xx = 0; i_xx < i_qty; i_xx++)
{
bc_qty++;
int x_mod = bc_qty % 32;
switch (x_mod)
{
/*ABAB*/
case 1:
ws_bc1.get_Range("A" + (i_base_id + 0), Type.Missing).Value2 = ls_code;
ws_bc1.get_Range("B" + (i_base_id + 0), Type.Missing).Value2 = ls_code_num;
ws_bc1.get_Range("A" + (i_base_id + 1), Type.Missing).Value2 = ls_lab;
ws_bc1.get_Range("B" + (i_base_id + 1), Type.Missing).Value2 = ls_size;
ws_bc1.get_Range("B" + (i_base_id + 0), "B" + (i_base_id + 1)).Merge(false);
//worksheet.Rows[1].Cells[7].Style.Font.Size = 20;
//worksheet.get_Range("A7", "A7").Style.Font.Size = 20;
//xlWorkSheet.get_Range("b2", "e3").Merge(false);
ws_bc1.get_Range("A" + (i_base_id + 8), Type.Missing).Value2 = ls_ln;
break;
case 2:
ws_bc1.get_Range("A" + (i_base_id + 2), Type.Missing).Value2 = ls_code;
ws_bc1.get_Range("B" + (i_base_id + 2), Type.Missing).Value2 = ls_code_num;
ws_bc1.get_Range("A" + (i_base_id + 3), Type.Missing).Value2 = ls_lab;
ws_bc1.get_Range("B" + (i_base_id + 3), Type.Missing).Value2 = ls_size;
ws_bc1.get_Range("B" + (i_base_id + 2), "B" + (i_base_id + 3)).Merge(false);
break;
case 3:
ws_bc1.get_Range("A" + (i_base_id + 4), Type.Missing).Value2 = ls_code;
ws_bc1.get_Range("B" + (i_base_id + 4), Type.Missing).Value2 = ls_code_num;
ws_bc1.get_Range("A" + (i_base_id + 5), Type.Missing).Value2 = ls_lab;
ws_bc1.get_Range("B" + (i_base_id + 5), Type.Missing).Value2 = ls_size;
ws_bc1.get_Range("B" + (i_base_id + 4), "B" + (i_base_id + 5)).Merge(false);
break;
case 4:
ws_bc1.get_Range("A" + (i_base_id + 6), Type.Missing).Value2 = ls_code;
ws_bc1.get_Range("B" + (i_base_id + 6), Type.Missing).Value2 = ls_code_num;
ws_bc1.get_Range("A" + (i_base_id + 7), Type.Missing).Value2 = ls_lab;
ws_bc1.get_Range("B" + (i_base_id + 7), Type.Missing).Value2 = ls_size;
ws_bc1.get_Range("B" + (i_base_id + 6), "B" + (i_base_id + 7)).Merge(false);
break;
case 5:
ws_bc1.get_Range("A" + (i_base_id + 9), Type.Missing).Value2 = ls_code;
ws_bc1.get_Range("B" + (i_base_id + 9), Type.Missing).Value2 = ls_code_num;
ws_bc1.get_Range("A" + (i_base_id + 10), Type.Missing).Value2 = ls_lab;
ws_bc1.get_Range("B" + (i_base_id + 10), Type.Missing).Value2 = ls_size;
ws_bc1.get_Range("B" + (i_base_id + 9), "B" + (i_base_id + 10)).Merge(false);
break;
case 6:
ws_bc1.get_Range("A" + (i_base_id + 11), Type.Missing).Value2 = ls_code;
ws_bc1.get_Range("B" + (i_base_id + 11), Type.Missing).Value2 = ls_code_num;
ws_bc1.get_Range("A" + (i_base_id + 12), Type.Missing).Value2 = ls_lab;
ws_bc1.get_Range("B" + (i_base_id + 12), Type.Missing).Value2 = ls_size;
ws_bc1.get_Range("B" + (i_base_id + 11), "B" + (i_base_id + 12)).Merge(false);
break;
case 7:
ws_bc1.get_Range("A" + (i_base_id + 13), Type.Missing).Value2 = ls_code;
ws_bc1.get_Range("B" + (i_base_id + 13), Type.Missing).Value2 = ls_code_num;
ws_bc1.get_Range("A" + (i_base_id + 14), Type.Missing).Value2 = ls_lab;
ws_bc1.get_Range("B" + (i_base_id + 14), Type.Missing).Value2 = ls_size;
ws_bc1.get_Range("B" + (i_base_id + 13), "B" + (i_base_id + 14)).Merge(false);
break;
case 8:
ws_bc1.get_Range("A" + (i_base_id + 15), Type.Missing).Value2 = ls_code;
ws_bc1.get_Range("B" + (i_base_id + 15), Type.Missing).Value2 = ls_code_num;
ws_bc1.get_Range("A" + (i_base_id + 16), Type.Missing).Value2 = ls_lab;
ws_bc1.get_Range("B" + (i_base_id + 16), Type.Missing).Value2 = ls_size;
ws_bc1.get_Range("B" + (i_base_id + 15), "B" + (i_base_id + 16)).Merge(false);
break;
/*EFEF*/
case 9:
ws_bc1.get_Range("E" + (i_base_id + 0), Type.Missing).Value2 = ls_code;
ws_bc1.get_Range("F" + (i_base_id + 0), Type.Missing).Value2 = ls_code_num;
ws_bc1.get_Range("E" + (i_base_id + 1), Type.Missing).Value2 = ls_lab;
ws_bc1.get_Range("F" + (i_base_id + 1), Type.Missing).Value2 = ls_size;
ws_bc1.get_Range("F" + (i_base_id + 0), "F" + (i_base_id + 1)).Merge(false);
break;
case 10:
ws_bc1.get_Range("E" + (i_base_id + 2), Type.Missing).Value2 = ls_code;
ws_bc1.get_Range("F" + (i_base_id + 2), Type.Missing).Value2 = ls_code_num;
ws_bc1.get_Range("E" + (i_base_id + 3), Type.Missing).Value2 = ls_lab;
ws_bc1.get_Range("F" + (i_base_id + 3), Type.Missing).Value2 = ls_size;
ws_bc1.get_Range("F" + (i_base_id + 2), "F" + (i_base_id + 3)).Merge(false);
break;
case 11:
ws_bc1.get_Range("E" + (i_base_id + 4), Type.Missing).Value2 = ls_code;
ws_bc1.get_Range("F" + (i_base_id + 4), Type.Missing).Value2 = ls_code_num;
ws_bc1.get_Range("E" + (i_base_id + 5), Type.Missing).Value2 = ls_lab;
ws_bc1.get_Range("F" + (i_base_id + 5), Type.Missing).Value2 = ls_size;
ws_bc1.get_Range("F" + (i_base_id + 4), "F" + (i_base_id + 5)).Merge(false);
break;
case 12:
ws_bc1.get_Range("E" + (i_base_id + 6), Type.Missing).Value2 = ls_code;
ws_bc1.get_Range("F" + (i_base_id + 6), Type.Missing).Value2 = ls_code_num;
ws_bc1.get_Range("E" + (i_base_id + 7), Type.Missing).Value2 = ls_lab;
ws_bc1.get_Range("F" + (i_base_id + 7), Type.Missing).Value2 = ls_size;
ws_bc1.get_Range("F" + (i_base_id + 6), "F" + (i_base_id + 7)).Merge(false);
break;
case 13:
ws_bc1.get_Range("E" + (i_base_id + 9), Type.Missing).Value2 = ls_code;
ws_bc1.get_Range("F" + (i_base_id + 9), Type.Missing).Value2 = ls_code_num;
ws_bc1.get_Range("E" + (i_base_id + 10), Type.Missing).Value2 = ls_lab;
ws_bc1.get_Range("F" + (i_base_id + 10), Type.Missing).Value2 = ls_size;
ws_bc1.get_Range("F" + (i_base_id + 9), "F" + (i_base_id + 10)).Merge(false);
break;
case 14:
ws_bc1.get_Range("E" + (i_base_id + 11), Type.Missing).Value2 = ls_code;
ws_bc1.get_Range("F" + (i_base_id + 11), Type.Missing).Value2 = ls_code_num;
ws_bc1.get_Range("E" + (i_base_id + 12), Type.Missing).Value2 = ls_lab;
ws_bc1.get_Range("F" + (i_base_id + 12), Type.Missing).Value2 = ls_size;
ws_bc1.get_Range("F" + (i_base_id + 11), "F" + (i_base_id + 12)).Merge(false);
break;
case 15:
ws_bc1.get_Range("E" + (i_base_id + 13), Type.Missing).Value2 = ls_code;
ws_bc1.get_Range("F" + (i_base_id + 13), Type.Missing).Value2 = ls_code_num;
ws_bc1.get_Range("E" + (i_base_id + 14), Type.Missing).Value2 = ls_lab;
ws_bc1.get_Range("F" + (i_base_id + 14), Type.Missing).Value2 = ls_size;
ws_bc1.get_Range("F" + (i_base_id + 13), "F" + (i_base_id + 14)).Merge(false);
break;
case 16:
ws_bc1.get_Range("E" + (i_base_id + 15), Type.Missing).Value2 = ls_code;
ws_bc1.get_Range("F" + (i_base_id + 15), Type.Missing).Value2 = ls_code_num;
ws_bc1.get_Range("E" + (i_base_id + 16), Type.Missing).Value2 = ls_lab;
ws_bc1.get_Range("F" + (i_base_id + 16), Type.Missing).Value2 = ls_size;
ws_bc1.get_Range("F" + (i_base_id + 15), "F" + (i_base_id + 16)).Merge(false);
break;
/*HIHI*/
case 17:
ws_bc1.get_Range("H" + (i_base_id + 0), Type.Missing).Value2 = ls_code;
ws_bc1.get_Range("I" + (i_base_id + 0), Type.Missing).Value2 = ls_code_num;
ws_bc1.get_Range("H" + (i_base_id + 1), Type.Missing).Value2 = ls_lab;
ws_bc1.get_Range("I" + (i_base_id + 1), Type.Missing).Value2 = ls_size;
ws_bc1.get_Range("I" + (i_base_id + 0), "I" + (i_base_id + 1)).Merge(false);
break;
case 18:
ws_bc1.get_Range("H" + (i_base_id + 2), Type.Missing).Value2 = ls_code;
ws_bc1.get_Range("I" + (i_base_id + 2), Type.Missing).Value2 = ls_code_num;
ws_bc1.get_Range("H" + (i_base_id + 3), Type.Missing).Value2 = ls_lab;
ws_bc1.get_Range("I" + (i_base_id + 3), Type.Missing).Value2 = ls_size;
ws_bc1.get_Range("I" + (i_base_id + 2), "I" + (i_base_id + 3)).Merge(false);
break;
case 19:
ws_bc1.get_Range("H" + (i_base_id + 4), Type.Missing).Value2 = ls_code;
ws_bc1.get_Range("I" + (i_base_id + 4), Type.Missing).Value2 = ls_code_num;
ws_bc1.get_Range("H" + (i_base_id + 5), Type.Missing).Value2 = ls_lab;
ws_bc1.get_Range("I" + (i_base_id + 5), Type.Missing).Value2 = ls_size;
ws_bc1.get_Range("I" + (i_base_id + 4), "I" + (i_base_id + 5)).Merge(false);
break;
case 20:
ws_bc1.get_Range("H" + (i_base_id + 6), Type.Missing).Value2 = ls_code;
ws_bc1.get_Range("I" + (i_base_id + 6), Type.Missing).Value2 = ls_code_num;
ws_bc1.get_Range("H" + (i_base_id + 7), Type.Missing).Value2 = ls_lab;
ws_bc1.get_Range("I" + (i_base_id + 7), Type.Missing).Value2 = ls_size;
ws_bc1.get_Range("I" + (i_base_id + 6), "I" + (i_base_id + 7)).Merge(false);
break;
case 21:
ws_bc1.get_Range("H" + (i_base_id + 9), Type.Missing).Value2 = ls_code;
ws_bc1.get_Range("I" + (i_base_id + 9), Type.Missing).Value2 = ls_code_num;
ws_bc1.get_Range("H" + (i_base_id + 10), Type.Missing).Value2 = ls_lab;
ws_bc1.get_Range("I" + (i_base_id + 10), Type.Missing).Value2 = ls_size;
ws_bc1.get_Range("I" + (i_base_id + 9), "I" + (i_base_id + 10)).Merge(false);
break;
case 22:
ws_bc1.get_Range("H" + (i_base_id + 11), Type.Missing).Value2 = ls_code;
ws_bc1.get_Range("I" + (i_base_id + 11), Type.Missing).Value2 = ls_code_num;
ws_bc1.get_Range("H" + (i_base_id + 12), Type.Missing).Value2 = ls_lab;
ws_bc1.get_Range("I" + (i_base_id + 12), Type.Missing).Value2 = ls_size;
ws_bc1.get_Range("I" + (i_base_id + 11), "I" + (i_base_id + 12)).Merge(false);
break;
case 23:
ws_bc1.get_Range("H" + (i_base_id + 13), Type.Missing).Value2 = ls_code;
ws_bc1.get_Range("I" + (i_base_id + 13), Type.Missing).Value2 = ls_code_num;
ws_bc1.get_Range("H" + (i_base_id + 14), Type.Missing).Value2 = ls_lab;
ws_bc1.get_Range("I" + (i_base_id + 14), Type.Missing).Value2 = ls_size;
ws_bc1.get_Range("I" + (i_base_id + 13), "I" + (i_base_id + 14)).Merge(false);
break;
case 24:
ws_bc1.get_Range("H" + (i_base_id + 15), Type.Missing).Value2 = ls_code;
ws_bc1.get_Range("I" + (i_base_id + 15), Type.Missing).Value2 = ls_code_num;
ws_bc1.get_Range("H" + (i_base_id + 16), Type.Missing).Value2 = ls_lab;
ws_bc1.get_Range("I" + (i_base_id + 16), Type.Missing).Value2 = ls_size;
ws_bc1.get_Range("I" + (i_base_id + 15), "I" + (i_base_id + 16)).Merge(false);
break;
/*LMLM*/
case 25:
ws_bc1.get_Range("L" + (i_base_id + 0), Type.Missing).Value2 = ls_code;
ws_bc1.get_Range("M" + (i_base_id + 0), Type.Missing).Value2 = ls_code_num;
ws_bc1.get_Range("L" + (i_base_id + 1), Type.Missing).Value2 = ls_lab;
ws_bc1.get_Range("M" + (i_base_id + 1), Type.Missing).Value2 = ls_size;
ws_bc1.get_Range("M" + (i_base_id + 0), "M" + (i_base_id + 1)).Merge(false);
break;
case 26:
ws_bc1.get_Range("L" + (i_base_id + 2), Type.Missing).Value2 = ls_code;
ws_bc1.get_Range("M" + (i_base_id + 2), Type.Missing).Value2 = ls_code_num;
ws_bc1.get_Range("L" + (i_base_id + 3), Type.Missing).Value2 = ls_lab;
ws_bc1.get_Range("M" + (i_base_id + 3), Type.Missing).Value2 = ls_size;
ws_bc1.get_Range("M" + (i_base_id + 2), "M" + (i_base_id + 3)).Merge(false);
break;
case 27:
ws_bc1.get_Range("L" + (i_base_id + 4), Type.Missing).Value2 = ls_code;
ws_bc1.get_Range("M" + (i_base_id + 4), Type.Missing).Value2 = ls_code_num;
ws_bc1.get_Range("L" + (i_base_id + 5), Type.Missing).Value2 = ls_lab;
ws_bc1.get_Range("M" + (i_base_id + 5), Type.Missing).Value2 = ls_size;
ws_bc1.get_Range("M" + (i_base_id + 4), "M" + (i_base_id + 5)).Merge(false);
break;
case 28:
ws_bc1.get_Range("L" + (i_base_id + 6), Type.Missing).Value2 = ls_code;
ws_bc1.get_Range("M" + (i_base_id + 6), Type.Missing).Value2 = ls_code_num;
ws_bc1.get_Range("L" + (i_base_id + 7), Type.Missing).Value2 = ls_lab;
ws_bc1.get_Range("M" + (i_base_id + 7), Type.Missing).Value2 = ls_size;
ws_bc1.get_Range("M" + (i_base_id + 6), "M" + (i_base_id + 7)).Merge(false);
break;
case 29:
ws_bc1.get_Range("L" + (i_base_id + 9), Type.Missing).Value2 = ls_code;
ws_bc1.get_Range("M" + (i_base_id + 9), Type.Missing).Value2 = ls_code_num;
ws_bc1.get_Range("L" + (i_base_id + 10), Type.Missing).Value2 = ls_lab;
ws_bc1.get_Range("M" + (i_base_id + 10), Type.Missing).Value2 = ls_size;
ws_bc1.get_Range("M" + (i_base_id + 9), "M" + (i_base_id + 10)).Merge(false);
break;
case 30:
ws_bc1.get_Range("L" + (i_base_id + 11), Type.Missing).Value2 = ls_code;
ws_bc1.get_Range("M" + (i_base_id + 11), Type.Missing).Value2 = ls_code_num;
ws_bc1.get_Range("L" + (i_base_id + 12), Type.Missing).Value2 = ls_lab;
ws_bc1.get_Range("M" + (i_base_id + 12), Type.Missing).Value2 = ls_size;
ws_bc1.get_Range("M" + (i_base_id + 11), "M" + (i_base_id + 12)).Merge(false);
break;
case 31:
ws_bc1.get_Range("L" + (i_base_id + 13), Type.Missing).Value2 = ls_code;
ws_bc1.get_Range("M" + (i_base_id + 13), Type.Missing).Value2 = ls_code_num;
ws_bc1.get_Range("L" + (i_base_id + 14), Type.Missing).Value2 = ls_lab;
ws_bc1.get_Range("M" + (i_base_id + 14), Type.Missing).Value2 = ls_size;
ws_bc1.get_Range("M" + (i_base_id + 13), "M" + (i_base_id + 14)).Merge(false);
break;
case 0:
ws_bc1.get_Range("L" + (i_base_id + 15), Type.Missing).Value2 = ls_code;
ws_bc1.get_Range("M" + (i_base_id + 15), Type.Missing).Value2 = ls_code_num;
ws_bc1.get_Range("L" + (i_base_id + 16), Type.Missing).Value2 = ls_lab;
ws_bc1.get_Range("M" + (i_base_id + 16), Type.Missing).Value2 = ls_size;
ws_bc1.get_Range("M" + (i_base_id + 15), "M" + (i_base_id + 16)).Merge(false);
//复制模板区域
rowIndex = 0;
while (rowIndex < 17)
{
指定位置插入行(ws_bc1.get_Range("A18", Type.Missing));
rowIndex++;
}
Excel.Range range2 = ws_bc1.get_Range("A1:M17", Type.Missing);
Excel.Range range3 = ws_bc1.get_Range("A18:M34", Type.Missing);
制单元格(range2, range3);
break;
}
}
}
}
}
//}
//catch (Exception ex)
//{
// MessageBox.Show(ex.Message.ToString());
//}
}
