using System;
|
using System.Collections.Generic;
|
using System.ComponentModel;
|
using System.Data;
|
using System.Drawing;
|
using System.Text;
|
using System.Windows.Forms;
|
using gregn6Lib;
|
using Pub_Class;
|
using SQLHelper;
|
|
namespace WorkM
|
{
|
public partial class Sc_ProcessExchangeBill_DH1 : Form
|
{
|
public Sc_ProcessExchangeBill_DH1()
|
{
|
InitializeComponent();
|
}
|
//定义列
|
// 定义列 - 根据新字段重新定义
|
public const Int16 HSnoCol = 0; // 序号
|
public const Int16 HICMOInterIDCol = 1; // 生产订单内码
|
public const Int16 HICMOEntryIDCol = 2; // 生产订单子内码
|
public const Int16 HICMOBillNoCol = 3; // 生产订单号
|
public const Int16 HWorkShopIDCol = 4; // 生产车间
|
public const Int16 HMaterIDCol = 5; // HMaterID
|
public const Int16 HMaterNumberCol = 6; // 物料代码
|
public const Int16 HMaterNameCol = 7; // 物料名称
|
public const Int16 HMaterModelCol = 8; // 规格型号
|
public const Int16 HQtyCol = 9; // 订单总数
|
public const Int16 HProQtyCol = 10; // 流转卡数量
|
public const Int16 HBatchNoCol = 11; // 批次号
|
public const Int16 HProjectNumCol = 12; // 项目编号
|
public const Int16 HMateOutBatchNoCol = 13; // 原料批次
|
public const Int16 HMouldNumCol = 14; // 模穴号
|
public const Int16 HGroupNumberCol = 15; // 班组
|
public const Int16 HBatchManagerCol = 16; // 启用批次
|
public const Int16 HRoutingInterIDCol = 17; // 工艺路线内码
|
public const Int16 HRoutingNameCol = 18; // 工艺路线
|
public const Int16 HDateCol = 19; // 流转卡日期
|
public const Int16 HInterIDCol = 20; // 流转卡内码
|
public const Int16 HBillNoCol = 21; // 流转卡号
|
public const Int16 HEditCol = 22;
|
|
// 总列数
|
public const Int16 TotalColumnCount = 23;
|
|
|
|
|
//
|
public const string ModName = "3772"; //单据类型
|
public string ModCaption = "工序流转卡"; //单据名称
|
public const string ModRightName = "Sc_ProcessExchangeBill";
|
public const string ModRightNameEdit = ModRightName + "_Edit";
|
public const string ModRightNameCheck = ModRightName + "_Check";
|
public const string ModRightNameClose = ModRightName + "_Close";
|
public const string ModRightNameDelete = ModRightName + "_Delete";
|
public const string ModRightNameMoney = ModRightName + "_Money";
|
public const string ModRightNameQty = ModRightName + "_Qty";
|
public bool BillChange; //单据修改状态
|
//
|
public DBUtility.ClsPub.Enum_BillStatus BillStatus; //单据状态（新增，修改，浏览，更新单价，变更）
|
public Int64 KeyID; //单据主内码
|
public bool grdStatus; //网格状态（不可编辑，可编辑）
|
public DAL.ClsSc_ProcessExchangeBill BillNew = new DAL.ClsSc_ProcessExchangeBill(); //对应单据类
|
public DAL.ClsSc_ProcessExchangeBill BillOld = new DAL.ClsSc_ProcessExchangeBill(); //对应单据类
|
ClsGridViewSum oSumGrid = new ClsGridViewSum();
|
public DataSet oXT;
|
public string CampanyName = ""; //客户定制化名称
|
|
// 添加属性来接收选中的订单ID
|
public List<string> SelectedOrderIds { get; set; }
|
public string HSouceBillType { get; set; }
|
//-------------------------------------------------------------------------
|
|
#region 固定代码
|
|
|
//清空界面
|
public void Sub_ClearBill()
|
{
|
|
txtHMaker.Text = ClsPub.CurUserName;
|
txtHMakeDate.Text = "";
|
txtHChecker.Text = "";
|
txtHCheckDate.Text = "";
|
txtHCloseMan.Text = "";
|
txtHCloseDate.Text = "";
|
txtHDeleteMan.Text = "";
|
txtHDeleteDate.Text = "";
|
txtHUpDater.Text = "";
|
txtHUpDateDate.Text = "";
|
initGrid();
|
}
|
|
//保存列宽
|
private void bclk_Click(object sender, EventArgs e)
|
{
|
DBUtility.Xt_BaseBillFun.SaveGrid(grdMain, this.Name);
|
}
|
//增行按钮
|
private void AddRow_Click(object sender, EventArgs e)
|
{
|
if (grdMain.CurrentRow == null)
|
{
|
return;
|
}
|
if (DBUtility.ClsPub.isBool(grdMain.Rows[grdMain.CurrentRow.Index].Cells[HEditCol].Value) == false)
|
{
|
DBUtility.Xt_BaseBillFun.AddRow(oSumGrid);
|
}
|
}
|
//删行按纽
|
private void DelRow_Click(object sender, EventArgs e)
|
{
|
if (grdMain.CurrentRow == null)
|
{
|
return;
|
}
|
if (DBUtility.ClsPub.isBool(grdMain.Rows[grdMain.CurrentRow.Index].Cells[HEditCol].Value) == false)
|
{
|
DBUtility.Xt_BaseBillFun.DelRow(oSumGrid);
|
}
|
}
|
private void mrlk_Click(object sender, EventArgs e)
|
{
|
DBUtility.Xt_BaseBillFun.DefaultGridView(grdMain, this.Name);
|
}
|
|
//放弃 编辑
|
private void Sub_AbandonBill()
|
{
|
if (BillStatus == DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew || BillStatus == DBUtility.ClsPub.Enum_BillStatus.BillStatus_Modify)
|
{
|
if (MessageBox.Show("单据尚未保存,是否放弃？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
|
{
|
}
|
}
|
}
|
private void Sc_ProcessExchangeBill_Paint(object sender, PaintEventArgs e)//画线
|
{
|
|
}
|
//控件位置
|
private void Sub_ControlLocation()
|
{
|
//
|
}
|
|
//窗体加载
|
private void Sc_ProcessExchangeBill_Load(object sender, EventArgs e)
|
{
|
//打印初始化
|
oSumGrid.NoCol = HSnoCol;
|
oSumGrid.ogrdMain = grdMain;
|
oSumGrid.oGridsum = grdSum;
|
//
|
this.Text = ModCaption; //命名窗体标题
|
this.lblCaption.Text = ModCaption;//命名单据标题
|
}
|
|
//保存按钮
|
private void bc_Click(object sender, EventArgs e)
|
{
|
this.Sub_SaveBill();
|
}
|
//放弃按钮
|
private void fq_Click(object sender, EventArgs e)
|
{
|
this.Sub_AbandonBill();
|
}
|
//退出按钮
|
private void tc_Click(object sender, EventArgs e)
|
{
|
this.Close();
|
}
|
|
|
//timer
|
private void timer1_Tick(object sender, EventArgs e)
|
{
|
timer1.Enabled = false;
|
Sub_ControlLocation();
|
if (BillStatus == DBUtility.ClsPub.Enum_BillStatus.BillStatus_View)
|
{
|
|
}
|
else
|
{
|
this.Sub_AddBill();
|
DBUtility.Xt_BaseBillFun.SetSumGrid(oSumGrid);
|
}
|
// 如果有选中的订单ID，直接查询并显示数据
|
if (SelectedOrderIds != null && SelectedOrderIds.Count > 0)
|
{
|
LoadAndDisplaySelectedOrders();
|
}
|
else if (oXT != null)
|
{
|
Sub_WriteInForm(oXT.Tables[0], 0);
|
}
|
|
}
|
//窗体卸载
|
private void Sc_ProcessExchangeBill_FormClosing(object sender, FormClosingEventArgs e)
|
{
|
BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew;
|
DBUtility.Xt_BaseBillFun.SaveGrid(grdMain, this.Name);
|
}
|
|
|
#endregion
|
|
#region 读写类
|
|
//单据完整性判断 未完成
|
private bool Sub_AllowSave()
|
{
|
//明细表是否为零行
|
bool b = false;
|
for (int i = 0; i < grdMain.RowCount; i++)
|
{
|
|
}
|
if (b == false)
|
{
|
MessageBox.Show("表体明细行不存在！请录入！", "提示");
|
return false;
|
}
|
return true;
|
}
|
|
|
//保存单据
|
private bool Sub_SaveBill()
|
{
|
try
|
{
|
Model.ClsSc_ProcessExchangeBillSub oBillSub = new Model.ClsSc_ProcessExchangeBillSub();
|
Int32 i;
|
bool bResult;
|
BillNew = new DAL.ClsSc_ProcessExchangeBill();
|
//失去焦点
|
lblCaption.Focus();
|
//赋值ID
|
if (BillStatus == DBUtility.ClsPub.Enum_BillStatus.BillStatus_Modify)
|
BillNew.omodel.HInterID = BillOld.omodel.HInterID;
|
else if (BillStatus == DBUtility.ClsPub.Enum_BillStatus.BillStatus_UpdatePrice)
|
BillNew.omodel.HInterID = BillOld.omodel.HInterID;
|
//主类赋值
|
//判断会计期是否合理
|
string s = "";
|
int sYear = 0;
|
int sPeriod = 0;
|
|
//保存完毕后处理
|
if (BillStatus == DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew)
|
{
|
bResult = BillNew.AddBill(ref ClsPub.sExeReturnInfo);
|
}
|
else
|
{
|
bResult = BillNew.ModifyBill(BillNew.omodel.HInterID, ref ClsPub.sExeReturnInfo);
|
}
|
//提示
|
if (bResult == true)
|
{
|
return true;
|
}
|
else
|
{
|
MessageBox.Show("保存失败!原因:" + ClsPub.sExeReturnInfo, "提示");
|
return false;
|
}
|
}
|
catch(Exception e1)
|
{
|
MessageBox.Show(ClsPub.sExeReturnInfo + e1.Message);
|
return false;
|
}
|
}
|
#endregion
|
|
|
#region 窗体处理方法
|
//初始化GRID
|
private void initGrid()
|
{
|
// 清空现有列
|
grdMain.Columns.Clear();
|
|
// 设置总列数
|
grdMain.ColumnCount = TotalColumnCount;
|
|
// 设置行头和列头样式
|
grdMain.RowsDefaultCellStyle.WrapMode = DataGridViewTriState.True;
|
grdMain.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.EnableResizing;
|
grdMain.RowHeadersVisible = true;
|
grdMain.AllowUserToResizeRows = true;
|
|
// 设置列标题和属性
|
// 序号列（自动编号）
|
grdMain.Columns[HSnoCol].HeaderText = "序号";
|
grdMain.Columns[HSnoCol].Width = 100;
|
grdMain.Columns[HSnoCol].ReadOnly = true;
|
|
// 生产订单内码 - 隐藏
|
grdMain.Columns[HICMOInterIDCol].HeaderText = "生产订单内码";
|
grdMain.Columns[HICMOInterIDCol].Width = 100;
|
grdMain.Columns[HICMOInterIDCol].Visible = false;
|
|
// 生产订单子内码 - 隐藏
|
grdMain.Columns[HICMOEntryIDCol].HeaderText = "生产订单子内码";
|
grdMain.Columns[HICMOEntryIDCol].Width = 100;
|
grdMain.Columns[HICMOEntryIDCol].Visible = false;
|
|
// 生产订单号
|
grdMain.Columns[HICMOBillNoCol].HeaderText = "生产订单号";
|
grdMain.Columns[HICMOBillNoCol].Width = 120;
|
grdMain.Columns[HICMOBillNoCol].ReadOnly = true;
|
|
// 生产车间 - 隐藏
|
grdMain.Columns[HWorkShopIDCol].HeaderText = "生产车间";
|
grdMain.Columns[HWorkShopIDCol].Width = 100;
|
grdMain.Columns[HWorkShopIDCol].Visible = false;
|
|
// HMaterID - 隐藏
|
grdMain.Columns[HMaterIDCol].HeaderText = "HMaterID";
|
grdMain.Columns[HMaterIDCol].Width = 100;
|
grdMain.Columns[HMaterIDCol].Visible = false;
|
|
// 物料代码
|
grdMain.Columns[HMaterNumberCol].HeaderText = "物料代码";
|
grdMain.Columns[HMaterNumberCol].Width = 150;
|
grdMain.Columns[HMaterNumberCol].ReadOnly = true;
|
|
// 物料名称
|
grdMain.Columns[HMaterNameCol].HeaderText = "物料名称";
|
grdMain.Columns[HMaterNameCol].Width = 150;
|
grdMain.Columns[HMaterNameCol].ReadOnly = true;
|
|
// 规格型号 - 隐藏
|
grdMain.Columns[HMaterModelCol].HeaderText = "规格型号";
|
grdMain.Columns[HMaterModelCol].Width = 100;
|
grdMain.Columns[HMaterModelCol].Visible = false;
|
|
// 订单总数
|
grdMain.Columns[HQtyCol].HeaderText = "订单总数";
|
grdMain.Columns[HQtyCol].Width = 110;
|
grdMain.Columns[HQtyCol].ReadOnly = true;
|
|
// 流转卡数量 - 可编辑
|
grdMain.Columns[HProQtyCol].HeaderText = "流转卡数量";
|
grdMain.Columns[HProQtyCol].Width = 110;
|
grdMain.Columns[HProQtyCol].ReadOnly = false;
|
|
// 批次号 - 隐藏
|
grdMain.Columns[HBatchNoCol].HeaderText = "批次号";
|
grdMain.Columns[HBatchNoCol].Width = 110;
|
grdMain.Columns[HBatchNoCol].Visible = false;
|
grdMain.Columns[HBatchNoCol].ReadOnly = false;
|
|
// 项目编号 - 隐藏
|
grdMain.Columns[HProjectNumCol].HeaderText = "项目编号";
|
grdMain.Columns[HProjectNumCol].Width = 110;
|
grdMain.Columns[HProjectNumCol].Visible = false;
|
grdMain.Columns[HProjectNumCol].ReadOnly = false;
|
|
// 原料批次 - 隐藏
|
grdMain.Columns[HMateOutBatchNoCol].HeaderText = "原料批次";
|
grdMain.Columns[HMateOutBatchNoCol].Width = 110;
|
grdMain.Columns[HMateOutBatchNoCol].Visible = false;
|
grdMain.Columns[HMateOutBatchNoCol].ReadOnly = false;
|
|
// 模穴号 - 隐藏
|
grdMain.Columns[HMouldNumCol].HeaderText = "模穴号";
|
grdMain.Columns[HMouldNumCol].Width = 110;
|
grdMain.Columns[HMouldNumCol].Visible = false;
|
|
// 班组 - 隐藏
|
grdMain.Columns[HGroupNumberCol].HeaderText = "班组";
|
grdMain.Columns[HGroupNumberCol].Width = 110;
|
grdMain.Columns[HGroupNumberCol].Visible = false;
|
grdMain.Columns[HGroupNumberCol].ReadOnly = false;
|
|
// 启用批次 - 隐藏
|
grdMain.Columns[HBatchManagerCol].HeaderText = "启用批次";
|
grdMain.Columns[HBatchManagerCol].Width = 110;
|
grdMain.Columns[HBatchManagerCol].Visible = false;
|
|
// 工艺路线内码 - 隐藏
|
grdMain.Columns[HRoutingInterIDCol].HeaderText = "工艺路线内码";
|
grdMain.Columns[HRoutingInterIDCol].Width = 150;
|
grdMain.Columns[HRoutingInterIDCol].Visible = false;
|
|
// 工艺路线 - 可编辑
|
grdMain.Columns[HRoutingNameCol].HeaderText = "工艺路线";
|
grdMain.Columns[HRoutingNameCol].Width = 170;
|
grdMain.Columns[HRoutingNameCol].ReadOnly = false;
|
|
// 流转卡日期 - 可编辑
|
grdMain.Columns[HDateCol].HeaderText = "流转卡日期";
|
grdMain.Columns[HDateCol].Width = 120;
|
grdMain.Columns[HDateCol].ReadOnly = false;
|
|
// 流转卡内码 - 隐藏
|
grdMain.Columns[HInterIDCol].HeaderText = "流转卡内码";
|
grdMain.Columns[HInterIDCol].Width = 130;
|
grdMain.Columns[HInterIDCol].Visible = false;
|
|
grdMain.Columns[HEditCol].HeaderText = "不可编辑";
|
grdMain.Columns[HEditCol].Visible = false;
|
// 流转卡号
|
grdMain.Columns[HBillNoCol].HeaderText = "流转卡号";
|
grdMain.Columns[HBillNoCol].Width = 170;
|
grdMain.Columns[HBillNoCol].ReadOnly = true;
|
|
// 设置可编辑列
|
string sAllowCol = HProQtyCol.ToString() + "," +
|
HBatchNoCol.ToString() + "," +
|
HProjectNumCol.ToString() + "," +
|
HMateOutBatchNoCol.ToString() + "," +
|
HGroupNumberCol.ToString() + "," +
|
HRoutingNameCol.ToString() + "," +
|
HDateCol.ToString();
|
|
// 设置合计列
|
string sTotalCol = HQtyCol.ToString() + "," + HProQtyCol.ToString();
|
|
// 格式化网格
|
DBUtility.Xt_BaseBillFun.initGridLast(sAllowCol, sTotalCol, oSumGrid);
|
oSumGrid.SetGridMain();
|
|
// 设置隐藏列
|
DBUtility.ClsPub.HideGridView(grdMain, Name, ClsPub.AppPath);
|
}
|
|
//新增单据
|
private void Sub_AddBill()
|
{
|
this.BillNew = new DAL.ClsSc_ProcessExchangeBill();
|
this.BillOld = new DAL.ClsSc_ProcessExchangeBill();
|
this.BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew;
|
this.Sub_OperStatus();//设置TOOLBAR
|
this.Sub_ClearBill();//清空界面
|
}
|
|
//TOOLBAR状态 按钮是否灰度
|
public void Sub_OperStatus()
|
{
|
switch (BillStatus)
|
{
|
case DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew:
|
//新增状态
|
yl.Enabled = false;
|
dy.Enabled = false;
|
AddRow.Enabled = true;
|
DelRow.Enabled = true;
|
bc.Enabled = true;
|
fq.Enabled = true;
|
tc.Enabled = true;
|
Sub_LrtextStatus(true);
|
grdStatus = true;
|
break;
|
}
|
|
}
|
|
private void Sub_LrtextStatus(bool TextEnabled)
|
{
|
if (TextEnabled == true)
|
{
|
//控件全部有效
|
grdMain.BackColor = ClsPub.EditColor;
|
|
}
|
else
|
{ //控件全部无效
|
grdMain.BackColor = ClsPub.ViewColor;
|
}
|
}
|
|
//'判断网格行的录入是否正确
|
private bool CheckGridRow(int Row)
|
{
|
Cell oCell = new Cell();
|
int c = 0;
|
//for (c = 0; c < grdMain.ColumnCount; c++)
|
//{
|
// oCell.Row = Row;
|
// oCell.Col = c;
|
// //if (!CheckGridCell(oCell))
|
// // return false;
|
|
//}
|
return true;
|
}
|
|
//帮助函数
|
private void Sub_GridKey(int sKeyCode, int sRow, int sCol, DataGridViewTextBoxEditingControl oEdit)
|
{
|
if (!grdStatus)
|
{
|
return;
|
}
|
oSumGrid.EditStatus = true;
|
switch (sKeyCode)
|
{
|
case 118: //F7
|
{
|
switch (sCol)
|
{
|
|
default:
|
break;
|
}
|
break;
|
}
|
case 117: //F6
|
{
|
switch (sCol)
|
{
|
default:
|
break;
|
}
|
break;
|
}
|
default:
|
break;
|
}
|
}
|
|
|
#region 基本不变
|
|
|
//网格编辑前判断
|
private void grdMain_CellBeginEdit(object sender, DataGridViewCellCancelEventArgs e)
|
{
|
int i = grdMain.CurrentCell.ColumnIndex;
|
if (DBUtility.ClsPub.isBool(grdMain.Rows[grdMain.CurrentRow.Index].Cells[HEditCol].Value) == true)
|
{
|
e.Cancel = true;
|
}
|
if (DBUtility.Xt_BaseBillFun.AllowEdit(grdStatus, oSumGrid, i))
|
{
|
e.Cancel = true;
|
}
|
}
|
|
private void grdMain_Scroll(object sender, ScrollEventArgs e)
|
{
|
DBUtility.Xt_BaseBillFun.SetSumGrid(oSumGrid);
|
oSumGrid.DisplayCurRow();
|
}
|
|
//网格编辑后处理
|
private void grdMain_CellEndEdit(object sender, DataGridViewCellEventArgs e)
|
{
|
DBUtility.Xt_BaseBillFun.SetSumGrid(oSumGrid);
|
if (this.EditingControl != null) //释放事件
|
{
|
EditingControl.KeyDown -= new KeyEventHandler(this.EditingControl_KeyDown);
|
this.EditingControl = null;
|
}
|
}
|
|
DataGridViewTextBoxEditingControl EditingControl;
|
|
private void grdMain_CellLeave(object sender, DataGridViewCellEventArgs e)
|
{
|
//
|
if (!grdStatus)
|
{
|
return;
|
}
|
DBUtility.Xt_BaseBillFun.SetSumGrid(oSumGrid);
|
//
|
if (!CheckGridRow(oSumGrid.OldCell.Row))
|
return;
|
}
|
|
private void grdMain_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e)
|
{
|
if (grdMain.CurrentCell != null)
|
{
|
if (e.Control is DataGridViewTextBoxEditingControl)
|
{
|
this.EditingControl = (DataGridViewTextBoxEditingControl)e.Control;
|
//增加委托处理
|
this.EditingControl.KeyDown += new KeyEventHandler(this.EditingControl_KeyDown);
|
}
|
}
|
}
|
|
private void EditingControl_KeyDown(object sender, KeyEventArgs e)
|
{
|
//业务处理
|
Sub_GridKey(e.KeyValue, grdMain.CurrentRow.Index, grdMain.CurrentCell.ColumnIndex, EditingControl);
|
}
|
|
|
private void grdMain_RowHeadersWidthChanged(object sender, EventArgs e)
|
{
|
DBUtility.Xt_BaseBillFun.SetSumGrid(oSumGrid);
|
}
|
|
private void grdMain_ColumnWidthChanged(object sender, DataGridViewColumnEventArgs e)
|
{
|
DBUtility.Xt_BaseBillFun.SetSumGrid(oSumGrid);
|
}
|
|
#endregion
|
|
#endregion
|
|
|
#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(ClsPub.AppPath + @"\" + sOpenTmp + ".grf"); //here .
|
Report.BeforePostRecord += new _IGridppReportEvents_BeforePostRecordEventHandler(ReportBeforePostRecord);
|
Report.FetchRecord += new _IGridppReportEvents_FetchRecordEventHandler(ReportFetchRecordByDataTable);
|
}
|
//赋值表头
|
private void ReportBeforePostRecord()//
|
{
|
try
|
{
|
//Report.FieldByName("流转卡编号").AsString = txtHBillNo.Text;
|
//Report.FieldByName("流转卡数量").AsString = txtHQty.Text;
|
//Report.FieldByName("产品代码").AsString = txtHMaterNumber2.Text;
|
//Report.FieldByName("产品名称").AsString = txtHMaterID2.Text;
|
//Report.FieldByName("计划开工日期").AsString = dtpHPlanBeginDate.Value.ToShortDateString();
|
//Report.FieldByName("计划完工日期").AsString = dtpHPlanEndDate.Value.ToShortDateString();
|
//Report.FieldByName("订单跟踪号").AsString = txtHOrderProcNO.Text;
|
//Report.FieldByName("原料批次").AsString = txtHMateOutBatchNo.Text;
|
//Report.FieldByName("模具设备").AsString = txtHEquipMentID.Text;
|
//Report.FieldByName("项目号").AsString = txtHProjectNum.Text;
|
//Report.FieldByName("图号版本").AsString = textHPicNumVer.Text;
|
//Report.FieldByName("总装图号").AsString = textHPicNumAssemble.Text;
|
//Report.FieldByName("材质").AsString = textHMaterTexture.Text;
|
//Report.FieldByName("成品编号").AsString = textHProductNum.Text;
|
//Report.FieldByName("版本").AsString = textHVerNum.Text;
|
}
|
catch (Exception e)
|
{
|
MessageBox.Show("打印失败，[项目号],[流转卡编号],[流转卡数量],[产品代码],[产品名称],[计划开工日期],[计划完工日期],[订单跟踪号],[原料批次],[模具设备],[图号版本],[总装图号],[材质],[成品编号],[版本]." + e.Message);
|
}
|
|
}
|
//赋值表体
|
private void ReportFetchRecordByDataTable()
|
{
|
DataTable oDt = new DataTable();
|
// BLL.Utility.FillRecordToReport(Report, grdMain, oDt, HProcIDCol);
|
}
|
//打印设置
|
private void set_Click(object sender, EventArgs e)
|
{
|
//
|
BLL.Gy_OpenTmp oFrm = new BLL.Gy_OpenTmp();
|
oFrm.sBillName = ModName;
|
oFrm.sBillModel = ModCaption;
|
oFrm.ShowDialog();
|
}
|
//打印
|
private void dy_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);
|
BillOld.Set_PrintQty(DBUtility.ClsPub.isLong(BillOld.omodel.HInterID));
|
Report.Print(true);
|
}
|
}
|
|
#endregion
|
|
|
|
// 新增方法：根据选中的订单ID查询并显示数据
|
private void LoadAndDisplaySelectedOrders()
|
{
|
try
|
{
|
ClsCN oCn = new ClsCN();
|
DataTable combinedTable = null;
|
|
foreach (string orderId in SelectedOrderIds)
|
{
|
// 解析订单ID格式：主内码@子内码
|
string[] parts = orderId.Split('@');
|
if (parts.Length != 2) continue;
|
|
Int64 HICMOID = DBUtility.ClsPub.isLong(parts[0]);
|
Int64 HEntryID = DBUtility.ClsPub.isLong(parts[1]);
|
string sql = "exec h_p_Sc_ProcessExchange_DH '" + HICMOID + "','" + HEntryID + "'";
|
DataSet Ds = oCn.RunProcReturn(sql,"h_p_Sc_ProcessExchange_DH");
|
|
if (Ds != null && Ds.Tables[0].Rows.Count > 0)
|
{
|
if (combinedTable == null)
|
{
|
combinedTable = Ds.Tables[0].Copy();
|
}
|
else
|
{
|
// 合并数据
|
combinedTable.Merge(Ds.Tables[0]);
|
}
|
}
|
}
|
|
if (combinedTable != null && combinedTable.Rows.Count > 0)
|
{
|
// 直接调用现有的写入方法显示数据到明细页签
|
Sub_WriteInForm(combinedTable, 0);
|
}
|
else
|
{
|
MessageBox.Show("未能加载选中的生产订单数据！");
|
}
|
}
|
catch (Exception ex)
|
{
|
MessageBox.Show("加载订单数据失败：" + ex.Message);
|
}
|
}
|
|
private void yc_Click(object sender, EventArgs e)
|
{
|
BLL.Gy_GridView_Hide oHide = new BLL.Gy_GridView_Hide();
|
oHide.KeyItem = this.Name;
|
oHide.oGrd = grdMain;
|
oHide.ShowDialog();
|
//
|
DBUtility.ClsPub.HideGridView(grdMain, Name, ClsPub.AppPath);//设置隐藏列
|
}
|
|
private void 隐藏列设置ToolStripMenuItem_Click(object sender, EventArgs e)
|
{
|
|
}
|
|
|
|
private void grdMain_MouseUp(object sender, MouseEventArgs e)
|
{
|
|
if (grdMain.CurrentRow == null)
|
return;
|
}
|
|
|
|
//根据TABLE写入界面
|
public void Sub_WriteInForm(DataTable oTable, int j)
|
{
|
// 用于记录当前的生产订单和对应的流转卡信息
|
string currentSourceInterID = "";
|
string currentSourceEntryID = "";
|
string baseBillNo = "";
|
int k = 1; // 序号计数器
|
|
for (int i = 0; i <= oTable.Rows.Count - 1; i++)
|
{
|
if (i >= grdMain.RowCount - 1)
|
grdMain.Rows.Add();
|
|
string icmoInterID = oTable.Rows[i]["HICMOInterID"].ToString();
|
string icmoEntryID = oTable.Rows[i]["HICMOEntryID"].ToString();
|
|
string hInterID = "0"; // 默认内码为0
|
string hBillNo = ""; // 流转卡号
|
|
if (i == 0)
|
{
|
// 首次进入，获取基础流转卡单号
|
baseBillNo = ClsPub.CreateBillCode_Prod("3772", ref ClsPub.sExeReturnInfo, true);
|
hBillNo = baseBillNo + "-" + k.ToString().PadLeft(2, '0');
|
currentSourceInterID = icmoInterID;
|
currentSourceEntryID = icmoEntryID;
|
}
|
else if (currentSourceInterID == icmoInterID && currentSourceEntryID == icmoEntryID)
|
{
|
// 同一个生产订单，递增序号
|
k++;
|
hBillNo = baseBillNo + "-" + k.ToString().PadLeft(2, '0');
|
}
|
else
|
{
|
// 新的生产订单，重置序号和基础单号
|
baseBillNo = ClsPub.CreateBillCode_Prod("3772", ref ClsPub.sExeReturnInfo, true);
|
k = 1;
|
hBillNo = baseBillNo + "-" + k.ToString().PadLeft(2, '0');
|
currentSourceInterID = icmoInterID;
|
currentSourceEntryID = icmoEntryID;
|
}
|
|
// 加载表体数据到新定义的列
|
grdMain.Rows[i].Cells[HICMOInterIDCol].Value = oTable.Rows[i]["HICMOInterID"].ToString();
|
grdMain.Rows[i].Cells[HICMOEntryIDCol].Value = oTable.Rows[i]["HICMOEntryID"].ToString();
|
grdMain.Rows[i].Cells[HICMOBillNoCol].Value = oTable.Rows[i]["HICMOBillNo"].ToString();
|
grdMain.Rows[i].Cells[HWorkShopIDCol].Value = oTable.Rows[i]["HWorkShopID"].ToString();
|
grdMain.Rows[i].Cells[HMaterIDCol].Value = oTable.Rows[i]["HMaterID"].ToString();
|
grdMain.Rows[i].Cells[HMaterNumberCol].Value = oTable.Rows[i]["物料代码"].ToString();
|
grdMain.Rows[i].Cells[HMaterNameCol].Value = oTable.Rows[i]["物料名称"].ToString();
|
grdMain.Rows[i].Cells[HMaterModelCol].Value = oTable.Rows[i]["规格型号"].ToString();
|
grdMain.Rows[i].Cells[HQtyCol].Value = DBUtility.ClsPub.isDoule(oTable.Rows[i]["HQty"], 0);
|
grdMain.Rows[i].Cells[HProQtyCol].Value = DBUtility.ClsPub.isDoule(oTable.Rows[i]["HProQty"], 0);
|
|
grdMain.Rows[i].Cells[HBatchNoCol].Value = oTable.Rows[i]["HBatchNo"].ToString();
|
grdMain.Rows[i].Cells[HProjectNumCol].Value = "";
|
grdMain.Rows[i].Cells[HMateOutBatchNoCol].Value = "";
|
grdMain.Rows[i].Cells[HMouldNumCol].Value = "0#";
|
grdMain.Rows[i].Cells[HGroupNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HBatchManagerCol].Value = oTable.Rows[i]["是否启用批次"].ToString();
|
grdMain.Rows[i].Cells[HRoutingInterIDCol].Value = oTable.Rows[i]["HRoutingInterID"].ToString();
|
grdMain.Rows[i].Cells[HRoutingNameCol].Value = oTable.Rows[i]["HRoutingName"].ToString();
|
grdMain.Rows[i].Cells[HDateCol].Value = oTable.Rows[i]["HDate"].ToString();
|
grdMain.Rows[i].Cells[HInterIDCol].Value = hInterID; // 默认为0，保存时再生成实际内码
|
grdMain.Rows[i].Cells[HBillNoCol].Value = hBillNo;
|
grdMain.Rows[i].Cells[HEditCol].Value = false; // 明确设置为可编辑
|
|
// 设置序号
|
grdMain.Rows[i].Cells[HSnoCol].Value = (i + 1).ToString();
|
}
|
|
// 设置可编辑列
|
string sAllowCol = HProQtyCol.ToString() + "," +
|
HBatchNoCol.ToString() + "," +
|
HProjectNumCol.ToString() + "," +
|
HMateOutBatchNoCol.ToString() + "," +
|
HGroupNumberCol.ToString() + "," +
|
HRoutingNameCol.ToString() + "," +
|
HDateCol.ToString();
|
|
// 设置合计列
|
string sTotalCol = HQtyCol.ToString() + "," + HProQtyCol.ToString();
|
|
// 格式化网格
|
DBUtility.Xt_BaseBillFun.initGridLast(sAllowCol, sTotalCol, oSumGrid);
|
// 刷新合计行
|
DBUtility.Xt_BaseBillFun.SetSumGrid(oSumGrid);
|
}
|
|
|
|
|
private void yc_Click_1(object sender, EventArgs e)
|
{
|
BLL.Gy_GridView_Hide oHide = new BLL.Gy_GridView_Hide();
|
oHide.KeyItem = this.Name;
|
oHide.oGrd = grdMain;
|
oHide.ShowDialog();
|
//
|
DBUtility.ClsPub.HideGridView(grdMain, Name, ClsPub.AppPath);//设置隐藏列
|
}
|
|
private void Sc_ProcessExchangeBill_KeyDown(object sender, KeyEventArgs e)
|
{
|
if (e.Modifiers == Keys.Control && e.KeyCode == Keys.S) //按Ctrl+ S触发
|
{
|
this.Sub_SaveBill();
|
}
|
|
}
|
|
private void cmdWorkType_Click(object sender, EventArgs e)
|
{
|
//DAL.ClsIF_WorkType_View oTpye = new DAL.ClsIF_WorkType_View();
|
//if (oTpye.RefreshView())
|
//{
|
// this.txtHWorkTypeID.Text = oTpye.oModel.HName;
|
|
// this.txtHWorkTypeID.Tag = oTpye.oModel.HNumber.ToString();
|
|
//}
|
//else
|
//{
|
// this.txtHWorkTypeID.Text = "";
|
|
//}
|
}
|
|
|
private void txtHPlanQty_TextChanged(object sender, EventArgs e)
|
{
|
|
}
|
|
private void 隐藏列设置ToolStripMenuItem_Click_1(object sender, EventArgs e)
|
{
|
BLL.Gy_GridView_Hide oHide = new BLL.Gy_GridView_Hide();
|
oHide.KeyItem = this.Name;
|
oHide.oGrd = grdMain;
|
oHide.ShowDialog();
|
//
|
DBUtility.ClsPub.HideGridView(grdMain, Name, ClsPub.AppPath);//设置隐藏列
|
}
|
|
private void grdMain_CellContentClick(object sender, DataGridViewCellEventArgs e)
|
{
|
|
}
|
|
private void Tool_ItemClicked(object sender, ToolStripItemClickedEventArgs e)
|
{
|
|
}
|
|
private void txtHExplanation_TextChanged(object sender, EventArgs e)
|
{
|
|
}
|
|
private void grdMain_KeyDown(object sender, KeyEventArgs e)
|
{
|
|
}
|
}
|
}
|
