private void btnOutput_Click(object sender, EventArgs e)
{
//UpdateProductCode(txtProductCode.Text);
DataRow drMessage;
DataTable dtBill = m_findSellIn.GetBill(m_strBillID, 0);
if (dtBill == null || dtBill.Rows.Count == 0)
{
drMessage = null;
}
else
{
drMessage = m_findSellIn.GetBill(m_strBillID, 0).Rows[0];
}
string strDate = drMessage == null?ServerTime.Time.ToString()
: drMessage["Date"].ToString();
string strYwType = drMessage == null ? ""
: drMessage["YWFS"].ToString();
DataTable dtNew = new DataTable();
DataTable dt = (DataTable)dataGridView1.DataSource;
dtNew.Columns.Add("序号");
dtNew.Columns.Add("产品型号");
dtNew.Columns.Add("入库日期");
dtNew.Columns.Add("产品编号");
dtNew.Columns.Add("产品状态");
dtNew.Columns.Add("产品说明");
dtNew.Columns.Add("退库状态");
dtNew.Columns.Add("箱子编号");
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dtNew.NewRow();
dr["序号"] = dt.Rows[i]["Number"].ToString();
dr["产品型号"] = txtGoodsCode.Text.Trim().ToString();
dr["入库日期"] = strDate;
dr["产品编号"] = dt.Rows[i]["ProductCode"].ToString();
dr["产品状态"] = m_dicMarkInfo.First().Value.ToString();
dr["产品说明"] = "【" + strYwType + "】 " + m_barCodeInfo.Remark;
dr["退库状态"] = "";
dr["箱子编号"] = dt.Rows[i]["BoxNo"].ToString();
dtNew.Rows.Add(dr);
}
ExcelHelperP.DataTableToExcel(saveFileDialog1, dtNew, null);
}
public void toolStripMenuItem_导入_Click(object sender, EventArgs e)
{
Control cltr = this.SourceControl;
if (cltr == null)
{
return;
}
if (cltr is DataGridView)
{
DataGridView dgvTemp = cltr as DataGridView;
DataTable dtTemp = ExcelHelperP.RenderFromExcel(openFileDialog1);
if (dtTemp == null)
{
return;
}
foreach (DataGridViewColumn cl in dgvTemp.Columns)
{
if (!dtTemp.Columns.Contains(cl.HeaderText))
{
MessageDialog.ShowPromptMessage("文件无【" + cl.HeaderText + "】列名");
return;
}
}
if (_InputEvent != null)
{
_InputEvent(dtTemp);
}
MessageDialog.ShowPromptMessage("导入成功");
}
else
{
if (_导入 != null)
{
_导入();
}
}
}
private void btnInput_Click(object sender, EventArgs e)
{
try
{
DataTable dtTemp = ExcelHelperP.RenderFromExcel(openFileDialog1);
if (dtTemp == null || dtTemp.Rows.Count == 0)
{
throw new Exception("请填写对应列名的内容");
}
if (!dtTemp.Columns.Contains("出厂流水码"))
{
MessageDialog.ShowPromptMessage("未找到列名为：【出厂流水码】的列");
return;
}
if (!dtTemp.Columns.Contains("箱体编码"))
{
MessageDialog.ShowPromptMessage("未找到列名为：【箱体编码】的列");
return;
}
m_dtProductCodes.Rows.Clear();
dataGridView1.DataSource = m_dtProductCodes;
foreach (DataRow dr in dtTemp.Rows)
{
if (dr["出厂流水码"].ToString().Trim().Length != 0)
{
txtProductCode.Text = dr["出厂流水码"].ToString().Trim();
_TempBoxNo = dr["箱体编码"].ToString().Trim();
btnAdd_Click(sender, e);
}
}
_TempBoxNo = "";
}
catch (Exception ex)
{
MessageDialog.ShowPromptMessage(ex.Message);
}
}
public void toolStripMenuItem_导出_Click(object sender, EventArgs e)
{
Control cltr = this.SourceControl;
if (cltr == null)
{
return;
}
if (cltr is DataGridView)
{
DataGridView dgvTemp = cltr as DataGridView;
ExcelHelperP.DatagridviewToExcel(saveFileDialog1, dgvTemp);
}
else
{
if (_导出 != null)
{
_导出();
}
}
}
private void btnImport_Click(object sender, EventArgs e)
{
DataTable dtTemp = ExcelHelperP.RenderFromExcel(openFileDialog1);
if (dtTemp == null)
{
return;
}
m_receivedUserType =
GlobalObject.GeneralFunction.StringConvertToEnum <BillFlowMessage_ReceivedUserType>(tabControl1.SelectedTab.Name);
switch (m_receivedUserType)
{
case BillFlowMessage_ReceivedUserType.用户:
if (!dtTemp.Columns.Contains("员工姓名") && !dtTemp.Columns.Contains("员工编号"))
{
MessageDialog.ShowPromptMessage("无【员工编号】或【员工姓名】列");
return;
}
DataTable tempTable = ((DataTable)dataGridView2.DataSource).Clone();
foreach (DataRow dr in dtTemp.Rows)
{
DataRow newRow = tempTable.NewRow();
View_HR_Personnel personnel = new View_HR_Personnel();
object obj = "";
if (dtTemp.Columns.Contains("员工编号"))
{
obj = dr["员工编号"];
}
else
{
obj = dr["员工姓名"];
}
if (obj == null)
{
MessageDialog.ShowPromptMessage("有一行记录为空，请重新检查");
return;
}
personnel = UniversalFunction.GetPersonnelInfo(obj.ToString());
if (personnel == null)
{
MessageDialog.ShowPromptMessage("【员工编号】/【员工姓名】： " + obj.ToString() + " 数据错误,请重新检查");
return;
}
newRow["员工编号"] = personnel.工号;
newRow["员工姓名"] = personnel.姓名;
tempTable.Rows.Add(newRow);
}
dataGridView1.DataSource = tempTable;
break;
case BillFlowMessage_ReceivedUserType.角色:
break;
default:
break;
}
}
private void btnExport_Click(object sender, EventArgs e)
{
ExcelHelperP.DatagridviewToExcel(saveFileDialog1, dataGridView1);
}
private void toolStripMenuItem_取消导入项_Click(object sender, EventArgs e)
{
Control cltr = this.SourceControl;
if (cltr == null)
{
return;
}
if (cltr is DataGridView)
{
DataGridView dgvTemp = cltr as DataGridView;
int columnsIndex = -1;
foreach (DataGridViewColumn cl in dgvTemp.Columns)
{
if (cl.CellType == typeof(DataGridViewCheckBoxColumn) ||
cl.CellType == typeof(DataGridViewCheckBoxCell))
{
columnsIndex = cl.Index;
break;
}
}
if (columnsIndex != -1)
{
DataTable dtTemp = ExcelHelperP.RenderFromExcel(openFileDialog1);
if (dtTemp == null)
{
return;
}
foreach (DataGridViewColumn cl in dgvTemp.Columns)
{
if (cl.Index != columnsIndex)
{
if (!dtTemp.Columns.Contains(cl.Name))
{
MessageDialog.ShowPromptMessage("文件无【" + cl.Name + "】列名");
return;
}
}
}
foreach (DataGridViewRow dgvr in dgvTemp.Rows)
{
foreach (DataRow dr in dtTemp.Rows)
{
foreach (DataGridViewColumn dgvc in dgvTemp.Columns)
{
if (dgvc.Index != columnsIndex)
{
dgvr.Cells[dgvc.Name].Value = dgvr.Cells[dgvc.Name].Value == null ? "" : dgvr.Cells[dgvc.Name].Value.ToString();
dr[dgvc.Name] = dr[dgvc.Name] == null ? "" : dr[dgvc.Name].ToString();
if (dgvr.Cells[dgvc.Name].Value.ToString() == dr[dgvc.Name].ToString())
{
dgvr.Cells[columnsIndex].Value = false;
}
}
}
}
}
}
}
else
{
if (_取消导入项 != null)
{
_取消导入项();
}
}
}
private void CreateExcelFile()
{
ExcelHelperP.DatagridviewToExcel(saveFileDialog1, dataGridView1);
//Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();
//if (excel == null)
//{
// MessageDialog.ShowPromptMessage("无法打开EXCEL, 不能进行此操作");
// return;
//}
//Cursor preCursor = Cursor.Current;
//try
//{
// Microsoft.Office.Interop.Excel.Workbook workbook = excel.Application.Workbooks.Add(true);
// char beginColHead = 'A';//A-Z, AA-AZ, BA-BZ
// int colWidth = 0;
// string[] colHeadArray = { "", "A", "B", "C", "D", "E" };
// // 从数据库中获取列宽信息
// List<Show_FieldWidth> lstFieldWidth = StapleInfo.FieldWidthServer.GetFieldWidth();
// // 获取A-Z列
// Microsoft.Office.Interop.Excel.Range range = (Microsoft.Office.Interop.Excel.Range)excel.Columns["A:Z", Type.Missing];
// // 每行高度
// range.RowHeight = 25;
// // 每列宽度
// //range.ColumnWidth = 15;
// // 每行水平居中对齐
// range.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter;
// // 每行垂直居中对齐
// range.VerticalAlignment = Microsoft.Office.Interop.Excel.XlVAlign.xlVAlignCenter;
// range.WrapText = true; // 自动换行
// //range.EntireColumn.AutoFit(); // 列高根据内容自动调整
// //range.EntireRow.AutoFit(); // 行高根据内容自动调整
// for (int i = 0; i < m_quertResultTable.Columns.Count; i++)
// {
// if (!dataGridView1.Columns[i].Visible)
// {
// m_quertResultTable.Columns.RemoveAt(i);
// i--;
// continue;
// }
// #region 设置EXCEL列宽
// string colHead = colHeadArray[i / 26] + Convert.ToChar(Convert.ToByte(beginColHead) + i % 26).ToString();
// List<Show_FieldWidth> fwInfo = StapleInfo.FieldWidthServer.GetFieldWidth(lstFieldWidth, m_quertResultTable.Columns[i].ColumnName);
// if (fwInfo.Count > 0)
// {
// colWidth = fwInfo[0].ExcelColumnWidth;
// }
// else
// {
// colWidth = 12;
// }
// ((Microsoft.Office.Interop.Excel.Range)excel.Columns[colHead, Type.Missing]).ColumnWidth = colWidth;
// #endregion
// excel.Cells[1, i + 1] = m_quertResultTable.Columns[i].ColumnName;
// }
// int rowIndex = 2;
// for (int i = 0; i < m_quertResultTable.Rows.Count; i++)
// {
// for (int col = 0; col < m_quertResultTable.Columns.Count; col++)
// {
// if (MustTextMode(m_quertResultTable.Columns[col].ColumnName))
// {
// excel.Cells[rowIndex, col + 1] = "'" + m_quertResultTable.Rows[i][col];
// }
// else
// {
// excel.Cells[rowIndex, col + 1] = m_quertResultTable.Rows[i][col];
// }
// }
// rowIndex++;
// }
// //excel.Cells[1, 1] = "hello";
// //excel.Cells[1, 2] = "world";
// //excel.Cells[2, 1] = "hello2";
// //excel.Cells[2, 2] = "world2";
// //excel.Visible = true;
// Cursor.Current = Cursors.WaitCursor;
// workbook.SaveAs(saveFileDialog1.FileName, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value,
// Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
// excel.Quit();
// excel = null;
//}
//finally
//{
// Cursor.Current = preCursor;
// if (excel != null)
// excel.Quit();
//}
}
private void btnExport_Click(object sender, EventArgs e)
{
ExcelHelperP.DatagridviewToExcel(saveFileDialog1, GetDataGridView(tabControl1.SelectedTab) as DataGridView);
}
private void CreateExcelFile()
{
ExcelHelperP.DatagridviewToExcel(saveFileDialog1, dataGridView1);
}
void OutPutExcel(DataGridView dgrv)
{
ExcelHelperP.DatagridviewToExcel(saveFileDialog1, dgrv);
}
