using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using SQLHelper; namespace MES { public partial class Sc_ProcessFlowQuery : Form { public Sc_ProcessFlowQuery() { InitializeComponent(); } public string ModName = ""; public string ModCaption = "工序流转进度查询"; Pub_Class.ClsGridListSum oSumGrid = new Pub_Class.ClsGridListSum(); // private void initGrid() { DBUtility.Xt_BaseBillFun.initGridRpt(grdMain, this.Name); } // private void Display() { ClsCN SubCn = new ClsCN(); DataSet DSet = new DataSet(); //显示报表头 标题 //停止GRID刷新 加快速度 //显示过滤条件 //过滤条件Dlg string sDlgWhere = ""; sDlgWhere = sDlgWhere + ",'" + dtpHBDate.Value.ToShortDateString() + "'"; sDlgWhere = sDlgWhere + ",'" + dtpHEDate.Value.ToShortDateString() + "'"; sDlgWhere = sDlgWhere + "," + DBUtility.ClsPub.isLong(txtHSourceID.Tag); sDlgWhere = sDlgWhere + "," + DBUtility.ClsPub.isLong(txtHDeptID.Tag); sDlgWhere = sDlgWhere + ",'" + txtHBillNo.Text.Trim() + "'"; sDlgWhere = sDlgWhere + ",'" + cmbHStatus.Text.Trim() + "'"; if (sDlgWhere.Trim().Length > 0) { sDlgWhere = sDlgWhere.Substring(1, sDlgWhere.Length - 1); } // DSet = SubCn.RunProcReturn("exec h_p_Sc_ProcessFlowQuery " + sDlgWhere, "Gy_Czygl", ref Pub_Class.ClsPub.sExeReturnInfo); //生成首行标题 if (DSet == null) { MessageBox.Show("没有返回任何结果,尝试再次查询！" + DBUtility.ClsPub.sExeReturnInfo); return; } // grdMain.DataSource = DSet.Tables[0].DefaultView; //设置合计列 string sTotalCol = ""; sTotalCol = DBUtility.Gy_BaseFun.GetTotalCols(DSet); string[] sT; sT = sTotalCol.Split(Convert.ToChar(",")); oSumGrid.BuildTotalCols(sT); // DBUtility.Xt_BaseBillFun.DisplayGrid(grdMain, this.Name, "是", 0); // DBUtility.Xt_BaseBillFun.GetGrid(grdMain, this.Name); Total(); } // private void timer1_Tick(object sender, EventArgs e) { timer1.Enabled = false; cmbHStatus.SelectedIndex = 0; DBUtility.Gy_BaseFun.GetControlInfo(groupBox1, this.Name); initGrid(); Display(); } private void tc_Click(object sender, EventArgs e) { this.Close(); } private void sx_Click(object sender, EventArgs e) { Int64 HMainID = 0; Int64 HSubID = 0; Int64 sSourceID = 0; Int64 sItemID = 0; if (grdMain.CurrentRow == null) return; HMainID = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[Fun_GetCol("HProcPlanInterID")].Value); HSubID = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[Fun_GetCol("HProcPlanEntryID")].Value); sSourceID = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[Fun_GetCol("HSourceID")].Value); sItemID = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[Fun_GetCol("hMainID")].Value); if (HMainID == 0) return; Sc_ProcessReport_Simple oBill = new Sc_ProcessReport_Simple(); oBill.BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew; oBill.sHProcPlanInterID = HMainID; oBill.sHProcPlanEntryID = HSubID; oBill.lSourceID = sSourceID; oBill.HICMOStatusInterID = sItemID; oBill.ShowDialog(); } private void dj_Click(object sender, EventArgs e) { Sub_ShowBill();// 生成领料单 } //显示单据 private void Sub_ShowBill() { //Int64 lngBillKey = 0; //double sDayPlanQty = 0; //Int64 lMainID = 0; //if (grdMain.CurrentRow == null) // return; //lMainID = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[Fun_GetCol("hMainID")].Value); //lngBillKey = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[Fun_GetCol("HICMOInterID")].Value); //sDayPlanQty = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[Fun_GetCol("本日计划数")].Value); //if (lngBillKey == 0) // return; //WarM.Kf_MateOutBill oBill = new WarM.Kf_MateOutBill(); //oBill.BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew; //oBill.HICMOInterID = lngBillKey; //oBill.sDayPlanQty = sDayPlanQty; //oBill.HICMOStatusInterID = lMainID; //oBill.ShowDialog(); } // private Int32 Fun_GetCol(string sCol) { return DBUtility.Xt_BaseBillFun.Fun_GetCol(sCol, grdMain); } // private void Sc_ProcessFlowQuery_Load(object sender, EventArgs e) { SetFormCaption(); oSumGrid.ogrdMain = grdMain; //初始化 new oSumGrid.oGridsum = grdSum; } //设置报表名称 private void SetFormCaption() { this.Text = ModCaption; lblCaption.Text = this.Text; initGrid();//网格标题初始化 } private void cx_Click(object sender, EventArgs e) { DBUtility.Gy_BaseFun.SaveControlInfo(groupBox1, this.Name); Display(); } private void xz_Click(object sender, EventArgs e) { //Int64 lngBillKey = 0; //if (grdMain.CurrentRow == null) // return; //lngBillKey = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[Fun_GetCol("HICMOInterID")].Value); //if (lngBillKey == 0) // return; //WarM.Kf_ProductInBill_K3 oBill = new WarM.Kf_ProductInBill_K3(); //oBill.BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew; //oBill.sHICMOInterID = lngBillKey; //oBill.ShowDialog(); Sc_ProcessReportQuery oSc_ProcessReportQuery = new Sc_ProcessReportQuery(); oSc_ProcessReportQuery.ShowDialog(); } private void sc_Click(object sender, EventArgs e) { Sub_DeleteBill(); } //删除 private void Sub_DeleteBill() { //编辑权限 //if (!DBUtility.ClsPub.Security_Log(ModRightNameEdit, 1, true,DBUtility.ClsPub.CurUserName)) //{ // return; //} //// //Int64 lngBillKey = 0; //if (grdMain.CurrentRow == null) // return; //lngBillKey = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[Fun_GetCol("hmainid")].Value); //if (lngBillKey == 0) // return; //DAL.ClsSc_ProcessReport oBill = new DAL.ClsSc_ProcessReport(); //if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) //{ // if (MessageBox.Show("确定要删除当前单据？", "提示", MessageBoxButtons.OKCancel)==DialogResult.OK) // { // if (oBill.omodel.HChecker != "") // { // MessageBox.Show("单据已经审核,不能删除！", "提示"); // return; // } // if (!oBill.DeleteBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo)) // { // MessageBox.Show(DBUtility.ClsPub.sExeReturnInfo, "提示"); // return; // } // else // { // Display(); // } // } //} //else //{ // MessageBox.Show("单据未找到", "提示"); //} } private void timer2_Tick(object sender, EventArgs e) { timer2.Enabled = false; timer1.Enabled = true; } private void bclk_Click(object sender, EventArgs e) { //保存列宽 DBUtility.Xt_BaseBillFun.SaveGrid(grdMain, this.Name); } private void mrlk_Click(object sender, EventArgs e) { DBUtility.Xt_BaseBillFun.DefaultGridView(grdMain, this.Name); } // private void GraphicsGrid() { DBUtility.Xt_BaseBillFun.GraphicsGrid(grdMain); } #region //打印设置 //GridppReport Report; ////预览 //private void yl_Click(object sender, EventArgs e) //{ // //选择打印模板 // BLL.Gy_OpenTmp oFrm = new BLL.Gy_OpenTmp(); // oFrm.sBillName = ModName; // oFrm.sBillModel = ModCaption; // oFrm.ShowDialog(); // if (oFrm.OKTag == Pub_Class.ClsPub.Enum_OKTag.OKTag_OK) // { // // // Sub_SetReport(oFrm.sOpenTmp); // Report.PrintPreview(true); // } //} //private void Sub_SetReport(string sOpenTmp) //{ // //判断行数 // // // Report = new GridppReport(); // Report.LoadFromFile(DBUtility.ClsPub.AppPath + @"\" + sOpenTmp + ".grf"); //here . // Report.FetchRecord += new _IGridppReportEvents_FetchRecordEventHandler(ReportFetchRecordByDataTable); //} //private void ReportFetchRecordByDataTable() //{ // //BLL.Utility.FillRecordToReport(Report, grdMain, grdPrint, Fun_GetCol("HMaterID")); //} #endregion // private void grdMain_Paint(object sender, PaintEventArgs e) { GraphicsGrid(); } //合计 new private void Total() { if (grdMain.Rows.Count > 0 && grdMain.ColumnCount > 0) { oSumGrid.SetGridsum(); oSumGrid.Total(); } } //合计 new private void grdMain_ColumnWidthChanged(object sender, DataGridViewColumnEventArgs e) { Total(); } //合计 new private void grdMain_CellMouseUp(object sender, DataGridViewCellMouseEventArgs e) { Total(); } //导出EXCEL private void dc_Click(object sender, EventArgs e) { DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain); } private void kg_Click(object sender, EventArgs e) { if (grdMain.CurrentRow == null) return; ClsCN oCn = new ClsCN(); long lngBillKey = 0; lngBillKey = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentCell.RowIndex].Cells[Fun_GetCol("hMainID")].Value); // oCn.RunProc("exec h_p_Sc_UpDateICMOBillQualityStatus " + lngBillKey.ToString() + ",1"); MessageBox.Show("计划单开工！"); } private void gq_Click(object sender, EventArgs e) { } private void gy_Click(object sender, EventArgs e) { if (grdMain.CurrentRow == null) return; ClsCN oCn = new ClsCN(); DataSet oDs = new DataSet(); long HMaterID = 0; long lngBillKey = 0; HMaterID =DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentCell.RowIndex].Cells[Fun_GetCol("hmaterid")].Value); oDs = oCn.RunProcReturn("select top 1 * from Gy_RoutingBillMain where hmaterid=" + HMaterID.ToString() + " and hdeleteman=''", "Gy_RoutingBillMain"); if (oDs == null || oDs.Tables[0].Rows.Count == 0) { return; } lngBillKey = DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0]["HInterID"]); // Sub_ShowRoutingBill(lngBillKey); } private void Sub_ShowRoutingBill(long lngBillKey) { //if (lngBillKey == 0) // return; //DAL.ClsGy_RoutingBill oBill = new DAL.ClsGy_RoutingBill(); //if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) //{ // PlanM.Gy_RoutingBill oFrm = new PlanM.Gy_RoutingBill(); // oFrm.ModCaption = "工序路线"; // oFrm.BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_View; // oFrm.BillOld = oBill; // oFrm.ShowDialog(); //} //else //{ // MessageBox.Show("工艺路线未找到", "提示"); //} //oBill = null; } private void qt_Click(object sender, EventArgs e) { } private void dy_Click(object sender, EventArgs e) { Int64 lngBillKey = 0; double sPlanQty = 0; string sICMOBillNo = ""; if (grdMain.CurrentRow == null) return; lngBillKey = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[Fun_GetCol("HMaterID")].Value); sICMOBillNo = DBUtility.ClsPub.isStrNull(grdMain.Rows[grdMain.CurrentRow.Index].Cells[Fun_GetCol("任务单号")].Value); sPlanQty = DBUtility.ClsPub.isDoule(grdMain.Rows[grdMain.CurrentRow.Index].Cells[Fun_GetCol("本日计划数")].Value); if (lngBillKey == 0) return; Sc_ProcessFlowCard oBill = new Sc_ProcessFlowCard(); oBill.BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew; oBill.sHMaterID = lngBillKey; oBill.sHICMOBillNo = sICMOBillNo; oBill.sHPlanQty = sPlanQty; oBill.ShowDialog(); } private void cmdHGroupID_Click(object sender, EventArgs e) { DAL.ClsGy_Source_View oGroup = new DAL.ClsGy_Source_View(); if (oGroup.RefreshView()) { txtHSourceID.Tag = oGroup.oModel.HItemID.ToString(); txtHSourceID.Text = oGroup.oModel.HName; } } private void txtHSourceID_TextChanged(object sender, EventArgs e) { if (txtHSourceID.Text.Trim() == "") { txtHSourceID.Tag = ""; } } private void cmdHDeptID_Click(object sender, EventArgs e) { DAL.ClsGy_Department_View oDept = new DAL.ClsGy_Department_View(); if (oDept.RefreshView()) { txtHDeptID.Tag = oDept.oModel.HItemID.ToString(); txtHDeptID.Text = oDept.oModel.HName; } } private void txtHDeptID_TextChanged(object sender, EventArgs e) { if (txtHDeptID.Text.Trim() == "") { txtHDeptID.Tag = ""; } } } }