using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using DevExpress.XtraEditors; using System.Data.SqlClient; using ICSSoft.Frame.Data.BLL; using ICSSoft.Base.Language.Tool; using ICSSoft.Base.UserControl.MessageControl; using ICSSoft.Base.Report.Filter; using ICSSoft.Base.Config.DBHelper; using ICSSoft.Base.UserControl.FormControl; using ICSSoft.Base.ReferForm.AppReferForm; using ICSSoft.Base.Lable.PrintTool; using ICSSoft.Base.Config.AppConfig; using ICSSoft.Base.Report.GridReport; using ICSSoft.Frame.APP.Entity; using ICSSoft.Frame.Data.Entity; using DevExpress.XtraGrid.Views.BandedGrid; using System.Text.RegularExpressions; using System.Data.Linq; namespace ICSSoft.Frame.APP { using NPOI.HSSF.UserModel; using NPOI.SS.UserModel; using NPOI.XSSF.UserModel; using System.IO; public partial class FormICSEQPSTP : DevExpress.XtraEditors.XtraForm { List colNameList = new List(); private string sqlFilter = ""; private string connFilter = ""; String guid = AppConfig.GetGuid(); private DataTable dataSource = null; #region 构造函数 public FormICSEQPSTP() { InitializeComponent(); this.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height); this.WindowState = FormWindowState.Maximized; } #endregion #region 加载 private void FormICSFACTORY_Load(object sender, EventArgs e) { colNameList.Add(new FormReadExcelUIModelColumns("存货编码", true)); colNameList.Add(new FormReadExcelUIModelColumns("工序代码", true)); colNameList.Add(new FormReadExcelUIModelColumns("是否固定设备Y/N", false)); colNameList.Add(new FormReadExcelUIModelColumns("设备编号", false)); colNameList.Add(new FormReadExcelUIModelColumns("调机工时/准备工时", true)); colNameList.Add(new FormReadExcelUIModelColumns("加工工时/标准工时", true)); colNameList.Add(new FormReadExcelUIModelColumns("夹装工时", true)); colNameList.Add(new FormReadExcelUIModelColumns("检验工时", true)); colNameList.Add(new FormReadExcelUIModelColumns("是否启用Y/N", true)); colNameList.Add(new FormReadExcelUIModelColumns("类型", false)); colNameList.Add(new FormReadExcelUIModelColumns("轴数", false)); colNameList.Add(new FormReadExcelUIModelColumns("刀柄", false)); colNameList.Add(new FormReadExcelUIModelColumns("刀库", false)); colNameList.Add(new FormReadExcelUIModelColumns("可加工外形", false)); colNameList.Add(new FormReadExcelUIModelColumns("精度", false)); colNameList.Add(new FormReadExcelUIModelColumns("工序等级", true)); colNameList.Add(new FormReadExcelUIModelColumns("委外工时(天)", true)); grvDetail.CustomDrawRowIndicator += new DevExpress.XtraGrid.Views.Grid.RowIndicatorCustomDrawEventHandler(grvDetail_CustomDrawRowIndicator); btnFilter_Click(sender, e); } #endregion #region 权限 /// /// 操作权限 /// /// public DataTable RightOfExute() { DataTable rData = new DataTable(); rData.Columns.Add("BtnName"); rData.Columns.Add("ActionName"); //查看权限(必须有) DataRow seeRow = rData.NewRow(); seeRow["BtnName"] = "see"; seeRow["ActionName"] = "查看"; rData.Rows.Add(seeRow); foreach (Control ctr in panelControl3.Controls) { if (ctr.Name == btnFilter.Name || ctr.Name == btnConfig.Name || ctr.Name == btnSelect.Name || ctr.Name == btnCanSelect.Name || ctr.Name == btnImportMould.Name || ctr.Name == btnOutPut.Name || ctr.Name == btnFalsh.Name || ctr.Name == lblTitle.Name || ctr.Name == btnClose.Name) continue; DataRow dr = rData.NewRow(); dr["BtnName"] = ctr.Name; dr["ActionName"] = ctr.Text; rData.Rows.Add(dr); } //List ControlList = new List(); //ControlList.Add(btnConfig); //ControlList.Add(btnAdd); //ControlList.Add(btnEdit); //ControlList.Add(btnDelLable); //foreach (Control ctr in ControlList) //{ // if (ctr.GetType() == typeof(SimpleButton)) // { // DataRow dr = rData.NewRow(); // dr["BtnName"] = ctr.Name; // dr["ActionName"] = ctr.Text; // rData.Rows.Add(dr); // } //} rData.AcceptChanges(); return rData; } /// /// 数据权限 /// /// public DataTable RightOfData() { DataTable rData = new DataTable(); rData.Columns.Add("BodyName"); rData.Columns.Add("ControlName"); rData.Columns.Add("ControlCaption"); rData.AcceptChanges(); return rData; } #endregion #region 退出 private void btnClose_Click(object sender, EventArgs e) { AppConfig.CloseFormShow(this.Text); this.Close(); } private void btnExit_Click(object sender, EventArgs e) { AppConfig.CloseFormShow(this.Text); this.Close(); } #endregion #region 选择 #region 全选 private void btnSelect_Click(object sender, EventArgs e) { grvDetail.PostEditor(); this.Validate(); for (int i = 0; i < grvDetail.RowCount; i++) { grvDetail.SetRowCellValue(i, colisSelect, "Y"); } } #endregion #region 全消 private void btnCanSelect_Click(object sender, EventArgs e) { grvDetail.PostEditor(); this.Validate(); for (int i = 0; i < grvDetail.RowCount; i++) { grvDetail.SetRowCellValue(i, colisSelect, ""); } } #endregion #region 双击选择 private void grvDetail_DoubleClick(object sender, EventArgs e) { if (grvDetail.FocusedRowHandle < 0) { return; } if (grvDetail.FocusedColumn == colisSelect) { if (grvDetail.GetRowCellValue(grvDetail.FocusedRowHandle, colisSelect).ToString() == "") { grvDetail.SetRowCellValue(grvDetail.FocusedRowHandle, colisSelect, "Y"); } else { grvDetail.SetRowCellValue(grvDetail.FocusedRowHandle, colisSelect, ""); } } } #endregion #endregion #region 数据源相关 #region 过滤 private string tempTableName = ""; private void btnFilter_Click(object sender, EventArgs e) { FormFilter filter = new FormFilter(AppConfig.GetSourceId(this.Tag.ToString(), btnConfig.Name)); filter.OldTempTableName = tempTableName; if (filter.ShowDialog() == DialogResult.OK) { DevExpress.Utils.WaitDialogForm _wait = new DevExpress.Utils.WaitDialogForm("正在查找...请稍等..."); try { _wait.Show(); tempTableName = filter.NewTempTableName; sqlFilter = filter.SqlText; connFilter = filter.FilterConnectString; dataSource = filter.FilterData.Tables[0]; grdDetail.DataSource = dataSource; foreach (DevExpress.XtraGrid.Columns.GridColumn col in grvDetail.Columns) { if (col.Name == "colITEMCODE" || col.Name == "colITEMNAME") { col.BestFit(); } } //grvDetail.BestFitColumns(); rptPage.RecordNum = dataSource.Rows.Count; rptPage.PageSize = 490; rptPage.PageIndex = 1; rptPage.ReLoad(); rptPage.PageIndex = 1; rptPage.PageSize = 500; rptPage.ReLoad(); _wait.Close(); } catch (Exception ex) { MessageBox.Show("异常:" + ex.Message, "异常", MessageBoxButtons.OK, MessageBoxIcon.Error); _wait.Close(); } } } #endregion #region 绑定数据源 private void btnConfig_Click(object sender, EventArgs e)//绑定数据源 { if (AppConfig.UserCode.ToLower() != "demo") { //ICSBaseSimpleCode.AppshowMessageBox("您没有权限设置数据源,请联系软件提供商!"); return; } FormDataSource fdata = new FormDataSource(AppConfig.GetMenuId(this.Tag.ToString()), btnConfig.Name); fdata.ShowDialog(); } #endregion #region 列表 private void grvDetail_CustomDrawRowIndicator(object sender, DevExpress.XtraGrid.Views.Grid.RowIndicatorCustomDrawEventArgs e) { if (e.Info.IsRowIndicator && e.RowHandle >= 0) e.Info.DisplayText = (e.RowHandle + 1).ToString(); } #endregion #region 分页 private void rptPage_PageIndexChanged(object Sender, EventArgs e) { DataTable data = AppConfig.GetPageData(dataSource, rptPage.PageIndex, rptPage.PageSize).Copy(); //DataTable data = AppConfig.GetPageDataByDb(tempTableName, "pagerowindex", rptPage.PageSize, rptPage.PageIndex, dataSource.Rows.Count); grdDetail.DataSource = data; } #endregion #endregion #region CRUD #region 增加 private void btnAdd_Click(object sender, EventArgs e) { SimpleButton btntemp = (SimpleButton)sender; if (AppConfig.GetUserExcuteRight(this.Tag.ToString(), btntemp.Name) == false) { ICSBaseSimpleCode.AppshowMessageBox("对不起您没有:" + btntemp.Text + "权限,请联系系统管理员!"); return; } FormICSEQPSTPAdd add = new FormICSEQPSTPAdd(); add.ShowDialog(); btnFalsh_Click(null, null); } #endregion #region 修改 private void btnEdit_Click(object sender, EventArgs e) { SimpleButton btntemp = (SimpleButton)sender; if (AppConfig.GetUserExcuteRight(this.Tag.ToString(), btntemp.Name) == false) { ICSBaseSimpleCode.AppshowMessageBox("对不起您没有:" + btntemp.Text + "权限,请联系系统管理员!"); return; } int count = 0; for (int i = 0; i < grvDetail.RowCount; i++) { if (grvDetail.GetRowCellValue(i, colisSelect).ToString() == "Y") { count++; } } if (count != 1) { ICSBaseSimpleCode.AppshowMessageBox("请选择数据,且只能选择一条进行编辑!!!"); return; } try { string id; for (int i = 0; i < grvDetail.RowCount; i++) { if (grvDetail.GetRowCellValue(i, colisSelect).ToString() == "Y") { id = grvDetail.GetRowCellValue(i, colID).ToString(); FormICSEQPSTPAdd add = new FormICSEQPSTPAdd(id); add.ShowDialog(); } } btnFalsh_Click(null, null); } catch (Exception ex) { //throw ex; ICSBaseSimpleCode.AppshowMessageBox(ex.Message); } } #endregion #region 删除 private void btnDel_Click(object sender, EventArgs e) { SimpleButton btntemp = (SimpleButton)sender; if (AppConfig.GetUserExcuteRight(this.Tag.ToString(), btntemp.Name) == false) { ICSBaseSimpleCode.AppshowMessageBox("对不起您没有:" + btntemp.Text + "权限,请联系系统管理员!"); return; } List routecodeList = new List(); for (int i = 0; i < grvDetail.RowCount; i++) { if (grvDetail.GetRowCellValue(i, colisSelect).ToString() == "Y") { routecodeList.Add(grvDetail.GetRowCellValue(i, colID).ToString()); } } if (routecodeList.Count == 0 || routecodeList == null) { ICSBaseSimpleCode.AppshowMessageBox("请选择数据"); return; } if (ICSBaseSimpleCode.AppshowMessageBoxRepose("确定删除吗?删除后无法恢复,确定吗?") != DialogResult.OK) { btnCanSelect_Click(sender, e); return; } ICSEQPSTPBLL.deleteInfo(routecodeList, AppConfig.AppConnectString); ICSBaseSimpleCode.AppshowMessageBox("删除成功"); btnFalsh_Click(null, null); } #endregion #region 刷新 private void btnFalsh_Click(object sender, EventArgs e) { if (connFilter == null || connFilter == "") { return; } DevExpress.Utils.WaitDialogForm _wait = new DevExpress.Utils.WaitDialogForm("正在查找...请稍等..."); try { _wait.Show(); FormFilter filter = new FormFilter(AppConfig.GetSourceId(this.Tag.ToString(), btnConfig.Name), false); filter.OldTempTableName = tempTableName; //tempTableName = filter.NewTempTableName; //DataTable data = DBHelper.ExecuteDataset(AppConfig.FrameConnectString, CommandType.Text, "select * from " + tempTableName).Tables[0]; dataSource = DBHelper.ExecuteDataset(connFilter, CommandType.Text, sqlFilter).Tables[0]; grdDetail.DataSource = dataSource; rptPage.RecordNum = dataSource.Rows.Count; rptPage.PageIndex = 1; rptPage.ReLoad(); _wait.Close(); } catch (Exception ex) { MessageBox.Show("异常:" + ex.Message, "异常", MessageBoxButtons.OK, MessageBoxIcon.Error); _wait.Close(); } } #endregion #region 审核 private void btnCheck_Click(object sender, EventArgs e) { SimpleButton btntemp = (SimpleButton)sender; if (AppConfig.GetUserExcuteRight(this.Tag.ToString(), btntemp.Name) == false) { ICSBaseSimpleCode.AppshowMessageBox("对不起您没有:" + btntemp.Text + "权限,请联系系统管理员!"); return; } List routecodeList = new List(); for (int i = 0; i < grvDetail.RowCount; i++) { if (grvDetail.GetRowCellValue(i, colisSelect).ToString() == "Y") { routecodeList.Add(grvDetail.GetRowCellValue(i, colID).ToString()); } } if (routecodeList.Count == 0 || routecodeList == null) { ICSBaseSimpleCode.AppshowMessageBox("请选择数据"); return; } if (ICSBaseSimpleCode.AppshowMessageBoxRepose("确定审核吗?") != DialogResult.OK) { btnCanSelect_Click(sender, e); return; } ICSEQPSTPBLL.checkInfo(routecodeList, AppConfig.AppConnectString); ICSBaseSimpleCode.AppshowMessageBox("审核成功"); btnFalsh_Click(null, null); } #endregion #endregion #region 导入导出 #region 导出 private void btnOutPut_Click(object sender, EventArgs e) { FormOutExcel foe = new FormOutExcel(this.Tag.ToString(), grdDetail); foe.ShowDialog(); } #endregion #region 导入 bool 管控物料 = true; bool 管控工序 = true; bool 管控设备 = true; bool 管控六大维度 = true; private void btnImportData_Click(object sender, EventArgs e) { DateTime dtNow = AppConfig.GetSeverDateTime("yyyy-MM-dd HH:mm:ss"); Regex reg = new Regex("^(0|([1-9]\\d*))(\\.\\d+)?$"); SimpleButton btntemp = (SimpleButton)sender; if (AppConfig.GetUserExcuteRight(this.Tag.ToString(), btntemp.Name) == false) { ICSBaseSimpleCode.AppshowMessageBox("对不起您没有:" + btntemp.Text + "权限,请联系系统管理员!"); return; } DevExpress.Utils.WaitDialogForm _wait = new DevExpress.Utils.WaitDialogForm(); _wait.Hide(); try { FormReadExcel fre = new FormReadExcel(); if (fre.ShowDialog() != DialogResult.OK) { return; } DataTable dataSource = fre._excelData; if (dataSource == null) { throw new Exception("excel数据取得失败"); } _wait.Show(); _wait.Caption = "判断模版是否正确......"; //判断模版是否正确 foreach (FormReadExcelUIModelColumns columnsName in colNameList) { if (!dataSource.Columns.Contains(columnsName.columnsName)) { throw new Exception("模版不正确,缺少列" + columnsName.columnsName); } } _wait.Caption = "数据整理中......"; //获取基础验证信息 DataSet ds4Check = GetVerificationInfo(); List InitInvInfoList = new List(); foreach (DataRow dr in dataSource.Rows) { int Rindex = dataSource.Rows.IndexOf(dr); bool 固定设备 = false; bool 委外工序 = false; string ITEMCODE = ""; string OPCODE = ""; string EQPCODE = ""; string EQPTypeCode = ""; string cClass = ""; string cHandles = ""; string cAxis = ""; string cToolMagazine = ""; string cMachinableProfiles = ""; string cAccuracy = ""; string ISREF = ""; string JiaGongTime = ""; string TiaoJiTime = ""; string JiaZhuangTime = ""; string JianYanTime = ""; string WTIME = ""; decimal? wtime = null; string OPLVL = null; //判断必输项目是否为空 foreach (FormReadExcelUIModelColumns col in colNameList) { if (col.NotNull) { if (string.IsNullOrEmpty(dr[col.columnsName].ToString().Trim())) { throw new Exception("列" + col.columnsName + "没有输入值"); } } } 固定设备 = dr["是否固定设备Y/N"].ToString().Trim().ToUpper() == "Y"; ITEMCODE = dr["存货编码"].ToString().Trim().ToUpper(); OPCODE = dr["工序代码"].ToString().Trim().ToUpper(); ISREF = dr["是否启用Y/N"].ToString().Trim().ToUpper() == "Y" ? "是" : "否"; TiaoJiTime = dr["调机工时/准备工时"].ToString().Trim().ToUpper(); JiaGongTime = dr["加工工时/标准工时"].ToString().Trim().ToUpper(); JiaZhuangTime = dr["夹装工时"].ToString().Trim().ToUpper(); JianYanTime = dr["检验工时"].ToString().Trim().ToUpper(); OPLVL = dr["工序等级"].ToString().Trim().ToUpper(); WTIME = dr["委外工时(天)"].ToString().Trim().ToUpper(); //物料档案检查 if (管控物料) { if (ds4Check.Tables["存货档案"].Select("存货编码='" + ITEMCODE + "'").Length == 0) { throw new Exception("存货档案,不包含此存货编码: " + ITEMCODE); } } //工序档案检查 if (管控工序) { DataRow[] opdr = ds4Check.Tables["工序档案"].Select("工序代码='" + OPCODE + "'"); if (opdr.Length == 0) { throw new Exception("工序档案,不包含此工序: " + OPCODE); } 委外工序 = Convert.ToBoolean(opdr[0]["委外"]); } //时间规范检查 if (!reg.IsMatch(TiaoJiTime)) { throw new Exception("调机工时/准备工时错误,只能输入非负数,行" + Rindex.ToString()); } if (!reg.IsMatch(JiaGongTime)) { throw new Exception("加工工时/标准工时错误,只能输入非负数,行" + Rindex.ToString()); } if (!reg.IsMatch(JiaZhuangTime)) { throw new Exception("夹装工时错误,只能输入非负数,行" + Rindex.ToString()); } if (!reg.IsMatch(JianYanTime)) { throw new Exception("检验工时错误,只能输入非负数,行" + Rindex.ToString()); } if (委外工序) { EQPTypeCode = "委外"; OPLVL = null; if (string.IsNullOrEmpty(WTIME)) { throw new Exception("物料:" + ITEMCODE + "工序:" + OPCODE + ",是委外工序,但委外工时为空"); } decimal wwtime = 0; bool w = decimal.TryParse(WTIME, out wwtime); if (!w || wwtime <= 0) { throw new Exception("物料:" + ITEMCODE + "工序:" + OPCODE + ",委外工时维护错误:" + WTIME); } } else { wtime = null; if (固定设备) { EQPTypeCode = "固定设备"; EQPCODE = dr["设备编号"].ToString().Trim().ToUpper(); if (string.IsNullOrEmpty(EQPCODE)) { throw new Exception("非委外工序" + OPCODE + "固定设备为'Y'时,设备编码必须填写"); } //设备代码检查 if (管控设备) { if (ds4Check.Tables["设备档案"].Select("设备代码='" + EQPCODE + "'").Length == 0) { throw new Exception("设备档案.不包含设备: " + EQPCODE); } } } else { EQPTypeCode = "设备类型"; cClass = dr["类型"].ToString().Trim().ToUpper(); cHandles = dr["刀柄"].ToString().Trim().ToUpper(); cAxis = dr["轴数"].ToString().Trim().ToUpper(); cToolMagazine = dr["刀库"].ToString().Trim().ToUpper(); cMachinableProfiles = dr["可加工外形"].ToString().Trim().ToUpper(); cAccuracy = dr["精度"].ToString().Trim().ToUpper(); if (string.IsNullOrEmpty(cClass) || string.IsNullOrEmpty(cHandles) || string.IsNullOrEmpty(cAxis) || string.IsNullOrEmpty(cToolMagazine) || string.IsNullOrEmpty(cMachinableProfiles) || string.IsNullOrEmpty(cAccuracy)) { throw new Exception("非委外工序" + OPCODE + "固定设备为'N'时,设备类型对应的六大维度必须填写"); } if (管控六大维度) { int dcToolMagazine = 0; int dcMachinableProfiles = 0; //六大维度检查 if (ds4Check.Tables["类型"].Select("类型='" + cClass + "'").Length == 0) { throw new Exception("六大维度-类型.不包含: " + cClass); } if (ds4Check.Tables["刀柄"].Select("刀柄='" + cHandles + "'").Length == 0) { throw new Exception("六大维度-刀柄.不包含: " + cHandles); } if (ds4Check.Tables["轴数"].Select("轴数='" + cAxis + "'").Length == 0) { throw new Exception("六大维度-轴数.不包含: " + cAxis); } if (int.TryParse(cToolMagazine, out dcToolMagazine)) { throw new Exception("刀库数" + dcToolMagazine + "必须为正整数"); } if (dcToolMagazine <= 0) { throw new Exception("刀库数" + dcToolMagazine + "必须为正整数"); } if (int.TryParse(cMachinableProfiles, out dcMachinableProfiles)) { throw new Exception("可加工外形: " + cToolMagazine + "必须为正整数"); } if (dcMachinableProfiles <= 0) { throw new Exception("可加工外形: " + cToolMagazine + "必须为正整数"); } //if (ds4Check.Tables["刀库数"].Select("刀库数='" + cToolMagazine + "'").Length == 0) //{ // throw new Exception("六大维度-刀库数.不包含: " + cToolMagazine); //} //if (ds4Check.Tables["可加工外形"].Select("可加工外形='" + cMachinableProfiles + "'").Length == 0) //{ // throw new Exception("六大维度-可加工外形.不包含: " + cMachinableProfiles); //} if (ds4Check.Tables["精度"].Select("精度='" + cAccuracy + "'").Length == 0) { throw new Exception("六大维度-精度.不包含: " + cAccuracy); } } } } ICSEQPSTP Info = new ICSEQPSTP(); Info.ID = ""; Info.ITEMCODE = ITEMCODE; Info.OPCODE = OPCODE; Info.EQPCODE = EQPCODE; Info.EQPTypeCode = EQPTypeCode; Info.ISREF = ISREF; Info.Status = "New"; Info.cClass = cClass; Info.cHandles = cHandles; Info.cAxis = cAxis; Info.cAccuracy = cAccuracy; Info.cMachinableProfiles = cMachinableProfiles; Info.cToolMagazine = cToolMagazine; Info.TiaoJiTime = Info.RTIME = Math.Round(Convert.ToDecimal(TiaoJiTime), 2); Info.JiaGongTime = Info.STIME = Math.Round(Convert.ToDecimal(JiaGongTime), 2); Info.JiaZhuangTime = Math.Round(Convert.ToDecimal(JiaZhuangTime), 2); Info.JianYanTime = Math.Round(Convert.ToDecimal(JianYanTime), 2); Info.OPLVL = OPLVL; Info.WTIME = wtime; Info.MUSER = AppConfig.UserCode; Info.MUSERName = AppConfig.UserName; Info.MTIME = dtNow; Info.WorkPoint = AppConfig.WorkPointCode; //Info.EATTRIBUTE1 = ""; //Info.ETTRCODE = dr["自定义项"].ToString(); //Info.OutsourcingProperties = dr["外协属性"].ToString(); //Info.BladeModelAndBrand = dr["刀片型号和品牌"].ToString(); //Info.ToolingNo = dr["工装编号"].ToString(); InitInvInfoList.Add(Info); } _wait.Caption = "导入数据......"; ICSEQPSTPBLL.Import(InitInvInfoList, AppConfig.AppConnectString); _wait.Close(); ICSBaseSimpleCode.AppshowMessageBox("数据导入成功!"); btnFalsh_Click(null, null); } catch (Exception ex) { _wait.Close(); ICSBaseSimpleCode.AppshowMessageBox("数据导入失败:" + ex.Message); } } #endregion #region 导入模板下载 private void btnImportMould_Click(object sender, EventArgs e) { DevExpress.Utils.WaitDialogForm _wait = new DevExpress.Utils.WaitDialogForm(); _wait.Hide(); string anjianExcelFileName = Environment.CommandLine.Substring(1, Environment.CommandLine.LastIndexOf("\\")) + "Output\\"; try { _wait.Show(); _wait.Caption = "模板下载中......"; SaveFileDialog dlgSaveFileDialog = new SaveFileDialog(); //弹框提示保存 dlgSaveFileDialog.InitialDirectory = anjianExcelFileName; //默认打开目录 dlgSaveFileDialog.FilterIndex = 1; dlgSaveFileDialog.RestoreDirectory = true; dlgSaveFileDialog.FileName = "标准工时导入模板.xlsx"; //默认保存名称 dlgSaveFileDialog.Filter = "Excel文件(*.xlsx)|*.xlsx"; if (dlgSaveFileDialog.ShowDialog() == DialogResult.OK) { string fileName = dlgSaveFileDialog.FileName; //获取弹出框选择或填写的文件名称 FileUtil.exportToExcelFile(fileName, colNameList); _wait.Close(); ICSBaseSimpleCode.AppshowMessageBox("模板下载成功!"); } _wait.Close(); } catch (Exception ex) { _wait.Close(); ICSBaseSimpleCode.AppshowMessageBox("模板下载失败:" + ex.Message); } } #endregion #region 获取检查依据 DataSet GetVerificationInfo() { DataSet ds = new DataSet(); #region 存货 if (管控物料) { string sqlItemCode = @" SELECT DISTINCT A.ITEMCODE AS 存货编码,B.INVNAME AS 存货名称 FROM dbo.ICSITEMROUTE2OP A LEFT JOIN ICSINVENTORY B ON A.ITEMCODE=B.INVCODE AND A.WorkPoint=B.WorkPoint WHERE A.WorkPoint='{0}' ORDER BY A.ITEMCODE ASC"; sqlItemCode = string.Format(sqlItemCode, AppConfig.WorkPointCode); DataTable dtItemCode = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sqlItemCode).Tables[0]; if (dtItemCode.Rows.Count == 0) { throw new Exception("存货档案无数据"); } dtItemCode.TableName = "存货档案"; ds.Tables.Add(dtItemCode.Copy()); } #endregion #region 六大维度 if (管控六大维度) { string sql6 = @"SELECT LTRIM(RTRIM(EnumText)) as 类型 FROM Sys_EnumValues WHERE EnumKey='30001' AND LTRIM(RTRIM(EnumText))<>'' AND WorkPointCode='" + AppConfig.WorkPointCode + "' ORDER BY EnumValue"; DataTable dt30001 = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql6).Tables[0]; if (dt30001.Rows.Count == 0) { throw new Exception("自定义项,设备类型(六大维度)-类型,未维护"); } dt30001.TableName = "类型"; ds.Tables.Add(dt30001.Copy()); sql6 = @"SELECT LTRIM(RTRIM(EnumText)) as 刀柄 FROM Sys_EnumValues WHERE EnumKey='30002' AND LTRIM(RTRIM(EnumText))<>'' AND WorkPointCode='" + AppConfig.WorkPointCode + "' ORDER BY EnumValue"; DataTable dt30002 = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql6).Tables[0]; if (dt30002.Rows.Count == 0) { throw new Exception("自定义项,设备类型(六大维度)-刀柄,未维护"); } dt30002.TableName = "刀柄"; ds.Tables.Add(dt30002.Copy()); sql6 = @"SELECT LTRIM(RTRIM(EnumText)) as 轴数 FROM Sys_EnumValues WHERE EnumKey='30003' AND LTRIM(RTRIM(EnumText))<>'' AND WorkPointCode='" + AppConfig.WorkPointCode + "' ORDER BY EnumValue"; DataTable dt30003 = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql6).Tables[0]; if (dt30003.Rows.Count == 0) { throw new Exception("自定义项,设备类型(六大维度)-轴数,未维护"); } dt30003.TableName = "轴数"; ds.Tables.Add(dt30003.Copy()); sql6 = @"SELECT LTRIM(RTRIM(EnumText)) as 刀库数 FROM Sys_EnumValues WHERE EnumKey='30004' AND LTRIM(RTRIM(EnumText))<>'' AND WorkPointCode='" + AppConfig.WorkPointCode + "' ORDER BY EnumValue"; DataTable dt30004 = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql6).Tables[0]; if (dt30004.Rows.Count == 0) { throw new Exception("自定义项,设备类型(六大维度)-刀库数,未维护"); } dt30004.TableName = "刀库数"; ds.Tables.Add(dt30004.Copy()); sql6 = @"SELECT LTRIM(RTRIM(EnumText)) as 可加工外形 FROM Sys_EnumValues WHERE EnumKey='30005' AND LTRIM(RTRIM(EnumText))<>'' AND WorkPointCode='" + AppConfig.WorkPointCode + "' ORDER BY EnumValue"; DataTable dt30005 = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql6).Tables[0]; if (dt30005.Rows.Count == 0) { throw new Exception("自定义项,设备类型(六大维度)-可加工外形,未维护"); } dt30005.TableName = "可加工外形"; ds.Tables.Add(dt30005.Copy()); sql6 = @"SELECT LTRIM(RTRIM(EnumText)) as 精度 FROM Sys_EnumValues WHERE EnumKey='30006' AND LTRIM(RTRIM(EnumText))<>'' AND WorkPointCode='" + AppConfig.WorkPointCode + "' ORDER BY EnumValue"; DataTable dt30006 = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql6).Tables[0]; if (dt30006.Rows.Count == 0) { throw new Exception("自定义项,设备类型(六大维度)-精度,未维护"); } dt30006.TableName = "精度"; ds.Tables.Add(dt30006.Copy()); } #endregion #region 设备 if (管控设备) { string sqlEqpCode = @"SELECT EQPCODE AS 设备代码,EQPNAME AS 设备名称 FROM [dbo].[ICSEquipment] WHERE WorkPoint='" + AppConfig.WorkPointCode + "' ORDER BY EQPCode"; DataTable dtEqpCode = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sqlEqpCode).Tables[0]; if (dtEqpCode.Rows.Count == 0) { throw new Exception("设备档案没有可用数据"); } dtEqpCode.TableName = "设备档案"; ds.Tables.Add(dtEqpCode.Copy()); } #endregion #region 工序 if (管控工序) { string sqlOPCode = @"SELECT OPCODE AS 工序代码,CONVERT(BIT,ISNULL(EATTRIBUTE1,'0')) AS 委外 FROM dbo.ICSOP WHERE WorkPoint='" + AppConfig.WorkPointCode + "' AND EnableFlag=1 ORDER BY OPCODE"; DataTable dtOPCode = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sqlOPCode).Tables[0]; if (dtOPCode.Rows.Count == 0) { throw new Exception("工序档案没有可用数据"); } dtOPCode.TableName = "工序档案"; ds.Tables.Add(dtOPCode.Copy()); } #endregion return ds; } #endregion #endregion #region 移动窗体 private const int WM_NCHITTEST = 0x84; private const int HTCLIENT = 0x1; private const int HTCAPTION = 0x2; //首先必须了解Windows的消息传递机制,当有鼠标活动消息时, //系统发送WM_NCHITTEST 消息给窗体作为判断消息发生地的根据。 nchittest //假如你点击的是标题栏,窗体收到的消息值就是 HTCAPTION , //同样地,若接受到的消息是 HTCLIENT,说明用户点击的是客户区,也就是鼠标消息发生在客户区。 //重写窗体,使窗体可以不通过自带标题栏实现移动 protected override void WndProc(ref Message m) { //当重载窗体的 WndProc 方法时,可以截获 WM_NCHITTEST 消息并改些该消息, //当判断鼠标事件发生在客户区时,改写改消息,发送 HTCAPTION 给窗体, //这样,窗体收到的消息就时 HTCAPTION ,在客户区通过鼠标来拖动窗体就如同通过标题栏来拖动一样。 //注意:当你重载 WndProc 并改写鼠标事件后,整个窗体的鼠标事件也就随之改变了。 switch (m.Msg) { case WM_NCHITTEST: base.WndProc(ref m); if ((int)m.Result == HTCLIENT) m.Result = (IntPtr)HTCAPTION; return; } //拦截双击标题栏、移动窗体的系统消息 if (m.Msg != 0xA3) { base.WndProc(ref m); } } #endregion #region erp工序工艺工时导入 DataTable dtEQ = new DataTable(); DataTable dtINV = new DataTable(); private void btnImportAll_Click(object sender, EventArgs e) { //ICSBaseSimpleCode.AppshowMessageBox("erp数据未整理完成, 此功能当前不可用"); //return; //C 25 40 12 0180A //类型,刀柄,轴,刀库,外形,精度 string filename = ""; using (OpenFileDialog ofd = new OpenFileDialog()) { ofd.Filter = "Excel 97-2003(*.xls)|*.xls|Excel 2007(*.xlsx)|*.xlsx"; if (ofd.ShowDialog() == DialogResult.OK) { filename = ofd.FileName.ToLower(); if (!filename.EndsWith(".xls") && !filename.EndsWith(".xlsx")) { return; } } } IWorkbook workbook = null; DataTable dtMain = new DataTable(); DataTable dtSub = new DataTable(); DataTable dtBaseOP = new DataTable(); DevExpress.Utils.WaitDialogForm _wait = new DevExpress.Utils.WaitDialogForm("正在获取Excel数据..."); try { //start _wait.Show(); FileStream fs = new FileStream(filename, FileMode.Open, FileAccess.Read); if (filename.ToLower().EndsWith(".xls")) { workbook = new HSSFWorkbook(fs); } else { workbook = new XSSFWorkbook(fs); } //取第一个sheet页的数据 ISheet sheet = workbook.GetSheetAt(0); int start = 1; //主表 dtMain = GetDataFromSheet(sheet, ref start); // 子表 dtSub = GetDataFromSheet(sheet, ref start); //资源释放 workbook.Close(); if (dtMain.Rows.Count == 0) { throw new Exception("主表格式错误,获取数据 0 行, 注意:表头不能为空"); } if (dtSub.Rows.Count == 0) { throw new Exception("子表格式错误,获取数据 0 行, 注意:表头不能为空"); } //获取基本数据 _wait.SetCaption("获取基础数据..."); //if (dtEQ.Rows.Count == 0) //{ // dtEQ = GetEQ(AppConfig.AppConnectString, AppConfig.WorkPointCode); //} //if (dtINV.Rows.Count == 0) //{ // dtINV = GetINV(AppConfig.AppConnectString, AppConfig.WorkPointCode); //} dtBaseOP = GetBaseOP(AppConfig.AppConnectString, AppConfig.WorkPointCode); dtEQ = GetFIXEQ(AppConfig.AppConnectString, AppConfig.WorkPointCode); dtINV = GetINV(AppConfig.AppConnectString, AppConfig.WorkPointCode); //检查数据并转为实体 _wait.SetCaption("数据整理..."); List list = InitData(dtMain, dtSub, dtINV, dtEQ, dtBaseOP); //上传 _wait.SetCaption("数据上传..."); ICSEQPSTPBLL.ImportFromErp(AppConfig.AppConnectString, list); //end _wait.Close(); ICSBaseSimpleCode.AppshowMessageBox("导入成功!"); } catch (Exception ex) { if (workbook != null) { workbook.Close(); } _wait.Close(); ICSBaseSimpleCode.AppshowMessageBox(ex.Message); } } /// /// 读取nc模板 /// /// sheet /// 起始行 /// 子表起始行 private DataTable GetDataFromSheet(ISheet sheet, ref int start) { DataTable dt1 = new DataTable(); //获取第start行数据 IRow dt1firstRow = sheet.GetRow(start); //获取数据列的数量 int columnCount = dt1firstRow.LastCellNum; for (int i = dt1firstRow.FirstCellNum; i < columnCount; i++) { //获取单元格 ICell cell = dt1firstRow.GetCell(i); if (cell != null) { //将第start行数据作为表头 string cellValue = cell.StringCellValue; if (i == dt1firstRow.FirstCellNum) { if (!cellValue.StartsWith("\"head_$head") && !cellValue.StartsWith("\"rtitems")) { throw new Exception("不是标准模板,禁止导入!"); } dt1.Columns.Add("主序号"); continue; } if (!string.IsNullOrEmpty(cellValue)) { dt1.Columns.Add(cellValue.Trim('*').Trim()); } } } //获取数据行的数量 int rowCount = sheet.LastRowNum; int rowStart = start + 1; for (int i = rowStart; i <= rowCount; i++) { //获取行 IRow row = sheet.GetRow(i); //主子表有空行间隔 if (row == null) { //主表结束,返回子表起始行号 start = i + 1; break; } DataRow dataRow = dt1.NewRow(); for (int j = row.FirstCellNum; j < dt1.Columns.Count; j++) { if (row.GetCell(j) != null) { //这里减FirstCellNum可以去除空白列数据 dataRow[j - row.FirstCellNum] = row.GetCell(j).ToString().Trim().ToUpper(); } } dt1.Rows.Add(dataRow); } if (start == 1) { throw new Exception("不是标准模板,禁止导入!"); } return dt1; } private List InitData(DataTable dtMain, DataTable dtSub, DataTable dtINV, DataTable dtEQ, DataTable dtBaseOP) { DateTime timeNow = AppConfig.GetSeverDateTime("yyyy-MM-dd HH:mm:ss"); //DateTime timeNow = Convert.ToDateTime("1999-09-09 09:09:09"); string[] wpnames = AppConfig.WorkPointName.Split(new char[] { '(', ')', '(', ')' }); string wpname = wpnames[wpnames.Length - 1]; string ITEMID = ""; string ITEMCODE = ""; string ROUTECODE = ""; string defaultRoute = ""; string avaRoute = ""; string workPoint = ""; decimal ROUTEVER = 1.0m; ////1.工艺路线 //List list_route = new List(); ////2.工序 //List list_op = new List(); ////3.工艺绑定工序 //List list_r2o = new List(); ////4.1物料绑定工艺 //List list_i2r = new List(); ////4.2 ICSITEMROUTE2OP ////5.物料工艺工时 //List list_stp = new List(); string msgHead = ""; List list = new List(); foreach (DataRow drMain in dtMain.Rows) { string MgrRoute = drMain["工艺负责人"].ToString().Trim(); string 主序号 = drMain["主序号"].ToString();//0 ITEMCODE = ROUTECODE = drMain["物料编码"].ToString();//R01NAGV46201,工艺路线默认物料+流水号,保存时获取流水号 string factoryName = drMain["工厂"].ToString();//上海阿为特精密机械股份有限公司 defaultRoute = drMain["默认"].ToString();//Y avaRoute = drMain["版本类型"].ToString();//有效版本 string sROUTEVER = drMain["工艺路线版本"].ToString(); if (avaRoute != "有效版本" && defaultRoute != "Y") { continue; } if (!factoryName.Contains(wpname)) { throw new Exception("工厂错误, 只能导入当前登录账套的信息:" + AppConfig.WorkPointName); } if (!decimal.TryParse(sROUTEVER, out ROUTEVER)) { throw new Exception("工艺路线版本错误" + sROUTEVER); } if (string.IsNullOrEmpty(MgrRoute)) { throw new Exception("工艺负责人不能为空" + ITEMCODE); } DataRow[] drINV = dtINV.Select("ITEMCODE='" + ITEMCODE + "'"); if (drINV.Length == 0) { throw new Exception("物料不存在:" + ITEMCODE); } ITEMID = drINV[0]["ITEMID"].ToString(); DataRow[] drSubNew = dtSub.Select("主序号='" + 主序号 + "'"); if (drSubNew.Length == 0) { continue; } DataTable dtSubNew = drSubNew.CopyToDataTable(); DataTable dtNew = dtSub.Clone(); dtNew.Columns["Ahwit工序号"].DataType = typeof(int); foreach (DataRow s in dtSubNew.Rows) { dtNew.ImportRow(s); } dtNew.DefaultView.Sort = "Ahwit工序号 ASC"; dtNew = dtNew.DefaultView.ToTable(); ITEM2ROUTE2OP2TIMEawt info = null; bool existsInfo = false; for (int i = 0; i < list.Count; i++) { if (list[i].ITEMCODE == ITEMCODE) { existsInfo = true; info = list[i]; break; } } if (!existsInfo) { info = new ITEM2ROUTE2OP2TIMEawt(); info.ITEMID = ITEMID; info.ITEMCODE = ITEMCODE; info.MTIME = timeNow; info.USERID = AppConfig.UserId; info.USERCODE = AppConfig.UserCode; info.USERNAME = AppConfig.UserName; info.WorkPoint = AppConfig.WorkPointCode; info.listRoute = new List(); list.Add(info); } ROUTEawt route = null; bool existsRoute = false; foreach (ROUTEawt item in info.listRoute) { if (item.ROUTECODE == ROUTECODE + "_" + ROUTEVER.ToString("f1")) { existsRoute = true; route = item; break; } } if (!existsRoute) { route = new ROUTEawt(); route.ROUTEVER = ROUTEVER.ToString("f1"); route.ROUTECODE = ROUTECODE + "_" + route.ROUTEVER;//工艺编码:物料+工艺版本 route.MGR_USER = MgrRoute; route.ROUTETYPE = "Normal"; route.ENABLED = "生效"; route.EFFDATE = Convert.ToDateTime("2000-01-01 00:00:00.000"); route.IVLDATE = Convert.ToDateTime("2099-12-31 23:59:00.000"); route.listOP = new List(); info.listRoute.Add(route); } foreach (DataRow dr in dtNew.Rows) { // int OPSEQ = 0; string OPCODE = ""; string EQPTypeCode = ""; string EQPID = ""; string EQPCODE = ""; string EQPNAME = ""; string cClass = "Z"; int cHandles = 0; int cAxis = 0; int cToolMagazine = 0; int cMachinableProfiles = 0; string cAccuracy = "Z"; decimal? WTIME = 3; decimal RTIME = 0; decimal STIME = 0; decimal JYTIME = 0; decimal ZJTIME = 0; string OPLVL = ""; string OPMemo = ""; string OPAttr = ""; string CtrlType = ""; string CostCenter = ""; string OriOPCODE = dr["工序编码"].ToString(); string OriOPNAME = ""; string cxtype = ""; string cxjd = ""; string cxbrand1 = ""; string cxbrand2 = ""; string cxbrand3 = ""; if (OriOPCODE == "I01" || OriOPCODE == "W01" || OriOPCODE == "W02" || OriOPCODE == "") { continue; } var BaseOP = dtBaseOP.Select("OirOPCODE='" + OriOPCODE + "'"); if (BaseOP.Length == 0) { throw new Exception("没有找到基础工序" + OriOPCODE + "请先维护"); } OriOPNAME = BaseOP[0]["OriOPNAME"].ToString().Trim(); if (string.IsNullOrEmpty(OriOPNAME)) { throw new Exception("基础工序" + OriOPCODE + "名称是空"); } //string sOPSEQ = dr["系统工序号"].ToString();//10,20,30等 string sOPSEQ = dr["Ahwit工序号"].ToString(); string EQ6 = dr["Ahwit机器需求"].ToString();//C2540120180A OPMemo = dr["工艺描述"].ToString(); CostCenter = dr["工作中心编码"].ToString(); string sISWW = dr["委外工序"].ToString();//Y,N string sRTIME = dr["调机(准备)时间"].ToString(); sRTIME = string.IsNullOrEmpty(sRTIME) ? "0" : sRTIME; string sSTIME = dr["加工时间"].ToString(); sSTIME = string.IsNullOrEmpty(sSTIME) ? "0" : sSTIME; string sJYTIME = dr["检验(等待)时间"].ToString(); sJYTIME = string.IsNullOrEmpty(sJYTIME) ? "0" : sJYTIME; string sZJTIME = dr["装夹(拆卸)时间"].ToString(); sZJTIME = string.IsNullOrEmpty(sZJTIME) ? "0" : sZJTIME; string sWTIME = "3";//默认3天 OPLVL = dr["Ahwit难易程度"].ToString(); //阿威特生效时效绑定到了工序上,与程序框架不符,忽略此项. 默认工艺路线生效时效为2000-2999 //string s = dr["生效日期"].ToString(); //string e = dr["失效日期"].ToString(); msgHead = "主序号" + 主序号 + ",物料编码" + ITEMCODE + ",Ahwit工序号" + sOPSEQ + ",工序编码" + OriOPCODE; try { bool opsucc = Int32.TryParse(sOPSEQ, out OPSEQ); if (!opsucc || OPSEQ < 0) { throw new Exception("[Ahwit工序号] 必须是正整数"); } if (sISWW == "Y") { OPAttr = "委外"; CtrlType = "串行"; sWTIME = sSTIME; OPLVL = null; EQPTypeCode = "委外"; if (sWTIME == "" || sWTIME == "0") { throw new Exception("委外工序时,委外工时必须填写"); } WTIME = Convert.ToDecimal(sWTIME); if (WTIME <= 0) { throw new Exception("委外工时必须大于 0"); } } else { OPAttr = "自制"; CtrlType = "并行"; if (OPLVL == "高级") { OPLVL = "A"; } else if (OPLVL == "中级") { OPLVL = "B"; } else { OPLVL = "C"; } //工时判断 RTIME = Convert.ToDecimal(sRTIME); STIME = Convert.ToDecimal(sSTIME); JYTIME = Convert.ToDecimal(sJYTIME); ZJTIME = Convert.ToDecimal(sZJTIME); if (RTIME < 0 || STIME < 0 || JYTIME < 0 || ZJTIME < 0) { throw new Exception("非委外工序工时必须>=0"); } WTIME = 3; //6大维度 //if (string.IsNullOrEmpty(EQ6)) //{ // throw new Exception("非委外工序必须维护 [Ahwit机器需求]"); //} if (EQ6.Length == 12) { //6 截取规则:类型1刀柄2轴数1刀具3外形4精度1 EQPTypeCode = "加工中心"; cClass = EQ6.Substring(0, 1); string scHandles = EQ6.Substring(1, 2); string scAxis = EQ6.Substring(3, 1); string scToolMagazine = EQ6.Substring(4, 3); string scMachinableProfiles = EQ6.Substring(7, 4); cAccuracy = EQ6.Substring(11, 1); if (string.IsNullOrEmpty(cClass)) { throw new Exception("类别不能为空!"); } if (string.IsNullOrEmpty(scHandles)) { throw new Exception("刀柄不能为空!"); } if (string.IsNullOrEmpty(scAxis)) { throw new Exception("轴数不能为空!"); } if (string.IsNullOrEmpty(scToolMagazine)) { throw new Exception("刀库不能为空!"); } if (string.IsNullOrEmpty(scMachinableProfiles)) { throw new Exception("可加工外形不能为空!"); } if (string.IsNullOrEmpty(cAccuracy)) { throw new Exception("精度不能为空!"); } try { cHandles = Convert.ToInt32(scHandles); cAxis = Convert.ToInt32(scAxis); cToolMagazine = Convert.ToInt32(scToolMagazine); cMachinableProfiles = Convert.ToInt32(scMachinableProfiles); } catch (Exception) { throw new Exception("刀柄,轴数,刀库,可加工外形只能由数字组成: " + scHandles + "," + scAxis + "," + scToolMagazine + "," + scMachinableProfiles); } } else if (EQ6.Length == 8) { //设备 EQPTypeCode = "车削中心"; cxtype= EQ6.Substring(0, 1); cxbrand1= EQ6.Substring(2, 2); cxbrand2 = EQ6.Substring(4, 2); cxbrand3 = EQ6.Substring(6, 2); cxjd = EQ6.Substring(8, 1); if (string.IsNullOrEmpty(cxtype)) { throw new Exception("车削类别不能为空!"); } if (string.IsNullOrEmpty(cxjd)) { throw new Exception("车削精度不能为空!"); } if (string.IsNullOrEmpty(cxbrand1)&& string.IsNullOrEmpty(cxbrand2)&& string.IsNullOrEmpty(cxbrand3)) { throw new Exception("请至少维护一个车床品牌!"); } } else if (EQ6.Length == 0) { //设备 EQPTypeCode = "固定设备"; var drEQ1 = dtEQ.AsEnumerable().Where(a => ("," + a.Field("FIXOP").Trim().Trim(',') + ",").Contains("," + OriOPCODE + ",")); //var drEQ1 = dtEQ.Select("FIXOP like '%" + OriOPCODE + "%'"); var cErpEQ = drEQ1.AsDataView().Count; if (cErpEQ == 0) { throw new Exception("erp工序:" + OriOPCODE + "没有对应的固定设备"); } if (cErpEQ > 1) { throw new Exception("erp工序:" + OriOPCODE + "对应多个固定设备"); } var drEQ = drEQ1.CopyToDataTable(); EQPID = drEQ.Rows[0]["EQPID"].ToString().Trim(); EQPCODE = drEQ.Rows[0]["EQPCODE"].ToString().Trim(); EQPNAME = drEQ.Rows[0]["EQPNAME"].ToString().Trim(); } else { throw new Exception("[Ahwit机器需求] : " + EQ6 + ",只能是12位(六大维度)或空(固定设备)或8位(车削中心) .当前位数:" + EQ6.Length.ToString()); } } } catch (Exception ex) { throw new Exception(msgHead + "\r\n" + ex.Message); } OPTIMEawt op = new OPTIMEawt(); op.ID = AppConfig.GetGuid(); op.OPSEQ = OPSEQ; op.OriOPCODE = OriOPCODE; int flow = 1; foreach (OPTIMEawt item in route.listOP) { if (item.OriOPCODE == op.OriOPCODE) { // OPCODE=OriOPCODE+本工序出现次数 flow++; } } op.OPCODE = op.OriOPCODE + flow.ToString().PadLeft(2, '0'); op.OPNAME = op.OPDESC = OriOPNAME + flow.ToString().PadLeft(2, '0'); op.OPCOLLECTION = "人工收集"; op.OPCONTROL = "10000000000000"; op.CostCenter = CostCenter;//阿威特没有用到加工中心 op.OpFrom = "NC"; op.EnableFlag = true; op.OPLVL = OPLVL; op.OPAttr = OPAttr; op.CtrlType = CtrlType; //--// op.默认工时 = "是"; op.WTIME = WTIME; op.RTIME = RTIME; op.STIME = STIME; op.ZJTime = ZJTIME; op.JYTime = JYTIME; op.Type = EQPTypeCode; op.Status = "New"; op.cClass = cClass; op.cHandles = cHandles; op.cAxis = cAxis; op.cToolMagazine = cToolMagazine; op.cMachinableProfiles = cMachinableProfiles; op.cAccuracy = cAccuracy; op.Memo = OPMemo; op.EQPCODE = EQPCODE; op.CXBrand1 = cxbrand1; op.CXBrand2 = cxbrand2; op.CXBrand3 = cxbrand3; op.CXJD = cxjd; op.CXTYPE = cxtype; route.listOP.Add(op); #region 旧实体 // ICSOP INFO_OP = new ICSOP(); //INFO_OP.ID = AppConfig.GetGuid(); //INFO_OP.OPCODE = OPCODE; //INFO_OP.OPDESC = INFO_OP.OPNAME = OPCODE;//NAME同CODE //INFO_OP.OPCOLLECTION = "人工收集"; //INFO_OP.OPCONTROL = "10000000000000"; //INFO_OP.CostCenter = CostCenter; //INFO_OP.OpFrom = "NC"; //INFO_OP.EnableFlag = true; //INFO_OP.MTIME = timeNow; //INFO_OP.EATTRIBUTE1 = OPAttr == "自制" ? "0" : "1"; //INFO_OP.MUSER = AppConfig.UserId; //INFO_OP.MUSERName = AppConfig.UserName; //INFO_OP.WorkPoint = AppConfig.WorkPointCode; //ICSROUTE INFO_ROUTE = new ICSROUTE(); //INFO_ROUTE.ID = AppConfig.GetGuid(); //INFO_ROUTE.ROUTECODE = ROUTECODE;//动态 //INFO_ROUTE.ROUTEDESC = ROUTECODE; //INFO_ROUTE.ROUTETYPE = "Normal"; //INFO_ROUTE.ENABLED = "生效"; //INFO_ROUTE.EFFDATE = Convert.ToDateTime("2000-01-01 00:00:00.000"); //INFO_ROUTE.IVLDATE = Convert.ToDateTime("2099-12-31 23:59:00.000"); //INFO_ROUTE.EATTRIBUTE1 = null; //INFO_ROUTE.MTIME = timeNow; //INFO_ROUTE.MUSER = AppConfig.UserId; //INFO_ROUTE.MUSERName = AppConfig.UserName; //INFO_ROUTE.WorkPoint = AppConfig.WorkPointCode; //ICSROUTE2OP INFO_R2OP = new ICSROUTE2OP(); //INFO_R2OP.ID = AppConfig.GetGuid(); //INFO_R2OP.ROUTEID = null;//保存后获取 //INFO_R2OP.OPID = null;//保存后获取 //INFO_R2OP.ROUTECODE = ROUTECODE;//动态 //INFO_R2OP.OPCODE = OPCODE; //INFO_R2OP.OPSEQ = OPSEQ; //INFO_R2OP.OPCONTROL = "10000000000000"; //INFO_R2OP.OPAttr = OPAttr; //INFO_R2OP.CtrlType = CtrlType; //INFO_R2OP.MUSER = AppConfig.UserCode; //INFO_R2OP.MUSERName = AppConfig.UserName; //INFO_R2OP.MTIME = DateTime.Now; //INFO_R2OP.WORKPOINT = AppConfig.WorkPointCode; //ICSEQPSTP INFO_EQPSTP = new ICSEQPSTP(); //INFO_EQPSTP.ID = AppConfig.GetGuid(); //INFO_EQPSTP.ITEMCODE = ITEMCODE; //INFO_EQPSTP.OPCODE = OPCODE; //INFO_EQPSTP.EQPCODE = EQPCODE; //INFO_EQPSTP.ETTRCODE = ""; //INFO_EQPSTP.ISREF = "是"; //INFO_EQPSTP.Status = "New"; //INFO_EQPSTP.JiaGongTime = INFO_EQPSTP.STIME = STIME; //INFO_EQPSTP.TiaoJiTime = INFO_EQPSTP.RTIME = RTIME; //INFO_EQPSTP.JiaZhuangTime = ZJTIME; //INFO_EQPSTP.JianYanTime = JYTIME; //INFO_EQPSTP.EQPTypeCode = EQPTypeCode;//此处不在存设备类型,设备类型是6大维度决定 //INFO_EQPSTP.cClass = cClass; //INFO_EQPSTP.cHandles = cHandles; //INFO_EQPSTP.cAxis = cAxis; //INFO_EQPSTP.cToolMagazine = cToolMagazine; //INFO_EQPSTP.cMachinableProfiles = cMachinableProfiles; //INFO_EQPSTP.cAccuracy = cAccuracy; //INFO_EQPSTP.OPLVL = OPLVL; //INFO_EQPSTP.WTIME = WTIME; //INFO_EQPSTP.EATTRIBUTE1 = ROUTECODE; //INFO_EQPSTP.ToolingNo = OPMemo; //INFO_EQPSTP.MUSER = AppConfig.UserCode; //INFO_EQPSTP.MUSERName = AppConfig.UserName; //INFO_EQPSTP.MTIME = DateTime.Now; //INFO_EQPSTP.WorkPoint = AppConfig.WorkPointCode; //list_stp.Add(INFO_EQPSTP); #endregion } } return list; } private DataTable GetFIXEQ(string conn, string wp) { return ICSEQPSTPBLL.GetFIXEQ(conn, wp); } private DataTable GetINV(string conn, string wp) { return ICSEQPSTPBLL.GetINV(conn, wp); } private DataTable GetBaseOP(string conn, string wp) { return ICSEQPSTPBLL.GetBaseOP(conn, wp); } #endregion } }