using System;
|
using System.Collections.Generic;
|
using System.ComponentModel;
|
using System.Data;
|
using System.Drawing;
|
using System.Text;
|
using System.Windows.Forms;
|
using gregn6Lib;
|
|
namespace SCM
|
{
|
public partial class Sc_ProcessReportDel : Form
|
{
|
public Sc_ProcessReportDel()
|
{
|
InitializeComponent();
|
}
|
//public DBUtility.frmBillQueryCondition_New frmCondition;
|
public string ViewName = "Get_ICMOBillInfo";
|
public string ModCaption = "生产订单取消报工";
|
public string HInnerBillNo = "";
|
public const string ModName = "3714";
|
public const string ModRightName = "Sc_ProcessReportDel";
|
public const string ModRightNameEdit = ModRightName + "_Edit";
|
public const string ModRightNameCheck = ModRightName + "_Check";
|
public const string ModRightNameClose = ModRightName + "_Close";
|
public const string ModRightNameDelete = ModRightName + "_Delete";
|
public int HHGQtyCol = 0;
|
public int HBHGQtyCol = 0;
|
public int HQtyCol = 0;
|
public int HICMOInterIDCol = 0;
|
public int HICMOEntryIDCol = 0;
|
public int HICMOBillNoCol = 0;
|
public int HMaterialIDCol = 0;
|
public int HMaterialNumberCol = 0;
|
public int HDeptIDCol = 0;
|
public int HDeptNumberCol = 0;
|
public int HJTIDCol = 0;
|
public int HWHIDCol = 0;
|
public int HWHNameCol = 0;
|
public int HSPIDCol = 0;
|
public int HSPNameCol = 0;
|
public Sc_ProcessReportDel oFrm;
|
Pub_Class.ClsGridViewSum oSumGrid = new Pub_Class.ClsGridViewSum();
|
public Int32 iTopRow = 0;//画横线
|
public SCM.WMSWeb.WebService1 oWeb = new SCM.WMSWeb.WebService1();
|
|
//
|
private void initGrid()
|
{
|
DBUtility.Xt_BaseBillFun.initGridList(grdMain, this.Name);
|
grdMain.CellBorderStyle = DataGridViewCellBorderStyle.Single; //网格线样式：显示网格线
|
grdMain.ReadOnly = false;
|
}
|
//
|
|
private void Display()
|
{
|
string HBillNo = "";
|
HBillNo = txtHICMOBillNo.Text.Trim().ToString();
|
string HMaterNumber = "";
|
HMaterNumber = txtHMaterID2.Text.Trim().ToString();
|
string HMaterName = "";
|
HMaterName = txtHMaterName2.Text.Trim().ToString();
|
string HMaterModel = "";
|
HMaterModel = txtHMaterModel2.Text.Trim().ToString();
|
string HBeginDate = "";
|
HBeginDate = dtpHBDate.Value.ToShortDateString();
|
string HEndDate = "";
|
HEndDate = dtpHEDate.Value.ToShortDateString();
|
long HDeptNumber = 0;
|
HDeptNumber = DBUtility.ClsPub.isLong(txtHDeptID.Tag);
|
string HJT = "";
|
HJT = txtHJT.Text.Trim().ToString();
|
DataSet DSet;
|
//SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
DSet = oWeb.Get_ICMOBillInfo("exec Get_ProcReportInfoDel '" + HBillNo + "' , '" + HMaterNumber + "', '" + HMaterName + "', '" + HMaterModel + "' ,'" + HBeginDate + "' ,'" + HEndDate + "' , '" + HDeptNumber + "' ,'" + HJT + "'", "Get_ProcReportInfoDel", ref DBUtility.ClsPub.sExeReturnInfo);
|
//DSet = oCn.RunProcReturn("exec Get_ProcReportInfoDel '" + HBillNo + "' , '" + HMaterNumber + "' , '" + HMaterNumber2 + "' ,'" + HBeginDate + "' ,'" + HEndDate + "' , '" + HDeptNumber + "' ,'" + HJT + "'", "Get_ProcReportInfoDel", ref DBUtility.ClsPub.sExeReturnInfo);
|
if (DSet == null || DSet.Tables[0].Rows.Count == 0)
|
{
|
grdMain.DataSource = null;
|
MessageBox.Show("没有返回任何结果,尝试再次查询！" + DBUtility.ClsPub.sExeReturnInfo);
|
return;
|
}
|
grdMain.DataSource = DSet.Tables[0].DefaultView;
|
//设置合计列
|
//string sTotalCol = "";
|
//string[] sT;
|
//sT = sTotalCol.Split(Convert.ToChar(","));
|
//oSumGrid.BuildTotalCols(sT);
|
//
|
//冻结
|
//int FrCol = DBUtility.ClsPub.isInt(frmCondition.txtFrozenCol.Text);
|
//string s = frmCondition.cmbHComplete.Text;
|
//DBUtility.Xt_BaseBillFun.DisplayGrid(grdMain, this.Name, s, FrCol);
|
//画线
|
SCM.公用类.Xt_BaseBillFun.DisplayGrid(grdMain);
|
GraphLine();
|
|
Total();
|
HBHGQtyCol = Fun_GetCol("不合格实收数量");
|
HHGQtyCol = Fun_GetCol("合格实收数量");
|
|
}
|
//
|
private void timer1_Tick(object sender, EventArgs e)
|
{
|
timer1.Enabled = false;
|
initGrid();
|
Display();
|
}
|
|
private void tc_Click(object sender, EventArgs e)
|
{
|
this.Close();
|
}
|
|
private void sx_Click(object sender, EventArgs e)
|
{
|
timer1.Enabled = true;
|
}
|
|
private void dj_Click(object sender, EventArgs e)
|
{
|
Sub_ShowBill();
|
}
|
//显示单据
|
private void Sub_ShowBill()
|
{
|
|
}
|
//
|
private Int32 Fun_GetCol(string sCol)
|
{
|
return DBUtility.Xt_BaseBillFun.Fun_GetCol(sCol, grdMain);
|
}
|
//
|
private void Sc_ProcessReportDel_Load(object sender, EventArgs e)
|
{
|
oWeb.Url = ClsPub1.WEBSURL;
|
//
|
//frmCondition = new DBUtility.frmBillQueryCondition_New();
|
oSumGrid.ogrdMain = grdMain; //初始化 new
|
oSumGrid.oGridsum = grdSum;
|
dtpHBDate.Value = DateTime.Today.AddDays(-30);
|
dtpHEDate.Value = DateTime.Today;
|
this.Text = ModCaption;
|
lblCaption.Text = ModCaption;
|
initGrid();
|
}
|
|
private void grdMain_DblClick(object sender, EventArgs e)
|
{
|
|
//Sub_ShowBill();
|
}
|
|
private void timer2_Tick(object sender, EventArgs e)
|
{
|
}
|
|
|
|
|
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 GraphLine()
|
{
|
int MainIDCol = Fun_GetCol("hmainid");
|
int SubIDCol = Fun_GetCol("hsubid");
|
//string s = frmCondition.cmbHComplete.Text;
|
long n = 0;
|
//DBUtility.Xt_BaseBillFun.GraphLine(grdMain, MainIDCol, SubIDCol, s, ref n);
|
//显示
|
lbldj.Text = "查询出 " + n.ToString() + " 张单据";
|
lbljl.Text = "共有 " + grdMain.RowCount.ToString() + " 条记录";
|
}
|
|
private void GraphicsGrid()
|
{
|
DBUtility.Xt_BaseBillFun.GraphicsGrid(grdMain);
|
DBUtility.Xt_BaseBillFun.GraphicsRowGrid(grdMain, iTopRow, iTopRow + 50, Fun_GetCol("hmainid"));
|
}
|
|
#region //打印设置
|
|
GridppReport Report;
|
//预览
|
private void yl_Click(object sender, EventArgs e)
|
{
|
//选择打印模板
|
BLL.Gy_OpenTmp oFrm = new BLL.Gy_OpenTmp();
|
oFrm.sBillName = ModName;
|
oFrm.sBillModel = ModCaption;
|
oFrm.ShowDialog();
|
if (oFrm.OKTag == Pub_Class.ClsPub.Enum_OKTag.OKTag_OK)
|
{
|
//
|
Sub_SetReport(oFrm.sOpenTmp);
|
Report.PrintPreview(true);
|
}
|
}
|
|
private void Sub_SetReport(string sOpenTmp)
|
{
|
//判断行数
|
//
|
Report = new GridppReport();
|
Report.LoadFromFile(DBUtility.ClsPub.AppPath + @"\" + sOpenTmp + ".grf"); //here .
|
Report.FetchRecord += new _IGridppReportEvents_FetchRecordEventHandler(ReportFetchRecordByDataTable);
|
}
|
|
private void ReportFetchRecordByDataTable()
|
{
|
try
|
{
|
//BLL.Utility.FillRecordToReport(Report, grdMain, grdPrint, Fun_GetCol("HMaterID"));
|
}
|
catch (Exception e)
|
{
|
MessageBox.Show("打印失败!：" + e.Message);
|
}
|
}
|
|
#endregion
|
//
|
private void grdMain_Paint(object sender, PaintEventArgs e)
|
{
|
GraphicsGrid();
|
}
|
|
//合计 new
|
private void Total()
|
{
|
if (grdMain.Rows.Count > 0 && grdMain.ColumnCount > 0)
|
{
|
oSumGrid.SetGridsum();
|
oSumGrid.Total();
|
}
|
}
|
//合计 new
|
private void grdMain_ColumnWidthChanged(object sender, DataGridViewColumnEventArgs e)
|
{
|
Total();
|
}
|
//合计 new
|
private void grdMain_CellMouseUp(object sender, DataGridViewCellMouseEventArgs e)
|
{
|
Total();
|
}
|
//导出EXCEL
|
private void dc_Click(object sender, EventArgs e)
|
{
|
DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
|
}
|
|
private void cx_Click(object sender, EventArgs e)
|
{
|
Display();
|
}
|
|
private void grdMain_CellEndEdit(object sender, DataGridViewCellEventArgs e)
|
{
|
DBUtility.Xt_BaseBillFun.SetSumGrid(oSumGrid);
|
//RowCount(e.RowIndex, 0); //计算 金额 单价
|
//
|
if (this.EditingControl != null) //释放事件
|
{
|
EditingControl.KeyDown -= new KeyEventHandler(this.EditingControl_KeyDown);
|
this.EditingControl = null;
|
}
|
}
|
|
DataGridViewTextBoxEditingControl EditingControl;
|
private void grdMain_CellBeginEdit(object sender, DataGridViewCellCancelEventArgs e)
|
{
|
int i = grdMain.CurrentCell.ColumnIndex;
|
|
string s = DBUtility.ClsPub.isStrNull(grdMain.Columns[i].HeaderText);
|
if (s == "合格实收数量" || s == "不合格实收数量" || s == "合格收货仓库" || s == "合格收货仓位")
|
{
|
e.Cancel = false;
|
}
|
else
|
{
|
e.Cancel = true;
|
}
|
}
|
|
private void cmdHMaterID2_Click(object sender, EventArgs e)
|
{
|
SCM.ClsCLD_Material_View oMater = new SCM.ClsCLD_Material_View();
|
string MaWhere = "";
|
MaWhere = " and HUSEORGID = " + ClsPub1.HOrgID;
|
if (oMater.RefreshView(MaWhere))
|
{
|
this.txtHMaterID2.Text = oMater.omodel.HNumber;
|
this.txtHMaterID2.Tag = oMater.omodel.HItemID.ToString();
|
this.txtHMaterName2.Text = oMater.omodel.HName;
|
this.txtHMaterModel2.Text = oMater.omodel.HModel;
|
}
|
else
|
{
|
this.txtHMaterID2.Text = "";
|
this.txtHMaterID2.Tag = 0;
|
this.txtHMaterName2.Text = "";
|
this.txtHMaterModel2.Text = "";
|
}
|
}
|
|
private void cmdHMaterID_Click(object sender, EventArgs e)
|
{
|
SCM.ClsCLD_Material_View oMater = new SCM.ClsCLD_Material_View();
|
string MaWhere = "";
|
MaWhere = " and HUSEORGID = " + ClsPub1.HOrgID;
|
if (oMater.RefreshView(MaWhere))
|
{
|
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.txtHMaterID.Tag = 0;
|
this.txtHMaterName.Text = "";
|
this.txtHMaterModel.Text = "";
|
}
|
}
|
|
private void cmdHDeptID_Click(object sender, EventArgs e)
|
{
|
SCM.ClsCLD_Department_View oDept = new SCM.ClsCLD_Department_View();
|
string DeWhere = "";
|
DeWhere = " and HUSEORGID = " + ClsPub1.HOrgID;
|
if (oDept.RefreshView(DeWhere))
|
{
|
this.txtHDeptID.Text = oDept.oModel.HName;
|
this.txtHDeptID.Tag = oDept.oModel.HItemID.ToString();
|
}
|
else
|
{
|
this.txtHDeptID.Text = "";
|
this.txtHDeptID.Tag = 0;
|
}
|
}
|
|
|
private void BG_Click(object sender, EventArgs e)
|
{
|
DataSet DSet;
|
if (grdMain.CurrentRow == null)
|
return;
|
long lngBillKey = 0;
|
long lngBillKeyEntry = 0;
|
|
lngBillKey = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[Fun_GetCol("HInterID")].Value);
|
lngBillKeyEntry = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[Fun_GetCol("HEntryID")].Value);
|
if (lngBillKey == 0 || lngBillKeyEntry==0)
|
return;
|
if (MessageBox.Show("确定要取消该报工单吗？", "提示", MessageBoxButtons.OKCancel) == DialogResult.OK)
|
{
|
DSet = oWeb.Get_ICMOBillInfo("exec Del_ProcReportInfo '" + lngBillKey + "' , '" + lngBillKeyEntry + "' ", "Del_ProcReportInfo", ref DBUtility.ClsPub.sExeReturnInfo);
|
if (DSet == null || DSet.Tables[0].Rows.Count == 0)
|
{
|
|
return;
|
}
|
if (DBUtility.ClsPub.isLong(DSet.Tables[0].Rows[0][0]) == 0)
|
{
|
MessageBox.Show(DSet.Tables[0].Rows[0][1].ToString());
|
return;
|
}
|
else {
|
oWeb.getRunProc("exec Del_ProcReport '" + lngBillKey + "' , '" + lngBillKeyEntry + "' ", ref DBUtility.ClsPub.sExeReturnInfo);
|
MessageBox.Show(DSet.Tables[0].Rows[0][1].ToString());
|
Display();
|
return;
|
}
|
}
|
|
}
|
|
private void bty_Click(object sender, EventArgs e)
|
{
|
|
}
|
|
private void Sub_GridKey(int sKeyCode, int sRow, int sCol, DataGridViewTextBoxEditingControl oEdit)
|
{
|
|
//DAL.ClsCLD_Process_View oProc = new DAL.ClsCLD_Process_View();
|
//DAL.ClsCLD_Employee_View oEmp = new DAL.ClsCLD_Employee_View();
|
SCM.ClsCLD_Material_View oMater = new SCM.ClsCLD_Material_View();
|
//DAL.ClsCLD_Unit_View oUnit = new DAL.ClsCLD_Unit_View();
|
//DAL.ClsCLD_Source_View oSource = new DAL.ClsCLD_Source_View();
|
//DAL.ClsCLD_ORGANIZATIONS_View oOrg = new DAL.ClsCLD_ORGANIZATIONS_View();
|
SCM.ClsCLD_Warehouse_View oWare = new SCM.ClsCLD_Warehouse_View();
|
SCM.ClsCLD_StockPlace_View oSp = new SCM.ClsCLD_StockPlace_View();
|
//if (!grdStatus)
|
//{
|
// return;
|
//}
|
//if (oSumGrid.FindAllowEditCol(sCol))
|
//{
|
oSumGrid.EditStatus = true;
|
//}
|
//else
|
//{
|
// return;
|
//}
|
switch (sKeyCode)
|
{
|
case 118: //F7
|
{
|
int i = grdMain.CurrentCell.ColumnIndex;
|
|
string s = DBUtility.ClsPub.isStrNull(grdMain.Columns[i].HeaderText);
|
if (s == "合格收货仓库")
|
{
|
//oOrg.GetInfoByName(cmbHOrg.Text);
|
oWare.WherePart = "";
|
//if (oWare.RefreshView(" and HUSEORGID =" + oOrg.omodel.HItemID))
|
if (oWare.RefreshView())
|
{
|
grdMain.Rows[sRow].Cells[HWHIDCol].Value = oWare.oModel.HItemID.ToString();
|
grdMain.Rows[sRow].Cells[HWHNameCol].Value = oWare.oModel.HName;
|
grdMain.Rows[sRow].Cells[HSPIDCol].Value = 0;
|
grdMain.Rows[sRow].Cells[HSPNameCol].Value = "";
|
oEdit.Text = oWare.oModel.HName;
|
}
|
else
|
{
|
grdMain.Rows[sRow].Cells[HWHIDCol].Value = 0;
|
grdMain.Rows[sRow].Cells[HWHNameCol].Value = "";
|
grdMain.Rows[sRow].Cells[HSPIDCol].Value = 0;
|
grdMain.Rows[sRow].Cells[HSPNameCol].Value = "";
|
}
|
}
|
if (s == "合格收货仓位")
|
{
|
//oOrg.GetInfoByName(cmbHOrg.Text);
|
oSp.WherePart = "";
|
if (oSp.RefreshView(" and HWHID = '" + DBUtility.ClsPub.isStrNull(grdMain.Rows[sRow].Cells[HWHIDCol].Value) + "'"))
|
//if (oSp.RefreshView(" and HWHID = '" + DBUtility.ClsPub.isStrNull(grdMain.Rows[sRow].Cells[HWHIDCol].Value) + "' and HUSEORGID =" + oOrg.omodel.HItemID))
|
{
|
grdMain.Rows[sRow].Cells[HWHIDCol].Value = oSp.omodel.HItemID.ToString();
|
grdMain.Rows[sRow].Cells[HWHNameCol].Value = oSp.omodel.HName;
|
grdMain.Rows[sRow].Cells[HSPIDCol].Value = oSp.omodel.HMainStockID.ToString();
|
grdMain.Rows[sRow].Cells[HSPNameCol].Value = oSp.omodel.HMainStockName;
|
oEdit.Text = oSp.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[sRow].Cells[HWHIDCol].Value = 0;
|
grdMain.Rows[sRow].Cells[HWHNameCol].Value = "";
|
grdMain.Rows[sRow].Cells[HSPIDCol].Value = 0;
|
grdMain.Rows[sRow].Cells[HSPNameCol].Value = "";
|
}
|
}
|
|
|
//case HMaterNumberCol:
|
// oOrg.GetInfoByName(cmbHOrg.Text);
|
// oMater.WherePart = "";
|
// if (oMater.RefreshView(" and HUSEORGID =" + oOrg.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;
|
// grdMain.Rows[sRow].Cells[HUnitIDCol].Value = oMater.omodel.HUnitID.ToString();
|
// grdMain.Rows[sRow].Cells[HUnitNumberCol].Value = oMater.omodel.HUnitNumber;
|
// grdMain.Rows[sRow].Cells[HUnitNameCol].Value = oMater.omodel.HUnitName;
|
// }
|
// 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 = "";
|
// grdMain.Rows[sRow].Cells[HUnitIDCol].Value = 0;
|
// grdMain.Rows[sRow].Cells[HUnitNumberCol].Value = "";
|
// grdMain.Rows[sRow].Cells[HUnitNameCol].Value = "";
|
// }
|
// break;
|
|
|
}
|
break;
|
}
|
}
|
private void EditingControl_KeyDown(object sender, KeyEventArgs e)
|
{
|
//业务处理
|
Sub_GridKey(e.KeyValue, grdMain.CurrentRow.Index, grdMain.CurrentCell.ColumnIndex, 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 txtHMaterID2_TextChanged(object sender, EventArgs e)
|
{
|
if (txtHMaterID2.Text.Trim() == "")
|
{
|
txtHMaterID2.Tag = "0";
|
txtHMaterName2.Text = "";
|
txtHMaterModel2.Text = "";
|
}
|
}
|
}
|
}
|
