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;
|
|
namespace WorkM
|
{
|
public partial class MES_StationEntrustOutBill : Form
|
{
|
public MES_StationEntrustOutBill()
|
{
|
InitializeComponent();
|
}
|
|
public bool sTextChanged = true;
|
|
//下拉框
|
ComboBox cmb = new ComboBox(); //这里实例化一个ComboBox控件
|
Rectangle _Rectangle;
|
|
//定义列
|
public const Int16 HTagCol = 0;
|
public const Int16 HSnoCol = 1;
|
public const Int16 HMaterNumberCol = 2;
|
public const Int16 HMaterNameCol = 3;
|
public const Int16 HMaterModelCol = 4;
|
public const Int16 HUnitNameCol = 5;
|
public const Int16 HWhNameCol = 6;
|
public const Int16 HQtyCol = 7;
|
public const Int16 HRemarkCol = 8;
|
public const Int16 HOrderProcNoCol = 9;
|
|
//
|
//
|
//表2
|
public const Int16 SecHTagCol = 0;
|
public const Int16 SecHSnoCol = 1;
|
public const Int16 SecHTypeCol = 2;
|
public const Int16 SecHProcNoCol = 3;
|
public const Int16 SecHTechParamIDCol = 4;
|
public const Int16 SecHTechParamNumberCol = 5;
|
public const Int16 SecHTechParamNameCol = 6;
|
public const Int16 SecHStdCol = 7;
|
public const Int16 SecHValueCol = 8;
|
public const Int16 SecHTechParamUnitIDCol = 9;
|
public const Int16 SecHTechParamUnitNumberCol = 10;
|
public const Int16 SecHTechParamUnitNameCol = 11;
|
public const Int16 SecHEntryIDCol = 12;
|
|
|
public string ModName = "3793";
|
public string ModCaption = "委外工序接收";
|
public const string ModRightName = "MES_StationEntrustOutBill";
|
public const string ModRightNameEdit = ModRightName + "_Edit";
|
public const string ModRightNameDelete = ModRightName + "_Delete";
|
public const string ModRightNameMoney = ModRightName + "_Money";
|
public bool BillChange; //
|
|
public DBUtility.ClsPub.Enum_BillStatus BillStatus;
|
public Int64 KeyID;
|
public bool grdStatus;
|
public DAL.ClsSc_StationEntrustOutBill BillNew = new DAL.ClsSc_StationEntrustOutBill();
|
public DAL.ClsSc_StationEntrustOutBill BillOld = new DAL.ClsSc_StationEntrustOutBill();
|
|
ClsGridViewSum oSumGrid = new ClsGridViewSum();
|
ClsGridViewSum oSumGrid_Sub = new ClsGridViewSum();
|
public Int64 lngBillKey; //流转卡ID
|
public Int64 lngBillSubKey; //流转卡子ID
|
public Int64 lngBillKey_WW;
|
public Int64 lngBillSubKey_WW = -1;
|
|
long sHMainSourceInterID; //进站单ID
|
string sHMainSourceBillNo; //进站单号
|
//-------------------------------------------------------------------------
|
#region 固定代码
|
|
|
//清空界面
|
public void Sub_ClearBill()
|
{
|
DBUtility.Xt_BaseBillFun.Sub_ClearBill(gbUp);
|
//DBUtility.Xt_BaseBillFun.Sub_ClearBill(gbUp2);
|
DBUtility.Xt_BaseBillFun.Sub_ClearBill1(tabPage1);
|
DBUtility.Xt_BaseBillFun.Sub_ClearBill1(tabPage2);
|
initGrid();
|
initGrid_Sub();
|
txtHBarCode.Text = "";
|
txtHProcExchBillNo.Enabled = true;
|
txtHWWWorkOrderBillNo.Enabled = true;
|
txtHProcNO.Enabled = true;
|
txtHBarCode.Enabled = true;
|
txtHPieceQty.Enabled = true;
|
txtHBadPNL.Enabled = true;
|
tabControl1.SelectedIndex = 0;
|
txtHBarCode.Focus();
|
lngBillKey = 0;
|
lngBillSubKey = 0;
|
txtHTaxRate.Text = "16";
|
this.txtHICMOBillNo.Tag = "0";
|
}
|
//出站按钮
|
private void cmdOK_Click(object sender, EventArgs e)
|
{
|
this.Sub_SaveBill();
|
cmdCancel.Focus();
|
//DBUtility.Xt_BaseBillFun.SaveGrid(grdMain, this.Name);
|
//DBUtility.Xt_BaseBillFun.SaveGrid(grdSub, this.Name + "1");
|
}
|
//取消按钮
|
private void cmdCancel_Click(object sender, EventArgs e)
|
{
|
if (BillStatus == DBUtility.ClsPub.Enum_BillStatus.BillStatus_View)
|
{
|
if (!BillOld.CheckHaveNoPass(BillOld.omodel.HInterID, ref ClsPub.sErrInfo))
|
{
|
MessageBox.Show(ClsPub.sErrInfo);
|
return;
|
}
|
}
|
//DBUtility.Xt_BaseBillFun.SaveGrid(grdMain, this.Name);
|
//DBUtility.Xt_BaseBillFun.SaveGrid(grdSub, this.Name + "1");
|
this.Close();
|
}
|
//控件位置
|
private void Sub_ControlLocation()
|
{
|
//gbUp.Width = P1.Width - 20;
|
//gbUp.Left = 10;
|
//gbUp.Height = P1.Height - 35;
|
//gbUp.Top = 30;
|
}
|
//窗体加载
|
private void Sc_StationEntrustOutBill_Load(object sender, EventArgs e)
|
{
|
//打印初始化
|
oSumGrid.NoCol = HSnoCol;
|
oSumGrid.ogrdMain = grdMain;
|
oSumGrid.oGridsum = grdSum;
|
//
|
this.Text = ModCaption; //命名窗体标题
|
this.lblCaption.Text = ModCaption;//命名单据标题
|
//判断金额权限
|
if (!ClsPub.Security_Log(ModRightNameMoney, 1, false, DBUtility.ClsPub.CurUserName))
|
{
|
txtHPrice.Visible = false;
|
txtHMoney.Visible = false;
|
label18.Visible = false; //单价
|
label19.Visible = false; //金额
|
txtHRemark.Visible = false;
|
label22.Visible = false; //备注
|
label24.Visible = false; //不含税金额
|
label25.Visible = false; //不含税单价
|
txtHPrice_BHS.Visible = false;
|
txtHMoney_BHS.Visible = false;
|
|
}
|
}
|
//窗体尺寸变化时
|
private void Sc_StationEntrustOutBill_Resize(object sender, EventArgs e)
|
{
|
//Sub_ControlLocation();
|
}
|
//timer
|
private void timer1_Tick(object sender, EventArgs e)
|
{
|
timer1.Enabled = false;
|
Sub_ControlLocation();
|
if (BillStatus == DBUtility.ClsPub.Enum_BillStatus.BillStatus_View)
|
{
|
this.Sub_ShowBill();
|
}
|
else
|
{
|
this.Sub_AddBill();
|
}
|
}
|
//窗体卸载
|
private void Sc_StationEntrustOutBill_FormClosing(object sender, FormClosingEventArgs e)
|
{
|
BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew;
|
//DBUtility.Xt_BaseBillFun.SaveGrid(grdMain, this.Name);
|
}
|
//新增单据
|
private void Sub_AddBill()
|
{
|
this.BillNew = new DAL.ClsSc_StationEntrustOutBill();
|
this.BillOld = new DAL.ClsSc_StationEntrustOutBill();
|
this.BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew;
|
this.Sub_OperStatus();//设置TOOLBAR
|
this.Sub_ClearBill();//清空界面
|
this.txtHStationOutTime.Text = DBUtility.ClsPub.GetServerDate(-1);
|
|
this.txtHBillNo.Text = ClsPub.CreateBillCode(BillNew.BillType, ref ClsPub.sExeReturnInfo, true);//得到新单号
|
|
if (lngBillKey != 0 )
|
{
|
LotShow();
|
}
|
|
}
|
private void LotShow()
|
{
|
//DataSet Ds;
|
//DataSet DsGY;
|
//DataSet DsJG;
|
//SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
////Ds = oCn.RunProcReturn("Select * from h_v_MES_NowWorkBillList Where hmainid=" + lngBillKey + "and hsubid=" + lngBillSubKey, "h_v_MES_NowWorkBillList", ref DBUtility.ClsPub.sErrInfo);
|
////Ds = oCn.RunProcReturn("exec h_p_MES_NowWorkBillList " + lngBillKey + "," + lngBillSubKey, "h_p_MES_NowWorkBillList", ref DBUtility.ClsPub.sErrInfo);
|
//Ds = oCn.RunProcReturn("exec h_p_Sc_GetProcByLotNo " + lngBillKey, "h_p_Sc_GetProcByLotNo");
|
//if (Ds == null)
|
//{
|
// MessageBox.Show("错误原因：" + DBUtility.ClsPub.sErrInfo);
|
// return;
|
//}
|
//if (Ds.Tables[0].Rows.Count == 0)
|
//{
|
// MessageBox.Show("LOT卡无效!");
|
// return;
|
//}
|
|
//if (DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HInorOut"]) == "out" && DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HProcType"]) == "自制")
|
//{
|
// MessageBox.Show("该LOT卡下道工序为自制出站!");
|
// return;
|
//}
|
//else if (DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HInorOut"]) == "in" && DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HProcType"]) == "委外")
|
//{
|
// MessageBox.Show("该LOT卡下道工序为委外发出!");
|
// return;
|
//}
|
//else if (DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HInorOut"]) == "in" && DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HProcType"]) == "自制")
|
//{
|
// MessageBox.Show("该LOT卡下道工序为自制进站!");
|
// return;
|
//}
|
//lngBillSubKey = ClsPub.isLong(Ds.Tables[0].Rows[0]["HSubID"]);
|
//txtHICMOBillNo.Tag = ClsPub.isLong(Ds.Tables[0].Rows[0]["HICMOInterID"]);
|
//txtHICMOBillNo.Text = ClsPub.isStrNull(Ds.Tables[0].Rows[0]["任务单号"]);
|
//txtHProcExchBillNo.Text = ClsPub.isStrNull(Ds.Tables[0].Rows[0]["单据号"]);
|
//txtHProcID.Tag = ClsPub.isLong(Ds.Tables[0].Rows[0]["HProcID"]);
|
//txtHProcID.Text = ClsPub.isStrNull(Ds.Tables[0].Rows[0]["工序"]);
|
//txtHMaterID.Tag = ClsPub.isLong(Ds.Tables[0].Rows[0]["HMaterID"]);
|
//txtHMaterID.Text = ClsPub.isStrNull(Ds.Tables[0].Rows[0]["产品代码"]);
|
//txtHMaterName.Text = ClsPub.isStrNull(Ds.Tables[0].Rows[0]["产品"]);
|
//txtHMaterModel.Text = ClsPub.isStrNull(Ds.Tables[0].Rows[0]["规格型号"]);
|
////txtHSourceID.Tag = ClsPub.isLong(Ds.Tables[0].Rows[0]["HSourceID"]);
|
////txtHSourceID.Text = ClsPub.isStrNull(Ds.Tables[0].Rows[0]["生产资源"]);
|
////txtHGroupID.Tag = ClsPub.isLong(Ds.Tables[0].Rows[0]["HGroupID"]);
|
////txtHGroupID.Text = ClsPub.isStrNull(Ds.Tables[0].Rows[0]["班组"]);
|
////txtHEmpID.Tag = ClsPub.isLong(Ds.Tables[0].Rows[0]["HWorkerID"]);
|
////txtHEmpID.Text = ClsPub.isStrNull(Ds.Tables[0].Rows[0]["操作工"]);
|
//txtHICMOQty.Text = ClsPub.isStrNull(Ds.Tables[0].Rows[0]["任务单数量"]);
|
//txtHPlanQty.Text = ClsPub.isStrNull(Ds.Tables[0].Rows[0]["计划数量"]);
|
//txtHQty.Text = ClsPub.isStrNull(Ds.Tables[0].Rows[0]["计划数量"]);
|
//txtHPlanPieceQty.Text = ClsPub.isStrNull(Ds.Tables[0].Rows[0]["板数"]);
|
//txtHPieceQty.Text = ClsPub.isStrNull(Ds.Tables[0].Rows[0]["板数"]);
|
//txtHSupID.Tag = ClsPub.isLong(Ds.Tables[0].Rows[0]["HSupID"]);
|
//txtHSupID.Text = ClsPub.isStrNull(Ds.Tables[0].Rows[0]["供应商"]);
|
|
|
//sHMainSourceInterID = ClsPub.isLong(Ds.Tables[0].Rows[0]["HJZInterID"]);
|
//sHMainSourceBillNo = ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HJZBillNo"]);
|
//txtHTaxRate.Text = ClsPub.isStrNull(Ds.Tables[0].Rows[0]["税率"]);
|
//txtHPrice.Text = ClsPub.isStrNull(ClsPub.isDoule(Ds.Tables[0].Rows[0]["单价"],6));
|
//txtHMoney.Text = ClsPub.isStrNull(ClsPub.isDoule(ClsPub.isDoule(Ds.Tables[0].Rows[0]["板数"]) * ClsPub.isDoule( ClsPub.isDoule(Ds.Tables[0].Rows[0]["单价"],6)), 4));
|
//txtHPrice_BHS.Text = ClsPub.isStrNull(ClsPub.isDoule(ClsPub.isDoule(txtHPrice.Text) / (ClsPub.isDoule(txtHTaxRate.Text)/100+1), 6));
|
//txtHMoney_BHS.Text = ClsPub.isStrNull(ClsPub.isDoule(ClsPub.isDoule(txtHMoney.Text) / (ClsPub.isDoule(txtHTaxRate.Text)/100+1), 4));
|
//txtHRemark.Text = ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HRemark"]);
|
//txtHInnerBillNo.Text = ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HInnerBillNo"]);
|
|
//initGrid();
|
//initGrid_Sub();
|
//for (int i = 0; i < Ds.Tables[0].Rows.Count; i++)
|
//{
|
// if (i >= grdMain.RowCount - 1)
|
// {
|
// grdMain.Rows.Add();
|
// }
|
// grdMain.Rows[i].Cells[HTagCol].Value = "*";
|
// grdMain.Rows[i].Cells[HProcNoCol].Value = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["HProcNo"]);
|
// grdMain.Rows[i].Cells[HProcIDCol].Value = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["HProcID"]);
|
// grdMain.Rows[i].Cells[HProcNumberCol].Value = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["工序代码"]);
|
// grdMain.Rows[i].Cells[HProcNameCol].Value = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["工序"]);
|
// grdMain.Rows[i].Cells[HQtyCol].Value = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["计划数量"]);
|
// grdMain.Rows[i].Cells[HEntryIDCol].Value = i + 1;
|
// grdMain.Rows[i].Cells[HProcExchEntryIDCol].Value = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["hsubid"]);
|
|
// DsGY = oCn.RunProcReturn("exec h_p_Sc_GetTechParamByProc " + DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HProcID"]), "h_p_Sc_GetTechParamByProc");
|
// //明细类赋值
|
// for (int j = 0; j < DsGY.Tables[0].Rows.Count; j++)
|
// {
|
// Model.ClsSc_StationEntrustOutBillSub_Item oSub = new Model.ClsSc_StationEntrustOutBillSub_Item();
|
// oSub.HEntryID = i + 1;
|
// oSub.HProcNo = ClsPub.isLong(Ds.Tables[0].Rows[i]["HProcNo"]);
|
// oSub.HTechParamID = ClsPub.isLong(DsGY.Tables[0].Rows[j]["HTechParamID"]);
|
// oSub.HTechParamUnitID = ClsPub.isLong(DsGY.Tables[0].Rows[j]["HTechParamUnitID"]);
|
// oSub.HValue = "";
|
// oSub.HStd = "";
|
// oSub.HType = ClsPub.isStrNull(DsGY.Tables[0].Rows[j]["HType"]);
|
// BillOld.DetailColl1.Add(oSub);
|
// }
|
//}
|
////DsJG = oCn.RunProcReturn("exec h_p_MES_GetSupPrice " + DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HSupID"])
|
//// + " ," + DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HMaterID"])
|
//// + " ," + DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HProcID"]), "h_p_MES_GetSupPrice");
|
////if (DsJG == null)
|
////{
|
//// MessageBox.Show("获取单价失败！", "提示");
|
//// return;
|
////}
|
////if (DsJG.Tables[0].Rows.Count == 0)
|
////{
|
//// txtHPrice.Text = "0";
|
//// txtHMoney.Text = "0";
|
//// txtHRemark.Text = "";
|
////}
|
////else
|
////{
|
//// txtHPrice.Text = DsJG.Tables[0].Rows[0][0].ToString();
|
//// txtHMoney.Text = ClsPub.isStrNull(DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[0]["板数"]) * DBUtility.ClsPub.isDoule(DsJG.Tables[0].Rows[0][0].ToString()));
|
//// txtHRemark.Text = DsJG.Tables[0].Rows[0][1].ToString();
|
////}
|
}
|
//TOOLBAR状态 按钮是否灰度
|
public void Sub_OperStatus()
|
{
|
switch (BillStatus)
|
{
|
case DBUtility.ClsPub.Enum_BillStatus.BillStatus_View:
|
//浏览状态
|
grdStatus = false;
|
cmdOK.Enabled = false;
|
cmdBF.Enabled = true;
|
cmdXG.Enabled = true;
|
cmdCancel.Enabled = true;
|
Sub_LrtextStatus(false);
|
break;
|
case DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew:
|
//新增状态
|
grdStatus = true;
|
cmdOK.Enabled = true;
|
cmdBF.Enabled = false;
|
cmdXG.Enabled = false;
|
cmdCancel.Enabled = true;
|
Sub_LrtextStatus(true);
|
break;
|
case DBUtility.ClsPub.Enum_BillStatus.BillStatus_Modify:
|
//修改状态
|
grdStatus = true;
|
cmdOK.Enabled = true;
|
cmdBF.Enabled = false;
|
cmdXG.Enabled = false;
|
cmdCancel.Enabled = true;
|
Sub_LrtextStatus(true);
|
break;
|
}
|
}
|
//根据编辑状态 设置 控件是否允许录入
|
private void Sub_LrtextStatus(bool TextEnabled)
|
{
|
if (TextEnabled == true)
|
{
|
//控件全部有效
|
gbUp.Enabled = true;
|
//gbUp2.Enabled = true;
|
|
}
|
else
|
{ //控件全部无效
|
gbUp.Enabled = false;
|
//gbUp2.Enabled = false;
|
}
|
}
|
|
#endregion
|
|
|
#region 读写类
|
//显示单据
|
public void Sub_ShowBill()
|
{
|
sTextChanged = false;
|
DAL.ClsIF_Material_View oMater = new DAL.ClsIF_Material_View();//物料
|
DAL.ClsGy_Employee_View oEmp = new DAL.ClsGy_Employee_View();//职员
|
DAL.ClsGy_Source_View oSource = new DAL.ClsGy_Source_View();//生产资源
|
DAL.ClsGy_Process_View oProc = new DAL.ClsGy_Process_View();//工序
|
DAL.ClsGy_Group_View oGroup = new DAL.ClsGy_Group_View();//班组
|
DAL.ClsIF_Supplier_View oSup = new DAL.ClsIF_Supplier_View();//供应商
|
DAL.ClsGy_WorkCenter_View oCenter = new DAL.ClsGy_WorkCenter_View();//工作中心
|
//判断是否存在单据
|
if (BillOld.ShowBill(BillOld.omodel.HInterID, ref ClsPub.sExeReturnInfo) == false)
|
{
|
MessageBox.Show(ClsPub.sExeReturnInfo, "提示");
|
return;
|
}
|
//清空
|
Sub_ClearBill();
|
//grid禁止刷新
|
//加载表头
|
if (oMater.GetInfoByID(BillOld.omodel.HMaterID))
|
{
|
this.txtHMaterID.Text = oMater.omodel.HNumber;
|
this.txtHMaterID.Tag = oMater.omodel.HItemID.ToString();
|
this.txtHMaterName.Text = oMater.omodel.HName;
|
this.txtHMaterModel.Text = oMater.omodel.HModel;
|
}
|
else
|
{
|
this.txtHMaterID.Text = "";
|
this.txtHMaterName.Text = "";
|
this.txtHMaterModel.Text = "";
|
}
|
//
|
if (oSup.GetInfoByID(BillOld.omodel.HSupID))
|
{
|
this.txtHSupID.Text = oSup.omodel.HName;
|
this.txtHSupID.Tag = oSup.omodel.HItemID.ToString();
|
}
|
else
|
{
|
this.txtHSupID.Text = "";
|
}
|
//
|
if (oEmp.GetInfoByID(BillOld.omodel.HEmpID))
|
{
|
this.txtHEmpID.Text = oEmp.omodel.HName;
|
this.txtHEmpID.Tag = oEmp.omodel.HItemID.ToString();
|
}
|
else
|
{
|
this.txtHEmpID.Text = "";
|
}
|
//
|
if (oSource.GetInfoByID(BillOld.omodel.HSourceID))
|
{
|
this.txtHSourceID.Text = oSource.omodel.HName;
|
this.txtHSourceID.Tag = oSource.omodel.HItemID.ToString();
|
}
|
else
|
{
|
this.txtHSourceID.Text = "";
|
}
|
//
|
if (oProc.GetInfoByID(BillOld.omodel.HProcID))
|
{
|
this.txtHProcID.Text = oProc.omodel.HName;
|
this.txtHProcID.Tag = oProc.omodel.HItemID.ToString();
|
}
|
else
|
{
|
this.txtHProcID.Text = "";
|
}
|
//
|
if (oGroup.GetInfoByID(BillOld.omodel.HGroupID))
|
{
|
this.txtHGroupID.Text = oGroup.omodel.HName;
|
this.txtHGroupID.Tag = oGroup.omodel.HItemID.ToString();
|
}
|
else
|
{
|
this.txtHGroupID.Text = "";
|
}
|
//
|
this.txtHBillNo.Text = BillOld.omodel.HBillNo;
|
this.txtHInnerBillNo.Text = BillOld.omodel.HInnerBillNo;
|
this.txtHICMOBillNo.Text = BillOld.omodel.HICMOBillNo;
|
this.txtHICMOBillNo.Tag = BillOld.omodel.HICMOInterID;
|
lngBillKey = BillOld.omodel.HProcExchInterID;
|
lngBillSubKey = BillOld.omodel.HProcExchEntryID;
|
lngBillKey_WW = BillOld.omodel.HWWWorkOrderInterID;
|
lngBillSubKey_WW = BillOld.omodel.HWWWorkOrderEntryID;
|
this.txtHWWWorkOrderBillNo.Text = BillOld.omodel.HWWWorkOrderBillNo;
|
this.txtHProcExchBillNo.Text = BillOld.omodel.HProcExchBillNo;
|
this.txtHStationOutTime.Text = BillOld.omodel.HStationOutTime.ToString();
|
this.txtHICMOQty.Text = BillOld.omodel.HICMOQty.ToString();
|
this.txtHPlanQty.Text = BillOld.omodel.HPlanQty.ToString();
|
this.txtHBadPNL.Text = BillOld.omodel.HBadPNL.ToString();
|
this.txtHRemark.Text = BillOld.omodel.HRemark.ToString();
|
this.txtHWasterQty.Text = BillOld.omodel.HWasterQty.ToString();
|
this.txtHBadCount.Text = BillOld.omodel.HBadCount.ToString();
|
this.txtHQty.Text = BillOld.omodel.HQty.ToString();
|
this.txtHPieceQty.Text = BillOld.omodel.HPieceQty.ToString();
|
this.txtHPlanPieceQty.Text = BillOld.omodel.HPlanPieceQty.ToString();
|
this.txtHPrice.Text = BillOld.omodel.HPrice.ToString();
|
this.txtHMoney.Text = BillOld.omodel.HMoney.ToString();
|
this.txtHProcNO.Text = BillOld.omodel.HProcNo.ToString();
|
this.txtHPrice_BHS.Text = BillOld.omodel.HPrice_BHS.ToString();
|
this.txtHMoney_BHS.Text = BillOld.omodel.HMoney_BHS.ToString();
|
this.txtHTaxRate.Text = BillOld.omodel.HTaxRate.ToString();
|
this.txtHOrderProcNO.Text = BillOld.omodel.HOrderProcNO.ToString();
|
|
|
sHMainSourceInterID = BillOld.omodel.HMainSourceInterID;
|
sHMainSourceBillNo = BillOld.omodel.HMainSourceBillNo;
|
//加载表体
|
initGrid();
|
//initGrid_Sub();
|
//根据送货单号 获取 全部该送货单号的记录 并打印
|
//if (txtHInnerBillNo.Text.Trim() != "")
|
//{
|
// SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
// DataSet ds = oCn.RunProcReturn("exec h_p_MES_StationEntrustOutBillPrint_Add '" + txtHInnerBillNo.Text.Trim() + "'," + txtHSupID.Tag + "", "h_p_MES_StationEntrustOutBillPrint");
|
// if (ds == null || ds.Tables[0].Rows.Count == 0)
|
// {
|
|
// }
|
// else
|
// {
|
// for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
|
// {
|
// if (i >= grdMain.RowCount - 1)
|
// {
|
// grdMain.Rows.Add();
|
// }
|
// //单据固定赋值
|
// grdMain.Rows[i].Cells[HTagCol].Value = "*";
|
// grdMain.Rows[i].Cells[HSnoCol].Value = i + 1;
|
|
// grdMain.Rows[i].Cells[HMaterNumberCol].Value = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[i]["HMaterNumber"]);
|
// grdMain.Rows[i].Cells[HMaterNameCol].Value = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[i]["HMaterName"]);
|
// grdMain.Rows[i].Cells[HMaterModelCol].Value = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[i]["HMaterModel"]);
|
// grdMain.Rows[i].Cells[HUnitNameCol].Value = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[i]["HUnitName"]);
|
// grdMain.Rows[i].Cells[HWhNameCol].Value = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[i]["HWHName"]);
|
// grdMain.Rows[i].Cells[HQtyCol].Value = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[i]["HQTY"]);
|
// grdMain.Rows[i].Cells[HRemarkCol].Value = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[i]["HRemark"]);
|
// grdMain.Rows[i].Cells[HOrderProcNoCol].Value = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[i]["HOrderProcNo"]);
|
// }
|
// }
|
|
//}
|
|
//======================================================================================
|
//
|
|
|
Sub_OperStatus();
|
sTextChanged = true;
|
|
|
txtHProcExchBillNo.Enabled = false;
|
txtHProcNO.Enabled = false;
|
|
}
|
|
//单据完整性判断 未完成
|
private bool Sub_AllowSave()
|
{
|
//判断该用户名是否有该工站权限
|
//if (BillNew.CheckCenterIDByUser(DBUtility.ClsPub.isLong(66865)) == false)
|
//{
|
// MessageBox.Show("没有该工站权限！", "提示");
|
// return false;
|
//}
|
//if (BillStatus == DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew)
|
//{
|
// //判断是否已经出站
|
// DataSet Ds;
|
// SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
// Ds = oCn.RunProcReturn("select 1 from Sc_StationOutBillMain where HProcExchInterID=" + lngBillKey + " and HProcExchEntryID=" + lngBillSubKey, "Sc_StationOutBillMain");
|
// if (Ds == null || Ds.Tables[0].Rows.Count > 0)
|
// {
|
// MessageBox.Show("该工序已接收，请重新扫描！", "提示");
|
// return false;
|
// }
|
//}
|
////判断参数内容是否存在空的数据
|
//foreach (Model.ClsSc_StationEntrustOutBillSub_Item oSub in BillOld.DetailColl1)
|
//{
|
// if (oSub.HValue == "")
|
// {
|
// MessageBox.Show("实际参数值不允许存在空行,如实际情况为空，请输入 '/ ' ", "提示");
|
// return false;
|
// }
|
// if (oSub.HStd == "" && oSub.HType == "首件")
|
// {
|
// MessageBox.Show("首件标准参数值不允许存在空行,如实际情况为空，请输入 '/ ' ", "提示");
|
// return false;
|
// }
|
//}
|
|
//必输项目是否为空
|
//if (DBUtility.ClsPub.isLong(lngBillKey_WW) <= 0)
|
//{
|
// MessageBox.Show("委外工单号没有选择！", "提示");
|
// return false;
|
//}
|
//if (DBUtility.ClsPub.isLong(lngBillSubKey_WW) < 0)
|
//{
|
// MessageBox.Show("委外工单号没有选择2！", "提示");
|
// return false;
|
//}
|
|
|
//必输项目是否为空
|
if (DBUtility.ClsPub.isLong(lngBillKey) <= 0)
|
{
|
MessageBox.Show("流转卡没有选择！", "提示");
|
return false;
|
}
|
if (DBUtility.ClsPub.isLong(lngBillSubKey) <= 0)
|
{
|
MessageBox.Show("流水号2没有选择！", "提示");
|
return false;
|
}
|
if (DBUtility.ClsPub.isLong(txtHProcNO.Text) <= 0)
|
{
|
MessageBox.Show("流水号没有选择！", "提示");
|
return false;
|
}
|
if (DBUtility.ClsPub.isStrNull(txtHProcExchBillNo.Text) =="")
|
{
|
MessageBox.Show("流转卡号没有选择！", "提示");
|
return false;
|
}
|
if (DBUtility.ClsPub.isStrNull(txtHInnerBillNo.Text) == "")
|
{
|
MessageBox.Show("发货号没有输入！", "提示");
|
return false;
|
}
|
if (DBUtility.ClsPub.isLong(txtHProcID.Tag) == 0)
|
{
|
MessageBox.Show("当前工序没有选择！", "提示");
|
return false;
|
}
|
if (DBUtility.ClsPub.isLong(txtHMaterID.Tag) == 0)
|
{
|
MessageBox.Show("产品没有选择！", "提示");
|
return false;
|
}
|
//if (DBUtility.ClsPub.isLong(txtHGroupID.Tag) == 0)
|
//{
|
// MessageBox.Show("生产班组没有选择！", "提示");
|
// return false;
|
//}
|
|
if (DBUtility.ClsPub.isLong(txtHSupID.Tag) == 0)
|
{
|
MessageBox.Show("供应商没有选择！", "提示");
|
return false;
|
}
|
|
//if (DBUtility.ClsPub.isLong(txtHEmpID.Tag) == 0)
|
//{
|
// MessageBox.Show("操作员没有选择！", "提示");
|
// return false;
|
//}
|
//if (DBUtility.ClsPub.isLong(txtHSourceID.Tag) == 0)
|
//{
|
// MessageBox.Show("生产资源没有选择！", "提示");
|
// return false;
|
//}
|
|
//if (DBUtility.ClsPub.isDoule(txtHQty.Text.Trim())==0 && DBUtility.ClsPub.isDoule(txtHPieceQty.Text.Trim()) == 0.0)
|
//{
|
// MessageBox.Show("接收个数不能为0！", "提示");
|
// return false;
|
//}
|
if (DBUtility.ClsPub.isDoule(txtHQty.Text.Trim()) + DBUtility.ClsPub.isDoule(txtHWasterQty.Text.Trim()) <= 0)
|
{
|
MessageBox.Show("接收个数不能为0！", "提示");
|
return false;
|
}
|
if (DBUtility.ClsPub.isDoule(txtHQty.Text.Trim()) < 0)
|
{
|
MessageBox.Show("接收个数不能小于0！", "提示");
|
return false;
|
}
|
//if (DBUtility.ClsPub.isDoule(txtHQty.Text.Trim()) > DBUtility.ClsPub.isDoule(txtHPlanQty.Text.Trim()))
|
//{
|
// MessageBox.Show("接收数量不能大于计划数量！", "提示");
|
// return false;
|
//}
|
|
if (DBUtility.ClsPub.isDoule(txtHWasterQty.Text.Trim()) < 0)
|
{
|
MessageBox.Show("不合格数不能小于0！", "提示");
|
return false;
|
}
|
//if (DBUtility.ClsPub.isDoule(txtHWasterQty.Text.Trim()) > DBUtility.ClsPub.isDoule(txtHPlanQty.Text.Trim()))
|
//{
|
// MessageBox.Show("不合格数不能大于计划数量！", "提示");
|
// return false;
|
//}
|
if (DBUtility.ClsPub.isDoule(txtHTaxRate.Text.Trim()) < 0)
|
{
|
MessageBox.Show("税率不能为负！", "提示");
|
return false;
|
}
|
//if (DBUtility.ClsPub.isDoule(txtHPrice.Text) == 0)
|
//{
|
// MessageBox.Show("含税单价不能为0！", "提示");
|
// return false;
|
//}
|
//if (DBUtility.ClsPub.isDoule(txtHQty.Text.Trim()) == 0.0)
|
//{
|
// MessageBox.Show("接收PCS数不能为0！", "提示");
|
// return false;
|
//}
|
//if (DBUtility.ClsPub.isDoule(txtHQty.Text.Trim()) > DBUtility.ClsPub.isDoule(txtHPlanQty.Text.Trim()))
|
//{
|
// MessageBox.Show("接收个数不能大于发出 PCS数！", "提示");
|
// return false;
|
//}
|
//if (DBUtility.ClsPub.isDoule(txtHPieceQty.Text.Trim()) > DBUtility.ClsPub.isDoule(txtHPlanPieceQty.Text.Trim()))
|
//{
|
// MessageBox.Show("接收件数不能大于发出件数！", "提示");
|
// return false;
|
//}
|
|
//if (DBUtility.ClsPub.isDoule(txtHWasterQty.Text.Trim()) > DBUtility.ClsPub.isDoule(txtHPlanQty.Text.Trim()))
|
//{
|
// MessageBox.Show("报废PCS数不能大于发出 PCS数！", "提示");
|
// return false;
|
//}
|
//if (DBUtility.ClsPub.isDoule(txtHBadPNL.Text.Trim()) > DBUtility.ClsPub.isDoule(txtHPlanPieceQty.Text.Trim()))
|
//{
|
// MessageBox.Show("报废PNL数不能大于发出 PNL数！", "提示");
|
// return false;
|
//}
|
//单据号是否重复
|
if (BillNew.IsExistBillNo(ref ClsPub.sExeReturnInfo, txtHBillNo.Text.Trim(), BillStatus, BillOld.omodel.HInterID))
|
{
|
MessageBox.Show("单据号重复！", "提示");
|
return false;
|
}
|
return true;
|
}
|
//保存单据
|
private bool Sub_SaveBill()
|
{
|
Model.ClsSc_StationEntrustOutBillSub oBillSub = new Model.ClsSc_StationEntrustOutBillSub();
|
//判断权限
|
if (!ClsPub.Security_Log(ModRightNameEdit, 1, true, DBUtility.ClsPub.CurUserName))
|
{
|
return false;
|
}
|
//
|
bool bResult;
|
BillNew = new DAL.ClsSc_StationEntrustOutBill();
|
//失去焦点
|
lblCaption.Focus();
|
//SaveSub();//保存参数表信息
|
if (!Sub_AllowSave())//单据完整性判断
|
return false;
|
//赋值ID
|
if (BillStatus == DBUtility.ClsPub.Enum_BillStatus.BillStatus_Modify)
|
BillNew.omodel.HInterID = BillOld.omodel.HInterID;
|
//主类赋值
|
//判断会计期是否合理
|
string s = "";
|
int sYear = 0;
|
int sPeriod = 0;
|
if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(DBUtility.ClsPub.isDate(this.txtHStationOutTime.Text), ref sYear, ref sPeriod, ref s) == false)
|
{
|
MessageBox.Show(s, "提示");
|
return false;
|
}
|
//
|
BillNew.omodel.HYear = sYear;
|
BillNew.omodel.HPeriod = sPeriod;
|
BillNew.omodel.HBillNo = this.txtHBillNo.Text.Trim();
|
BillNew.omodel.HInnerBillNo = this.txtHInnerBillNo.Text.Trim();
|
BillNew.omodel.HICMOBillNo = this.txtHICMOBillNo.Text.Trim();
|
BillNew.omodel.HICMOInterID = DBUtility.ClsPub.isLong(this.txtHICMOBillNo.Tag);
|
BillNew.omodel.HProcExchInterID = lngBillKey;
|
BillNew.omodel.HProcExchEntryID = lngBillSubKey;
|
BillNew.omodel.HProcExchBillNo = this.txtHProcExchBillNo.Text.Trim();
|
BillNew.omodel.HProcID = DBUtility.ClsPub.isLong(this.txtHProcID.Tag);
|
BillNew.omodel.HMaterID = DBUtility.ClsPub.isLong(this.txtHMaterID.Tag);
|
BillNew.omodel.HStationOutTime = DBUtility.ClsPub.isDate(this.txtHStationOutTime.Text);
|
BillNew.omodel.HEmpID = DBUtility.ClsPub.isLong(this.txtHEmpID.Tag);
|
BillNew.omodel.HSourceID = DBUtility.ClsPub.isLong(this.txtHSourceID.Tag);
|
BillNew.omodel.HGroupID = DBUtility.ClsPub.isLong(this.txtHGroupID.Tag);
|
BillNew.omodel.HICMOQty = DBUtility.ClsPub.isDoule(this.txtHICMOQty.Text);
|
BillNew.omodel.HPlanQty = DBUtility.ClsPub.isDoule(this.txtHPlanQty.Text);
|
BillNew.omodel.HQty = DBUtility.ClsPub.isDoule(this.txtHQty.Text);
|
BillNew.omodel.HSupID = DBUtility.ClsPub.isLong(this.txtHSupID.Tag);
|
BillNew.omodel.HPieceQty = DBUtility.ClsPub.isDoule(this.txtHPieceQty.Text);
|
BillNew.omodel.HPlanPieceQty = DBUtility.ClsPub.isDoule(this.txtHPlanPieceQty.Text);
|
BillNew.omodel.HPrice = ClsPub.isDoule(DBUtility.ClsPub.isDoule(this.txtHPrice.Text,6));
|
BillNew.omodel.HMoney = ClsPub.isDoule(DBUtility.ClsPub.isDoule(this.txtHMoney.Text,4));
|
BillNew.omodel.HProcNo = DBUtility.ClsPub.isLong(this.txtHProcNO.Text);
|
BillNew.omodel.HPrice_BHS = ClsPub.isDoule(DBUtility.ClsPub.isDoule(this.txtHPrice_BHS.Text,6));
|
BillNew.omodel.HMoney_BHS = ClsPub.isDoule(DBUtility.ClsPub.isDoule(this.txtHMoney_BHS.Text, 4));
|
BillNew.omodel.HTaxRate = DBUtility.ClsPub.isDoule(this.txtHTaxRate.Text);
|
|
//BillNew.omodel.HOrderProcNO = this.txtHOrderProcNO.Text.Trim();
|
BillNew.omodel.HOrderProcNO = DBUtility.ClsPub.isStrNull(this.txtHOrderProcNO.Text);
|
BillNew.omodel.HBadPNL = DBUtility.ClsPub.isDoule(this.txtHBadPNL.Text);
|
BillNew.omodel.HWasterQty = DBUtility.ClsPub.isDoule(this.txtHWasterQty.Text);
|
BillNew.omodel.HBadCount = DBUtility.ClsPub.isDoule(this.txtHBadCount.Text);
|
BillNew.omodel.HRemark = DBUtility.ClsPub.isStrNull(this.txtHRemark.Text);
|
BillNew.omodel.HLastSubProc = true;
|
BillNew.omodel.HMainSourceInterID = sHMainSourceInterID;
|
BillNew.omodel.HMainSourceBillNo = sHMainSourceBillNo;
|
BillNew.omodel.HMainSourceBillType = "3792";
|
|
BillNew.omodel.HWWWorkOrderInterID = lngBillKey_WW;
|
BillNew.omodel.HWWWorkOrderEntryID = lngBillSubKey_WW;
|
BillNew.omodel.HWWWorkOrderBillNo = DBUtility.ClsPub.isStrNull(this.txtHWWWorkOrderBillNo.Text);
|
|
//明细类赋值
|
//BillNew.DetailColl = new List<Model.ClsSc_StationEntrustOutBillSub>();
|
//for (int i = 0; i <= grdMain.RowCount - 1; i++)
|
//{
|
// if (ClsPub.isLong(grdMain.Rows[i].Cells[HProcIDCol].Value) != 0)
|
// {
|
// Model.ClsSc_StationEntrustOutBillSub oSub = new Model.ClsSc_StationEntrustOutBillSub();
|
// //固定赋值========================================
|
// oSub.HEntryID = DBUtility.ClsPub.isLong(grdMain.Rows[i].Cells[HEntryIDCol].Value);
|
// oSub.HRemark = "";
|
// oSub.HSourceInterID = lngBillKey;
|
// oSub.HSourceEntryID = DBUtility.ClsPub.isLong(grdMain.Rows[i].Cells[HProcExchEntryIDCol].Value);
|
// oSub.HSourceBillType = "3772";
|
// oSub.HSourceBillNo = DBUtility.ClsPub.isStrNull(this.txtHProcExchBillNo.Text);
|
// oSub.HRelationQty = 0;
|
// oSub.HRelationMoney = 0;
|
// oSub.HCloseMan = "";
|
// oSub.HEntryCloseDate = DBUtility.ClsPub.isDate(null);
|
// oSub.HCloseType = false;
|
// //=============================
|
// oSub.HProcID = DBUtility.ClsPub.isLong(grdMain.Rows[i].Cells[HProcIDCol].Value);
|
// oSub.HProcNo = DBUtility.ClsPub.isLong(grdMain.Rows[i].Cells[HProcNoCol].Value);
|
// oSub.HMaterID = DBUtility.ClsPub.isLong(this.txtHMaterID.Tag);
|
// oSub.HEmpID = DBUtility.ClsPub.isLong(this.txtHEmpID.Tag);
|
// oSub.HSourceID = DBUtility.ClsPub.isLong(this.txtHSourceID.Tag);
|
// oSub.HQty = DBUtility.ClsPub.isDoule(grdMain.Rows[i].Cells[HQtyCol].Value);
|
// oSub.HPieceQty = DBUtility.ClsPub.isDoule(this.txtHPieceQty.Text);
|
// oSub.HSourceName = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HSourceNameCol].Value);
|
|
// oSub.HBillNo_bak = BillNew.omodel.HBillNo;
|
|
// oSub.HProcExchInterID = lngBillKey;
|
// oSub.HProcExchEntryID = DBUtility.ClsPub.isLong(grdMain.Rows[i].Cells[HProcExchEntryIDCol].Value);
|
// oSub.HProcExchBillNo = DBUtility.ClsPub.isStrNull(this.txtHProcExchBillNo.Text);
|
// BillNew.DetailColl.Add(oSub);
|
// }
|
//}
|
//明细类赋值2
|
BillNew.DetailColl1 = BillOld.DetailColl1;
|
|
//保存完毕后处理
|
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)
|
{
|
BillChange = true;
|
MessageBox.Show("单据存盘完毕!单据号:" + this.txtHBillNo.Text.Trim(), "提示");
|
if (BillStatus == DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew)
|
{
|
BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_View;
|
BillOld.omodel.HInterID = BillNew.omodel.HInterID;
|
this.Sub_ShowBill();
|
}
|
else if (BillStatus == DBUtility.ClsPub.Enum_BillStatus.BillStatus_Modify)
|
{
|
BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_View;
|
}
|
this.Sub_OperStatus();
|
return true;
|
}
|
else
|
{
|
MessageBox.Show("保存失败!原因:" + ClsPub.sExeReturnInfo, "提示");
|
return false;
|
}
|
}
|
#endregion
|
|
#region 窗体处理方法
|
|
//初始化GRID
|
private void initGrid()
|
{
|
DBUtility.Xt_BaseBillFun.initGridMESList(grdCardList, this.Name + "grdCardList");
|
grdCardList.DataSource = null;
|
|
//
|
grdMain.ColumnCount = 10; //总列数
|
DBUtility.Xt_BaseBillFun.initGridFst(grdMain, this.Name);
|
//=
|
grdMain.Columns[HSnoCol].HeaderText = "序号";
|
grdMain.Columns[HRemarkCol].HeaderText = "表体备注";
|
grdMain.Columns[HMaterNumberCol].HeaderText = "物料代码";
|
grdMain.Columns[HMaterNameCol].HeaderText = "物料名称";
|
grdMain.Columns[HMaterModelCol].HeaderText = "规格型号";
|
grdMain.Columns[HUnitNameCol].HeaderText = "计量单位名称";
|
grdMain.Columns[HQtyCol].HeaderText = "数量";
|
grdMain.Columns[HWhNameCol].HeaderText = "仓库名称";
|
grdMain.Columns[HOrderProcNoCol].HeaderText = "订单跟踪号";
|
////固定赋值=====================================================
|
//=============================================================================
|
|
//格式化
|
////隐藏列
|
|
grdMain.Columns[HTagCol].Visible = false;
|
//设置可编辑列
|
//HQtyCol.ToString() +
|
// "," +
|
string sAllowCol = "";
|
//设置合计列
|
string sTotalCol = "";
|
|
//格式化网格
|
DBUtility.Xt_BaseBillFun.initGridLast(sAllowCol, sTotalCol, oSumGrid);
|
|
oSumGrid.SetGridMain();
|
//得到对应源单信息
|
|
}
|
|
//初始化GRID Sub
|
private void initGrid_Sub()
|
{
|
//grdSub.RowCount = 0;
|
//grdSub.ColumnCount = 13; //总列数
|
//DBUtility.Xt_BaseBillFun.initGridFst(grdSub, this.Name + "1");
|
////=
|
//grdSub.Columns[SecHProcNoCol].HeaderText = "工序号";
|
//grdSub.Columns[SecHTypeCol].HeaderText = "参数类型";
|
//grdSub.Columns[SecHTechParamIDCol].HeaderText = "参数ID";
|
//grdSub.Columns[SecHTechParamNumberCol].HeaderText = "参数代码";
|
//grdSub.Columns[SecHTechParamNameCol].HeaderText = "参数名称";
|
//grdSub.Columns[SecHTechParamUnitIDCol].HeaderText = "参数单位ID";
|
//grdSub.Columns[SecHTechParamUnitNumberCol].HeaderText = "参数单位代码";
|
//grdSub.Columns[SecHTechParamUnitNameCol].HeaderText = "参数单位名称";
|
//grdSub.Columns[SecHValueCol].HeaderText = "实际参数值";
|
//grdSub.Columns[SecHStdCol].HeaderText = "标准参数值";
|
//////固定赋值=====================================================
|
//grdSub.Columns[SecHSnoCol].HeaderText = "序号";
|
////=============================================================================
|
////下拉框
|
//grdSub.Controls.Add(cmb); //把下拉框控件加入DataGridView
|
//cmb.Visible = false; //先不让它显示
|
//cmb.DropDownStyle = ComboBoxStyle.DropDownList;//设置格式为不可编辑
|
//cmb.Items.Clear();
|
//cmb.Items.Add("首件");
|
//cmb.Items.Add("工艺");
|
//cmb.Items.Add("辅材");
|
//cmb.SelectedIndexChanged += new EventHandler(cmb_TextChange); //为下拉框控件加入事件cmb_TextChange
|
////格式化
|
//////隐藏列
|
//grdSub.Columns[SecHTagCol].Visible = false;
|
//grdSub.Columns[SecHTechParamIDCol].Visible = false;
|
//grdSub.Columns[SecHTechParamUnitIDCol].Visible = false;
|
//grdSub.Columns[SecHTechParamNumberCol].Visible = false;
|
//grdSub.Columns[SecHTechParamUnitNumberCol].Visible = false;
|
//grdSub.Columns[SecHEntryIDCol].Visible = false;
|
////设置可编辑列
|
//string sAllowCol = SecHValueCol.ToString() +
|
// "," + SecHStdCol.ToString();
|
////设置合计列
|
//string sTotalCol = "";
|
////格式化网格
|
//DBUtility.Xt_BaseBillFun.initGridLast(sAllowCol, sTotalCol, oSumGrid_Sub);
|
}
|
//网格下拉框
|
private void cmb_TextChange(object sender, EventArgs e)
|
{
|
//grdSub.CurrentCell.Value = cmb.Text.ToString(); //下拉框选择时，就把值赋给所在的单元格
|
}
|
//帮助函数
|
private void Sub_GridKey(int sKeyCode, int sRow, int sCol, DataGridViewTextBoxEditingControl oEdit)
|
{
|
|
if (!grdStatus)
|
{
|
return;
|
}
|
}
|
|
//帮助函数
|
private void Sub_GridKey_Sub(int sKeyCode, int sRow, int sCol, DataGridViewTextBoxEditingControl oEdit)
|
{
|
if (!grdStatus)
|
{
|
return;
|
}
|
oSumGrid.EditStatus = true;
|
switch (sKeyCode)
|
{
|
case 118: //F7
|
{
|
switch (sCol)
|
{
|
|
case SecHTechParamNumberCol:
|
//BLL.ClsBaseSelect.SetGridByTech(grdSub, sRow, SecHTechParamIDCol, SecHTechParamNumberCol, SecHTechParamNameCol);
|
//grdSub.Rows[sRow].Cells[SecHProcNoCol].Value = grdMain.Rows[grdMain.CurrentRow.Index].Cells[HProcNoCol].Value;
|
//grdSub.Rows[sRow].Cells[SecHEntryIDCol].Value = grdMain.Rows[grdMain.CurrentRow.Index].Cells[HEntryIDCol].Value;
|
//oEdit.Text = DBUtility.ClsPub.isStrNull(grdSub.Rows[sRow].Cells[SecHTechParamNumberCol].Value);
|
break;
|
case SecHTechParamUnitNumberCol:
|
//BLL.ClsBaseSelect.SetGridByTechU(grdSub, sRow, SecHTechParamUnitIDCol, SecHTechParamUnitNumberCol, SecHTechParamUnitNameCol);
|
//oEdit.Text = DBUtility.ClsPub.isStrNull(grdSub.Rows[sRow].Cells[SecHTechParamUnitNumberCol].Value);
|
break;
|
default:
|
break;
|
}
|
break;
|
}
|
case 117: //F6
|
{
|
switch (sCol)
|
{
|
default:
|
break;
|
}
|
break;
|
}
|
default:
|
break;
|
}
|
}
|
|
#endregion
|
|
private void cmdHMaterID_Click(object sender, EventArgs e)
|
{
|
DAL.ClsIF_Material_View oMater = new DAL.ClsIF_Material_View();
|
if (oMater.RefreshView())
|
{
|
txtHMaterID.Tag = oMater.oModel.HItemID.ToString();
|
if (oMater.GetInfoByID(oMater.oModel.HItemID))
|
{
|
txtHMaterID.Text = oMater.omodel.HNumber;
|
txtHMaterName.Text = oMater.omodel.HName;
|
txtHMaterModel.Text = oMater.omodel.HModel;
|
}
|
else
|
{
|
txtHMaterID.Text = "";
|
txtHMaterName.Text = "";
|
txtHMaterModel.Text = "";
|
}
|
}
|
else
|
{
|
txtHMaterID.Text = "";
|
txtHMaterName.Text = "";
|
txtHMaterModel.Text = "";
|
}
|
}
|
|
private void txtHMaterID_TextChanged(object sender, EventArgs e)
|
{
|
if (txtHMaterID.Text.Trim() == "")
|
{
|
this.txtHMaterID.Tag = "0";
|
this.txtHMaterName.Text = "";
|
this.txtHMaterModel.Text = "";
|
}
|
}
|
|
private void cmdHEmpID_Click(object sender, EventArgs e)
|
{
|
BLL.ClsBaseSelect.SetTextByEmp(txtHEmpID);
|
}
|
|
private void txtHEmpID_TextChanged(object sender, EventArgs e)
|
{
|
BLL.ClsPub_BLL.Sub_ClearText(txtHEmpID);
|
}
|
|
private void cmdHSourceID_Click(object sender, EventArgs e)
|
{
|
DAL.ClsGy_Source_View oSource = new DAL.ClsGy_Source_View();
|
if (oSource.RefreshView())
|
{
|
txtHSourceID.Text = oSource.oModel.HName;
|
txtHSourceID.Tag = oSource.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txtHSourceID.Text = "";
|
}
|
}
|
|
private void txtHSourceID_TextChanged(object sender, EventArgs e)
|
{
|
BLL.ClsPub_BLL.Sub_ClearText(txtHSourceID);
|
}
|
|
private void cmdHProcID_Click(object sender, EventArgs e)
|
{
|
//BLL.ClsBaseSelect.SetTextByProc(txtHProcID);
|
//if (lngBillKey == 0)
|
//{
|
// MessageBox.Show("请先扫描LOT卡！","提示");
|
// return;
|
//}
|
//else
|
//{
|
DAL.ClsGy_Process_View oProc = new DAL.ClsGy_Process_View();
|
if (oProc.RefreshView())
|
{
|
//lngBillSubKey = oProc.oModel.HEntryID;
|
txtHProcID.Text = oProc.oModel.HName;
|
txtHProcID.Tag = oProc.oModel.HItemID.ToString();
|
//Sub_AddBill();
|
}
|
else
|
{
|
//lngBillSubKey = 0;
|
txtHProcID.Text = "";
|
txtHProcID.Tag = 0;
|
}
|
//}
|
|
}
|
|
private void txtHProcID_TextChanged(object sender, EventArgs e)
|
{
|
BLL.ClsPub_BLL.Sub_ClearText(txtHProcID);
|
}
|
|
private void cmdHGroupID_Click(object sender, EventArgs e)
|
{
|
BLL.ClsBaseSelect.SetTextByGroup(txtHGroupID);
|
}
|
|
private void txtHGroupID_TextChanged(object sender, EventArgs e)
|
{
|
BLL.ClsPub_BLL.Sub_ClearText(txtHGroupID);
|
}
|
|
private void txtHProcExchBillNo_KeyDown(object sender, KeyEventArgs e)
|
{
|
|
if (e.KeyCode == Keys.Return)
|
{
|
if (txtHProcExchBillNo.Text.Trim() == "")
|
{
|
MessageBox.Show("工序流转卡卡号，不能为空！");
|
return;
|
}
|
|
DataSet Ds;
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
string sBillNo = txtHProcExchBillNo.Text.Trim();
|
|
//得到信息
|
Ds = oCn.RunProcReturn("select top 1 * from h_v_Sc_ProcessExchangeBillList where 单据号= '" + sBillNo + "'", "h_v_Sc_ProcessExchangeBillList");
|
//写入信息
|
if (Ds == null || Ds.Tables[0].Rows.Count == 0)
|
{
|
txtHProcExchBillNo.Text = "";
|
MessageBox.Show("未查询到流转卡信息！");
|
return;
|
}
|
for (int i = 0; i < Ds.Tables[0].Rows.Count; i++)
|
{
|
Sub_WriteInForm_SM(Ds.Tables[0], i);
|
}
|
//Sub_ShowBill();
|
txtHProcNO.Focus();
|
txtHProcExchBillNo.Enabled = false;
|
}
|
|
|
//if (e.KeyCode == Keys.Enter)
|
//{
|
// DAL.ClsSc_ProcessExchangeBill oPeb = new DAL.ClsSc_ProcessExchangeBill();
|
// if (oPeb.GetIDByNo(DBUtility.ClsPub.isStrNull(txtHProcExchBillNo.Text), ref ClsPub.sExeReturnInfo) == false)
|
// {
|
// MessageBox.Show(ClsPub.sExeReturnInfo, "提示");
|
// lngBillKey = 0;
|
// lngBillSubKey = 0;
|
// txtHProcID.Tag = 0;
|
// txtHProcID.Text = "";
|
// txtHProcExchBillNo.Text = "";
|
// return;
|
// }
|
// lngBillKey = oPeb.omodel.HInterID;
|
// lngBillSubKey = 0;
|
// txtHProcID.Tag = 0;
|
// txtHProcID.Text = "";
|
// LotShow();
|
//}
|
}
|
|
|
//根据TABLE写入界面
|
private void Sub_WriteInForm_SM(DataTable oTable, int i)
|
{
|
DAL.ClsGy_Material_View oMater = new DAL.ClsGy_Material_View();
|
|
//
|
this.txtHICMOBillNo.Tag = oTable.Rows[0]["hicmointerid"].ToString();
|
this.txtHICMOBillNo.Text = oTable.Rows[0]["任务单号"].ToString();
|
this.txtHMaterID.Tag = oTable.Rows[0]["HMaterID"].ToString();
|
this.txtHMaterName.Text = oTable.Rows[0]["产品"].ToString();
|
this.txtHMaterID.Text = oTable.Rows[0]["产品代码"].ToString();
|
this.txtHMaterModel.Text = oTable.Rows[0]["规格型号"].ToString();
|
//this.txtHBatchNo.Text = oTable.Rows[0]["批号"].ToString();
|
//this.txtHUnitID.Tag = oTable.Rows[0]["HUnitID"].ToString();
|
//this.txtHUnitID.Text = oTable.Rows[0]["单位"].ToString();
|
//this.txtHQty.Text = DBUtility.ClsPub.isDoule(oTable.Rows[0]["生产数量"], 0);
|
this.txtHQty.Text = "0";
|
this.txtHPieceQty.Text = DBUtility.ClsPub.isDoule(oTable.Rows[0]["生产数量"], 0);
|
this.txtHPlanQty.Text = DBUtility.ClsPub.isDoule(oTable.Rows[0]["生产数量"], 0);
|
txtHProcExchBillNo.Text = DBUtility.ClsPub.isStrNull(oTable.Rows[0]["单据号"]);
|
txtHICMOQty.Text = DBUtility.ClsPub.isStrNull(oTable.Rows[0]["任务单数量"]);
|
lngBillKey = DBUtility.ClsPub.isLong(oTable.Rows[0]["hmainid"]);
|
lngBillSubKey = DBUtility.ClsPub.isLong(oTable.Rows[0]["HSubID"]);
|
this.txtHOrderProcNO.Text = DBUtility.ClsPub.isStrNull(oTable.Rows[0]["订单跟踪号"]);
|
|
//加载表体
|
|
}
|
|
private void txtHProcID_KeyDown(object sender, KeyEventArgs e)
|
{
|
if (e.KeyCode == Keys.Enter)
|
{
|
if (lngBillKey == 0)
|
{
|
MessageBox.Show("请先扫描流转卡！", "提示");
|
return;
|
}
|
if (DBUtility.ClsPub.isStrNull(txtHProcID.Text) != "")
|
{
|
DAL.ClsGy_Process_View oProc = new DAL.ClsGy_Process_View();
|
if (oProc.GetInfoByNumber(DBUtility.ClsPub.isStrNull(txtHProcID.Text)))
|
{
|
lngBillSubKey = oProc.omodel.HEntryID;
|
txtHProcID.Text = oProc.omodel.HName;
|
txtHProcID.Tag = oProc.omodel.HItemID;
|
txtHQty.Focus();
|
Show();
|
}
|
else
|
{
|
lngBillSubKey = 0;
|
txtHProcID.Text = "";
|
txtHProcID.Tag = 0;
|
}
|
}
|
else
|
{
|
lngBillSubKey = 0;
|
txtHProcID.Text = "";
|
txtHProcID.Tag = 0;
|
}
|
}
|
}
|
|
private void txtHEmpID_KeyDown(object sender, KeyEventArgs e)
|
{
|
if (e.KeyCode == Keys.Enter)
|
{
|
if (DBUtility.ClsPub.isStrNull(txtHEmpID.Text) != "")
|
{
|
DAL.ClsGy_Employee_View oEmp = new DAL.ClsGy_Employee_View();
|
if (oEmp.GetInfoByNumber(DBUtility.ClsPub.isStrNull(txtHEmpID.Text)))
|
{
|
txtHEmpID.Text = oEmp.omodel.HName;
|
txtHEmpID.Tag = oEmp.omodel.HItemID;
|
}
|
else
|
{
|
txtHEmpID.Text = "";
|
txtHEmpID.Tag = 0;
|
}
|
}
|
else
|
{
|
txtHEmpID.Text = "";
|
txtHEmpID.Tag = 0;
|
}
|
}
|
}
|
|
private void txtHSourceID_KeyDown(object sender, KeyEventArgs e)
|
{
|
if (e.KeyCode == Keys.Enter)
|
{
|
if (DBUtility.ClsPub.isStrNull(txtHSourceID.Text) != "")
|
{
|
DAL.ClsGy_Source_View oSource = new DAL.ClsGy_Source_View();
|
if (oSource.GetInfoByNumber(DBUtility.ClsPub.isStrNull(txtHSourceID.Text)))
|
{
|
txtHSourceID.Text = oSource.omodel.HName;
|
txtHSourceID.Tag = oSource.omodel.HItemID;
|
}
|
else
|
{
|
txtHSourceID.Text = "";
|
txtHSourceID.Tag = 0;
|
}
|
}
|
else
|
{
|
txtHSourceID.Text = "";
|
txtHSourceID.Tag = 0;
|
}
|
}
|
}
|
|
private void txtHGroupID_KeyDown(object sender, KeyEventArgs e)
|
{
|
if (e.KeyCode == Keys.Enter)
|
{
|
if (DBUtility.ClsPub.isStrNull(txtHGroupID.Text) != "")
|
{
|
DAL.ClsGy_Group_View oGroup = new DAL.ClsGy_Group_View();
|
if (oGroup.GetInfoByNumber(DBUtility.ClsPub.isStrNull(txtHGroupID.Text)))
|
{
|
txtHGroupID.Text = oGroup.omodel.HName;
|
txtHGroupID.Tag = oGroup.omodel.HItemID;
|
}
|
else
|
{
|
txtHGroupID.Text = "";
|
txtHGroupID.Tag = 0;
|
}
|
}
|
else
|
{
|
txtHGroupID.Text = "";
|
txtHGroupID.Tag = 0;
|
}
|
}
|
}
|
|
private void cmdAddNew_Click(object sender, EventArgs e)
|
{
|
lngBillKey = 0;
|
lngBillSubKey = 0;
|
Sub_AddBill();
|
}
|
|
private void GetgrdSub(long sEntryID)
|
{
|
//DAL.ClsGy_TechnologyParameter_View oTech = new DAL.ClsGy_TechnologyParameter_View();
|
//DAL.ClsGy_TechnologyParameterUnit_View oTechU = new DAL.ClsGy_TechnologyParameterUnit_View();
|
//DAL.ClsGy_FirstPieceParameter_View oFirst = new DAL.ClsGy_FirstPieceParameter_View();
|
//DAL.ClsGy_FirstPieceParameterUnit_View oFirstU = new DAL.ClsGy_FirstPieceParameterUnit_View();
|
//DAL.ClsGy_Auxiliary_View oAuxiliary = new DAL.ClsGy_Auxiliary_View();
|
//initGrid_Sub();
|
//int i = 0;
|
//foreach (Model.ClsSc_StationEntrustOutBillSub_Item oSub in BillOld.DetailColl1)
|
//{
|
// if (oSub.HEntryID == sEntryID)
|
// {
|
// if (i >= grdSub.RowCount - 1)
|
// grdSub.Rows.Add();
|
// grdSub.Rows[i].Cells[SecHTagCol].Value = "*";
|
// if (oSub.HType == "工艺")
|
// {
|
// grdSub.Rows[i].Cells[SecHTechParamIDCol].Value = oSub.HTechParamID.ToString();
|
// if (oTech.GetInfoByID(oSub.HTechParamID))
|
// {
|
// grdSub.Rows[i].Cells[SecHTechParamNumberCol].Value = oTech.omodel.HNumber;
|
// grdSub.Rows[i].Cells[SecHTechParamNameCol].Value = oTech.omodel.HName;
|
// }
|
// else
|
// {
|
// grdSub.Rows[i].Cells[SecHTechParamNumberCol].Value = "";
|
// grdSub.Rows[i].Cells[SecHTechParamNameCol].Value = "";
|
// }
|
// grdSub.Rows[i].Cells[SecHTechParamUnitIDCol].Value = oSub.HTechParamUnitID.ToString();
|
// if (oTechU.GetInfoByID(oSub.HTechParamUnitID))
|
// {
|
// grdSub.Rows[i].Cells[SecHTechParamUnitNumberCol].Value = oTechU.omodel.HNumber;
|
// grdSub.Rows[i].Cells[SecHTechParamUnitNameCol].Value = oTechU.omodel.HName;
|
// }
|
// else
|
// {
|
// grdSub.Rows[i].Cells[SecHTechParamUnitNumberCol].Value = "";
|
// grdSub.Rows[i].Cells[SecHTechParamUnitNameCol].Value = "";
|
// }
|
// }
|
// else if (oSub.HType == "首件")
|
// {
|
// grdSub.Rows[i].Cells[SecHTechParamIDCol].Value = oSub.HTechParamID.ToString();
|
// if (oFirst.GetInfoByID(oSub.HTechParamID))
|
// {
|
// grdSub.Rows[i].Cells[SecHTechParamNumberCol].Value = oFirst.omodel.HNumber;
|
// grdSub.Rows[i].Cells[SecHTechParamNameCol].Value = oFirst.omodel.HName;
|
// }
|
// else
|
// {
|
// grdSub.Rows[i].Cells[SecHTechParamNumberCol].Value = "";
|
// grdSub.Rows[i].Cells[SecHTechParamNameCol].Value = "";
|
// }
|
// grdSub.Rows[i].Cells[SecHTechParamUnitIDCol].Value = oSub.HTechParamUnitID.ToString();
|
// if (oFirstU.GetInfoByID(oSub.HTechParamUnitID))
|
// {
|
// grdSub.Rows[i].Cells[SecHTechParamUnitNumberCol].Value = oFirstU.omodel.HNumber;
|
// grdSub.Rows[i].Cells[SecHTechParamUnitNameCol].Value = oFirstU.omodel.HName;
|
// }
|
// else
|
// {
|
// grdSub.Rows[i].Cells[SecHTechParamUnitNumberCol].Value = "";
|
// grdSub.Rows[i].Cells[SecHTechParamUnitNameCol].Value = "";
|
// }
|
// }
|
// else
|
// {
|
// grdSub.Rows[i].Cells[SecHTechParamIDCol].Value = oSub.HTechParamID.ToString();
|
// if (oAuxiliary.GetInfoByID(oSub.HTechParamID))
|
// {
|
// grdSub.Rows[i].Cells[SecHTechParamNumberCol].Value = oAuxiliary.omodel.HNumber;
|
// grdSub.Rows[i].Cells[SecHTechParamNameCol].Value = oAuxiliary.omodel.HName;
|
// }
|
// else
|
// {
|
// grdSub.Rows[i].Cells[SecHTechParamNumberCol].Value = "";
|
// grdSub.Rows[i].Cells[SecHTechParamNameCol].Value = "";
|
// }
|
// grdSub.Rows[i].Cells[SecHTechParamUnitNumberCol].Value = "";
|
// grdSub.Rows[i].Cells[SecHTechParamUnitNameCol].Value = "";
|
// }
|
// grdSub.Rows[i].Cells[SecHProcNoCol].Value = oSub.HProcNo.ToString();
|
// grdSub.Rows[i].Cells[SecHValueCol].Value = oSub.HValue;
|
// grdSub.Rows[i].Cells[SecHStdCol].Value = oSub.HStd;
|
// grdSub.Rows[i].Cells[SecHTypeCol].Value = oSub.HType;
|
// grdSub.Rows[i].Cells[SecHEntryIDCol].Value = oSub.HEntryID.ToString();
|
|
// i = i + 1;
|
// }
|
//}
|
}
|
|
#region 基本不变
|
//网格编辑前判断
|
private void grdMain_CellBeginEdit(object sender, DataGridViewCellCancelEventArgs e)
|
{
|
//int i = grdMain.CurrentCell.ColumnIndex;
|
//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_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);
|
}
|
|
|
//网格编辑前判断
|
private void grdSub_CellBeginEdit(object sender, DataGridViewCellCancelEventArgs e)
|
{
|
//int i = grdSub.CurrentCell.ColumnIndex;
|
//if (DBUtility.ClsPub.isStrNull(grdSub.Rows[grdSub.CurrentCell.RowIndex].Cells[SecHTypeCol].Value) != "首件" && i == SecHStdCol)
|
//{
|
// e.Cancel = true;
|
//}
|
//if (DBUtility.Xt_BaseBillFun.AllowEdit(grdStatus, oSumGrid_Sub, i))
|
//{
|
// e.Cancel = true;
|
//}
|
}
|
|
//滚动条滚动时，单元格位置发生变化，也得隐藏下拉框控件，不然下拉框控件位置不动就乱了
|
private void grdSub_Scroll(object sender, ScrollEventArgs e)
|
{
|
//cmb.Visible = false;
|
////DBUtility.Xt_BaseBillFun.SetSumGrid(oSumGrid_Sub);
|
//oSumGrid_Sub.DisplayCurRow();
|
}
|
|
//网格编辑后处理
|
private void grdSub_CellEndEdit(object sender, DataGridViewCellEventArgs e)
|
{
|
//DBUtility.Xt_BaseBillFun.SetSumGrid(oSumGrid_Sub);
|
//
|
//if (this.EditingControl_Sub != null) //释放事件
|
//{
|
// EditingControl_Sub.KeyDown -= new KeyEventHandler(this.EditingControl_Sub_KeyDown);
|
// this.EditingControl = null;
|
//}
|
}
|
//DataGridViewTextBoxEditingControl EditingControl_Sub;
|
|
private void grdSub_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e)
|
{
|
//if (grdSub.CurrentCell != null)
|
//{
|
// if (e.Control is DataGridViewTextBoxEditingControl)
|
// {
|
// this.EditingControl_Sub = (DataGridViewTextBoxEditingControl)e.Control;
|
// //增加委托处理
|
// this.EditingControl_Sub.KeyDown += new KeyEventHandler(this.EditingControl_Sub_KeyDown);
|
// }
|
//}
|
}
|
|
private void EditingControl_Sub_KeyDown(object sender, KeyEventArgs e)
|
{
|
//业务处理
|
//Sub_GridKey_Sub(e.KeyValue, grdSub.CurrentRow.Index, grdSub.CurrentCell.ColumnIndex, EditingControl_Sub);
|
}
|
|
private void grdSub_RowHeadersWidthChanged(object sender, EventArgs e)
|
{
|
//DBUtility.Xt_BaseBillFun.SetSumGrid(oSumGrid_Sub);
|
}
|
|
//当列的宽度变化时，下拉框控件先隐藏起来，不然单元格变大下拉框控件无法跟着变大哦
|
private void grdSub_ColumnWidthChanged(object sender, DataGridViewColumnEventArgs e)
|
{
|
//cmb.Visible = false;
|
//DBUtility.Xt_BaseBillFun.SetSumGrid(oSumGrid_Sub);
|
}
|
#endregion
|
|
private void grdMain_CellClick(object sender, DataGridViewCellEventArgs e)
|
{
|
//long sEntryID = ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[HEntryIDCol].Value);
|
//if (sEntryID != 0)
|
//{
|
// SaveSub();
|
|
// GetgrdSub(sEntryID);
|
//}
|
}
|
private void SaveSub()
|
{
|
//if (BillStatus != DBUtility.ClsPub.Enum_BillStatus.BillStatus_View)
|
//{
|
// long sEntryID = 0;
|
// for (int i = 0; i <= grdSub.RowCount - 1; i++)
|
// {
|
// if (DBUtility.ClsPub.isLong(grdSub.Rows[i].Cells[SecHEntryIDCol].Value) != 0)
|
// {
|
// sEntryID = ClsPub.isLong(grdSub.Rows[i].Cells[SecHEntryIDCol].Value);
|
// break;
|
// }
|
// }
|
// if (sEntryID == 0)
|
// {
|
// return;
|
// }
|
// for (int i = BillOld.DetailColl1.Count - 1; i >= 0; i--)
|
// {
|
// Model.ClsSc_StationEntrustOutBillSub_Item oSub = new Model.ClsSc_StationEntrustOutBillSub_Item();
|
// oSub = BillOld.DetailColl1[i];
|
// if (oSub.HEntryID == sEntryID)
|
// {
|
// BillOld.DetailColl1.Remove(BillOld.DetailColl1[i]);
|
// }
|
|
// }
|
// //明细类赋值
|
// for (int i = 0; i <= grdSub.RowCount - 1; i++)
|
// {
|
// if (DBUtility.ClsPub.isLong(grdSub.Rows[i].Cells[SecHEntryIDCol].Value) != 0)
|
// {
|
// Model.ClsSc_StationEntrustOutBillSub_Item oSub = new Model.ClsSc_StationEntrustOutBillSub_Item();
|
// oSub.HEntryID = ClsPub.isLong(grdSub.Rows[i].Cells[SecHEntryIDCol].Value);
|
// oSub.HProcNo = ClsPub.isLong(grdSub.Rows[i].Cells[SecHProcNoCol].Value);
|
// oSub.HTechParamID = ClsPub.isLong(grdSub.Rows[i].Cells[SecHTechParamIDCol].Value);
|
// oSub.HTechParamUnitID = ClsPub.isLong(grdSub.Rows[i].Cells[SecHTechParamUnitIDCol].Value);
|
// oSub.HValue = ClsPub.isStrNull(grdSub.Rows[i].Cells[SecHValueCol].Value);
|
// oSub.HStd = ClsPub.isStrNull(grdSub.Rows[i].Cells[SecHStdCol].Value);
|
// oSub.HType = ClsPub.isStrNull(grdSub.Rows[i].Cells[SecHTypeCol].Value);
|
// BillOld.DetailColl1.Add(oSub);
|
// }
|
// }
|
//}
|
}
|
|
//单元格被单击，判断是否是放下拉框控件的那一列
|
private void grdSub_CellClick(object sender, DataGridViewCellEventArgs e)
|
{
|
//if (e.ColumnIndex == SecHTypeCol)
|
//{
|
// _Rectangle = grdSub.GetCellDisplayRectangle(e.ColumnIndex, e.RowIndex, true); //得到所在单元格位置和大小
|
// cmb.Size = new Size(_Rectangle.Width, _Rectangle.Height); //把单元格大小赋给时间控件
|
// cmb.Location = new Point(_Rectangle.X, _Rectangle.Y); //把单元格位置赋给时间控件
|
// cmb.Visible = true; //可以显示控件了
|
//}
|
//else
|
// cmb.Visible = false;
|
}
|
|
private void bclk_Click(object sender, EventArgs e)
|
{
|
//DBUtility.Xt_BaseBillFun.SaveGrid(grdMain, this.Name);
|
//DBUtility.Xt_BaseBillFun.SaveGrid(grdSub, this.Name + "1");
|
}
|
|
private void cmbHSupID_Click(object sender, EventArgs e)
|
{
|
BLL.ClsBaseSelect.SetTextBySupplier(txtHSupID);
|
//GetPrice();
|
}
|
|
private void txtHSupID_KeyDown(object sender, KeyEventArgs e)
|
{
|
if (e.KeyCode == Keys.Enter)
|
{
|
//获取控件位置
|
int x = 0; int y = 0;
|
BLL.ClsPub_BLL.SetXY(this, panel2, gbUp, txtHSupID, ref x, ref y);
|
//选择基础
|
DAL.ClsIF_Supplier_View oSup = new DAL.ClsIF_Supplier_View();
|
if (oSup.RefreshViewDownMenu(" and (HNumber like '%" + txtHSupID.Text + "%' or HName like '%" + txtHSupID.Text + "%') ", x, y))
|
{
|
txtHSupID.Text = oSup.oModel.HName;
|
txtHSupID.Tag = oSup.oModel.HItemID.ToString();
|
//txtHSupID.ForeColor = System.Drawing.Color.Blue;
|
txtHBadPNL.Select();
|
}
|
else
|
{
|
txtHSupID.Text = "";
|
//txtHSupID.ForeColor = System.Drawing.Color.Black;
|
}
|
//GetPrice();
|
txtHPrice.Select();
|
}
|
}
|
|
private void GetPrice()
|
{
|
//DataSet DsJG;
|
//DataSet DsTaxRate;
|
//SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
//SQLHelper.ClsCNK3 oCnK3 = new SQLHelper.ClsCNK3();
|
//long HSupID = ClsPub.isLong(txtHSupID.Tag);
|
//long HMaterID = ClsPub.isLong(txtHMaterID.Tag);
|
//long HProcID = ClsPub.isLong(txtHProcID.Tag);
|
////
|
//DsTaxRate = oCnK3.RunProcReturn("select FValueAddRate from t_Supplier where FItemID=" + HSupID, "h_p_MES_GetSupPrice");
|
//if (DsTaxRate == null || DsTaxRate.Tables[0].Rows.Count == 0)
|
//{
|
// txtHTaxRate.Text = "0";
|
//}
|
//else
|
//{
|
// txtHTaxRate.Text = DsTaxRate.Tables[0].Rows[0]["FValueAddRate"].ToString();
|
//}
|
////
|
//DsJG = oCn.RunProcReturn("exec h_p_MES_GetSupPrice " + HSupID + " ," + HMaterID + " ," + HProcID, "h_p_MES_GetSupPrice");
|
//if (DsJG == null)
|
//{
|
// MessageBox.Show("获取单价失败！", "提示");
|
// return;
|
//}
|
//if (DsJG.Tables[0].Rows.Count == 0)
|
//{
|
// txtHPrice.Text = "0";
|
// txtHMoney.Text = "0";
|
// txtHPrice_BHS.Text = "0";
|
// txtHMoney_BHS.Text = "0";
|
// txtHRemark.Text = "";
|
//}
|
//else
|
//{
|
// txtHPrice.Text = ClsPub.isStrNull(DBUtility.ClsPub.isDoule(DsJG.Tables[0].Rows[0]["HPrice"], 6));
|
// txtHMoney.Text = ClsPub.isStrNull(ClsPub.isDoule((ClsPub.isDoule(txtHPieceQty.Text) + ClsPub.isDoule(txtHBadPNL.Text)) * ClsPub.isDoule(DBUtility.ClsPub.isDoule(DsJG.Tables[0].Rows[0]["HPrice"], 6)), 4));
|
// txtHPrice_BHS.Text = ClsPub.isStrNull(ClsPub.isDoule(DBUtility.ClsPub.isDoule(txtHPrice.Text) / (ClsPub.isDoule(txtHTaxRate.Text) / 100 + 1), 6));
|
// txtHMoney_BHS.Text = ClsPub.isStrNull(ClsPub.isDoule(DBUtility.ClsPub.isDoule(txtHMoney.Text) / (ClsPub.isDoule(txtHTaxRate.Text)/100+1), 4));
|
// txtHRemark.Text = DsJG.Tables[0].Rows[0]["HRemark"].ToString();
|
//}
|
}
|
private void txtHSupID_TextChanged(object sender, EventArgs e)
|
{
|
BLL.ClsPub_BLL.Sub_ClearText(txtHSupID);
|
}
|
|
private void cmdBF_Click(object sender, EventArgs e)
|
{
|
//SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
//DataSet Ds;
|
//Ds = oCn.RunProcReturn("select HInterID from QC_NoPassProdCheckBillMain where HMainSourceInterID=" + BillOld.omodel.HInterID, "QC_NoPassProdCheckBillMain", ref ClsPub.sErrInfo);
|
//if (Ds == null)
|
//{
|
// MessageBox.Show("获取报废单失败：" + ClsPub.sErrInfo);
|
// return;
|
//}
|
//if (Ds.Tables[0].Rows.Count == 0)
|
//{
|
// DataSet DsCheck;
|
// DsCheck = oCn.RunProcReturn("exec h_p_MES_StationOutBill_BFAdd " + BillOld.omodel.HInterID, "h_p_MES_StationOutBill_BFAdd");
|
// if (DsCheck == null)
|
// {
|
// MessageBox.Show("判断下道工序是否已经进站时出错！");
|
// return;
|
// }
|
// if (DsCheck.Tables[0].Rows.Count > 0)
|
// {
|
// MessageBox.Show("下道工序已经进站扫描，不允许生成MRB评审单！");
|
// return;
|
// }
|
// //if (ClsPub.isDoule(txtHWasterQty.Text) == 0 && ClsPub.isDoule(txtHBadPNL.Text) == 0)
|
// //{
|
// // return;
|
// //}
|
// QC_NoPassProdCheckBill oBF = new QC_NoPassProdCheckBill();
|
// oBF.BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew;
|
// oBF.HMainSourceInterID = BillOld.omodel.HInterID;
|
// oBF.HProcExchInterID = lngBillKey;
|
// oBF.HProcExchEntryID = lngBillSubKey;
|
// oBF.txtHLotNo.Text = txtHProcExchBillNo.Text;
|
// oBF.txtHMaterID.Text = txtHMaterName.Text;
|
// oBF.txtHMaterNumber.Text = txtHMaterID.Text;
|
// oBF.txtHModel.Text = txtHMaterModel.Text;
|
// oBF.txtHMaterID.Tag = txtHMaterID.Tag;
|
// oBF.txtHProcID.Tag = txtHProcID.Tag;
|
// oBF.txtHProcID.Text = txtHProcID.Text;
|
|
// oBF.txtHPlanQty.Text = ClsPub.isStrNull(ClsPub.isDoule(txtHWasterQty.Text) );
|
// oBF.txtHPlanPNL.Text = ClsPub.isStrNull(ClsPub.isDoule(txtHBadPNL.Text));
|
|
|
// //oBF.txtHBadPNL.Text = "0";
|
// oBF.txtHBadPNL.Text = ClsPub.isStrNull(ClsPub.isDoule(txtHBadPNL.Text));
|
// //oBF.txtHBadQty.Text = "0";
|
// oBF.txtHBadQty.Text = ClsPub.isStrNull(ClsPub.isDoule(txtHWasterQty.Text));
|
// oBF.ShowDialog();
|
// if (oBF.BillChange)
|
// {
|
// this.Sub_ShowBill();
|
// }
|
//}
|
//else
|
//{
|
// DAL.ClsQC_NoPassProdCheckBill oBill = new DAL.ClsQC_NoPassProdCheckBill();
|
// if (oBill.ShowBill(ClsPub.isLong(Ds.Tables[0].Rows[0][0]), ref DBUtility.ClsPub.sExeReturnInfo))
|
// {
|
// QC_NoPassProdCheckBill oFrm = new QC_NoPassProdCheckBill();
|
// oFrm.BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_View;
|
// oFrm.BillOld = oBill;
|
// oFrm.ShowDialog();
|
// if (oFrm.BillChange)
|
// {
|
// this.Sub_ShowBill();
|
// }
|
// }
|
// else
|
// {
|
// MessageBox.Show("单据未找到", "提示");
|
// }
|
// oBill = null;
|
//}
|
}
|
|
private void txtHPieceQty_TextChanged(object sender, EventArgs e)
|
{
|
if (sTextChanged == true)
|
{
|
sTextChanged = false;
|
double HPlanPieceQty = ClsPub.isDoule(txtHPlanPieceQty.Text); //发出PNL数
|
double HPieceQty = ClsPub.isDoule(txtHPieceQty.Text); //接收PNL数
|
double HPrice = ClsPub.isDoule(ClsPub.isDoule(txtHPrice.Text, 6)); //单价
|
double HTaxRate = ClsPub.isDoule(txtHTaxRate.Text); //税率
|
double HBadPNL = ClsPub.isDoule(txtHBadPNL.Text); //报废PNL数
|
|
txtHBadPNL.Text = ClsPub.isStrNull(HPlanPieceQty - HPieceQty);
|
txtHPrice_BHS.Text = ClsPub.isStrNull(ClsPub.isDoule(HPrice / (HTaxRate / 100 + 1), 6));
|
txtHMoney.Text = ClsPub.isStrNull(ClsPub.isDoule((HPlanPieceQty) * HPrice, 4));
|
double HMoney = ClsPub.isDoule(txtHMoney.Text); //金额
|
txtHMoney_BHS.Text = ClsPub.isStrNull(ClsPub.isDoule(HMoney / (HTaxRate / 100 + 1), 4));
|
sTextChanged = true;
|
}
|
}
|
|
private void txtHQty_TextChanged(object sender, EventArgs e)
|
{
|
//if (sTextChanged == true)
|
//{
|
// sTextChanged = false;
|
// txtHWasterQty.Text = ClsPub.isStrNull(ClsPub.isDoule(txtHPlanQty.Text) - ClsPub.isDoule(txtHQty.Text));
|
// sTextChanged = true;
|
//}
|
Proce_WhorkOut();
|
|
}
|
|
private void txtHBadPNL_TextChanged(object sender, EventArgs e)
|
{
|
//if (sTextChanged == true)
|
//{
|
// sTextChanged = false;
|
// double HPlanPieceQty = ClsPub.isDoule(txtHPlanPieceQty.Text); //发出PNL数
|
// double HPrice = ClsPub.isDoule(ClsPub.isDoule(txtHPrice.Text, 6)); //单价
|
// double HTaxRate = ClsPub.isDoule(txtHTaxRate.Text); //税率
|
// double HBadPNL = ClsPub.isDoule(txtHBadPNL.Text); //报废PNL数
|
|
// txtHPieceQty.Text = ClsPub.isStrNull(HPlanPieceQty - HBadPNL);
|
// double HPieceQty = ClsPub.isDoule(txtHPieceQty.Text); //接收PNL数
|
// txtHPrice_BHS.Text = ClsPub.isStrNull(ClsPub.isDoule(HPrice / (HTaxRate / 100 + 1), 6));
|
// txtHMoney.Text = ClsPub.isStrNull(ClsPub.isDoule((HPlanPieceQty) * HPrice, 4));
|
// double HMoney = ClsPub.isDoule(txtHMoney.Text); //金额
|
// txtHMoney_BHS.Text = ClsPub.isStrNull(ClsPub.isDoule(HMoney / (HTaxRate / 100 + 1), 4));
|
// sTextChanged = true;
|
//}
|
}
|
|
private void txtHBadPNL_Leave(object sender, EventArgs e)
|
{
|
|
}
|
private void txtHWasterQty_TextChanged(object sender, EventArgs e)
|
{
|
//if (sTextChanged == true)
|
//{
|
// sTextChanged = false;
|
// txtHQty.Text = ClsPub.isStrNull(ClsPub.isDoule(txtHPlanQty.Text) - ClsPub.isDoule(txtHWasterQty.Text));
|
// sTextChanged = true;
|
//}
|
}
|
|
private void txtHPieceQty_KeyDown(object sender, KeyEventArgs e)
|
{
|
if (e.KeyCode == Keys.Enter)
|
{
|
txtHQty.Select();
|
}
|
}
|
|
private void txtHQty_KeyDown(object sender, KeyEventArgs e)
|
{
|
if (e.KeyCode == Keys.Enter)
|
{
|
txtHPrice.Select();
|
}
|
}
|
|
private void txtHBadPNL_KeyDown(object sender, KeyEventArgs e)
|
{
|
if (e.KeyCode == Keys.Enter)
|
{
|
txtHWasterQty.Select();
|
}
|
}
|
|
private void txtHWasterQty_KeyDown(object sender, KeyEventArgs e)
|
{
|
if (e.KeyCode == Keys.Enter)
|
{
|
txtHPieceQty.Select();
|
}
|
}
|
|
private void txtHPieceQty_Leave(object sender, EventArgs e)
|
{
|
|
}
|
|
private void txtHQty_Leave(object sender, EventArgs e)
|
{
|
//txtHWasterQty.Text = ClsPub.isStrNull(ClsPub.isDoule(txtHPlanQty.Text) - ClsPub.isDoule(txtHQty.Text));
|
}
|
|
private void txtHWasterQty_Leave(object sender, EventArgs e)
|
{
|
//txtHQty.Text = ClsPub.isStrNull(ClsPub.isDoule(txtHPlanQty.Text) - ClsPub.isDoule(txtHWasterQty.Text));
|
}
|
|
//编辑单据
|
private void Sub_EditBill()
|
{
|
//判断权限
|
if (!ClsPub.Security_Log(ModRightNameEdit, 1, true, DBUtility.ClsPub.CurUserName))
|
{
|
return;
|
}
|
//判断该用户名是否有该工站权限
|
//if (BillNew.CheckCenterIDByUser(DBUtility.ClsPub.isLong(66865)) == false)
|
//{
|
// MessageBox.Show("没有该工站权限！", "提示");
|
// return;
|
//}
|
//检查是否开票
|
//string d = "";
|
//if (BillOld.CheckIsKP(BillOld.omodel.HInterID, ref d) == false)
|
//{
|
// MessageBox.Show(d, "提示");
|
// return;
|
//}
|
//
|
string s = "";
|
if (BillOld.ShowBill(BillOld.omodel.HInterID, ref s) == false)
|
{
|
MessageBox.Show("此单据有错误！", "提示");
|
return;
|
}
|
//判断是否可编辑
|
if (BillOld.omodel.HChecker != "")
|
{
|
MessageBox.Show("此单据已经被审核，不允许修改", "提示");
|
return;
|
}
|
//判断是否可编辑
|
txtHPieceQty.Enabled = false;
|
txtHQty.Enabled = true;
|
txtHBadPNL.Enabled = false;
|
txtHWasterQty.Enabled = true;
|
txtHTaxRate.Enabled = true;
|
|
//
|
this.BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_Modify;
|
this.Sub_OperStatus();//刷新TOOLBAR
|
//
|
txtHBillNo.Enabled = false; //单据号不允许修改
|
}
|
private void cmdXG_Click(object sender, EventArgs e)
|
{
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
DataSet ds;
|
//判断生产订单是否已结案，要求计划手工反结案 判断是否存在 相同单据号 的入库单
|
ds = oCn.RunProcReturn("exec h_p_MES_StationOutBill_DelCtrl '" + BillOld.omodel.HBillNo + "'", "h_p_MES_StationOutBill_DelCtrl");
|
if (ds == null)
|
{
|
MessageBox.Show("判断关联失败!");
|
return;
|
}
|
if (ds.Tables[0].Rows.Count > 0 && Pub_Class.ClsPub.isInt(ds.Tables[0].Rows[0][0]) == 2)
|
{
|
MessageBox.Show(Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0][1]));
|
return;
|
}
|
|
Sub_EditBill();
|
}
|
private void txtHPrice_KeyDown(object sender, KeyEventArgs e)
|
{
|
if (e.KeyCode == Keys.Enter)
|
{
|
cmdOK.Select();
|
}
|
}
|
|
private void txtHMoney_KeyDown(object sender, KeyEventArgs e)
|
{
|
if (e.KeyCode == Keys.Enter)
|
{
|
txtHRemark.Select();
|
}
|
}
|
|
private void txtHPrice_Leave(object sender, EventArgs e)
|
{
|
Proce_WhorkOut();
|
|
}
|
|
private void txtHMoney_Leave(object sender, EventArgs e)
|
{
|
Proce_WhorkOut();
|
|
}
|
|
private void txtHPrice_TextChanged(object sender, EventArgs e)
|
{
|
Proce_WhorkOut();
|
//if (sTextChanged == true)
|
//{
|
// sTextChanged = false;
|
// double HPrice = ClsPub.isDoule(ClsPub.isDoule(txtHPrice.Text, 6)); //单价
|
// double HTaxRate = ClsPub.isDoule(txtHTaxRate.Text); //税率
|
// double HBadPNL = ClsPub.isDoule(txtHBadPNL.Text); //报废PNL数
|
// double HPieceQty = ClsPub.isDoule(txtHPieceQty.Text); //接收PNL数
|
|
// txtHMoney.Text = ClsPub.isStrNull(ClsPub.isDoule((HPieceQty + HBadPNL) * HPrice, 4));
|
// double HMoney = ClsPub.isDoule(txtHMoney.Text); //金额
|
// txtHPrice_BHS.Text = ClsPub.isStrNull(ClsPub.isDoule(HPrice / (HTaxRate / 100 + 1), 6));
|
// txtHMoney_BHS.Text = ClsPub.isStrNull(ClsPub.isDoule(HMoney / (HTaxRate / 100 + 1), 4));
|
// sTextChanged = true;
|
//}
|
|
}
|
|
private void txtHMoney_TextChanged(object sender, EventArgs e)
|
{
|
//if (sTextChanged == true)
|
//{
|
// sTextChanged = false;
|
// double HMoney = ClsPub.isDoule(txtHMoney.Text); //金额
|
// double HBadPNL = ClsPub.isDoule(txtHBadPNL.Text); //报废PNL数
|
// double HPieceQty = ClsPub.isDoule(txtHPieceQty.Text); //接收PNL数
|
// double HTaxRate = ClsPub.isDoule(txtHTaxRate.Text); //税率
|
// if ((HPieceQty + HBadPNL) == 0)
|
// {
|
// txtHPrice.Text = "0";
|
// }
|
// else
|
// {
|
// txtHPrice.Text = ClsPub.isStrNull(ClsPub.isDoule(HMoney / (HPieceQty + HBadPNL), 6));
|
// }
|
// double HPrice = ClsPub.isDoule(ClsPub.isDoule(txtHPrice.Text, 6)); //单价
|
// txtHPrice_BHS.Text = ClsPub.isStrNull(ClsPub.isDoule(HPrice / (HTaxRate / 100 + 1), 6));
|
// txtHMoney_BHS.Text = ClsPub.isStrNull(ClsPub.isDoule(HMoney / (HTaxRate / 100 + 1), 4));
|
// sTextChanged = true;
|
//}
|
}
|
public double sMath(double a,int b)
|
{
|
a = Math.Round((double)(a), b, MidpointRounding.AwayFromZero);
|
return a;
|
}
|
|
private void txtHProcNO_KeyDown(object sender, KeyEventArgs e)
|
{
|
DataSet Ds;
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
string sProcNo = txtHProcNO.Text.Trim();
|
string sBillNo = txtHProcExchBillNo.Text.Trim();
|
if (e.KeyCode == Keys.Return)
|
{
|
if (txtHProcExchBillNo.Enabled == true)
|
{
|
MessageBox.Show("流转卡没有扫描，或者没有按回车键，请扫描流转卡或者在流转卡文本框中按回车键！");
|
return;
|
}
|
|
//得到信息
|
Ds = oCn.RunProcReturn("select top 1 * from h_v_Sc_ProcessExchangeBillList where 单据号= '" + sBillNo + "' and 下道流转工序<>'转' and 委外标记=1 and 流转标记=1 and 工序号='" + sProcNo + "'", "h_v_Sc_ProcessExchangeBillList");
|
//写入信息
|
if (Ds == null || Ds.Tables[0].Rows.Count == 0)
|
{
|
txtHProcNO.Text = "";
|
MessageBox.Show("流水号错误，请重新输入！");
|
return;
|
}
|
if (DBUtility.ClsPub.isBool(Ds.Tables[0].Rows[0]["委外标记"].ToString()) != true)
|
{
|
txtHProcNO.Text = "";
|
MessageBox.Show("该工序不是委外工序，请重新输入！");
|
return;
|
}
|
for (int i = 0; i < Ds.Tables[0].Rows.Count; i++)
|
{
|
Sub_WriteInForm_SM2(Ds.Tables[0], i);
|
}
|
int sHSupID = ClsPub.isInt(txtHSupID.Tag.ToString());
|
int sHMaterID = ClsPub.isInt(txtHMaterID.Tag.ToString());
|
Ds = oCn.RunProcReturn("select top 1 * from WW_EntrustWorkOrderBillSub where HSourceInterID= '" + DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HMainID"]) + "' and HSourceEntryID='" + DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HSubID"]) + "'", "Gy_ProcCommPrice");
|
if (Ds == null || Ds.Tables[0].Rows.Count == 0)
|
{
|
this.txtHPrice_BHS.Text = "";
|
this.txtHPrice.Text = "";
|
this.txtHTaxRate.Text = "";
|
}
|
else
|
{
|
//this.txtHPrice_BHS.Text = Ds.Tables[0].Rows[0]["HPrice"].ToString();
|
//this.txtHPrice.Text = Pub_Class.ClsPub.isStrNull(Pub_Class.ClsPub.isDoule(Ds.Tables[0].Rows[0]["HPrice"]) * (1.00 + (Pub_Class.ClsPub.isDoule(Ds.Tables[0].Rows[0]["HTaxRate"]) / 100.00)));
|
this.txtHPrice.Text = Ds.Tables[0].Rows[0]["HPrice"].ToString();
|
this.txtHPrice_BHS.Text = Pub_Class.ClsPub.isStrNull(Pub_Class.ClsPub.isDoule(Ds.Tables[0].Rows[0]["HPrice"]) / ((1.00 + ( 16.0000 / 100.0000))));
|
this.txtHTaxRate.Text ="16";
|
}
|
txtHQty.Focus();
|
}
|
}
|
//根据TABLE写入界面
|
private void Sub_WriteInForm_SM2(DataTable oTable, int i)
|
{
|
DAL.ClsGy_Material_View oMater = new DAL.ClsGy_Material_View();
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
DataSet ds;
|
lngBillSubKey = DBUtility.ClsPub.isLong(oTable.Rows[0]["HSubID"]);
|
lngBillKey = DBUtility.ClsPub.isLong(oTable.Rows[0]["HMainID"]);
|
//控制委外发出单 必须有 委外工单（目前存储过程里是 跳过的）
|
ds = oCn.RunProcReturn("exec h_p_MES_StationEntrustOutBill_Ctrl " + lngBillKey.ToString() + "," + lngBillSubKey.ToString() + "", "h_p_MES_StationEntrustOutBill_Ctrl");
|
if(ds==null || ds.Tables[0].Rows.Count==0)
|
{
|
MessageBox.Show("判断委外工单失败！");
|
txtHProcNO.Text="";
|
txtHProcNO.Focus();
|
return ;
|
|
}
|
else
|
{
|
if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0][0]) == "2")
|
{
|
MessageBox.Show(DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0][1]));
|
txtHProcNO.Text = "";
|
txtHProcNO.Focus();
|
return;
|
}
|
}
|
|
//this.txtHProcExchInterID.Text = oTable.Rows[0]["hmainid"].ToString();
|
//this.txtHProcExchEntryID.Text = oTable.Rows[0]["hsubid"].ToString();
|
//
|
this.txtHProcID.Tag = oTable.Rows[0]["HProcID"].ToString();
|
this.txtHProcID.Text = oTable.Rows[0]["工序"].ToString();
|
//this.txtHDeptID.Tag = oTable.Rows[0]["HDeptID"].ToString();
|
//this.txtHDeptID.Text = oTable.Rows[0]["加工车间"].ToString();
|
//this.txtHGroupID.Tag = oTable.Rows[0]["HGroupID"].ToString();
|
//this.txtHGroupID.Text = oTable.Rows[0]["班组"].ToString();
|
//this.txtHWorkEmpID.Tag = oTable.Rows[0]["HWorkerID"].ToString();
|
//this.txtHWorkEmpID.Text = oTable.Rows[0]["操作工"].ToString();
|
//this.txtHSourceID.Tag = oTable.Rows[0]["HSourceID"].ToString();
|
//this.txtHSourceID.Text = oTable.Rows[0]["生产资源"].ToString();
|
this.txtHSupID.Tag = oTable.Rows[0]["HSupID"].ToString();
|
this.txtHSupID.Text = oTable.Rows[0]["供应商"].ToString();
|
//txtHProcExchInterID.Text = oTable.Rows[0]["hmainid"].ToString();
|
//txtHProcExchEntryID.Text = oTable.Rows[0]["hsubID"].ToString();
|
|
|
|
//根据流转卡内码 获取工单内码（唯一工单或者唯一未接受完毕工单）
|
//如果 没有扫描 及 流水号 则 报错
|
if (lngBillKey == 0 || lngBillSubKey == 0)
|
{
|
return;
|
}
|
//根据工号获取委外工单 及内码，子内码 --根据流转卡主内码子内码 获取 委外工单信息
|
//SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
ds = oCn.RunProcReturn("exec h_p_WW_GetWWWorkBillInfoByHProcExch " + lngBillKey.ToString() + "," + lngBillSubKey.ToString(), "h_p_WW_GetWWWorkBillInfoByHProcExch");
|
if (ds == null)
|
{
|
//MessageBox.Show("没有找到对应的委外工单！");
|
return;
|
}
|
if (ds.Tables[0].Rows.Count > 0 && DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HBack"]) == 0)
|
{
|
txtHWWWorkOrderBillNo.Text = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBillNo"]);
|
lngBillKey_WW = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HInterID"]);
|
lngBillSubKey_WW = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HEntryID"]);
|
txtHWWWorkOrderBillNo.Enabled = false;
|
}
|
|
|
}
|
private void Proce_WhorkOut()
|
{
|
txtHMoney.Text = Pub_Class.ClsPub.isStrNull(Pub_Class.ClsPub.isDoule(txtHQty.Text) * Pub_Class.ClsPub.isDoule(txtHPrice.Text));
|
txtHMoney_BHS.Text = Pub_Class.ClsPub.isStrNull(Pub_Class.ClsPub.isDoule(txtHQty.Text) * Pub_Class.ClsPub.isDoule(txtHPrice_BHS.Text));
|
}
|
|
private void cmdDelBill_Click(object sender, EventArgs e)
|
{
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
try
|
{
|
if (MessageBox.Show("确定要删除当前单据对应的入库单？", "提示", MessageBoxButtons.OKCancel) == DialogResult.OK)
|
{
|
//oCn.RunProc(" update Sc_StationOutBillMain set HDelBillFlag=5 Where HInterID= " + BillOld.omodel.HInterID.ToString());
|
if (BillOld.DelBillProdIn(BillOld.omodel.HInterID, BillOld.omodel.HBillNo))
|
{
|
MessageBox.Show("删除入库单成功！");
|
}
|
else
|
{
|
MessageBox.Show("删除入库单失败11!" + Pub_Class.ClsPub.sExeReturnInfo);
|
}
|
return;
|
}
|
}
|
catch (Exception e1)
|
{
|
MessageBox.Show("删除入库单失败!");
|
|
}
|
}
|
|
private void MES_StationEntrustOutBill_KeyDown(object sender, KeyEventArgs e)
|
{
|
if (e.KeyCode == Keys.F12)
|
{
|
Sc_ProcExchBilltransRelationQty ofrm = new Sc_ProcExchBilltransRelationQty();
|
ofrm.keyitem = lngBillKey;
|
ofrm.ShowDialog();
|
}
|
}
|
|
private void button1_Click(object sender, EventArgs e)
|
{
|
//审核权限
|
//if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, true, DBUtility.ClsPub.CurUserName))
|
//{
|
// return;
|
//}
|
//
|
Int64 lInterID = 0;
|
lInterID = BillOld.omodel.HInterID;
|
if (lInterID == 0)
|
{
|
MessageBox.Show("单据未保存，不能审核");
|
return;
|
}
|
DAL.ClsSc_StationEntrustOutBill oBill = new DAL.ClsSc_StationEntrustOutBill();
|
//查看是否已审核,关闭,作废
|
if (oBill.ShowBill(lInterID, ref DBUtility.ClsPub.sExeReturnInfo))
|
{
|
if (oBill.omodel.HChecker.Trim() != "")
|
{
|
MessageBox.Show("单据已审核!不能再次审核", "提示");
|
return;
|
}
|
}
|
else
|
{
|
MessageBox.Show("单据不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo, "提示");
|
return;
|
}
|
//判断是否已经存在 ruku单
|
|
//审核
|
if (oBill.CheckBill(lInterID, ref DBUtility.ClsPub.sExeReturnInfo) == true)
|
{
|
MessageBox.Show("审核成功!", "提示");
|
return;
|
}
|
else
|
{
|
//删除同名ruku 单
|
|
//
|
MessageBox.Show("审核失败!原因:" + DBUtility.ClsPub.sExeReturnInfo, "提示");
|
return;
|
}
|
}
|
|
private void button2_Click(object sender, EventArgs e)
|
{
|
//审核权限
|
//if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, true, DBUtility.ClsPub.CurUserName))
|
//{
|
// return;
|
//}
|
//
|
Int64 lInterID = 0;
|
lInterID = BillOld.omodel.HInterID;
|
if (lInterID == 0)
|
{
|
MessageBox.Show("单据未保存，不能反审核");
|
return;
|
}
|
DAL.ClsSc_StationEntrustOutBill oBill = new DAL.ClsSc_StationEntrustOutBill();
|
//查看是否已审核,关闭,作废
|
if (oBill.ShowBill(lInterID, ref DBUtility.ClsPub.sExeReturnInfo))
|
{
|
if (oBill.omodel.HChecker.Trim() == "")
|
{
|
MessageBox.Show("单据未审核!不需要反审核!", "提示");
|
return;
|
}
|
}
|
else
|
{
|
MessageBox.Show("单据不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo, "提示");
|
return;
|
}
|
//反审核
|
if (oBill.AbandonCheck(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true)
|
{
|
MessageBox.Show("反审核成功!", "提示");
|
return;
|
}
|
else
|
{
|
MessageBox.Show("反审核失败!原因:" + DBUtility.ClsPub.sExeReturnInfo, "提示");
|
return;
|
}
|
}
|
|
private void txtHWWWorkOrderBillNo_KeyDown(object sender, KeyEventArgs e)
|
{
|
if (e.KeyCode == Keys.Return)
|
{
|
//如果 没有扫描 及 流水号 则 报错
|
if (lngBillKey == 0 || lngBillSubKey == 0)
|
{
|
MessageBox.Show("没有录入流转卡号或者流水号");
|
return;
|
}
|
//根据工号获取委外工单 及内码，子内码
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
DataSet ds;
|
ds = oCn.RunProcReturn("exec h_p_WW_GetWWWorkBillInfoByNo '" + txtHWWWorkOrderBillNo.Text + "'," + lngBillKey.ToString() + "," + lngBillSubKey.ToString(), "h_p_WW_GetWWWorkBillInfoByNo");
|
if (ds == null)
|
{
|
MessageBox.Show("没有找到对应的委外工单！");
|
return;
|
}
|
if (ds.Tables[0].Rows.Count > 0)
|
{
|
txtHWWWorkOrderBillNo.Text = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBillNo"]);
|
lngBillKey_WW = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HInterID"]);
|
lngBillSubKey_WW = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HEntryID"]);
|
txtHWWWorkOrderBillNo.Enabled = false;
|
}
|
|
}
|
}
|
|
GridppReport Report;
|
private void button3_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 = txtHInnerBillNo.Text;
|
Report.FieldByName("日期").AsString = txtHStationOutTime.Text;
|
Report.FieldByName("供应商").AsString = txtHSupID.Text;
|
Report.FieldByName("制单").AsString = DBUtility.ClsPub.CurUserName;
|
//Report.FieldByName("表头备注").AsString = txtHRemark.Text;
|
|
//Report.FieldByName("物料代码").AsString = txtHMaterID.Text;
|
//Report.FieldByName("物料名称").AsString = txtHMaterName.Text;
|
//Report.FieldByName("规格型号").AsString = txtHMaterModel.Text;
|
//Report.FieldByName("计量单位名称").AsString = "件";
|
//Report.FieldByName("仓库名称").AsString = txtHProcID.Text;
|
//Report.FieldByName("数量").AsString = txtHQty.Text;
|
//Report.FieldByName("表体备注").AsString = txtHRemark.Text;
|
//Report.FieldByName("订单跟踪号").AsString = txtHOrderProcNO.Text;
|
|
|
//grdMain.Columns[HRemarkCol].HeaderText = "备注";
|
//grdMain.Columns[HMaterNumberCol].HeaderText = "物料代码";
|
//grdMain.Columns[HMaterNameCol].HeaderText = "物料名称";
|
//grdMain.Columns[HMaterModelCol].HeaderText = "规格型号";
|
//grdMain.Columns[HUnitNameCol].HeaderText = "计量单位名称";
|
//grdMain.Columns[HQtyCol].HeaderText = "数量";
|
//grdMain.Columns[HWhNameCol].HeaderText = "仓库名称";
|
//grdMain.Columns[HOrderProcNoCol].HeaderText = "订单跟踪号";
|
}
|
catch (Exception e)
|
{
|
MessageBox.Show("打印失败"+ e.Message);
|
}
|
}
|
//赋值表体
|
private void ReportFetchRecordByDataTable()
|
{
|
try
|
{
|
DataTable dt = new DataTable();
|
BLL.Utility.FillRecordToReport(Report, grdMain, dt, HMaterNumberCol);
|
}
|
catch (Exception e)
|
{
|
MessageBox.Show("打印失败2,"+ e.Message);
|
}
|
}
|
|
private void gbUp_Enter(object sender, EventArgs e)
|
{
|
|
}
|
|
private void txtHBarCode_KeyDown(object sender, KeyEventArgs e)
|
{
|
if (e.KeyCode == Keys.Return)
|
{
|
if (txtHBarCode.Text.Trim() == "")
|
{
|
MessageBox.Show("工序流转卡卡号，不能为空！");
|
return;
|
}
|
|
DataSet Ds;
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
//拆分条形码
|
string sBillBarCode = txtHBarCode.Text.Trim();
|
string[] NewBarCode;
|
if (sBillBarCode.CompareTo("#") > 0)
|
{
|
NewBarCode = sBillBarCode.Split(Convert.ToChar("#"));
|
sBillBarCode = NewBarCode[0];
|
}
|
string sBillNo = sBillBarCode;
|
//========================================
|
|
//得到信息
|
Ds = oCn.RunProcReturn("select top 1 * from h_v_Sc_ProcessExchangeBillList where 单据号= '" + sBillNo + "'", "h_v_Sc_ProcessExchangeBillList");
|
//写入信息
|
if (Ds == null || Ds.Tables[0].Rows.Count == 0)
|
{
|
txtHProcExchBillNo.Text = "";
|
txtHBarCode.Text = "";
|
MessageBox.Show("未查询到流转卡信息！");
|
return;
|
}
|
for (int i = 0; i < Ds.Tables[0].Rows.Count; i++)
|
{
|
Sub_WriteInForm_SM(Ds.Tables[0], i);
|
}
|
//Sub_ShowBill();
|
txtHProcNO.Focus();
|
txtHProcExchBillNo.Enabled = false;
|
txtHBarCode.Enabled = false;
|
}
|
|
|
//if (e.KeyCode == Keys.Enter)
|
//{
|
// DAL.ClsSc_ProcessExchangeBill oPeb = new DAL.ClsSc_ProcessExchangeBill();
|
// if (oPeb.GetIDByNo(DBUtility.ClsPub.isStrNull(txtHProcExchBillNo.Text), ref ClsPub.sExeReturnInfo) == false)
|
// {
|
// MessageBox.Show(ClsPub.sExeReturnInfo, "提示");
|
// lngBillKey = 0;
|
// lngBillSubKey = 0;
|
// txtHProcID.Tag = 0;
|
// txtHProcID.Text = "";
|
// txtHProcExchBillNo.Text = "";
|
// return;
|
// }
|
// lngBillKey = oPeb.omodel.HInterID;
|
// lngBillSubKey = 0;
|
// txtHProcID.Tag = 0;
|
// txtHProcID.Text = "";
|
// LotShow();
|
//}
|
}
|
|
//新增
|
private void cmdXZ_Click(object sender, EventArgs e)
|
{
|
this.Sub_AddBill();
|
}
|
|
//报废品质确认按钮
|
private void cmdBFChecker_Click(object sender, EventArgs e)
|
{
|
QC_NoPassProdCheckBill oBF = new QC_NoPassProdCheckBill();
|
oBF.BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew;
|
oBF.HMainSourceInterID = BillOld.omodel.HInterID;
|
oBF.HProcExchInterID = lngBillKey;
|
oBF.HProcExchEntryID = lngBillSubKey;
|
oBF.HBillSubType = "报废评审";
|
oBF.txtHLotNo.Text = txtHProcExchBillNo.Text;
|
oBF.txtHOrderProcNo.Text = txtHOrderProcNO.Text;
|
oBF.txtHMaterID.Text = txtHMaterName.Text;
|
oBF.txtHMaterNumber.Text = txtHMaterID.Text;
|
oBF.txtHModel.Text = txtHMaterModel.Text;
|
oBF.txtHMaterID.Tag = txtHMaterID.Tag;
|
oBF.txtHProcID.Tag = txtHProcID.Tag;
|
oBF.txtHProcID.Text = txtHProcID.Text;
|
oBF.txtHWorkCenterID.Text = "";
|
oBF.txtHWorkCenterID.Tag = 0;
|
oBF.txtHICMOInterID.Text = Pub_Class.ClsPub.isStrNull(txtHICMOBillNo.Tag);
|
oBF.txtHICMOBillNo.Text = txtHICMOBillNo.Text;
|
oBF.txtHProcExchQty.Text = ClsPub.isStrNull(ClsPub.isDoule(txtHPlanQty.Text));
|
oBF.txtHPlanQty.Text = ClsPub.isStrNull(ClsPub.isDoule(txtHWasterQty.Text));
|
oBF.txtHPlanPNL.Text = ClsPub.isStrNull(ClsPub.isDoule(txtHBadPNL.Text));
|
oBF.txtHBadPNL.Text = ClsPub.isStrNull(ClsPub.isDoule(txtHBadPNL.Text));
|
oBF.txtHBadQty.Text = ClsPub.isStrNull(ClsPub.isDoule(txtHWasterQty.Text));
|
oBF.ShowDialog();
|
if (oBF.BillChange)
|
{
|
this.Sub_ShowBill();
|
}
|
}
|
|
//不良品质确认按钮
|
private void cmdChecker_Click(object sender, EventArgs e)
|
{
|
QC_NoPassProdCheckBill oBF = new QC_NoPassProdCheckBill();
|
oBF.BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew;
|
oBF.HMainSourceInterID = BillOld.omodel.HInterID;
|
oBF.HProcExchInterID = lngBillKey;
|
oBF.HProcExchEntryID = lngBillSubKey;
|
oBF.HBillSubType = "不良评审";
|
oBF.txtHLotNo.Text = txtHProcExchBillNo.Text;
|
oBF.txtHOrderProcNo.Text = txtHOrderProcNO.Text;
|
oBF.txtHMaterID.Text = txtHMaterName.Text;
|
oBF.txtHMaterNumber.Text = txtHMaterID.Text;
|
oBF.txtHModel.Text = txtHMaterModel.Text;
|
oBF.txtHMaterID.Tag = txtHMaterID.Tag;
|
oBF.txtHProcID.Tag = txtHProcID.Tag;
|
oBF.txtHProcID.Text = txtHProcID.Text;
|
oBF.txtHWorkCenterID.Text = "";
|
oBF.txtHWorkCenterID.Tag = 0;
|
oBF.txtHICMOInterID.Text = Pub_Class.ClsPub.isStrNull(txtHICMOBillNo.Tag);
|
oBF.txtHICMOBillNo.Text = txtHICMOBillNo.Text;
|
oBF.txtHProcExchQty.Text = ClsPub.isStrNull(ClsPub.isDoule(txtHPlanQty.Text));
|
oBF.txtHPlanQty.Text = ClsPub.isStrNull(ClsPub.isDoule(txtHBadCount.Text));
|
oBF.txtHPlanPNL.Text = ClsPub.isStrNull(ClsPub.isDoule(txtHBadPNL.Text));
|
oBF.txtHBadPNL.Text = ClsPub.isStrNull(ClsPub.isDoule(txtHBadPNL.Text));
|
oBF.txtHBadQty.Text = ClsPub.isStrNull(ClsPub.isDoule(txtHBadCount.Text));
|
oBF.ShowDialog();
|
if (oBF.BillChange)
|
{
|
this.Sub_ShowBill();
|
}
|
}
|
}
|
}
|
