using System;
|
using System.Collections.Generic;
|
using System.ComponentModel;
|
using System.Data;
|
using System.Drawing;
|
using System.Text;
|
using System.Windows.Forms;
|
using SQLHelper;
|
using Pub_Class;
|
|
namespace BLL
|
{
|
/// <summary>
|
/// 条码管理
|
/// </summary>
|
public partial class Gy_BarCodeEdit : Form
|
{
|
public Gy_BarCodeEdit()
|
{
|
InitializeComponent();
|
}
|
|
public const string ModName = "";
|
public const string ModCaption = "条码管理";
|
public Int64 HInterID = 0; //单据主内码
|
public Int64 HEntryID = 0; //单据子内码
|
//
|
public int HMaterIDCol = 0; //物料列
|
//
|
public string HBillType = ""; //单据类型
|
public long HMaterID = 0; //物料ID
|
public long HProcID = 0; //工序ID
|
public long HWhID = 0; //仓库ID
|
public long HSCWhID = 0; //调出仓库ID
|
public long HStockPlaceID = 0; //仓位ID
|
public long HOutStockPlaceID = 0; //调出仓位ID
|
public long HGroupID = 0; //班组ID
|
public long HSourceInterID = 0; //源单主ID
|
public long HSourceEntryID = 0; //源单子ID
|
public string HSourceBillType = ""; //源单类型
|
public long HSourceItemID = 0; //源单物料ID
|
//
|
public DBUtility.ClsPub.Enum_BillStatus BillStatus;
|
public ClsGy_BarCodeEdit_Ctl BillNew = new ClsGy_BarCodeEdit_Ctl();
|
public ClsGy_BarCodeEdit_Ctl BillOld = new ClsGy_BarCodeEdit_Ctl();
|
Pub_Class.ClsGridListSum oSumGrid = new Pub_Class.ClsGridListSum();
|
|
//
|
private Int32 Fun_GetCol(string sCol)
|
{
|
return DBUtility.Xt_BaseBillFun.Fun_GetCol(sCol, grdMain);
|
}
|
//
|
private void initGrid()
|
{
|
DBUtility.Xt_BaseBillFun.initGridList(grdMain, this.Name);
|
}
|
|
//刷新网格
|
private void Display()
|
{
|
//从数据库获取数据显示到网格
|
ClsCN SubCn = new ClsCN();
|
DataSet DSet;
|
string sSql = "";
|
string sWhere = this.HInterID.ToString() + ",'" + HBillType + "'";
|
//过滤条件
|
sSql = "exec h_p_Gy_BarCodeEditDisplay ";
|
//
|
DSet = SubCn.RunProcReturn(sSql + sWhere, "Gy_Czygl", ref DBUtility.ClsPub.sExeReturnInfo);
|
//生成首行标题
|
if (DSet == null)
|
{
|
MessageBox.Show("没有返回任何结果,请在过滤框中点击【恢复】按钮,尝试再次查询！" + DBUtility.ClsPub.sExeReturnInfo);
|
return;
|
}
|
//填充
|
grdMain.DataSource = DSet.Tables[0].DefaultView;
|
//设置合计列
|
string sTotalCol = "";
|
sTotalCol = DBUtility.Gy_BaseFun.GetTotalCols(DSet);
|
string[] sT;
|
sT = sTotalCol.Split(Convert.ToChar(","));
|
oSumGrid.BuildTotalCols(sT);
|
//
|
//冻结
|
int FrCol = 0;
|
string s = "";
|
DBUtility.Xt_BaseBillFun.DisplayGrid(grdMain, this.Name,s, FrCol);
|
//画线
|
|
//合计
|
Total();
|
}
|
|
|
private void GraphicsGrid()
|
{
|
DBUtility.Xt_BaseBillFun.GraphicsGrid(grdMain);
|
}
|
|
//刷新按钮
|
private void sx_Click(object sender, EventArgs e)
|
{
|
Display();
|
}
|
|
//引出按钮
|
private void dc_Click(object sender, EventArgs e)
|
{
|
DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
|
}
|
|
//窗体初始化
|
private void Gy_BarCodeEdit_Load(object sender, EventArgs e)
|
{
|
this.Text = ModCaption;
|
oSumGrid.ogrdMain = grdMain; //初始化 new
|
oSumGrid.oGridsum = grdSum;
|
//lblCaption.Text = ModCaption;
|
initGrid();
|
}
|
|
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);
|
}
|
|
//合计 new
|
private void Total()
|
{
|
if (grdMain.Rows.Count > 0 && grdMain.ColumnCount > 0)
|
{
|
oSumGrid.SetGridsum();
|
oSumGrid.Total();
|
}
|
}
|
//合计 new
|
private void grdMain_ColumnWidthChanged(object sender, DataGridViewColumnEventArgs e)
|
{
|
Total();
|
}
|
//合计 new
|
private void grdMain_CellMouseUp(object sender, DataGridViewCellMouseEventArgs e)
|
{
|
Total();
|
}
|
|
|
//条码框键盘事件
|
private void txtHBarCode_KeyDown(object sender, KeyEventArgs e)
|
{
|
//判断是否回车键
|
if (e.KeyCode == Keys.Enter)
|
{
|
//条码处理
|
set_BarCode();
|
txtHBarCode.Text = "";
|
}
|
}
|
|
//条码处理
|
private void set_BarCode()
|
{
|
//从条码档案里判断条码准确性
|
if (BillOld.HavParentCarCode(txtHBarCode.Text.Trim()))
|
{
|
//保存
|
Sub_SaveBill(BillOld);
|
}
|
else
|
{
|
MessageBox.Show("无效的条码！");
|
return;
|
}
|
}
|
|
//是否是空行
|
private bool IsNullRow(int Row)
|
{
|
return DBUtility.Xt_BaseBillFun.IsNullRow(Row, HMaterIDCol, grdMain);
|
}
|
|
//单据完整性判断 未完成
|
private bool Sub_AllowSave()
|
{
|
//必输项目是否为空
|
|
//明细表是否为零行
|
bool b = false;
|
for (int i = 0; i < grdMain.RowCount; i++)
|
{
|
if (!IsNullRow(i))
|
{
|
b = true;
|
break;
|
}
|
}
|
if (b == false)
|
{
|
MessageBox.Show("明细行不存在！", "提示");
|
return false;
|
}
|
return true;
|
}
|
|
private bool Sub_SaveBill(ClsGy_BarCodeEdit_Ctl oBar)
|
{
|
Int32 i;
|
bool bResult = false;
|
BillNew = new ClsGy_BarCodeEdit_Ctl();
|
//if (!Sub_AllowSave())//单据完整性判断
|
// return false;
|
//
|
//主类赋值
|
BillNew.omodel.HInterID = this.HInterID;
|
BillNew.omodel.HEntryID =this.HEntryID;
|
BillNew.omodel.HBillType = this.HBillType;
|
BillNew.omodel.HMaterID = oBar.omodel.HMaterID;
|
BillNew.omodel.HBatchNo = oBar.omodel.HBatchNo;
|
BillNew.omodel.HProcID = oBar.omodel.HProcID;
|
BillNew.omodel.HWhID = HWhID;
|
BillNew.omodel.HSCWhID = 0;
|
BillNew.omodel.HStockPlaceID = 0;
|
BillNew.omodel.HOutStockPlaceID = 0;
|
BillNew.omodel.HGroupID =0;
|
BillNew.omodel.HQty = oBar.omodel.HQty;
|
BillNew.omodel.HBarCode = oBar.omodel.HBarCode;
|
BillNew.omodel.HAddr = "";
|
BillNew.omodel.HSourceInterID = oBar.omodel.HSourceInterID;
|
BillNew.omodel.HSourceEntryID = oBar.omodel.HSourceEntryID;
|
BillNew.omodel.HSourceBillType = oBar.omodel.HSourceBillType;
|
BillNew.omodel.HSourceItemID = 0;
|
|
//保存完毕后处理
|
if (BillStatus == DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew)
|
{
|
bResult = BillNew.AddNew();
|
}
|
//提示
|
if (bResult == true)
|
{
|
if (BillStatus == DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew)
|
{
|
this.Display();
|
}
|
return true;
|
}
|
else
|
{
|
MessageBox.Show("保存失败!原因:" + ClsPub.sExeReturnInfo, "提示");
|
return false;
|
}
|
}
|
|
private void grdMain_Paint(object sender, PaintEventArgs e)
|
{
|
GraphicsGrid();
|
}
|
|
private void back_Click(object sender, EventArgs e)
|
{
|
this.Visible = false;
|
}
|
|
|
|
|
}
|
}
|
