private void frm_明细查询_Load(object sender, EventArgs e)
{
MinimizeBox = true;
MaximizeBox = true;
FormBorderStyle = FormBorderStyle.Fixed3D;
txt_gonghao.set_title("工号");
在制品DAL dal = new 在制品DAL();
DataRow myrow;
object[] myobj = new object[15];
SqlDataReader dr = dal.get成本明细();
if (dr.HasRows)
{
while (dr.Read())
{
dr.GetValues(myobj);
myrow = tb.NewRow();
myrow.ItemArray = myobj;
tb.Rows.Add(myrow);
}
}
dr.Close();
grd_data.set_date(tb);
}
private void fill()
{
在制品DAL dal = new 在制品DAL();
Object[] myobj = new object[14];
DataRow myrow;
SqlDataReader dr;
dr = dal.get在制品Reader(mydate.Value, deptcode);
if (dr.HasRows)
{
while (dr.Read())
{
dr.GetValues(myobj);
myrow = tb.NewRow();
myrow.ItemArray = myobj;
tb.Rows.Add(myrow);
}
}
dr.Close();
grd_data.set_date(tb);
}
private void btn_export_Click(object sender, EventArgs e)
{
Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbook wk;
Microsoft.Office.Interop.Excel.Worksheet mysheet;
int temprow;
List <string> mygonghaolist = new List <string>();
Range myrng;
object[] myobj;
System.Data.DataTable mytb = new System.Data.DataTable();
if (app == null)
{
MessageBox.Show("Excel 没有正常打开。 ");
return;
}
app.DisplayAlerts = false;
AppSettingsReader myread = new AppSettingsReader();
string filedir;
try
{
filedir = myread.GetValue("directory", Type.GetType("System.String")).ToString();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
app.Quit();
return;
}
wk = app.Workbooks.Open(filedir + "成本报表.xls");
//wk = app.Workbooks.Open(filedir + "成本模板.xls");
if (wk == null)
{
MessageBox.Show("模板文件没找到！");
return;
}
try
{
// 原材料
原始凭证DAL dal1 = new 原始凭证DAL();
SqlDataReader dr = dal1.get原始凭证成本报表(mydate.Value);
myobj = new object[20];
mysheet = wk.Worksheets["材料"];
if (dr.HasRows)
{
temprow = 5;
while (dr.Read())
{
dr.GetValues(myobj);
myrng = mysheet.Range[mysheet.Cells[temprow, 1], mysheet.Cells[temprow, 20]];
myrng.NumberFormatLocal = "0.00";
myrng.Value2 = myobj;
temprow++;
}
}
dr.Close();
在制品DAL dal3 = new 在制品DAL();
dr = dal3.导出成本(mydate.Value);
myobj = new object[18];
mysheet = wk.Worksheets["产品"];
if (dr.HasRows)
{
temprow = 4;
while (dr.Read())
{
dr.GetValues(myobj);
myrng = mysheet.Range[mysheet.Cells[temprow, 1], mysheet.Cells[temprow, 18]];
myrng.NumberFormatLocal = "0.00";
myrng.Value2 = myobj;
temprow++;
}
}
dr.Close();
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
string myfilename = saveFileDialog1.FileName;
wk.SaveAs(myfilename);
}
wk.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
app.Quit();
}
}
