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 Kf_WIPBal_Add : Form
|
{
|
public Kf_WIPBal_Add()
|
{
|
InitializeComponent();
|
}
|
|
|
public const Int16 HTagCol = 0;
|
public const Int16 HSnoCol = 1;
|
public const Int16 HICMOInterIDCol = 2;
|
public const Int16 HICMONoCol = 3;
|
public const Int16 HMaterIDCol = 4;
|
public const Int16 HMaterNumberCol = 5;
|
public const Int16 HMaterNameCol = 6;
|
public const Int16 HMaterModelCol = 7;
|
public const Int16 HProcNoCol = 8;
|
public const Int16 HProcIDCol = 9;
|
public const Int16 HProcNumberCol = 10;
|
public const Int16 HProcNameCol = 11;
|
public const Int16 HQtyCol = 12;
|
|
ClsGridViewSum oSumGrid = new ClsGridViewSum();
|
public bool grdStatus=true; //网格状态（不可编辑，可编辑）
|
|
#region 窗体处理方法
|
//初始化GRID
|
private void initGrid()
|
{
|
//
|
grdMain.ColumnCount = 13; //总列数
|
DBUtility.Xt_BaseBillFun.initGridFst(grdMain, this.Name);
|
////=
|
grdMain.Columns[HICMONoCol].HeaderText = "任务单号";
|
grdMain.Columns[HMaterNumberCol].HeaderText = "物料代码";
|
grdMain.Columns[HMaterNameCol].HeaderText = "物料名称";
|
grdMain.Columns[HMaterModelCol].HeaderText = "规格型号";
|
grdMain.Columns[HProcNoCol].HeaderText = "工序号";
|
grdMain.Columns[HProcNumberCol].HeaderText = "工序代码";
|
grdMain.Columns[HProcNameCol].HeaderText = "工序名称";
|
grdMain.Columns[HQtyCol].HeaderText = "期初数量";
|
////固定赋值=====================================================
|
grdMain.Columns[HSnoCol].HeaderText = "序号";
|
////=============================================================================
|
////格式化
|
//////隐藏列
|
grdMain.Columns[HTagCol].Visible = false;
|
grdMain.Columns[HICMOInterIDCol].Visible = false;
|
grdMain.Columns[HMaterIDCol].Visible = false;
|
grdMain.Columns[HProcIDCol].Visible = false;
|
|
//设置可编辑列
|
string sAllowCol = HICMONoCol.ToString() +
|
"," + HMaterNumberCol.ToString() +
|
"," + HProcNoCol.ToString() +
|
"," + HProcNumberCol.ToString() +
|
"," + HProcNameCol.ToString() +
|
"," + HQtyCol.ToString();
|
|
//设置合计列
|
string sTotalCol = HQtyCol.ToString();
|
//格式化网格
|
DBUtility.Xt_BaseBillFun.initGridLast(sAllowCol, sTotalCol, oSumGrid);
|
}
|
|
//帮助函数
|
private void Sub_GridKey(int sKeyCode, int sRow, int sCol, DataGridViewTextBoxEditingControl oEdit)
|
{
|
DAL.ClsK3_ICMOBill_View oICMO = new DAL.ClsK3_ICMOBill_View();
|
DAL.ClsK3_Material_View oMater = new DAL.ClsK3_Material_View();
|
DAL.ClsK3_Process_View oProc = new DAL.ClsK3_Process_View();
|
|
oSumGrid.EditStatus = true;
|
switch (sKeyCode)
|
{
|
case 118: //F7
|
{
|
switch (sCol)
|
{
|
case HICMONoCol:
|
oICMO.WherePart = "";
|
if (oICMO.RefreshView())
|
{
|
if (oICMO.GetInfoByID(oICMO.oModel.HItemID))
|
{
|
grdMain.Rows[sRow].Cells[HICMOInterIDCol].Value = oICMO.oModel.HItemID.ToString();
|
grdMain.Rows[sRow].Cells[HICMONoCol].Value = oICMO.oModel.HNumber;
|
if (oICMO.omodel.HMaterID != 0)
|
{
|
if (oMater.GetInfoByID(oICMO.omodel.HMaterID))
|
{
|
grdMain.Rows[sRow].Cells[HMaterIDCol].Value = oMater.omodel.HItemID.ToString();
|
grdMain.Rows[sRow].Cells[HMaterNumberCol].Value = oMater.omodel.HNumber;
|
grdMain.Rows[sRow].Cells[HMaterNameCol].Value = oMater.omodel.HName;
|
grdMain.Rows[sRow].Cells[HMaterModelCol].Value = oMater.omodel.HModel;
|
}
|
else
|
{
|
grdMain.Rows[sRow].Cells[HMaterIDCol].Value = 0;
|
grdMain.Rows[sRow].Cells[HMaterNumberCol].Value = "";
|
grdMain.Rows[sRow].Cells[HMaterNameCol].Value = "";
|
grdMain.Rows[sRow].Cells[HMaterModelCol].Value = "";
|
}
|
}
|
oEdit.Text = oICMO.oModel.HNumber;
|
}
|
else
|
{
|
grdMain.Rows[sRow].Cells[HICMOInterIDCol].Value = 0;
|
grdMain.Rows[sRow].Cells[HICMONoCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[sRow].Cells[HICMOInterIDCol].Value = 0;
|
grdMain.Rows[sRow].Cells[HICMONoCol].Value = "";
|
}
|
break;
|
|
//case HMaterNumberCol:
|
// BLL.ClsBaseSelect_K3.SetGridByMater_K3(grdMain, sRow, HMaterIDCol, HMaterNumberCol, HMaterNameCol, HMaterModelCol, 0, 0, 0, 0, 0);
|
|
// //BLL.ClsBaseSelect.SetGridByMater(grdMain, sRow, HMaterIDCol, HMaterNumberCol, HMaterNameCol, HMaterModelCol, HUnitIDCol, HUnitNumberCol, HUnitNameCol, HSubjoinCol, HColorCol);
|
// //BLL.ClsPub_BLL.SetGridWarehouse(DBUtility.ClsPub.isLong(txtHWHID.Tag), grdMain, HMaterIDCol, sRow, HWHIDCol, HWHNameCol, HWHNumberCol);
|
|
// oEdit.Text = DBUtility.ClsPub.isStrNull(grdMain.Rows[sRow].Cells[HMaterNumberCol].Value);
|
// break;
|
|
case HMaterNumberCol:
|
oMater.WherePart = "";
|
if (oMater.RefreshView())
|
{
|
if (oMater.GetInfoByID(oMater.omodel.HItemID))
|
{
|
grdMain.Rows[sRow].Cells[HMaterIDCol].Value = oMater.omodel.HItemID.ToString();
|
grdMain.Rows[sRow].Cells[HMaterNumberCol].Value = oMater.omodel.HNumber;
|
grdMain.Rows[sRow].Cells[HMaterNameCol].Value = oMater.omodel.HName;
|
grdMain.Rows[sRow].Cells[HMaterModelCol].Value = oMater.omodel.HModel;
|
oEdit.Text = oMater.omodel.HNumber;
|
}
|
else
|
{
|
grdMain.Rows[sRow].Cells[HMaterIDCol].Value = 0;
|
grdMain.Rows[sRow].Cells[HMaterNumberCol].Value = "";
|
grdMain.Rows[sRow].Cells[HMaterNameCol].Value = "";
|
grdMain.Rows[sRow].Cells[HMaterModelCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[sRow].Cells[HMaterIDCol].Value = 0;
|
grdMain.Rows[sRow].Cells[HMaterNumberCol].Value = "";
|
grdMain.Rows[sRow].Cells[HMaterNameCol].Value = "";
|
grdMain.Rows[sRow].Cells[HMaterModelCol].Value = "";
|
}
|
break;
|
|
case HProcNumberCol:
|
oProc.WherePart = "";
|
if (oProc.RefreshView())
|
{
|
if (oProc.GetInfoByID(oProc.oModel.HItemID))
|
{
|
grdMain.Rows[sRow].Cells[HProcIDCol].Value = oProc.oModel.HItemID.ToString();
|
grdMain.Rows[sRow].Cells[HProcNumberCol].Value = oProc.oModel.HNumber;
|
grdMain.Rows[sRow].Cells[HProcNameCol].Value = oProc.oModel.HName;
|
oEdit.Text = oProc.omodel.HNumber;
|
}
|
else
|
{
|
grdMain.Rows[sRow].Cells[HProcIDCol].Value = 0;
|
grdMain.Rows[sRow].Cells[HProcNumberCol].Value = "";
|
grdMain.Rows[sRow].Cells[HProcNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[sRow].Cells[HProcIDCol].Value = 0;
|
grdMain.Rows[sRow].Cells[HProcNumberCol].Value = "";
|
grdMain.Rows[sRow].Cells[HProcNameCol].Value = "";
|
}
|
break;
|
|
default:
|
break;
|
}
|
|
|
break;
|
}
|
case 117: //F6
|
{
|
switch (sCol)
|
{
|
default:
|
break;
|
}
|
break;
|
}
|
default:
|
break;
|
}
|
}
|
|
#region 基本不变
|
|
//是否是空行
|
private bool IsNullRow(int Row)
|
{
|
//return DBUtility.Xt_BaseBillFun.IsNullRow(Row, HEmpIDCol, grdMain);
|
return true;
|
}
|
|
|
//网格编辑前判断
|
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);
|
//RowCount(e.RowIndex, 0); //计算 金额 单价
|
//根据任务单号 返回 内码和物料
|
DAL.ClsK3_Process_View oProc = new DAL.ClsK3_Process_View();
|
DAL.ClsK3_ICMOBill_View oICMO = new DAL.ClsK3_ICMOBill_View();
|
DAL.ClsK3_Material_View oMater = new DAL.ClsK3_Material_View();
|
int sRow = e.RowIndex;
|
if (DBUtility.ClsPub.isStrNull(EditingControl.Text).Length >=1 && e.ColumnIndex == HProcNameCol)
|
{
|
if (oProc.GetInfoByName(EditingControl.Text))
|
{
|
grdMain.Rows[sRow].Cells[HProcIDCol].Value = oProc.omodel.HItemID.ToString();
|
grdMain.Rows[sRow].Cells[HProcNumberCol].Value = oProc.omodel.HNumber.ToString();
|
grdMain.Rows[sRow].Cells[HProcNameCol].Value = oProc.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[sRow].Cells[HProcIDCol].Value =0;
|
grdMain.Rows[sRow].Cells[HProcNumberCol].Value ="";
|
grdMain.Rows[sRow].Cells[HProcNameCol].Value = "";
|
}
|
}
|
if (DBUtility.ClsPub.isStrNull(EditingControl.Text).Length > 5 && e.ColumnIndex == HICMONoCol)
|
{
|
if (oICMO.GetInfoByNumberLike(DBUtility.ClsPub.isStrNull(EditingControl.Text)))
|
{
|
grdMain.Rows[sRow].Cells[HICMOInterIDCol].Value = oICMO.omodel.HInterID.ToString();
|
//EditingControl.Text = oICMO.oModel.HNumber;
|
grdMain.Rows[sRow].Cells[HICMONoCol].Value = oICMO.omodel.HBillNo;
|
|
if (oICMO.omodel.HMaterID != 0)
|
{
|
if (oMater.GetInfoByID(oICMO.omodel.HMaterID))
|
{
|
grdMain.Rows[sRow].Cells[HMaterIDCol].Value = oMater.omodel.HItemID.ToString();
|
grdMain.Rows[sRow].Cells[HMaterNumberCol].Value = oMater.omodel.HNumber;
|
grdMain.Rows[sRow].Cells[HMaterNameCol].Value = oMater.omodel.HName;
|
grdMain.Rows[sRow].Cells[HMaterModelCol].Value = oMater.omodel.HModel;
|
}
|
else
|
{
|
grdMain.Rows[sRow].Cells[HMaterIDCol].Value = 0;
|
grdMain.Rows[sRow].Cells[HMaterNumberCol].Value = "";
|
grdMain.Rows[sRow].Cells[HMaterNameCol].Value = "";
|
grdMain.Rows[sRow].Cells[HMaterModelCol].Value = "";
|
}
|
}
|
}
|
else
|
{
|
//grdMain.Rows[sRow].Cells[HICMOInterIDCol].Value = 0;
|
//grdMain.Rows[sRow].Cells[HICMONoCol].Value = "";
|
}
|
}
|
//
|
//
|
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_ColumnWidthChanged(object sender, DataGridViewColumnEventArgs e)
|
{
|
DBUtility.Xt_BaseBillFun.SetSumGrid(oSumGrid);
|
}
|
|
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);
|
}
|
|
|
#endregion
|
|
private void Kf_WIPBal_Add_Load(object sender, EventArgs e)
|
{
|
oSumGrid.NoCol = HSnoCol;
|
oSumGrid.ogrdMain = grdMain;
|
oSumGrid.oGridsum = grdSum;
|
initGrid();
|
|
|
|
}
|
|
#endregion
|
|
private void cmbOK_Click(object sender, EventArgs e)
|
{ //失去焦点
|
label7.Focus();
|
int HYear = ClsPub.isInt(cmbHYear.Text);
|
int HPeriod = ClsPub.isInt(cmbHPeriod.Text);
|
if (MessageBox.Show("确定要新增" + HYear + "年," + HPeriod + "月的期初记录？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
|
{
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
DataSet Ds;
|
long HICMOInterID;
|
long HMaterID;
|
long HProcNo;
|
long HProcID;
|
double HQty;
|
int j = 0;
|
for (int i = 0; i < grdMain.Rows.Count; i++)
|
{
|
if (ClsPub.isLong(grdMain.Rows[i].Cells[HICMOInterIDCol].Value) != 0)
|
{
|
j = j + 1;
|
HICMOInterID = ClsPub.isLong(grdMain.Rows[i].Cells[HICMOInterIDCol].Value);
|
HMaterID = ClsPub.isLong(grdMain.Rows[i].Cells[HMaterIDCol].Value);
|
HProcNo = ClsPub.isLong(grdMain.Rows[i].Cells[HProcNoCol].Value);
|
HProcID = ClsPub.isLong(grdMain.Rows[i].Cells[HProcIDCol].Value);
|
HQty = ClsPub.isDoule(grdMain.Rows[i].Cells[HQtyCol].Value);
|
if (HMaterID == 0)
|
{
|
MessageBox.Show("第" + (i + 1) + "行，物料不能为空！", "提示");
|
return;
|
}
|
if (HProcNo <= 0)
|
{
|
MessageBox.Show("第" + (i + 1) + "行，工序号不能小于0！", "提示");
|
return;
|
}
|
if (HProcID == 0)
|
{
|
MessageBox.Show("第" + (i + 1) + "行，工序不能为空！", "提示");
|
return;
|
}
|
if (HQty == 0)
|
{
|
MessageBox.Show("第" + (i + 1) + "行，数量不能为0！", "提示");
|
return;
|
}
|
Ds = oCn.RunProcReturn("select 1 from Kf_WIPBal where HYear=" + HYear + " and HPeriod=" + HPeriod + " and HICMOInterID=" + HICMOInterID + " and HMaterID=" + HMaterID + " and HProcNo=" + HProcNo + " and HProcID=" + HProcID, "Kf_WIPBal");
|
if (Ds.Tables[0].Rows.Count > 0)
|
{
|
MessageBox.Show("第" + (i + 1) + "行，已存在期初记录！", "提示");
|
return;
|
}
|
}
|
}
|
if (j == 0)
|
{
|
MessageBox.Show("请输入明细记录！", "提示");
|
return;
|
}
|
for (int i = 0; i < grdMain.Rows.Count; i++)
|
{
|
if (ClsPub.isLong(grdMain.Rows[i].Cells[HICMOInterIDCol].Value) != 0)
|
{
|
HICMOInterID = ClsPub.isLong(grdMain.Rows[i].Cells[HICMOInterIDCol].Value);
|
HMaterID = ClsPub.isLong(grdMain.Rows[i].Cells[HMaterIDCol].Value);
|
HProcNo = ClsPub.isLong(grdMain.Rows[i].Cells[HProcNoCol].Value);
|
HProcID = ClsPub.isLong(grdMain.Rows[i].Cells[HProcIDCol].Value);
|
HQty = ClsPub.isDoule(grdMain.Rows[i].Cells[HQtyCol].Value);
|
oCn.RunProc("exec h_p_Kf_WIPBal_Add " + HYear + "," + HPeriod + "," + HICMOInterID + "," + HMaterID + "," + HProcNo + "," + HProcID + "," + HQty + ",'" + ClsPub.CurUserName + "'");
|
}
|
}
|
MessageBox.Show("保存完毕！", "提示");
|
this.Close();
|
}
|
|
}
|
|
private void cmbCanCel_Click(object sender, EventArgs e)
|
{
|
this.Close();
|
}
|
|
private void bclk_Click(object sender, EventArgs e)
|
{
|
//保存列宽
|
DBUtility.Xt_BaseBillFun.SaveGrid(grdMain, this.Name);
|
}
|
|
private void mrlk_Click(object sender, EventArgs e)
|
{
|
DBUtility.Xt_BaseBillFun.DefaultGridView(grdMain, this.Name);
|
}
|
|
private void AddRow_Click(object sender, EventArgs e)
|
{
|
DBUtility.Xt_BaseBillFun.AddRow(oSumGrid);
|
}
|
|
private void DelRow_Click(object sender, EventArgs e)
|
{
|
DBUtility.Xt_BaseBillFun.DelRow(oSumGrid);
|
}
|
|
|
}
|
}
|
