using System;
|
using System.Collections.Generic;
|
using System.ComponentModel;
|
using System.Data;
|
using System.Drawing;
|
using System.Text;
|
using System.Windows.Forms;
|
using System.Runtime.InteropServices;
|
using gregn6Lib;
|
using SQLHelper;
|
|
namespace APSM
|
{
|
public partial class KF_LackMaterialAnalyse : Form //
|
{
|
public KF_LackMaterialAnalyse()
|
{
|
InitializeComponent();
|
}
|
public KF_LackMaterialAnalyseDetail oDetailDlg = new KF_LackMaterialAnalyseDetail();
|
public const Int16 FixCols = 7;
|
DAL.ClsSc_ICMOSortBill oMain=new DAL.ClsSc_ICMOSortBill();
|
public string ModName = "";
|
public string ModCaption = "车间缺料分析";
|
|
public const int HNumberCol = 0;
|
public const int HNameCol = 1;
|
public const int HModelCol = 2;
|
public const int HKCQtyCol = 3;
|
public const int HZTQtyCol = 4;
|
public const int HWFQtyCol = 5;
|
public const int HTotalCol = 6;
|
#region 固定代码
|
|
private void initGrid()
|
{
|
grdMain.Cols =7;
|
grdMain.Rows =2;
|
grdMain.FixedCols = 0;
|
grdMain.FixedRows = 2;
|
grdMain.ExplorerBar = VSFlex7.ExplorerBarSettings.flexExSort;
|
grdMain.AllowBigSelection = false;
|
grdMain.AllowSelection = false;
|
grdMain.SelectionMode = VSFlex7.SelModeSettings.flexSelectionByRow;
|
grdMain.ScrollTrack = true;
|
grdMain.WordWrap = true;
|
grdMain.set_ColWidth(-1, 1500);
|
grdMain.set_RowHeight(-1, 400);
|
grdMain.set_RowHeight(0, 500);
|
//隐藏列
|
grdMain.set_RowHidden(1, true);
|
grdMain.RowHeightMin = 250;
|
grdMain.Editable = VSFlex7.EditableSettings.flexEDNone;
|
grdMain.AllowUserResizing = VSFlex7.AllowUserResizeSettings.flexResizeBoth;
|
grdMain.AllowUserFreezing = VSFlex7.AllowUserFreezeSettings.flexFreezeBoth;
|
grdMain.set_FixedAlignment(-1, VSFlex7.AlignmentSettings.flexAlignCenterCenter);
|
grdMain.AutoSizeMode = VSFlex7.AutoSizeSettings.flexAutoSizeColWidth;
|
grdMain.set_TextMatrix(0, HNumberCol, "物料代码");
|
grdMain.set_TextMatrix(0, HNameCol, "物料名称");
|
grdMain.set_TextMatrix(0, HModelCol, "物料型号");
|
grdMain.set_TextMatrix(0, HKCQtyCol, "即时库存");
|
grdMain.set_TextMatrix(0, HZTQtyCol, "在途采购");
|
grdMain.set_TextMatrix(0, HWFQtyCol, "未发数");
|
grdMain.set_TextMatrix(0, HTotalCol, "合计");
|
grdMain.FrozenCols = 7;
|
//
|
LoadDateCol(28);
|
Sc_ICMOSortBillFun.GetGrid(grdMain, this.Name);
|
}
|
//得到对应列
|
private int Fun_GetCol(string sColName)
|
{
|
return Sc_ICMOSortBillFun.Fun_GetCol(sColName, grdMain);
|
}
|
|
private void tc_Click(object sender, EventArgs e)
|
{
|
this.Close();
|
}
|
|
KF_LackMaterialAnalyseDlg oDlg = new KF_LackMaterialAnalyseDlg();
|
private void cx_Click(object sender, EventArgs e)
|
{
|
oDlg.ShowDialog();
|
if (oDlg.IsOk == 1)
|
{
|
timer1.Enabled = true;
|
}
|
}
|
//设置报表名称
|
private void SetFormCaption()
|
{
|
this.Text = ModCaption;
|
lblCaption.Text = this.Text;
|
initGrid();//网格标题初始化
|
initHeadCaption();//表头初始化
|
}
|
|
|
private void Frm_EasyReport_Load(object sender, EventArgs e)
|
{
|
SetFormCaption();
|
}
|
|
|
private void timer1_Tick(object sender, EventArgs e)
|
{
|
timer1.Enabled = false;
|
if (Fun_AllowQuery())
|
{
|
System.Windows.Forms.Application.DoEvents();
|
Query();
|
System.Windows.Forms.Application.DoEvents();
|
}
|
}
|
|
private void Xs_SellOutPriceReport_KeyUp(object sender, KeyEventArgs e)
|
{
|
if (e.KeyValue == 13)
|
timer1.Enabled = true;
|
}
|
|
private void mrlk_Click(object sender, EventArgs e)
|
{
|
Sc_ICMOSortBillFun.DefaultGrid(grdMain, this.Name);
|
}
|
|
private void bclk_Click(object sender, EventArgs e)
|
{
|
//保存列宽
|
Sc_ICMOSortBillFun.SaveGrid(grdMain, this.Name);
|
}
|
|
//打印
|
private void dy_Click(object sender, EventArgs e)
|
{
|
//Sub_SetReport();
|
//Report.Print(true);
|
}
|
//预览
|
private void view_Click(object sender, EventArgs e)
|
{
|
//Sub_SetReport();
|
//Report.PrintPreview(true);
|
}
|
|
#endregion
|
|
#region 界面处理
|
//初始化表头显示
|
private void initHeadCaption()
|
{
|
|
}
|
|
private bool Fun_AllowQuery()//审核查询条件
|
{
|
//if (txtHBDeptID.Text.Trim().Length == 0)
|
//{
|
// MessageBox.Show(this, "请选择开始部门！", "提示");
|
// return false;
|
//}
|
return true;
|
}
|
|
private void Query()
|
{
|
string sSQL = "";
|
long lngCount =0;
|
int i =0;
|
int r =0;
|
int c =0;
|
Single cSumAmount=0;
|
Single ctmpAmount=0;
|
string sNewDate="";
|
int m =0;
|
grdMain.Redraw = VSFlex7.RedrawSettings.flexRDNone;
|
initGrid();
|
oDetailDlg.initGrid();
|
//
|
sNewDate = oMain.GetNewSetup(DBUtility.ClsPub.isLong(oDlg.txtHBDeptID.Tag)).ToShortDateString(); //得到最新排程
|
//加载投料记录
|
oMain.FillData(DBUtility.ClsPub.isLong(oDlg.txtHBDeptID.Tag));
|
//
|
System.Windows.Forms.Application.DoEvents();
|
sSQL = "exec h_p_Sc_GetICMOSortBillList "+DBUtility.ClsPub.isLong(oDlg.txtHBDeptID.Tag).ToString()+",'"+sNewDate+"'";
|
SQLHelper.ClsCN oCn=new ClsCN();
|
DataSet DS=oCn.RunProcReturn(sSQL,"gy_Material");
|
pb1.Maximum = DS.Tables[0].Rows.Count;
|
pb1.Visible = true;
|
for(i=0;i<DS.Tables[0].Rows.Count;i++)
|
{
|
InputTLD(DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[i]["HNumber"])
|
, DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[i]["HSourceName"])
|
, DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[i]["HICMOBillNo"])
|
, DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[i]["HSplitNo"])
|
, DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[i]["HDate"])
|
, DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[i]["HQty"]));
|
System.Windows.Forms.Application.DoEvents();
|
pb1.Value=i;
|
System.Windows.Forms.Application.DoEvents();
|
|
}
|
pb1.Visible = false;
|
//设置未发数
|
for( i=oDetailDlg.grdMain.FixedRows;i<oDetailDlg.grdMain.Rows;i++)
|
{
|
r = -1;
|
if( DBUtility.ClsPub.isSingle(oDetailDlg.grdMain.get_TextMatrix(i, 4)) -DBUtility.ClsPub.isSingle(oDetailDlg.grdMain.get_TextMatrix(i, 5)) != 0 )
|
{
|
r = FindRow(oDetailDlg.grdMain.get_TextMatrix(i, 0));
|
if( r != -1 )
|
{
|
//设置未发数
|
grdMain.set_TextMatrix(r,5,Convert.ToString(DBUtility.ClsPub.isSingle(grdMain.get_TextMatrix(r,5))
|
+DBUtility.ClsPub.isSingle(oDetailDlg.grdMain.get_TextMatrix(i,4))
|
-DBUtility.ClsPub.isSingle(oDetailDlg.grdMain.get_TextMatrix(i,5))));
|
}
|
}
|
}
|
//判断 未发数和 库存是否 够用
|
for(i=grdMain.FixedRows;i<grdMain.Rows;i++)
|
{
|
grdMain.set_Cell(VSFlex7.CellPropertySettings.flexcpBackColor, i, 3,i,3 ,DBUtility.ClsPub.Enum_Color.hx_Write);
|
grdMain.set_Cell(VSFlex7.CellPropertySettings.flexcpForeColor, i, 3,i,3, DBUtility.ClsPub.Enum_Color.hx_Black);
|
//
|
if (DBUtility.ClsPub.isSingle(grdMain.get_TextMatrix(i, 5)) -DBUtility.ClsPub.isSingle(grdMain.get_TextMatrix(i, 3)) > 0 )
|
{
|
//库存不足显示红色
|
grdMain.set_Cell(VSFlex7.CellPropertySettings.flexcpForeColor, i, 3, i , 3 ,DBUtility.ClsPub.Enum_Color.hx_Red);
|
}
|
}
|
//
|
for( i=grdMain.FixedRows;i<grdMain.Rows;i++)
|
{
|
ctmpAmount = 0;
|
cSumAmount =DBUtility.ClsPub.isSingle(grdMain.get_TextMatrix(i, 6))
|
- DBUtility.ClsPub.isSingle(grdMain.get_TextMatrix(i, 5))
|
+ DBUtility.ClsPub.isSingle(grdMain.get_TextMatrix(i, 3));
|
for( m=7;m<grdMain.Cols;m++)
|
{
|
ctmpAmount = ctmpAmount + DBUtility.ClsPub.isSingle(grdMain.get_TextMatrix(i, m));
|
if( ctmpAmount > cSumAmount)
|
{
|
grdMain.set_Cell(VSFlex7.CellPropertySettings.flexcpForeColor, i, m, i, m, DBUtility.ClsPub.Enum_Color.hx_Red);
|
}
|
}
|
//===================
|
}
|
grdMain.Redraw = VSFlex7.RedrawSettings.flexRDBuffered;
|
System.Windows.Forms.Application.DoEvents();
|
}
|
|
|
private void InputTLD(string sItemNumber ,string sJT ,string sSCRWDH ,string sPGDH ,string sDate ,string sQuantity )
|
{
|
int c;
|
int r;
|
int w;
|
Single bl=0;
|
long i;
|
long SUM ;
|
List<DAL.Cls_ICTLDetail> oColl;
|
if( sQuantity.Trim() != "" )
|
{
|
oColl=oMain.GetTLColl(sSCRWDH);
|
if(oColl==null || oColl.Count==0)
|
{
|
return ;
|
}
|
foreach(DAL.Cls_ICTLDetail oTLDetail in oColl)
|
{
|
r = FindRow( oTLDetail.WLDM );
|
if(r==-1)
|
{
|
grdMain.Rows=grdMain.Rows+1;
|
r = grdMain.Rows - 1;
|
}
|
grdMain.set_TextMatrix(r,0,oTLDetail.WLDM);
|
grdMain.set_TextMatrix(r, 1,oTLDetail.WLMC);
|
grdMain.set_TextMatrix(r, 2,oTLDetail.GGXH);
|
grdMain.set_TextMatrix(r, 3,oTLDetail.StockAmount.ToString()); // 'GetSumStockAmount(otldetail.wldm)
|
grdMain.set_TextMatrix(r, 4,oTLDetail.OrderAmount.ToString()); //'GetSumOrderAmount(otldetail.wldm)
|
grdMain.set_TextMatrix(r, 5,"");
|
c = FindCol(sDate);
|
if( c != -1 )
|
{
|
if( oTLDetail.FAuxQty != 0)
|
{
|
bl = oTLDetail.JHTLS / oTLDetail.FAuxQty;
|
}
|
if( DBUtility.ClsPub.isSingle(sQuantity) * bl != 0)
|
{
|
grdMain.set_TextMatrix(r, c,Convert.ToString( DBUtility.ClsPub.isSingle(grdMain.get_TextMatrix(r,c))+ DBUtility.ClsPub.isSingle(sQuantity)*bl));
|
grdMain.set_TextMatrix(r, 6,Convert.ToString( DBUtility.ClsPub.isSingle(grdMain.get_TextMatrix(r,6))+ DBUtility.ClsPub.isSingle(sQuantity)*bl));
|
}
|
}
|
//'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
|
r = FindDetailRow(oTLDetail.WLDM, oTLDetail.MainWLDM, sSCRWDH);
|
if( r == -1 )
|
{
|
oDetailDlg.grdMain.Rows = oDetailDlg.grdMain.Rows + 1;
|
r = oDetailDlg.grdMain.Rows - 1;
|
}
|
oDetailDlg.grdMain.set_TextMatrix(r, 0, oTLDetail.WLDM);
|
oDetailDlg.grdMain.set_TextMatrix(r, 1, oTLDetail.WLMC);
|
oDetailDlg.grdMain.set_TextMatrix(r, 2, oTLDetail.GGXH);
|
oDetailDlg.grdMain.set_TextMatrix(r, 3, sSCRWDH);
|
oDetailDlg.grdMain.set_TextMatrix(r, 4, oTLDetail.YFSL.ToString());
|
oDetailDlg.grdMain.set_TextMatrix(r, 5, oTLDetail.LLS.ToString());
|
oDetailDlg.grdMain.set_TextMatrix(r, 6, oTLDetail.BLS.ToString());
|
oDetailDlg.grdMain.set_TextMatrix(r, 7, sPGDH);
|
oDetailDlg.grdMain.set_TextMatrix(r, 8, oTLDetail.MainWLDM);
|
oDetailDlg.grdMain.set_TextMatrix(r, 9, oTLDetail.MainWLMC);
|
oDetailDlg.grdMain.set_TextMatrix(r, 10, sJT);
|
//
|
c = FindDetailCol(sDate);
|
if( c != -1 )
|
{
|
if( oTLDetail.FAuxQty != 0)
|
{
|
bl = oTLDetail.JHTLS / oTLDetail.FAuxQty;
|
}
|
if( DBUtility.ClsPub.isSingle(sQuantity) * bl != 0)
|
{
|
oDetailDlg.grdMain.set_TextMatrix(r, c ,Convert.ToString( DBUtility.ClsPub.isSingle(sQuantity) * bl));
|
oDetailDlg.grdMain.set_TextMatrix(r, 11,Convert.ToString( DBUtility.ClsPub.isSingle(oDetailDlg.grdMain.get_TextMatrix(r, 11)) + DBUtility.ClsPub.isSingle(sQuantity) * bl));
|
}
|
}
|
|
}
|
}
|
}
|
//
|
public int FindRow(string sItemCode)
|
{
|
// '通过物料编码查找数据所在的行
|
for(int r=grdMain.FixedRows;r<grdMain.Rows ;r++)
|
{
|
if(DBUtility.ClsPub.isStrNull(grdMain.get_TextMatrix(r, 0)).Trim() == sItemCode.Trim())
|
{
|
return r;
|
}
|
}
|
return -1;// '''未找到
|
}
|
//
|
public int FindCol(string sDate)
|
{
|
// '通过日期查找日期所归属的列
|
for(int c=7;c<grdMain.Cols;c++)
|
{
|
if (DBUtility.ClsPub.isStrNull(grdMain.get_TextMatrix(1, c)) == Convert.ToDateTime(sDate).ToString("yyyy-MM-dd"))
|
{
|
return c;
|
}
|
}
|
return -1;// '未找到
|
}
|
//
|
public int FindDetailRow(string sItemCode,string sMainItemCode ,string sRWDH)
|
{
|
//'通过日期查找日期所归属的列
|
// '通过物料编码查找数据所在的行
|
int r;
|
for(r=oDetailDlg.grdMain.FixedRows ;r<oDetailDlg.grdMain.Rows ;r++)
|
{
|
if (DBUtility.ClsPub.isStrNull(oDetailDlg.grdMain.get_TextMatrix(r, 0)).Trim() == sItemCode.Trim()
|
&& DBUtility.ClsPub.isStrNull(oDetailDlg.grdMain.get_TextMatrix(r, 8)).Trim() == sMainItemCode.Trim()
|
&& DBUtility.ClsPub.isStrNull(oDetailDlg.grdMain.get_TextMatrix(r, 3)).Trim() == sRWDH.Trim())
|
{
|
return r;
|
}
|
}
|
return -1;// '未找到
|
}
|
|
public int FindDetailCol(string sDate)
|
{
|
//'通过日期查找日期所归属的列
|
for(int c = 12;c< oDetailDlg.grdMain.Cols ;c++)
|
{
|
if (DBUtility.ClsPub.isStrNull(oDetailDlg.grdMain.get_TextMatrix(1, c)).Trim() == Convert.ToDateTime(sDate).ToString("yyyy-MM-dd"))
|
{
|
return c;
|
}
|
}
|
return -1;// '未找到
|
}
|
|
private void Display()
|
{
|
//
|
}
|
|
#endregion
|
|
#region 打印设置
|
|
//打印设置
|
GridppReport Report;
|
//设置打印模版路径
|
private void Sub_SetReport()
|
{
|
//Report = new GridppReport();
|
//Report.LoadFromFile(ClsPub.AppPath + @"\Report\应收款明细表.grf"); //here .
|
//Report.BeforePostRecord += new _IGridppReportEvents_BeforePostRecordEventHandler(ReportBeforePostRecord);
|
//Report.FetchRecord += new _IGridppReportEvents_FetchRecordEventHandler(ReportFetchRecordByDataTable);
|
}
|
//填入单据表头信息
|
private void ReportBeforePostRecord()//your report?kao
|
{
|
//Report.FieldByName("HDateItemID").AsString = lblHDateItemID.Text;
|
//Report.FieldByName("CusNumber").AsString = lblHCusNumber.Text;
|
//Report.FieldByName("CusName").AsString = lblHCusName.Text;
|
//Report.FieldByName("BeginBalance").AsString = lblHBeginBalance.Text;
|
}
|
//填入单据明细信息
|
private void ReportFetchRecordByDataTable()
|
{
|
//Utility.FillRecordToReport(Report, grdMain, false);
|
}
|
#endregion
|
|
#region 数据导出
|
|
[DllImport("User32.dll", CharSet = CharSet.Auto)]
|
public static extern int GetWindowThreadProcessId(IntPtr hwnd, out int ID);
|
private void yc_Click(object sender, EventArgs e)
|
{
|
//string saveFileName = "";
|
//bool fileSaved = false;
|
//SaveFileDialog saveDialog = new SaveFileDialog();
|
//saveDialog.DefaultExt = "xls";
|
//saveDialog.Filter = "Excel文件|*.xls";
|
//saveDialog.FileName = this.Text;
|
//saveDialog.ShowDialog();
|
//saveFileName = saveDialog.FileName;
|
//if (saveFileName.IndexOf(":") < 0) return; //被点了取消
|
////
|
//Excel.Application xlApp = new Excel.Application();
|
|
//if (xlApp == null)
|
//{
|
// MessageBox.Show(this, "无法创建Excel对象，可能您的机子未安装Excel", "提示");
|
// return;
|
//}
|
//Excel.Workbooks workbooks = xlApp.Workbooks;
|
//Excel.Workbook workbook = workbooks.Add(Excel.XlWBATemplate.xlWBATWorksheet);
|
//Excel.Worksheet worksheet = (Excel.Worksheet)workbook.Worksheets[1];//取得sheet1
|
////写入 标题
|
//for (int i = 0; i < grdMain.Cols; i++)
|
//{
|
// worksheet.Cells[1, i + 1] = ClsPub.isStrNull(grdMain.get_TextMatrix(0, i));
|
//}
|
////写入内容
|
//for (int r = grdMain.FixedRows; r < grdMain.Rows; r++)
|
//{
|
// for (int i = grdMain.FixedCols; i < grdMain.Cols; i++)
|
// {
|
// worksheet.Cells[r + 1, i + 1] = ClsPub.isStrNull(grdMain.get_TextMatrix(r, i));
|
// }
|
// System.Windows.Forms.Application.DoEvents();
|
//}
|
//worksheet.Columns.EntireColumn.AutoFit();//列宽自适应。
|
|
//if (saveFileName != "")
|
//{
|
// try
|
// {
|
// workbook.Saved = true;
|
// workbook.SaveCopyAs(saveFileName);
|
// fileSaved = true;
|
// }
|
// catch (Exception ex)
|
// {
|
// fileSaved = false;
|
// MessageBox.Show(this, "导出文件时出错,文件可能正被打开！\n" + ex.Message, "提示");
|
// }
|
//}
|
//else
|
//{
|
// fileSaved = false;
|
//}
|
//xlApp.Quit();
|
|
//IntPtr t = new IntPtr(xlApp.Hwnd); //得到这个句柄，具体作用是得到这块内存入口
|
//int k = 0;
|
//GetWindowThreadProcessId(t, out k); //得到本进程唯一标志k
|
//System.Diagnostics.Process p = System.Diagnostics.Process.GetProcessById(k); //得到对进程k的引用
|
//p.Kill(); //关闭进程k
|
//xlApp = null;
|
////GC.Collect();//强行销毁
|
//if (fileSaved && System.IO.File.Exists(saveFileName)) System.Diagnostics.Process.Start(saveFileName); //打开EXCEL
|
|
}
|
#endregion
|
|
|
private void timer2_Tick(object sender, EventArgs e)
|
{
|
timer2.Enabled = false;
|
oDlg.ShowDialog();
|
if (oDlg.IsOk == 1)
|
{
|
timer1.Enabled = true;
|
}
|
}
|
//加载 当月日期
|
private void LoadDateCol(int iDates)
|
{
|
Sc_ICMOSortBillFun.LoadDateCol(grdMain, FixCols, iDates);
|
}
|
|
private void grdMain_DblClick(object sender, EventArgs e)
|
{
|
if( grdMain.Row >= grdMain.FixedRows && grdMain.Row < grdMain.Rows)
|
{
|
string sSQL;
|
oDetailDlg.sWLDM =DBUtility.ClsPub.isStrNull( grdMain.get_TextMatrix(grdMain.Row, HNumberCol));
|
oDetailDlg.LoadData();
|
oDetailDlg.ShowDialog();
|
}
|
}
|
}
|
}
|
