using System;
|
using System.Collections.Generic;
|
using System.ComponentModel;
|
using System.Data;
|
using System.Drawing;
|
using System.Text;
|
using System.Windows.Forms;
|
using BaseSet;
|
using System.Threading;
|
|
namespace APSM
|
{
|
public partial class Sc_ICMOAutoSortBill : Form
|
{
|
public Sc_ICMOAutoSortBill()
|
{
|
InitializeComponent();
|
}
|
//¶¨ÒåÁÐ
|
public const Int16 FixCols =16;
|
//
|
public const Int16 HSourceIDCol = 1;
|
public const Int16 HSourceNameCol = 2;
|
public const Int16 HGroupIDCol = 3;
|
public const Int16 HGroupNameCol = 4;
|
public const Int16 HSourceQtyCol = 5;
|
public const Int16 HICMOBillNoCol = 6;
|
public const Int16 HMaterIDCol = 7;
|
public const Int16 HMaterNumberCol = 8;
|
public const Int16 HMaterNameCol = 9;
|
public const Int16 HMaterModelCol = 10;
|
public const Int16 HUnitIDCol = 11;
|
public const Int16 HUnitNumberCol = 12;
|
public const Int16 HUnitNameCol =13;
|
public const Int16 HPlanQtyCol = 14;
|
public const Int16 HRelationQtyCol = 15; //ÒÑÍ깤ÊýÁ¿
|
public const Int16 HInStockQtyCol = 16; //Èë¿âµ¥Êý
|
public const Int16 HWorkQtyCol = 17; //²úÄÜ
|
public const Int16 HProdTimesCol = 18; //Éú²úÖÜÆÚ=¼Æ»®Êý/²úÄÜ £¨Ð¡Ê±£©
|
public const Int16 HWorkTimesCol = 19;
|
public const Int16 HYXCol = 20;
|
public const Int16 HKTQCol =21;
|
public const Int16 HReadyQtyCol = 22; //¿ª¹¤ÓàÁ¿
|
public const Int16 HPlanBeginDateCol = 23; //¼Æ»®¿ª¹¤
|
public const Int16 HPlanEndDateCol = 24; //¼Æ»®Í깤
|
public const Int16 HLastBeginDateCol = 25; //×î³Ù¿ª¹¤=×î³ÙÍ깤-Éú²úÖÜÆÚ£¨×î¶ÌÖÜÆÚ£©
|
public const Int16 HLastEndDateCol = 26; //×î³ÙÍ깤=¶©µ¥½»»õÆÚ-ÌáÇ°ÆÚ
|
public const Int16 HOrderNeedQtyCol = 27; //¶©µ¥ÐèÇóÊý
|
public const Int16 HCusNameCol = 28; // ¿Í»§
|
public const Int16 HSeOrderBillNoCol = 29; //¶©µ¥ºÅ
|
public const Int16 HIsOutSellCol = 30; //ÊÇ·ñÍâó
|
|
public const Int16 HOrderCommitDateCol = 31; //¶©µ¥½»»õÆÚ=ÓëÔ¤²âµ¥³åÏúµÄ¶©µ¥×îÔç½»»õÆÚ¡£
|
public const Int16 HRemarkCol = 32;
|
|
public const Int16 HSourceInterIDCol = 33;
|
public const Int16 HSourceEntryIDCol = 34;
|
public const Int16 HSourceBillTypeCol = 35;
|
public const Int16 HICMOInterIDCol = 36;
|
public const Int16 HSeOrderInterIDCol = 37;
|
public const Int16 HSeOrderEntryIDCol = 38;
|
public const Int16 HSourceBillNoCol = 39;
|
public const Int16 HLockedCol = 40;
|
public const Int16 HSourceNumberCol = 41;
|
//grd2
|
public const Int16 HSecSourceIDCol = 1;
|
public const Int16 HSecSourceNumberCol = 2;
|
public const Int16 HSecSourceNameCol = 3;
|
public const Int16 HSecGroupIDCol = 4;
|
public const Int16 HSecGroupNameCol = 5;
|
public const Int16 HSecICMOBillNoCol = 6;
|
public const Int16 HSecICMOInterIDCol = 7;
|
public const Int16 HSecMaterIDCol = 8;
|
public const Int16 HSecMaterNumberCol = 9;
|
public const Int16 HSecMaterNameCol = 10;
|
public const Int16 HSecMaterModelCol = 11;
|
public const Int16 HSecPlanEndDateCol = 12;
|
public const Int16 HSecYXCol = 13;
|
public const Int16 HSecPlanQtyCol = 14;
|
public const Int16 HSecLeftQtyCol = 15;
|
|
//
|
public string ModName = "3749";
|
public string ModCaption = "Éú²ú¼Æ»®×Ô¶¯ÅųÌ";
|
//
|
public DBUtility.ClsPub.Enum_BillStatus BillStatus;
|
public string sAllowCol;
|
//
|
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
DAL.ClsSc_WorkBillAutoSortBill oMain = new DAL.ClsSc_WorkBillAutoSortBill();
|
Sc_ICMOAutoSortBillDlg oDlg = new Sc_ICMOAutoSortBillDlg();
|
BLL.FrmMonthCalendar oSelectDate = new BLL.FrmMonthCalendar();
|
DAL.ClsSc_ICMOSortBill oMainPC = new DAL.ClsSc_ICMOSortBill();
|
//
|
bool bEdit = false;
|
|
//ÊÇ·ñÑ¡ÔñÁË µ¥Ôª¸ñ
|
private bool IsSelectCell(int iRow,int iCol)
|
{
|
return false;
|
//return BLL.Sc_ICMOAutoSortBillFun.IsSelectCell(grdSourceBill, iRow, iCol);
|
}
|
//ÁÐÊÇ·ñÔÊÐí±à¼
|
private bool IsAllowEdit(int iRow,int iCol)
|
{
|
return false;
|
//return BLL.Sc_ICMOAutoSortBillFun.IsAllowEdit(grdSourceBill,FixCols, iRow, iCol);
|
}
|
|
private void timer1_Tick(object sender, EventArgs e)
|
{
|
timer1.Enabled = false;
|
//³õʼ»¯
|
initGrid();
|
oDlg.ShowDialog();
|
if (oDlg.IsOk == 1)
|
{
|
Display();
|
}
|
}
|
//MouseDown
|
|
//³õʼ»¯Íø¸ñ
|
private void initGrid()
|
{
|
//
|
grdSourceBill.ColumnCount = 42; //×ÜÁÐÊý
|
DBUtility.Xt_BaseBillFun.initGridFst(grdSourceBill, this.Name);
|
grdSourceBill.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
|
grdSourceBill.RowCount = 0;
|
grdSourceBill.ClipboardCopyMode = DataGridViewClipboardCopyMode.EnableWithoutHeaderText;
|
//=
|
grdSourceBill.Columns[HCusNameCol].HeaderText = "¿Í»§";
|
grdSourceBill.Columns[HIsOutSellCol].HeaderText = "ÊÇ·ñÍâó";
|
grdSourceBill.Columns[HSeOrderBillNoCol].HeaderText = "ÏúÊÛ¶©µ¥";
|
grdSourceBill.Columns[HICMOBillNoCol].HeaderText = "Éú²úÈÎÎñµ¥";
|
grdSourceBill.Columns[HMaterNumberCol].HeaderText = "ÎïÁÏ´úÂë";
|
grdSourceBill.Columns[HMaterNameCol].HeaderText = "ÎïÁÏÃû³Æ";
|
grdSourceBill.Columns[HMaterModelCol].HeaderText = "¹æ¸ñÐͺÅ";
|
grdSourceBill.Columns[HUnitNameCol].HeaderText = "µ¥Î»Ãû³Æ";
|
grdSourceBill.Columns[HPlanBeginDateCol].HeaderText = "¼Æ»®¿ª¹¤";
|
grdSourceBill.Columns[HPlanEndDateCol].HeaderText = "¼Æ»®Í깤";
|
grdSourceBill.Columns[HLastBeginDateCol].HeaderText = "×î³Ù¿ª¹¤";
|
grdSourceBill.Columns[HLastEndDateCol].HeaderText = "×î³ÙÍ깤";
|
grdSourceBill.Columns[HPlanQtyCol].HeaderText = "ÈÎÎñÊý";
|
grdSourceBill.Columns[HProdTimesCol].HeaderText = "Éú²úÖÜÆÚ";
|
grdSourceBill.Columns[HRelationQtyCol].HeaderText = "Í깤Êý";
|
grdSourceBill.Columns[HReadyQtyCol].HeaderText = "¿ª¹¤ÓàÁ¿";
|
grdSourceBill.Columns[HWorkQtyCol].HeaderText = "²úÄÜ";
|
grdSourceBill.Columns[HWorkTimesCol].HeaderText = "±ê×¼¹¤Ê±";
|
grdSourceBill.Columns[HSourceNameCol].HeaderText = "Éú²ú×ÊÔ´";
|
grdSourceBill.Columns[HSourceNumberCol].HeaderText = "×ÊÔ´´úÂë";
|
grdSourceBill.Columns[HGroupNameCol].HeaderText = "Éú²ú°à×é";
|
grdSourceBill.Columns[HSourceQtyCol].HeaderText = "×ÊÔ´Êý";
|
grdSourceBill.Columns[HInStockQtyCol].HeaderText = "ÒÑÈë¿âÊýÁ¿";
|
grdSourceBill.Columns[HYXCol].HeaderText = "ÓÅÏȼ¶";
|
grdSourceBill.Columns[HRemarkCol].HeaderText = "¶©µ¥±¸×¢";
|
grdSourceBill.Columns[HOrderNeedQtyCol].HeaderText = "¶©µ¥ÊýÁ¿";
|
grdSourceBill.Columns[HOrderCommitDateCol].HeaderText = "¶©µ¥½»»õÆÚ";
|
grdSourceBill.Columns[HSourceBillNoCol].HeaderText = "Ô´µ¥ºÅ";
|
grdSourceBill.Columns[HSourceBillTypeCol].HeaderText = "Ô´µ¥ÀàÐÍ";
|
grdSourceBill.Columns[HLockedCol].HeaderText = "Ëø¶¨±ê¼Ç";
|
////Òþ²ØÁÐ
|
grdSourceBill.Columns[0].Visible = false;
|
grdSourceBill.Columns[HMaterIDCol].Visible = false;
|
grdSourceBill.Columns[HUnitIDCol].Visible = false;
|
grdSourceBill.Columns[HKTQCol].Visible = false;
|
grdSourceBill.Columns[HICMOInterIDCol].Visible = false;
|
grdSourceBill.Columns[HSourceIDCol].Visible = false;
|
grdSourceBill.Columns[HGroupIDCol].Visible = false;
|
grdSourceBill.Columns[HUnitNumberCol].Visible = false;
|
grdSourceBill.Columns[HSourceInterIDCol].Visible = false;
|
grdSourceBill.Columns[HSourceEntryIDCol].Visible = false;
|
grdSourceBill.Columns[HSeOrderEntryIDCol].Visible = false;
|
grdSourceBill.Columns[HSeOrderInterIDCol].Visible = false;
|
////
|
//grdSourceBill.ReadOnly = true;
|
|
//ÉèÖÿɱà¼ÁÐ
|
sAllowCol = HGroupNameCol.ToString() +
|
"," + HSourceNameCol.ToString() +
|
"," + HSourceQtyCol.ToString() +
|
"," + HYXCol.ToString() +
|
"," + HWorkQtyCol.ToString();
|
|
/////grd2
|
grdMain.ColumnCount = FixCols;
|
DBUtility.Xt_BaseBillFun.initGridFst(grdMain, this.Name);
|
grdMain.BackgroundColor = Color.Lavender; //Íø¸ñ±³¾°É«
|
grdMain.ColumnHeadersDefaultCellStyle.BackColor = Color.Beige;
|
grdMain.ClipboardCopyMode = DataGridViewClipboardCopyMode.EnableWithoutHeaderText;
|
grdMain.ReadOnly = false;
|
grdMain.RowCount = 0;
|
grdMain.Columns[HSecICMOBillNoCol].HeaderText = "ÈÎÎñµ¥ºÅ";
|
grdMain.Columns[HSecLeftQtyCol].HeaderText = "´ýÉú²ú¼Æ»®Êý";
|
grdMain.Columns[HSecMaterNameCol].HeaderText = "ÎïÁÏÃû³Æ";
|
grdMain.Columns[HSecMaterNumberCol].HeaderText = "ÎïÁÏ´úÂë";
|
grdMain.Columns[HSecPlanQtyCol].HeaderText = "ÈÎÎñÊý";
|
grdMain.Columns[HSecSourceNameCol].HeaderText = "Éú²ú×ÊÔ´";
|
grdMain.Columns[HSecSourceNumberCol].HeaderText = "×ÊÔ´´úÂë";
|
grdMain.Columns[HSecGroupNameCol].HeaderText = "Éú²ú°à×é";
|
grdMain.Columns[HSecPlanEndDateCol].HeaderText = "¼Æ»®Í깤";
|
//grdMain.Columns[HSecICMOInterIDCol].HeaderText = "¼Æ»®Í깤";
|
grdMain.Columns[HSecYXCol].HeaderText = "ÓÅÏÈ";
|
//
|
grdMain.Columns[0].Visible = false;
|
grdMain.Columns[HSecICMOInterIDCol].Visible = false;
|
grdMain.Columns[HSecSourceIDCol].Visible = false;
|
grdMain.Columns[HSecGroupIDCol].Visible = false;
|
grdMain.Columns[HSecMaterIDCol].Visible = false;
|
//grdMain.ReadOnly = true;
|
for (int i = 0; i < grdMain.ColumnCount; i++)
|
{
|
grdMain.Columns[i].SortMode = DataGridViewColumnSortMode.Automatic; //ÁÐ ÅÅÐòģʽ
|
|
}
|
//
|
//
|
DBUtility.ClsPub.GetGridView(grdSource, this.Name + "grdSource", DBUtility.ClsPub.AppPath);
|
DBUtility.ClsPub.GetGridView(grdICMO, this.Name + "grdICMO", DBUtility.ClsPub.AppPath);
|
DBUtility.ClsPub.GetGridView(grdProcFlow, this.Name + "grdProcFlow", DBUtility.ClsPub.AppPath);
|
DBUtility.ClsPub.GetGridView(grdSourceBill, this.Name + "grdSourceBill", DBUtility.ClsPub.AppPath);
|
DBUtility.ClsPub.GetGridView(grdMain, this.Name + "grdMain", DBUtility.ClsPub.AppPath);
|
LoadDateCol(30);
|
grdMain.ColumnHeadersDefaultCellStyle.WrapMode = DataGridViewTriState.True;//±êÌâÐÐ×Ô¶¯»»ÐÐ
|
}
|
|
|
//¼ÓÔØ µ±ÔÂÈÕÆÚ
|
private void LoadDateCol(int iDates)
|
{
|
Sc_ICMOSortBillFun.LoadDateCol(grdMain, FixCols, iDates);
|
}
|
|
//ÏÔʾ¼ÓÔØ ÒÑÅų̼Ǽ
|
private void Display()
|
{
|
DAL.ClsGy_Source_View oSource = new DAL.ClsGy_Source_View();
|
DAL.ClsGy_Department_View oDept = new DAL.ClsGy_Department_View();
|
DAL.ClsGy_Material_View oMater = new DAL.ClsGy_Material_View();
|
DAL.ClsGy_Unit_View oUnit = new DAL.ClsGy_Unit_View();
|
DAL.ClsGy_Employee_View oEmp = new DAL.ClsGy_Employee_View();
|
DAL.ClsIF_Group_View oGroup = new DAL.ClsIF_Group_View();
|
|
int c = 0;
|
int i = 0;
|
//½«¹ýÂË¿òµÄ²¿Ãź͹¤ÐòдÈë½çÃ棬ÈôûÓв¿ÃÅÔò Ìø³ö¹ý³Ì
|
this.txtHDeptID.Tag = oDlg.txtHBDeptID.Tag;
|
this.txtHDeptID.Text = oDlg.txtHBDeptID.Text;
|
this.lblHDeptID.Text = oDlg.txtHBDeptID.Text;
|
//this.txtHProcID.Tag = oDlg.txtHBProcID.Tag;
|
//this.txtHProcID.Text = oDlg.txtHBProcID.Text;
|
//this.lblHProcID.Text = oDlg.txtHBProcID.Text;
|
if (DBUtility.ClsPub.isLong(txtHDeptID.Tag) == 0)
|
{
|
return;
|
}
|
//µÃµ½µ±Ç°HRelationInterID
|
oMain.HRelationInterID = oMain.GetRelationInterIDByDeptUser(DBUtility.ClsPub.isLong(txtHDeptID.Tag));
|
//¸ù¾Ý²¿Ãŵõ½Ä¬ÈÏ×ÊÔ´
|
if (oSource.GetInfoByDept(DBUtility.ClsPub.isLong(txtHDeptID.Tag)))
|
{
|
//HSourceID_MR = oSource.omodel.HItemID;
|
//HSourceNumber_MR = oSource.omodel.HNumber;
|
//HSourceName_MR = oSource.omodel.HName;
|
}
|
//return;
|
//
|
if (oMain.ShowBill(oMain.HRelationInterID, ref DBUtility.ClsPub.sExeReturnInfo) == false)
|
{
|
//MessageBox.Show(DBUtility.ClsPub.sExeReturnInfo, "Ìáʾ");
|
return;
|
}
|
//Çå¿Õ
|
//¼ÓÔØ Ö÷±í£¬ÈÎÎñµ¥ÐÅÏ¢
|
foreach (Model.ClsSc_WorkBillAutoSortBillMain oModel in oMain.MainColl)
|
{
|
if (i >= grdSourceBill.Rows.Count)
|
{
|
grdSourceBill.RowCount = grdSourceBill.Rows.Count + 1;
|
}
|
grdSourceBill.Rows[i].Cells[HSourceIDCol].Value = oModel.HSourceID.ToString();
|
if (oSource.GetInfoByID(oModel.HSourceID))
|
{
|
grdSourceBill.Rows[i].Cells[HSourceNameCol].Value = oSource.omodel.HName;
|
}
|
//
|
grdSourceBill.Rows[i].Cells[HGroupIDCol].Value = oModel.HGroupID.ToString();
|
if (oGroup.GetInfoByID(oModel.HGroupID))
|
{
|
grdSourceBill.Rows[i].Cells[HGroupNameCol].Value = oGroup.omodel.HName;
|
}
|
//
|
grdSourceBill.Rows[i].Cells[HSourceQtyCol].Value = oModel.HSourceQty.ToString();
|
grdSourceBill.Rows[i].Cells[HSeOrderBillNoCol].Value = oModel.HSeOrderBillNo;
|
grdSourceBill.Rows[i].Cells[HSeOrderInterIDCol].Value = oModel.HSeOrderInterID.ToString();
|
grdSourceBill.Rows[i].Cells[HSeOrderEntryIDCol].Value = oModel.HSeOrderEntryID.ToString();
|
//¸ù¾ÝÏúÊÛ¶©µ¥ID »ñÈ¡ÊÇ·ñÊÇ Íâ󶩵¥
|
grdSourceBill.Rows[i].Cells[HIsOutSellCol].Value = "";
|
//
|
grdSourceBill.Rows[i].Cells[HICMOInterIDCol].Value = oModel.HICMOInterID.ToString();
|
grdSourceBill.Rows[i].Cells[HSourceBillTypeCol].Value = oModel.HSourceBillType;
|
grdSourceBill.Rows[i].Cells[HSourceInterIDCol].Value = oModel.HSourceInterID.ToString();
|
grdSourceBill.Rows[i].Cells[HSourceEntryIDCol].Value = oModel.HSourceEntryID.ToString();
|
grdSourceBill.Rows[i].Cells[HCusNameCol].Value = "";
|
grdSourceBill.Rows[i].Cells[HICMOBillNoCol].Value = oModel.HICMOBillNo;
|
//grdMain.Rows[i].Cells[HRemarkCol].ToolTipText
|
grdSourceBill.Rows[i].Cells[HMaterIDCol].Value = oModel.HMaterID.ToString();
|
if (oMater.GetInfoByID(oModel.HMaterID))
|
{
|
grdSourceBill.Rows[i].Cells[HMaterNumberCol].Value = oMater.omodel.HNumber;
|
grdSourceBill.Rows[i].Cells[HMaterNameCol].Value = oMater.omodel.HName;
|
grdSourceBill.Rows[i].Cells[HMaterModelCol].Value = oMater.omodel.HModel;
|
}
|
grdSourceBill.Rows[i].Cells[HUnitIDCol].Value = oModel.HUnitID.ToString();
|
if (oUnit.GetInfoByID(oModel.HUnitID))
|
{
|
grdSourceBill.Rows[i].Cells[HUnitNumberCol].Value = oUnit.omodel.HNumber;
|
grdSourceBill.Rows[i].Cells[HUnitNameCol].Value = oUnit.omodel.HName;
|
}
|
grdSourceBill.Rows[i].Cells[HPlanBeginDateCol].Value = oModel.HPlanBeginDate.ToShortDateString();
|
grdSourceBill.Rows[i].Cells[HPlanEndDateCol].Value = oModel.HPlanEndDate.ToShortDateString();
|
grdSourceBill.Rows[i].Cells[HPlanQtyCol].Value = oModel.HPlanQty.ToString();
|
//µÃµ½ÀÛ¼Æ »ã±¨ÊýÁ¿ ºÍ²ð·Ö»ã±¨ÊýÁ¿
|
SetSourceWorkQty(i);//»ñÈ¡²úÄÜ
|
SetSourceRelationQty(i);//»ñÈ¡ Í깤ÊýÁ¿ £¨»ã±¨»òÕßÈë¿â£©
|
//
|
grdSourceBill.Rows[i].Cells[HWorkQtyCol].Value = oModel.HWorkQty.ToString();
|
grdSourceBill.Rows[i].Cells[HYXCol].Value = oModel.HYX.ToString();
|
grdSourceBill.Rows[i].Cells[HKTQCol].Value = DBUtility.ClsPub.BoolToString(oModel.HKTQ);
|
grdSourceBill.Rows[i].Cells[HReadyQtyCol].Value = oModel.HReadyTimes.ToString();
|
grdSourceBill.Rows[i].Cells[HRemarkCol].Value = oModel.HRemark;
|
grdSourceBill.Rows[i].Cells[HLockedCol].Value = oModel.HLocked;
|
//¼ÓÔØ×Ó±í ÈÕÆÚÐÅÏ¢(Ö»¼ÓÔØ Ëø¶¨µÄÊý¾Ý)
|
if (oModel.HLocked)
|
{
|
if (i >= grdMain.Rows.Count)
|
{
|
grdMain.RowCount = grdMain.Rows.Count + 1;
|
}
|
c = grdMain.RowCount - 1;
|
//ÉèÖÃ×Ó±íÐÅÏ¢
|
|
//ÉèÖÃÈռƻ®ÊýÁ¿
|
Sc_ICMOSortBillFun.SetSubGrid(grdMain, oMain, ref c, ref i, FixCols);
|
}
|
i++;
|
//
|
}
|
//»ñµÃÒÑÈë¿âÊýÁ¿
|
GetInStockQtyByICMOInterID();
|
//»Ïß
|
GraphLine();
|
//½»»õÆÚ¹ýÆÚ ±äÉ«
|
AddColor();
|
//µÃµ½×îÐÂÅųÌ
|
GetPcTime();
|
//»Ö¸´Ë¢ÐÂ
|
//
|
}
|
//AfterEdit
|
|
//¼ì²é²ð·ÖÊýÁ¿µÄºÏÀíÐÔ
|
private bool CheckJHS(int iRow)
|
{
|
return true;
|
//return BLL.Sc_ICMOAutoSortBillFun.CheckJHS(grdSourceBill, HICMoBillNoCol, HSplitPlanQtyCol, HPlanQtyCol, iRow);
|
}
|
|
|
//ÅųÌÇ°¼ì²é
|
private bool CheckSetupData()
|
{
|
if (grdSourceBill.RowCount == 0)
|
{
|
MessageBox.Show("ûÓÐÈκε¥¾Ý£¬²»ÔÊÐíÅų̣¡");
|
return false;
|
}
|
//if (!BLL.Sc_ICMOAutoSortBillFun.IsSelectZY(grdSourceBill, HSourceIDCol))
|
//{
|
// MessageBox.Show("ûÓÐÑ¡Ôñ×ÊÔ´£¬²»ÔÊÐíÅų̣¡");
|
// return false;
|
//}
|
return true;
|
}
|
|
//½»»õÆÚ ³¬ÆÚʱ ±äÉ«
|
private void AddColor()
|
{
|
//BLL.Sc_ICMOAutoSortBillFun.AddColor(grdSourceBill, HPlanEndDateCol, FixCols);
|
}
|
//±£´æ
|
private void SaveBill()
|
{
|
bool bResult;
|
List<ClsGridValues> oClsGridValues = new List<ClsGridValues>();
|
oClsGridValues.Clear();
|
lblCaption.Focus();
|
//
|
if (!AllowSave())
|
{
|
return;
|
}
|
//ȨÏÞÅжÏ
|
//ɾ³ýÈ«²¿Î´Ëø¶¨µÄ±¾²¿Ãŵ¥¾Ý£¬»òÕß×÷·Ï
|
Sub_DeleteBillUnLock();
|
//µÃµ½Ò»¸öÄÚÂë
|
Int64 HRelationInterID = DBUtility.ClsPub.CreateBillID(ModName, ref DBUtility.ClsPub.sExeReturnInfo);
|
//
|
DateTime MainDate = DBUtility.ClsPub.isDate(DBUtility.ClsPub.GetServerDate(0));
|
//Ñ»·
|
for (int i = 0; i < grdSource.Rows.Count; i++)
|
{
|
oMain.MainColl = new List<Model.ClsSc_WorkBillAutoSortBillMain>();
|
//дÈëÀà
|
Model.ClsSc_WorkBillAutoSortBillMain oModel = new Model.ClsSc_WorkBillAutoSortBillMain();
|
oMain.DetailColl = new List<Model.ClsSc_WorkBillAutoSortBillSub>();
|
//
|
oModel.HInterID = DBUtility.ClsPub.CreateBillID(ModName, ref DBUtility.ClsPub.sExeReturnInfo);
|
oModel.HBillNo = "";
|
oModel.HYear = 2012;
|
oModel.HPeriod = 1;
|
oModel.HDate = MainDate;
|
oModel.HDeptID = DBUtility.ClsPub.isLong(txtHDeptID.Tag);
|
oModel.HMaterID = DBUtility.ClsPub.isLong(grdSourceBill.Rows[i].Cells[HMaterIDCol].Value);
|
oModel.HSourceID = DBUtility.ClsPub.isLong(grdSourceBill.Rows[i].Cells[HSourceIDCol].Value);
|
oModel.HGroupID = DBUtility.ClsPub.isLong(grdSourceBill.Rows[i].Cells[HGroupIDCol].Value);
|
oModel.HUnitID = DBUtility.ClsPub.isLong(grdSourceBill.Rows[i].Cells[HUnitIDCol].Value);
|
oModel.HYX = DBUtility.ClsPub.isStrNull(grdSourceBill.Rows[i].Cells[HYXCol].Value);
|
oModel.HSourceQty = DBUtility.ClsPub.isDoule(grdSourceBill.Rows[i].Cells[HSourceQtyCol].Value);
|
|
oModel.HPlanBeginDate = DBUtility.ClsPub.isDate(grdSourceBill.Rows[i].Cells[HPlanBeginDateCol].Value);
|
oModel.HPlanEndDate = DBUtility.ClsPub.isDate(grdSourceBill.Rows[i].Cells[HPlanEndDateCol].Value);
|
oModel.HLastBeginDate = DBUtility.ClsPub.isDate(grdSourceBill.Rows[i].Cells[HLastBeginDateCol].Value);
|
oModel.HLastEndDate = DBUtility.ClsPub.isDate(grdSourceBill.Rows[i].Cells[HLastEndDateCol].Value);
|
oModel.HPlanQty = DBUtility.ClsPub.isDoule(grdSourceBill.Rows[i].Cells[HPlanQtyCol].Value);
|
oModel.HRelationQty = DBUtility.ClsPub.isDoule(grdSourceBill.Rows[i].Cells[HRelationQtyCol].Value);
|
|
oModel.HKTQ = DBUtility.ClsPub.isBool(grdSourceBill.Rows[i].Cells[HKTQCol].Value);
|
oModel.HWorkQty = DBUtility.ClsPub.isDoule(grdSourceBill.Rows[i].Cells[HWorkQtyCol].Value);
|
oModel.HReadyTimes = DBUtility.ClsPub.isDoule(grdSourceBill.Rows[i].Cells[HReadyQtyCol].Value);
|
oModel.HRemark = DBUtility.ClsPub.isStrNull(grdSourceBill.Rows[i].Cells[HRemarkCol].Value);
|
oModel.HMaker = DBUtility.ClsPub.CurUserName.ToString();
|
oModel.HMakeDate = MainDate.ToShortDateString();
|
oModel.HSourceInterID = DBUtility.ClsPub.isLong(grdSourceBill.Rows[i].Cells[HSourceInterIDCol].Value);
|
oModel.HSourceEntryID = DBUtility.ClsPub.isLong(grdSourceBill.Rows[i].Cells[HSourceEntryIDCol].Value);
|
oModel.HSourceBillNo = DBUtility.ClsPub.isStrNull(grdSourceBill.Rows[i].Cells[HSourceBillNoCol].Value);
|
oModel.HSourceBillType = DBUtility.ClsPub.isStrNull(grdSourceBill.Rows[i].Cells[HSourceBillTypeCol].Value);
|
oModel.HICMOInterID = DBUtility.ClsPub.isLong(grdSourceBill.Rows[i].Cells[HICMOInterIDCol].Value);
|
oModel.HICMOBillNo = DBUtility.ClsPub.isStrNull(grdSourceBill.Rows[i].Cells[HICMOBillNoCol].Value);
|
oModel.HSeOrderBillNo = DBUtility.ClsPub.isStrNull(grdSourceBill.Rows[i].Cells[HSeOrderBillNoCol].Value);
|
oModel.HSeOrderInterID = DBUtility.ClsPub.isLong(grdSourceBill.Rows[i].Cells[HSeOrderInterIDCol].Value);
|
oModel.HSeOrderEntryID = DBUtility.ClsPub.isLong(grdSourceBill.Rows[i].Cells[HSeOrderEntryIDCol].Value);
|
oModel.HOrderCommitDate = DBUtility.ClsPub.isDate(grdSourceBill.Rows[i].Cells[HOrderCommitDateCol].Value);
|
//
|
oMain.MainColl.Add(oModel);
|
//
|
Sc_ICMOSortBillFun.SaveGridSub(grdMain, grdMain, FixCols, oMain, MainDate, oModel.HWorkQty, ref i, oClsGridValues);
|
//±£´æÍê±Ïºó´¦Àí
|
bResult = oMain.AddBill(DBUtility.ClsPub.isLong(txtHDeptID.Tag), HRelationInterID, ref DBUtility.ClsPub.sExeReturnInfo);
|
//Ìáʾ
|
if (bResult == true)
|
{
|
//MessageBox.Show("µ¥¾Ý´æÅÌÍê±Ï!", "Ìáʾ");
|
}
|
else
|
{
|
MessageBox.Show("±£´æʧ°Ü!ÔÒò:" + DBUtility.ClsPub.sExeReturnInfo, "Ìáʾ");
|
}
|
}
|
////µÃµ½×îÐÂÅųÌ
|
GetPcTime();
|
}
|
|
//±£´æµ¥ÐÐ
|
private void SaveSingeBill(int iRow, int iRowSub, Int64 HRelationInterID, List<ClsGridValues> oClsGridVaules)
|
{
|
bool bResult;
|
lblCaption.Focus();
|
//
|
if (!AllowSave())
|
{
|
return;
|
}
|
//
|
//ȨÏÞÅжÏ
|
oMain.MainColl = new List<Model.ClsSc_WorkBillAutoSortBillMain>();
|
DateTime MainDate = DBUtility.ClsPub.isDate(DBUtility.ClsPub.GetServerDate(0));
|
//дÈëÀà
|
Model.ClsSc_WorkBillAutoSortBillMain oModel = new Model.ClsSc_WorkBillAutoSortBillMain();
|
oMain.DetailColl = new List<Model.ClsSc_WorkBillAutoSortBillSub>();
|
//
|
//
|
oModel.HInterID = DBUtility.ClsPub.CreateBillID(ModName, ref DBUtility.ClsPub.sExeReturnInfo);
|
oModel.HBillNo = "";
|
oModel.HYear = 2012;
|
oModel.HPeriod = 1;
|
oModel.HDate = MainDate;
|
oModel.HDeptID = DBUtility.ClsPub.isLong(txtHDeptID.Tag);
|
oModel.HMaterID = DBUtility.ClsPub.isLong(grdSourceBill.Rows[iRow].Cells[HMaterIDCol].Value);
|
oModel.HSourceID = DBUtility.ClsPub.isLong(grdSourceBill.Rows[iRow].Cells[HSourceIDCol].Value);
|
oModel.HGroupID = DBUtility.ClsPub.isLong(grdSourceBill.Rows[iRow].Cells[HGroupIDCol].Value);
|
oModel.HUnitID = DBUtility.ClsPub.isLong(grdSourceBill.Rows[iRow].Cells[HUnitIDCol].Value);
|
oModel.HYX = DBUtility.ClsPub.isStrNull(grdSourceBill.Rows[iRow].Cells[HYXCol].Value);
|
oModel.HSourceQty = DBUtility.ClsPub.isDoule(grdSourceBill.Rows[iRow].Cells[HSourceQtyCol].Value);
|
|
oModel.HPlanBeginDate = DBUtility.ClsPub.isDate(grdSourceBill.Rows[iRow].Cells[HPlanBeginDateCol].Value);
|
oModel.HPlanEndDate = DBUtility.ClsPub.isDate(grdSourceBill.Rows[iRow].Cells[HPlanEndDateCol].Value);
|
oModel.HLastBeginDate = DBUtility.ClsPub.isDate(grdSourceBill.Rows[iRow].Cells[HLastBeginDateCol].Value);
|
oModel.HLastEndDate = DBUtility.ClsPub.isDate(grdSourceBill.Rows[iRow].Cells[HLastEndDateCol].Value);
|
oModel.HPlanQty = DBUtility.ClsPub.isDoule(grdSourceBill.Rows[iRow].Cells[HPlanQtyCol].Value);
|
oModel.HRelationQty = DBUtility.ClsPub.isDoule(grdSourceBill.Rows[iRow].Cells[HRelationQtyCol].Value);
|
|
oModel.HKTQ = DBUtility.ClsPub.isBool(grdSourceBill.Rows[iRow].Cells[HKTQCol].Value);
|
oModel.HWorkQty = DBUtility.ClsPub.isDoule(grdSourceBill.Rows[iRow].Cells[HWorkQtyCol].Value);
|
oModel.HReadyTimes = DBUtility.ClsPub.isDoule(grdSourceBill.Rows[iRow].Cells[HReadyQtyCol].Value);
|
oModel.HRemark = DBUtility.ClsPub.isStrNull(grdSourceBill.Rows[iRow].Cells[HRemarkCol].Value);
|
oModel.HMaker = DBUtility.ClsPub.CurUserName.ToString();
|
oModel.HMakeDate = MainDate.ToShortDateString();
|
oModel.HSourceInterID = DBUtility.ClsPub.isLong(grdSourceBill.Rows[iRow].Cells[HSourceInterIDCol].Value);
|
oModel.HSourceEntryID = DBUtility.ClsPub.isLong(grdSourceBill.Rows[iRow].Cells[HSourceEntryIDCol].Value);
|
oModel.HSourceBillNo = DBUtility.ClsPub.isStrNull(grdSourceBill.Rows[iRow].Cells[HSourceBillNoCol].Value);
|
oModel.HSourceBillType = DBUtility.ClsPub.isStrNull(grdSourceBill.Rows[iRow].Cells[HSourceBillTypeCol].Value);
|
oModel.HICMOInterID = DBUtility.ClsPub.isLong(grdSourceBill.Rows[iRow].Cells[HICMOInterIDCol].Value);
|
oModel.HICMOBillNo = DBUtility.ClsPub.isStrNull(grdSourceBill.Rows[iRow].Cells[HICMOBillNoCol].Value);
|
oModel.HSeOrderBillNo = DBUtility.ClsPub.isStrNull(grdSourceBill.Rows[iRow].Cells[HSeOrderBillNoCol].Value);
|
oModel.HSeOrderInterID = DBUtility.ClsPub.isLong(grdSourceBill.Rows[iRow].Cells[HSeOrderInterIDCol].Value);
|
oModel.HSeOrderEntryID = DBUtility.ClsPub.isLong(grdSourceBill.Rows[iRow].Cells[HSeOrderEntryIDCol].Value);
|
oModel.HOrderCommitDate = DBUtility.ClsPub.isDate(grdSourceBill.Rows[iRow].Cells[HOrderCommitDateCol].Value);
|
//
|
oMain.MainColl.Add(oModel);
|
//
|
Sc_ICMOSortBillFun.SaveGridSub(grdMain,grdMain, FixCols, oMain, MainDate, oModel.HWorkQty, ref iRowSub,oClsGridVaules);
|
|
//±£´æÍê±Ïºó´¦Àí
|
bResult = oMain.AddBill(DBUtility.ClsPub.isLong(txtHDeptID.Tag), HRelationInterID, ref DBUtility.ClsPub.sExeReturnInfo);
|
|
//Ìáʾ
|
if (bResult == true)
|
{
|
//MessageBox.Show("µ¥¾Ý´æÅÌÍê±Ï!", "Ìáʾ");
|
}
|
else
|
{
|
MessageBox.Show("±£´æʧ°Ü!ÔÒò:" + DBUtility.ClsPub.sExeReturnInfo, "Ìáʾ");
|
}
|
}
|
|
//±£´æÇ° ¼ì²é
|
private bool AllowSave()
|
{
|
//for (int i = grdSourceBill.FixedRows; i < grdSourceBill.Rows; i++)
|
//{
|
// if (DBUtility.ClsPub.isStrNull(grdSourceBill.get_TextMatrix(i, HSourceIDCol)) == "")
|
// {
|
// MessageBox.Show("ÇëÏÈÑ¡ÔñºÃ×ÊÔ´£¬ÔÙ½øÐб£´æ£¡");
|
// return false;
|
// }
|
//}
|
if (DBUtility.ClsPub.isLong(txtHDeptID.Tag) == 0)
|
{
|
MessageBox.Show("ÇëÏÈÑ¡ÔñºÃ²¿ÃÅ£¬ÔÙ½øÐб£´æ£¡");
|
return false;
|
}
|
return true;
|
}
|
|
|
//ÊÇ·ñÊǺÏÀíÐÐ
|
private bool AllowRow()
|
{
|
if (grdSourceBill.CurrentRow == null)
|
{
|
return false;
|
}
|
else
|
{
|
return true;
|
}
|
}
|
|
|
//ÅųÌ
|
private bool DateSetup(bool bAuto)
|
{
|
Int64 lHGroupID = 0;
|
string sGroupName = "";
|
Single sLeftProdTimes=0;
|
string sSourceName = "";
|
string sSourceNumber = "";
|
string sICMOBillNo = "";
|
Int64 lMainID = 0;
|
Int64 lSourceID = 0;
|
Int64 lMaterID = 0;
|
string sMaterNumber = "";
|
string sMaterName = "";
|
string sMaterModel = "";
|
DateTime dEndDate = DateTime.Today;
|
Single sProdTimes = 0;
|
Single sPlanQty = 0;
|
Single iLeftQty = 0;
|
DataSet dsSub;
|
Single sWorkQty;
|
Int64 sYX;
|
Int64 HRelationInterID;
|
bool bFind = false;
|
DataSet ds;
|
List<ClsGridValues> oClsGridValues = new List<ClsGridValues>();
|
oClsGridValues.Clear();
|
//µÃµ½Ò»¸öÄÚÂë
|
HRelationInterID = DBUtility.ClsPub.CreateBillID(ModName, ref DBUtility.ClsPub.sExeReturnInfo);
|
//µ¯³öÇ°Ö÷Çģʽ´°Ì壬ÏÔʾ½ø¶È
|
DBUtility.Xt_ProcessWait oWait = new DBUtility.Xt_ProcessWait();
|
oWait.lblCaption.Text = "ÕýÔÚÅųÌÇëÉÔºò...";
|
oWait.lblHCount.Text = "";
|
oWait.lblHMaterName.Text = "";
|
oWait.pb1.Maximum = grdSourceBill.RowCount;
|
oWait.pb1.Value = 0;
|
oWait.Show();
|
grdMain.RowCount = 0;
|
//Çå¿ÕδËø¶¨ Åų̼Ǽ
|
Sub_DeleteBillUnLock();
|
//°´ÈÎÎñµ¥ÓÅÏȼ¶ Ñ»·
|
for (int i = 0; i < grdSourceBill.RowCount; i++)
|
{
|
//Èç¹ûËø¶¨¼Æ»®£¬Ôò²»ÐèÒªÔÙÅųÌ
|
if(DBUtility.ClsPub.isBool(grdSourceBill.Rows[i].Cells[HLockedCol].Value) ==true )
|
{
|
continue;
|
}
|
//ÕÒµ½±¾ÈÎÎñµ¥ ¿ÉÓÃÉú²ú×ÊÔ´
|
lMainID = DBUtility.ClsPub.isLong(grdSourceBill.Rows[i].Cells[HICMOInterIDCol].Value);
|
sICMOBillNo = DBUtility.ClsPub.isStrNull(grdSourceBill.Rows[i].Cells[HICMOBillNoCol].Value);
|
dEndDate = DBUtility.ClsPub.isDate(grdSourceBill.Rows[i].Cells[HLastEndDateCol].Value);
|
sProdTimes = DBUtility.ClsPub.isSingle(grdSourceBill.Rows[i].Cells[HProdTimesCol].Value);
|
sPlanQty = DBUtility.ClsPub.isSingle(grdSourceBill.Rows[i].Cells[HPlanQtyCol].Value);
|
lHGroupID = DBUtility.ClsPub.isLong(grdSourceBill.Rows[i].Cells[HGroupIDCol].Value);
|
sGroupName = DBUtility.ClsPub.isStrNull(grdSourceBill.Rows[i].Cells[HGroupNameCol].Value);
|
lMaterID = DBUtility.ClsPub.isLong(grdSourceBill.Rows[i].Cells[HMaterIDCol].Value);
|
sMaterNumber = DBUtility.ClsPub.isStrNull(grdSourceBill.Rows[i].Cells[HMaterNumberCol].Value);
|
sMaterName = DBUtility.ClsPub.isStrNull(grdSourceBill.Rows[i].Cells[HMaterNameCol].Value);
|
sMaterModel = DBUtility.ClsPub.isStrNull(grdSourceBill.Rows[i].Cells[HMaterModelCol].Value);
|
sWorkQty = DBUtility.ClsPub.isSingle(grdSourceBill.Rows[i].Cells[HWorkQtyCol].Value);
|
sYX = DBUtility.ClsPub.isLong(grdSourceBill.Rows[i].Cells[HYXCol].Value);
|
//
|
if (sICMOBillNo == "WORK155356")
|
{
|
sICMOBillNo = sICMOBillNo;
|
}
|
//Ê£ÓàÐèÇó¹¤Ê±
|
iLeftQty = sPlanQty ;
|
if (sWorkQty <= 0)
|
{
|
sLeftProdTimes = 0;
|
}
|
else
|
{
|
sLeftProdTimes = iLeftQty / sWorkQty;
|
}
|
//Èô±¾ÈÎÎñµ¥ÒÑÓа²ÅÅ×ÊÔ´£¨ÉÏ´ÎÅų̻òÕßÊÖ¹¤Åų̣© Ôò²»ÔÙÑ°ÕÒ×ÊÔ´£¬Ö±½ÓÅųÌ
|
if (DBUtility.ClsPub.isLong(grdSourceBill.Rows[i].Cells[HSourceIDCol].Value) != 0 &&
|
DBUtility.ClsPub.isStrNull(grdSourceBill.Rows[i].Cells[HSourceNameCol].Value) != ""
|
)
|
{
|
//»ñÈ¡¸ÃÉú²ú×ÊÔ´µÄÊ£Ó๤ʱ½øÐÐÅų̡£
|
lSourceID = DBUtility.ClsPub.isLong(grdSourceBill.Rows[i].Cells[HSourceIDCol].Value);
|
sSourceName = DBUtility.ClsPub.isStrNull(grdSourceBill.Rows[i].Cells[HSourceNameCol].Value);
|
sSourceNumber = DBUtility.ClsPub.isStrNull(grdSourceBill.Rows[i].Cells[HSourceNumberCol].Value);
|
//
|
ds = Sc_ICMOSortBillFun.GetWorkSourceByICMO(oCn, lMaterID, dEndDate, lSourceID, sLeftProdTimes);
|
}
|
else //ûÓÐ×ÊÔ´Ôò ×Ô¶¯ÕÒµ½×ÊÔ´
|
{
|
//
|
ds = Sc_ICMOSortBillFun.GetWorkSourceByICMO(oCn, lMaterID, dEndDate, sLeftProdTimes);
|
}
|
if (ds == null || ds.Tables[0].Rows.Count ==0) //ûÓпÉÒÔÅŵÄ×ÊÔ´
|
{
|
//Ìøµ½ÏÂÒ»µ¥ ±¾µ¥ºìÉ«ÏÔʾ
|
grdSourceBill.Rows[i].DefaultCellStyle.BackColor = Color.Brown;
|
continue;
|
}
|
else
|
{
|
grdSourceBill.Rows[i].DefaultCellStyle.BackColor = Color.White;
|
//¿ªÊ¼Åŵ¥
|
bFind = false;
|
//³¬½»»õÆÚ ÈÔÈ»ÅųÌ
|
for (int j = 0; j < ds.Tables[0].Rows.Count; j++)
|
{
|
//ÅжÏ×ÊÔ´Ê£Ó๤ʱ£¬ÊÇ·ñ´óÓÚ Éú²úÖÜÆÚ
|
if (DBUtility.ClsPub.isSingle(ds.Tables[0].Rows[j]["Ê£Ó๤ʱ"]) > sLeftProdTimes)
|
{
|
if (iLeftQty > 0) // Éú²ú¶©µ¥Ê£ÓàÊýÁ¿
|
{
|
//ÔÚ±¾×ÊÔ´ÉÏÉú²ú
|
//»ñÈ¡¸ÃÉú²ú×ÊÔ´µÄÊ£Ó๤ʱ½øÐÐÅų̡£
|
lSourceID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[j]["HitemID"]);
|
sSourceName = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[j]["×ÊÔ´Ãû³Æ"]);
|
sSourceNumber = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[j]["×ÊÔ´´úÂë"]);
|
grdSourceBill.Rows[i].Cells[HSourceIDCol].Value = lSourceID;
|
grdSourceBill.Rows[i].Cells[HSourceNameCol].Value = sSourceName;
|
grdSourceBill.Rows[i].Cells[HSourceNumberCol].Value = sSourceNumber;
|
dsSub = Sc_ICMOSortBillFun.GetWorkSourceTimeBySource(oCn, lSourceID);
|
if (dsSub == null || dsSub.Tables[0].Rows.Count == 0)
|
{
|
continue;//Èç¹ûûÓÐÊ£ÓàÔò Ö´ÐÐÏÂÒ»¸öÉú²ú¶©µ¥
|
}
|
if (dsSub != null )//²»¼Ó°àÅųÌ
|
{
|
//½«Êý¾ÝÅŵ½Íø¸ñÖÐ
|
grdMain.RowCount = grdMain.RowCount + 1; // grdmain ÐÂÔöÒ»ÐÐ
|
grdMain.Rows[grdMain.RowCount - 1].Cells[HSecICMOBillNoCol].Value = sICMOBillNo;
|
grdMain.Rows[grdMain.RowCount - 1].Cells[HSecICMOInterIDCol].Value = lMainID;
|
grdMain.Rows[grdMain.RowCount - 1].Cells[HSecLeftQtyCol].Value = iLeftQty;
|
grdMain.Rows[grdMain.RowCount - 1].Cells[HSecGroupIDCol].Value = lHGroupID;
|
grdMain.Rows[grdMain.RowCount - 1].Cells[HSecGroupNameCol].Value = sGroupName;
|
grdMain.Rows[grdMain.RowCount - 1].Cells[HSecMaterIDCol].Value = lMaterID;
|
grdMain.Rows[grdMain.RowCount - 1].Cells[HSecMaterNameCol].Value = sMaterName;
|
grdMain.Rows[grdMain.RowCount - 1].Cells[HSecMaterNumberCol].Value = sMaterNumber;
|
grdMain.Rows[grdMain.RowCount - 1].Cells[HSecMaterModelCol].Value = sMaterModel;
|
grdMain.Rows[grdMain.RowCount - 1].Cells[HSecPlanEndDateCol].Value = dEndDate;
|
grdMain.Rows[grdMain.RowCount - 1].Cells[HSecPlanQtyCol].Value = sPlanQty;
|
grdMain.Rows[grdMain.RowCount - 1].Cells[HSecSourceIDCol].Value = lSourceID;
|
grdMain.Rows[grdMain.RowCount - 1].Cells[HSecSourceNameCol].Value = sSourceName;
|
grdMain.Rows[grdMain.RowCount - 1].Cells[HSecSourceNumberCol].Value = sSourceNumber;
|
grdMain.Rows[grdMain.RowCount - 1].Cells[HSecYXCol].Value = sYX;
|
Sc_ICMOSortBillFun.SetInfoToGrid(grdMain, dsSub, null, grdMain.RowCount - 1, ref iLeftQty, sWorkQty, false, oClsGridValues);
|
}
|
bFind = true;
|
}
|
}
|
}
|
if (!bFind)
|
{
|
for (int j = 0; j < ds.Tables[0].Rows.Count; j++)
|
{
|
//ÅжÏ×ÊÔ´×î´óÊ£Ó๤ʱ£¬ÊÇ·ñ´óÓÚ Éú²úÖÜÆÚ
|
if (DBUtility.ClsPub.isSingle(ds.Tables[0].Rows[j]["×î´óÊ£Ó๤ʱ"]) > sLeftProdTimes)
|
{
|
if (iLeftQty > 0)
|
{
|
|
//ÔÚ±¾×ÊÔ´ÉÏÉú²ú
|
grdMain.RowCount = grdMain.RowCount + 1;
|
//»ñÈ¡¸ÃÉú²ú×ÊÔ´µÄÊ£Ó๤ʱ½øÐÐÅų̡£
|
lSourceID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[j]["HitemID"]);
|
sSourceName = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[j]["×ÊÔ´Ãû³Æ"]);
|
sSourceNumber = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[j]["×ÊÔ´´úÂë"]);
|
grdSourceBill.Rows[i].Cells[HSourceIDCol].Value = lSourceID;
|
grdSourceBill.Rows[i].Cells[HSourceNameCol].Value = sSourceName;
|
grdSourceBill.Rows[i].Cells[HSourceNumberCol].Value = sSourceNumber;
|
dsSub = Sc_ICMOSortBillFun.GetWorkSourceTimeBySource(oCn, lSourceID);
|
if (dsSub == null || dsSub.Tables[0].Rows.Count == 0)
|
{
|
continue;
|
}
|
if (dsSub != null)//¼Ó°àÅųÌ
|
{
|
//½«Êý¾ÝÅŵ½Íø¸ñÖÐ
|
grdMain.RowCount = grdMain.RowCount + 1; // grdmain ÐÂÔöÒ»ÐÐ
|
grdMain.Rows[grdMain.RowCount - 1].Cells[HSecICMOBillNoCol].Value = sICMOBillNo;
|
grdMain.Rows[grdMain.RowCount - 1].Cells[HSecICMOInterIDCol].Value = lMainID;
|
grdMain.Rows[grdMain.RowCount - 1].Cells[HSecLeftQtyCol].Value = iLeftQty;
|
grdMain.Rows[grdMain.RowCount - 1].Cells[HSecGroupIDCol].Value = lHGroupID;
|
grdMain.Rows[grdMain.RowCount - 1].Cells[HSecGroupNameCol].Value = sGroupName;
|
grdMain.Rows[grdMain.RowCount - 1].Cells[HSecMaterIDCol].Value = lMaterID;
|
grdMain.Rows[grdMain.RowCount - 1].Cells[HSecMaterNameCol].Value = sMaterName;
|
grdMain.Rows[grdMain.RowCount - 1].Cells[HSecMaterNumberCol].Value = sMaterNumber;
|
grdMain.Rows[grdMain.RowCount - 1].Cells[HSecMaterModelCol].Value = sMaterModel;
|
grdMain.Rows[grdMain.RowCount - 1].Cells[HSecPlanEndDateCol].Value = dEndDate;
|
grdMain.Rows[grdMain.RowCount - 1].Cells[HSecPlanQtyCol].Value = sPlanQty;
|
grdMain.Rows[grdMain.RowCount - 1].Cells[HSecSourceIDCol].Value = lSourceID;
|
grdMain.Rows[grdMain.RowCount - 1].Cells[HSecSourceNameCol].Value = sSourceName;
|
grdMain.Rows[grdMain.RowCount - 1].Cells[HSecSourceNumberCol].Value = sSourceNumber;
|
grdMain.Rows[grdMain.RowCount - 1].Cells[HSecYXCol].Value = sYX;
|
Sc_ICMOSortBillFun.SetInfoToGrid(grdMain, dsSub, null, grdMain.RowCount - 1, ref iLeftQty, sWorkQty, true, oClsGridValues);
|
}
|
}
|
bFind = true;
|
}
|
}
|
}
|
if (!bFind)
|
{
|
//Èç¹ûûÓÐÕÒµ½ºÏÊÊ×ÊÔ´Ôò£¬Ö±½ÓÅÅ×îºóÒ»¸öÊ£Óà×î´óµÄ×ÊÔ´¡£
|
//»ñÈ¡¸ÃÉú²ú×ÊÔ´µÄÊ£Ó๤ʱ½øÐÐÅų̡£
|
lSourceID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[ds.Tables[0].Rows.Count - 1]["HitemID"]);
|
sSourceName = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[ds.Tables[0].Rows.Count - 1]["×ÊÔ´Ãû³Æ"]);
|
sSourceNumber = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[ds.Tables[0].Rows.Count - 1]["×ÊÔ´´úÂë"]);
|
grdSourceBill.Rows[i].Cells[HSourceIDCol].Value = lSourceID;
|
grdSourceBill.Rows[i].Cells[HSourceNameCol].Value = sSourceName;
|
grdSourceBill.Rows[i].Cells[HSourceNumberCol].Value = sSourceNumber;
|
|
//»ñÈ¡¸ÃÉú²ú×ÊÔ´µÄÊ£Ó๤ʱ½øÐÐÅų̡£
|
dsSub = Sc_ICMOSortBillFun.GetWorkSourceTimeBySource(oCn, lSourceID);
|
if (dsSub == null || dsSub.Tables[0].Rows.Count == 0)
|
{
|
continue;
|
}
|
if (dsSub != null )//¼Ó°àÅųÌ
|
{
|
//½«Êý¾ÝÅŵ½Íø¸ñÖÐ
|
grdMain.RowCount = grdMain.RowCount + 1; // grdmain ÐÂÔöÒ»ÐÐ
|
grdMain.Rows[grdMain.RowCount - 1].Cells[HSecICMOBillNoCol].Value = sICMOBillNo;
|
grdMain.Rows[grdMain.RowCount - 1].Cells[HSecICMOInterIDCol].Value = lMainID;
|
grdMain.Rows[grdMain.RowCount - 1].Cells[HSecLeftQtyCol].Value = iLeftQty;
|
grdMain.Rows[grdMain.RowCount - 1].Cells[HSecGroupIDCol].Value = lHGroupID;
|
grdMain.Rows[grdMain.RowCount - 1].Cells[HSecGroupNameCol].Value = sGroupName;
|
grdMain.Rows[grdMain.RowCount - 1].Cells[HSecMaterIDCol].Value = lMaterID;
|
grdMain.Rows[grdMain.RowCount - 1].Cells[HSecMaterNameCol].Value = sMaterName;
|
grdMain.Rows[grdMain.RowCount - 1].Cells[HSecMaterNumberCol].Value = sMaterNumber;
|
grdMain.Rows[grdMain.RowCount - 1].Cells[HSecMaterModelCol].Value = sMaterModel;
|
grdMain.Rows[grdMain.RowCount - 1].Cells[HSecPlanEndDateCol].Value = dEndDate;
|
grdMain.Rows[grdMain.RowCount - 1].Cells[HSecPlanQtyCol].Value = sPlanQty;
|
grdMain.Rows[grdMain.RowCount - 1].Cells[HSecSourceIDCol].Value = lSourceID;
|
grdMain.Rows[grdMain.RowCount - 1].Cells[HSecSourceNameCol].Value = sSourceName;
|
grdMain.Rows[grdMain.RowCount - 1].Cells[HSecSourceNumberCol].Value = sSourceNumber;
|
grdMain.Rows[grdMain.RowCount - 1].Cells[HSecYXCol].Value = sYX;
|
Sc_ICMOSortBillFun.SetInfoToGrid(grdMain, dsSub, null, grdMain.RowCount - 1, ref iLeftQty, sWorkQty, true, oClsGridValues);
|
}
|
}
|
}
|
//
|
//±£´æÉú³ÉÅɹ¤µ¥
|
SaveSingeBill(i, grdMain.RowCount - 1, HRelationInterID,oClsGridValues);
|
//дÈë ½ø¶ÈµÈ´ý¿ò
|
Thread.Sleep(100);
|
Application.DoEvents();
|
oWait.pb1.Value = i + 1;
|
oWait.lblHCount.Text = oWait.pb1.Value.ToString() + "/" + oWait.pb1.Maximum.ToString();
|
oWait.lblHMaterName.Text = "";
|
Application.DoEvents();
|
}
|
////´æÈëÉú²ú״̬±í
|
oCn.RunProc("exec h_p_Sc_WorkAutoBillStatus_Add " + DBUtility.ClsPub.isLong(txtHDeptID.Tag).ToString());
|
//
|
oWait.Close();
|
return true;
|
}
|
|
|
|
//ÉèÖÃÓÅÏÈ
|
private bool SetYXNum()
|
{
|
//ÉèÖÃÓÅÏȼ¶ ±àºÅ
|
for (int i = 0; i < grdSourceBill.RowCount; i++)
|
{
|
grdSourceBill.Rows[i].Cells[HYXCol].Value = (i + 1)*10;
|
}
|
//
|
return true;
|
}
|
|
|
//ÅÅÐò
|
private void SortData()
|
{
|
//ðÅÝÅÅÐò·¨
|
//Ôö¼ÓÒ»¸ö±¸ÓÃÐÐ
|
grdSourceBill.RowCount = grdSourceBill.RowCount + 1;
|
for (int i = 0; i < grdSourceBill.RowCount - 2; i++)
|
{
|
for (int j = 0; j < grdSourceBill.RowCount - i - 2; j++)
|
{
|
//ÉèÖÃÈÎÎñµ¥ÓÅÏÈÅÅÐò£¬²¢ÉèÖÃÓÅÏÈ(×î³ÙÍ깤ÈÕÆÚ+¶©µ¥½»»õÆÚ) ·â×°
|
if (DBUtility.ClsPub.isDate(grdSourceBill.Rows[j].Cells[HLastEndDateCol].Value) > DBUtility.ClsPub.isDate(grdSourceBill.Rows[j+1].Cells[HLastEndDateCol].Value))
|
{
|
Sc_ICMOSortBillFun.ChangeGridItem(grdSourceBill,j);
|
}
|
else if (DBUtility.ClsPub.isDate(grdSourceBill.Rows[j].Cells[HLastEndDateCol].Value) == DBUtility.ClsPub.isDate(grdSourceBill.Rows[j + 1].Cells[HLastEndDateCol].Value))
|
{
|
if (DBUtility.ClsPub.isDate(grdSourceBill.Rows[j].Cells[HOrderCommitDateCol].Value) > DBUtility.ClsPub.isDate(grdSourceBill.Rows[j + 1].Cells[HOrderCommitDateCol].Value))
|
{
|
Sc_ICMOSortBillFun.ChangeGridItem(grdSourceBill, j);
|
}
|
else if (DBUtility.ClsPub.isDate(grdSourceBill.Rows[j].Cells[HOrderCommitDateCol].Value) == DBUtility.ClsPub.isDate(grdSourceBill.Rows[j + 1].Cells[HOrderCommitDateCol].Value))
|
{
|
if (DBUtility.ClsPub.isDoule(grdSourceBill.Rows[j].Cells[HOrderNeedQtyCol].Value )< DBUtility.ClsPub.isDoule(grdSourceBill.Rows[j + 1].Cells[HOrderNeedQtyCol].Value))
|
{
|
Sc_ICMOSortBillFun.ChangeGridItem(grdSourceBill, j);
|
}
|
}
|
else
|
{
|
//
|
}
|
}
|
else
|
{
|
//
|
}
|
}
|
}
|
//ɾ³ý±¸ÓÃÐÐ
|
grdSourceBill.RowCount = grdSourceBill.RowCount - 1;
|
}
|
|
|
//ɾ³ý±¾²¿ÃÅδËø¶¨ ¼Ç¼
|
private void Sub_DeleteBillUnLock()
|
{
|
if (oMain.DeleteBillUnlock(DBUtility.ClsPub.isLong(txtHDeptID.Tag))==false)
|
{
|
MessageBox.Show("×÷·ÏÀúÊ·µ¥¾Ýʧ°Ü£¡");
|
}
|
|
}
|
|
//Êý¾Ý×¼±¸ ÉèÖÃÈÎÎñµ¥Ïà¹ØÐÅÏ¢
|
private bool ReadyData()
|
{
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
DataSet ds;
|
//µ¯³öÇ°Ö÷Çģʽ´°Ì壬ÏÔʾ½ø¶È
|
DBUtility.Xt_ProcessWait oWait = new DBUtility.Xt_ProcessWait();
|
oWait.lblCaption.Text = "ÕýÔÚÅųÌÊý¾Ý×¼±¸ÇëÉÔºò...";
|
oWait.lblHCount.Text = "";
|
oWait.lblHMaterName.Text = "";
|
oWait.pb1.Maximum = grdSourceBill.RowCount;
|
oWait.pb1.Value = 0;
|
oWait.Show();
|
//Ñ»·¼ÆËãÍø¸ñÖеÄÈÎÎñµ¥
|
for (int i = 0; i < grdSourceBill.RowCount; i++)
|
{
|
//Ö´ÐмÆËãÈÎÎñµ¥¹ý³Ì
|
Thread.Sleep(100);
|
ds = oCn.RunProcReturn("exec h_p_Sc_GetInfoByICMOBillNo " + grdSourceBill.Rows[i].Cells[HICMOInterIDCol].Value.ToString(), "xt_xtgnb");
|
if (ds == null || ds.Tables[0].Rows.Count == 0)
|
{
|
//дÈë ½ø¶ÈµÈ´ý¿ò
|
Application.DoEvents();
|
oWait.pb1.Value = i + 1;
|
oWait.lblHCount.Text = oWait.pb1.Value.ToString() + "/" + oWait.pb1.Maximum.ToString();
|
oWait.lblHMaterName.Text = "";
|
Application.DoEvents();
|
}
|
else
|
{
|
//·µ»ØÐÅÏ¢»ØÌîÍø¸ñ
|
//grdSourceBill.Rows[i].Cells[HRelationQtyCol].Value = DBUtility.ClsPub.isSingle(ds.Tables[0].Rows[i]["¹ØÁªÊýÁ¿"]);
|
grdSourceBill.Rows[i].Cells[HWorkQtyCol].Value = DBUtility.ClsPub.isSingle(ds.Tables[0].Rows[0]["²úÄÜ"]);
|
grdSourceBill.Rows[i].Cells[HProdTimesCol].Value = DBUtility.ClsPub.isSingle(ds.Tables[0].Rows[0]["Éú²úÖÜÆÚ"]);
|
//grdSourceBill.Rows[i].Cells[HWorkTimesCol].Value = DBUtility.ClsPub.isSingle(ds.Tables[0].Rows[0]["¹¤Ê±"]);
|
grdSourceBill.Rows[i].Cells[HReadyQtyCol].Value = DBUtility.ClsPub.isSingle(ds.Tables[0].Rows[0]["¿ª¹¤ÓàÁ¿"]);
|
grdSourceBill.Rows[i].Cells[HLastBeginDateCol].Value = DBUtility.ClsPub.isDate(ds.Tables[0].Rows[0]["×î³Ù¿ª¹¤ÈÕÆÚ"]);
|
grdSourceBill.Rows[i].Cells[HLastEndDateCol].Value = DBUtility.ClsPub.isDate(ds.Tables[0].Rows[0]["×î³ÙÍ깤ÈÕÆÚ"]);
|
grdSourceBill.Rows[i].Cells[HOrderNeedQtyCol].Value = DBUtility.ClsPub.isSingle(ds.Tables[0].Rows[0]["¶©µ¥ÐèÇóÊý"]);
|
//grdSourceBill.Rows[i].Cells[HSeOrderBillNoCol].Value = DBUtility.ClsPub.(ds.Tables[0].Rows[0][""]);
|
grdSourceBill.Rows[i].Cells[HOrderCommitDateCol].Value = DBUtility.ClsPub.isDate(ds.Tables[0].Rows[0]["¶©µ¥½»»õÆÚ"]);
|
//дÈë ½ø¶ÈµÈ´ý¿ò
|
Application.DoEvents();
|
oWait.pb1.Value = i + 1;
|
oWait.lblHCount.Text = oWait.pb1.Value.ToString() + "/" + oWait.pb1.Maximum.ToString();
|
oWait.lblHMaterName.Text = "";
|
Application.DoEvents();
|
}
|
}
|
oWait.Close();
|
return true;
|
}
|
|
|
//µÃµ½ÐÂÈÕÆÚ
|
private bool GetNewDay(long lSourceID,int iRow,int iCol)
|
{
|
return true;
|
}
|
//¼ÆËãÿÈÕ¼Ó¹¤Ê±¼ä
|
private double CountDayHours(int iRow,int iCol)
|
{
|
return 0;
|
}
|
//»Ïß
|
private void GraphLine()
|
{
|
//
|
}
|
|
|
|
//µÃµ½µÃµ½±¾¹¤Ðò µ±ÈÕÉÏ°àʱ¼ä
|
private double GetWorkNumber(string FDate,long SourceID)
|
{
|
return 0;
|
//return BLL.Sc_ICMOAutoSortBillFun.GetWorkNumber(FDate, SourceID,oCn);
|
}
|
|
private void cx_Click(object sender, EventArgs e)
|
{
|
timer1.Enabled = true;
|
}
|
|
//¼ÓÔØ Ñ¡Ô´µ¥
|
private void sx_Click(object sender, EventArgs e)
|
{
|
DAL.Cls_S_Sc_ICMOBill oK3_ICMOBill = new DAL.Cls_S_Sc_ICMOBill();
|
string sWhere = " And HDeptID=" + DBUtility.ClsPub.isLong(txtHDeptID.Tag) + " ";
|
if (oK3_ICMOBill.Refresh(sWhere)) //Ñ¡ÔñÔµ¥
|
{
|
FillSelectData(oK3_ICMOBill.oBillSelectColl);
|
}
|
}
|
//¼ÓÔØ Ôµ¥µ½±¾µØ
|
private void FillSelectData(List<DBUtility.BillSelect> oList)
|
{
|
//
|
bool sBool = false;
|
DataSet Ds;
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
foreach (DBUtility.BillSelect oSelectRow in oList)
|
{
|
if (oSelectRow.BillType == "3710")
|
{
|
sBool = false;
|
//µÃµ½ÐÅÏ¢
|
Ds = oCn.RunProcReturn("select * from h_v_Sc_ICMOBillList_add where hmainid=" + oSelectRow.BillMainID + " and hsubid=" + oSelectRow.BillSubID, "h_v_Sc_ICMOBillList_add");
|
//дÈëÐÅÏ¢
|
for (int j = 0; j <= grdSourceBill.RowCount-1; j++)
|
{
|
if (DBUtility.ClsPub.isLong(grdSourceBill.Rows[j].Cells[HICMOInterIDCol].Value) == DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HMainID"]))
|
{
|
sBool = true;
|
MessageBox.Show("ÈÎÎñµ¥£º" + DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["µ¥¾ÝºÅ"] + "ÒÑ´æÔÚ´ýÅżƻ®ÖУ¬²»ÔÊÐíÌí¼Ó£¡"), "Ìáʾ");
|
break;
|
}
|
}
|
if (sBool != true)
|
{
|
grdSourceBill.RowCount = grdSourceBill.RowCount + 1;
|
Sub_WriteInForm(Ds.Tables[0], grdSourceBill.RowCount - 1);
|
}
|
}
|
}
|
}
|
//¸ù¾ÝTABLEдÈë½çÃæ
|
private void Sub_WriteInForm(DataTable oTable, int i)
|
{
|
DAL.ClsGy_Source_View oSource = new DAL.ClsGy_Source_View();
|
try
|
{
|
////¼ÓÔرíÌå
|
grdSourceBill.Rows[i].Cells[HSeOrderBillNoCol].Value = oTable.Rows[0]["ÏúÊÛ¶©µ¥ºÅ"].ToString();
|
grdSourceBill.Rows[i].Cells[HICMOBillNoCol].Value = oTable.Rows[0]["µ¥¾ÝºÅ"].ToString();
|
//grdSourceBill.Rows[i].Cells[HCusNameCol].Value = oTable.Rows[0]["HCusName"].ToString();
|
grdSourceBill.Rows[i].Cells[HMaterIDCol].Value = oTable.Rows[0]["HMaterID"].ToString();
|
grdSourceBill.Rows[i].Cells[HMaterNumberCol].Value = oTable.Rows[0]["ÎïÁÏ´úÂë"].ToString();
|
grdSourceBill.Rows[i].Cells[HMaterNameCol].Value = oTable.Rows[0]["ÎïÁÏÃû³Æ"].ToString();
|
grdSourceBill.Rows[i].Cells[HMaterModelCol].Value = oTable.Rows[0]["¹æ¸ñÐͺÅ"].ToString();
|
grdSourceBill.Rows[i].Cells[HUnitIDCol].Value = oTable.Rows[0]["HUnitID"].ToString();
|
//grdSourceBill.Rows[i].Cells[HUnitNumberCol].Value = oTable.Rows[0]["HUnitNumber"].ToString();
|
grdSourceBill.Rows[i].Cells[HUnitNameCol].Value = oTable.Rows[0]["¼ÆÁ¿µ¥Î»"].ToString();
|
grdSourceBill.Rows[i].Cells[HPlanBeginDateCol].Value = oTable.Rows[0]["¼Æ»®¿ª¹¤ÈÕÆÚ"].ToString();
|
grdSourceBill.Rows[i].Cells[HPlanEndDateCol].Value = oTable.Rows[0]["¼Æ»®Í깤ÈÕÆÚ"].ToString();
|
grdSourceBill.Rows[i].Cells[HPlanQtyCol].Value = DBUtility.ClsPub.isDoule(oTable.Rows[0]["ÈÎÎñÊýÁ¿"], 2);
|
grdSourceBill.Rows[i].Cells[HRelationQtyCol].Value = DBUtility.ClsPub.isDoule(oTable.Rows[0]["¹ØÁªÊýÁ¿"], 2);
|
grdSourceBill.Rows[i].Cells[HInStockQtyCol].Value = DBUtility.ClsPub.isDoule(oTable.Rows[0]["Èë¿âÊýÁ¿"], 2);
|
grdSourceBill.Rows[i].Cells[HLastBeginDateCol].Value ="";
|
grdSourceBill.Rows[i].Cells[HLastEndDateCol].Value = "";
|
grdSourceBill.Rows[i].Cells[HWorkQtyCol].Value = "0";
|
grdSourceBill.Rows[i].Cells[HWorkTimesCol].Value = "8";
|
grdSourceBill.Rows[i].Cells[HYXCol].Value = "";
|
grdSourceBill.Rows[i].Cells[HKTQCol].Value = "1";
|
grdSourceBill.Rows[i].Cells[HReadyQtyCol].Value = "0";
|
grdSourceBill.Rows[i].Cells[HRemarkCol].Value = oTable.Rows[0]["¶©µ¥±¸×¢"].ToString();
|
//============
|
grdSourceBill.Rows[i].Cells[HICMOInterIDCol].Value = oTable.Rows[0]["HMainID"].ToString();
|
grdSourceBill.Rows[i].Cells[HSeOrderInterIDCol].Value = oTable.Rows[0]["HSeOrderInterID"].ToString();
|
grdSourceBill.Rows[i].Cells[HSeOrderEntryIDCol].Value = oTable.Rows[0]["HSeOrderEntryID"].ToString();
|
grdSourceBill.Rows[i].Cells[HSourceEntryIDCol].Value = oTable.Rows[0]["HMainID"].ToString();
|
grdSourceBill.Rows[i].Cells[HSourceInterIDCol].Value = oTable.Rows[0]["HSubID"].ToString();
|
grdSourceBill.Rows[i].Cells[HIsOutSellCol].Value = oTable.Rows[0]["ÊÇ·ñÍâó"].ToString();
|
//grdSourceBill.Rows[i].Cells[HSourceBillTypeCol].Value = oTable.Rows[0]["HBillType"].ToString();
|
}
|
catch (Exception e)
|
{
|
MessageBox.Show(e.Message);
|
}
|
}
|
|
//»ñÈ¡Èë¿âÊýÁ¿
|
private void GetInStockQtyByICMOInterID()
|
{
|
DataSet Ds;
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
long HICMOInterID = 0;
|
for (int i = 0; i <= grdSourceBill.RowCount - 1; i++)
|
{
|
HICMOInterID = DBUtility.ClsPub.isLong(grdSourceBill.Rows[i].Cells[HICMOInterIDCol].Value);
|
Ds = oCn.RunProcReturn("select * from h_v_Sc_ICMOBillList_add where hmainid=" + HICMOInterID.ToString(), "h_v_Sc_ICMOBillList_add");
|
//дÈëÐÅÏ¢
|
if (Ds == null || Ds.Tables[0].Rows.Count == 0)
|
{
|
return;
|
}
|
grdSourceBill.Rows[i].Cells[HRelationQtyCol].Value = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[0]["¹ØÁªÊýÁ¿"], 2);
|
grdSourceBill.Rows[i].Cells[HInStockQtyCol].Value = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[0]["Èë¿âÊýÁ¿"], 2);
|
}
|
}
|
|
//±£´æÁпí
|
private void bclk_Click(object sender, EventArgs e)
|
{
|
//±£´æÁпí
|
DBUtility.ClsPub.SaveGridView(grdSource, this.Name + "grdSource", DBUtility.ClsPub.AppPath);
|
DBUtility.ClsPub.SaveGridView(grdICMO, this.Name + "grdICMO", DBUtility.ClsPub.AppPath);
|
DBUtility.ClsPub.SaveGridView(grdSourceBill, this.Name + "grdSourceBill", DBUtility.ClsPub.AppPath);
|
DBUtility.ClsPub.SaveGridView(grdMain, this.Name + "grdMain", DBUtility.ClsPub.AppPath);
|
DBUtility.ClsPub.SaveGridView(grdProcFlow, this.Name + "grdProcFlow", DBUtility.ClsPub.AppPath);
|
}
|
//ĬÈÏÁпí
|
private void mrlk_Click(object sender, EventArgs e)
|
{
|
DBUtility.ClsPub.DefaultGridView(grdSource);
|
DBUtility.ClsPub.DefaultGridView(grdICMO);
|
DBUtility.ClsPub.DefaultGridView(grdSourceBill);
|
DBUtility.ClsPub.DefaultGridView(grdMain);
|
DBUtility.ClsPub.DefaultGridView(grdProcFlow);
|
}
|
|
|
//Í˳ö°´Å¥
|
private void tc_Click(object sender, EventArgs e)
|
{
|
this.Close();
|
}
|
|
|
//Åų̰´Å¥
|
private void xz_Click(object sender, EventArgs e)
|
{
|
if (CheckSetupData() == false)
|
{
|
return;
|
}
|
if (MessageBox.Show("ÊÇ·ñÆô¶¯Åų̣¿","Ìáʾ", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.Cancel)
|
{
|
//this.DateSetup(false);
|
return;
|
}
|
else
|
{
|
this.DateSetup(true);
|
}
|
}
|
//Çå¿Õ°´Å¥
|
private void toolStripButton1_Click(object sender, EventArgs e)
|
{
|
//this.ClearDateCol(true);
|
}
|
|
//»Ö¸´°´Å¥
|
private void hf_Click(object sender, EventArgs e)
|
{
|
//this.ClearDateCol(false);
|
}
|
|
//±£´æ°´Å¥
|
private void bc_Click(object sender, EventArgs e)
|
{
|
if (bEdit == true)
|
{
|
MessageBox.Show("ÅųÌÊý×ÖÒѱ»Ð޸ģ¬ÇëÖØÐÂÖ´ÐÐÔÚ±£´æ£¡");
|
return;
|
}
|
SaveBill();
|
}
|
|
|
//ÄÜÁ¦°´Å¥
|
private void nl_Click(object sender, EventArgs e)
|
{
|
//ÄÜÁ¦ÉèÖÃ
|
//Gy_WorkTimes oFrm = new Gy_WorkTimes();
|
//oFrm.ShowDialog();
|
}
|
|
private void Sc_ICMOAutoSortBill_Load(object sender, EventArgs e)
|
{
|
this.Text = ModCaption;
|
this.lblCaption.Text = ModCaption;
|
}
|
|
//°ïÖúº¯Êý
|
private void Sub_GridKey(int sKeyCode, int sRow, int sCol, DataGridViewTextBoxEditingControl oEdit)
|
{
|
DAL.ClsGy_Source_View oSource = new DAL.ClsGy_Source_View();
|
DAL.ClsIF_Group_View oGroup = new DAL.ClsIF_Group_View();
|
switch (sKeyCode)
|
{
|
case 118: //F7
|
{
|
switch (sCol)
|
{
|
case HSourceNameCol:
|
BLL.ClsBaseSelect_InterFace.SetGridBySource(grdSourceBill, sRow, HSourceIDCol, HSourceNumberCol, HSourceNameCol);
|
Sc_ICMOSortBillFun.SetSourceWorkQty(grdSourceBill, HMaterIDCol, HSourceIDCol, 0, HWorkQtyCol, sRow, oMain);
|
if (oSource.GetGroupBySourceID(DBUtility.ClsPub.isLong(grdSourceBill.Rows[sRow].Cells[HSourceIDCol].Value)))
|
{
|
if (oGroup.GetInfoByID(oSource.omodel.HGroupK3ID))
|
{
|
grdSourceBill.Rows[sRow].Cells[HGroupIDCol].Value = oGroup.omodel.HItemID.ToString();
|
grdSourceBill.Rows[sRow].Cells[HGroupNameCol].Value = oGroup.omodel.HName;
|
}
|
}
|
else
|
{
|
grdSourceBill.Rows[sRow].Cells[HGroupIDCol].Value = "";
|
grdSourceBill.Rows[sRow].Cells[HGroupNameCol].Value = "";
|
}
|
oEdit.Text = DBUtility.ClsPub.isStrNull(grdSourceBill.Rows[sRow].Cells[HSourceNameCol].Value);
|
break;
|
case HGroupNameCol:
|
BLL.ClsBaseSelect_InterFace.SetGridByGroup(grdSourceBill, sRow, HGroupIDCol, 0, HGroupNameCol);
|
oEdit.Text = DBUtility.ClsPub.isStrNull(grdSourceBill.Rows[sRow].Cells[HGroupNameCol].Value);
|
break;
|
case HPlanBeginDateCol:
|
BLL.ClsPub_BLL.Sub_SelectDate(grdSourceBill, sRow, HPlanBeginDateCol);
|
//oEdit.Text = DBUtility.ClsPub.isStrNull(grdMain.Rows[sRow].Cells[HPlanBeginDateCol].Value);
|
oMainPC.Sub_setPlanBeginDate(DBUtility.ClsPub.isLong(grdSourceBill.Rows[sRow].Cells[HICMOInterIDCol].Value), DBUtility.ClsPub.isDate(grdSourceBill.Rows[sRow].Cells[HPlanBeginDateCol].Value), ref DBUtility.ClsPub.sExeReturnInfo);
|
break;
|
case HPlanEndDateCol:
|
BLL.ClsPub_BLL.Sub_SelectDate(grdSourceBill, sRow, HPlanEndDateCol);
|
//oEdit.Text = DBUtility.ClsPub.isStrNull(grdMain.Rows[sRow].Cells[HPlanEndDateCol].Value);
|
oMainPC.Sub_setPlanEndDate(DBUtility.ClsPub.isLong(grdSourceBill.Rows[sRow].Cells[HICMOInterIDCol].Value), DBUtility.ClsPub.isDate(grdSourceBill.Rows[sRow].Cells[HPlanEndDateCol].Value), ref DBUtility.ClsPub.sExeReturnInfo);
|
break;
|
default:
|
break;
|
}
|
break;
|
}
|
case 117: //F6
|
{
|
switch (sCol)
|
{
|
case HSourceNameCol:
|
if (oSource.RefreshViewByRelation(DBUtility.ClsPub.isLong(grdSourceBill.Rows[sRow].Cells[HMaterIDCol].Value)))
|
{
|
if (oSource.GetInfoByID(oSource.oModel.HItemID))
|
{
|
grdSourceBill.Rows[sRow].Cells[HSourceIDCol].Value = oSource.oModel.HItemID.ToString();
|
grdSourceBill.Rows[sRow].Cells[HSourceNameCol].Value = oSource.oModel.HName;
|
grdSourceBill.Rows[sRow].Cells[HSourceNumberCol].Value = oSource.oModel.HNumber;
|
if (oGroup.GetInfoByID(oSource.omodel.HGroupK3ID))
|
{
|
grdSourceBill.Rows[sRow].Cells[HGroupIDCol].Value = oGroup.omodel.HItemID.ToString();
|
grdSourceBill.Rows[sRow].Cells[HGroupNameCol].Value = oGroup.omodel.HName;
|
}
|
}
|
else
|
{
|
grdSourceBill.Rows[sRow].Cells[HSourceIDCol].Value = "";
|
grdSourceBill.Rows[sRow].Cells[HSourceNameCol].Value = "";
|
grdSourceBill.Rows[sRow].Cells[HSourceNumberCol].Value = "";
|
}
|
Sc_ICMOSortBillFun.SetSourceWorkQty(grdSourceBill, HMaterIDCol, HSourceIDCol, 0, HWorkQtyCol, sRow, oMain);
|
}
|
else
|
{
|
grdSourceBill.Rows[sRow].Cells[HSourceIDCol].Value = "";
|
grdSourceBill.Rows[sRow].Cells[HSourceNameCol].Value = "";
|
grdSourceBill.Rows[sRow].Cells[HSourceNumberCol].Value = "";
|
}
|
oEdit.Text = DBUtility.ClsPub.isStrNull(grdSourceBill.Rows[sRow].Cells[HSourceNameCol].Value);
|
break;
|
default:
|
break;
|
}
|
break;
|
}
|
default:
|
break;
|
}
|
}
|
|
|
//Ë¢ÐÂÈ«²¿×ÊÔ´ ²úÄÜ
|
private void RefreshWorkQty()
|
{
|
for (int i = 0; i < grdSourceBill.RowCount; i++)
|
{
|
//if (DBUtility.ClsPub.isLong(grdSourceBill.Rows[i].Cells[HSourceIDCol].Value) != 0)
|
//{
|
// SetSourceWorkQty(i);
|
//}
|
}
|
}
|
//ÉèÖñ¾ÐÐ ×ÊÔ´£¬²úÄÜ£¬²ð·Ö»ã±¨ÊýÁ¿
|
private void SetSourceWorkQty(int iRow)
|
{
|
Sc_ICMOSortBillFun.SetSourceWorkQty(grdSourceBill, HMaterIDCol, HSourceIDCol, DBUtility.ClsPub.isLong(txtHProcID.Tag), HWorkQtyCol, iRow, oMain);
|
}
|
//ÉèÖñ¾ÐÐ ×ÊÔ´ £¬²ð·Ö»ã±¨ÊýÁ¿
|
private void SetSourceRelationQty(int iRow)
|
{
|
Sc_ICMOSortBillFun.SetSourceRelationQty(grdSourceBill, iRow, HICMOInterIDCol, HSourceIDCol, HRelationQtyCol, HRelationQtyCol, oMain);
|
}
|
|
private void sc_Click_1(object sender, EventArgs e)
|
{
|
Sub_DeleteBill();
|
}
|
|
//ɾ³ýµ¥¾Ý
|
private void Sub_DeleteBill()
|
{
|
|
// ÅжÏÊÇ·ñÓл㱨
|
if (MessageBox.Show("È·¶¨ÒªÉ¾³ý´Ëµ¥¾Ý£¬±¾²Ù×÷²»¿É³·Ïú£¬Çë½÷É÷²Ù×÷£¡", "Ìáʾ", MessageBoxButtons.OKCancel) == DialogResult.Cancel)
|
{
|
return;
|
}
|
if (grdSourceBill.SelectedRows == null)
|
{
|
return;
|
}
|
for (int i = grdSourceBill.SelectedRows.Count - 1; i >= 0; i--)
|
{
|
grdSourceBill.Rows.Remove(grdSourceBill.SelectedRows[i]);
|
}
|
|
}
|
|
|
//ÉèÖÃÊÖ¹¤Ð޸ıê¼Ç
|
private void Sub_SetHandChangeFlag(int sCol, int sRow)
|
{
|
if (sCol < FixCols || sCol>=grdSourceBill.RowCount )
|
{
|
return;
|
}
|
//BLL.Sc_ICMOAutoSortBillFun.Sub_SetHandChangeFlag(grdSourceBill, sCol, sRow);
|
}
|
|
|
//ˢл㱨ÊýÁ¿
|
private void GetHRelationQty()
|
{
|
////grid½ûֹˢÐÂ
|
//grdSourceBill.Redraw = VSFlex7.RedrawSettings.flexRDNone;
|
////¼ÓÔرíÍ·
|
//for(int i=grdSourceBill.FixedRows ;i<grdSourceBill.Rows ;i++)
|
//{
|
// //µÃµ½ÀÛ¼Æ »ã±¨ÊýÁ¿
|
// //SetSourceWorkQty(i);
|
// SetSourceRelationQty(i);
|
// //
|
// //Èô »ã±¨ÊýÁ¿¡·¼Æ»®ÊýÁ¿ Ôò µ×É« »ÒÉ«ÏÔʾ
|
// if (DBUtility.ClsPub.isSingle(grdSourceBill.get_TextMatrix(i, HSplitPlanQtyCol)) <= DBUtility.ClsPub.isSingle(grdSourceBill.get_TextMatrix(i, HSplitRelationQtyCol)))
|
// {
|
// grdSourceBill.set_Cell(VSFlex7.CellPropertySettings.flexcpBackColor, i, grdSourceBill.FixedCols, i, FixCols, DBUtility.ClsPub.Enum_Color.hx_Control);
|
// grdSourceBill.set_RowHidden(i, true);
|
// }
|
// else
|
// {
|
// grdSourceBill.set_RowHidden(i, false);
|
// grdSourceBill.set_Cell(VSFlex7.CellPropertySettings.flexcpBackColor, i, grdSourceBill.FixedCols, i, FixCols, DBUtility.ClsPub.Enum_Color.hx_Write);
|
// }
|
//}
|
//grdSourceBill.Redraw = VSFlex7.RedrawSettings.flexRDBuffered;
|
}
|
|
//»ñÈ¡ÅųÌʱ¼ä
|
private void GetPcTime()
|
{
|
//DateTime d = oMain.GetNewSetup(DBUtility.ClsPub.isLong(txtHDeptID.Tag));
|
//lblHPCTime.Text = d.ToShortDateString() + " " + d.ToShortTimeString();
|
}
|
|
private void sd_Click(object sender, EventArgs e)
|
{
|
if (grdMain.CurrentRow == null)
|
return;
|
Sc_ICMOSortBillFun.LockICMOBill(true,DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[HSecICMOInterIDCol].Value),oCn);
|
//Ëø¶¨¶ÔÓ¦Íø¸ñÐÐ
|
for (int i = 0; i < grdSourceBill.Rows.Count; i++)
|
{
|
if (DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[HSecICMOInterIDCol].Value) == DBUtility.ClsPub.isLong(grdSourceBill.Rows[i].Cells[HICMOInterIDCol].Value))
|
{
|
grdSourceBill.Rows[i].Cells[HLockedCol].Value = true;
|
}
|
}
|
}
|
|
private void js_Click(object sender, EventArgs e)
|
{
|
if (grdMain.CurrentRow == null)
|
return;
|
Sc_ICMOSortBillFun.LockICMOBill(false, DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[HSecICMOInterIDCol].Value),oCn);
|
//Ëø¶¨¶ÔÓ¦Íø¸ñÐÐ
|
for (int i = 0; i < grdSourceBill.Rows.Count; i++)
|
{
|
if (DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[HSecICMOInterIDCol].Value) == DBUtility.ClsPub.isLong(grdSourceBill.Rows[i].Cells[HICMOInterIDCol].Value))
|
{
|
grdSourceBill.Rows[i].Cells[HLockedCol].Value = false;
|
}
|
}
|
}
|
|
private void px_Click(object sender, EventArgs e)
|
{
|
ReadyData();//Êý¾Ý×¼±¸
|
SortData(); //µ¥¾ÝÅÅÐò
|
}
|
|
private void sx_Click_1(object sender, EventArgs e)
|
{
|
initGrid();
|
Display();
|
}
|
|
private void glxx_Click(object sender, EventArgs e)
|
{
|
tbc1.Visible = !tbc1.Visible;
|
if (tbc1.Visible == false)
|
{
|
spc1.SplitterDistance = spc1.Size.Height-20;
|
}
|
else
|
{
|
spc1.SplitterDistance = spc1.Size.Height-200;
|
}
|
}
|
|
|
//ÈÎÎñµ¥¹ØÁªÐÅÏ¢
|
private void SetBillRelationInfo()
|
{
|
if (AllowRow() == false)
|
{
|
return;
|
}
|
if (tbc1.Visible)
|
{
|
//ˢвúÏß
|
Int64 sMaterID = 0;
|
sMaterID = DBUtility.ClsPub.isLong(grdSourceBill.Rows[grdSourceBill.CurrentRow.Index].Cells[HMaterIDCol].Value);
|
Sc_ICMOSortBillFun.GetSourceByMater(oCn, grdSource, sMaterID);
|
////ÏÔʾÈÎÎñµ¥ÐÅÏ¢
|
Int64 sICMOInterID = 0;
|
sICMOInterID = DBUtility.ClsPub.isLong(grdSourceBill.Rows[grdSourceBill.CurrentRow.Index].Cells[HICMOInterIDCol].Value);
|
Sc_ICMOSortBillFun.GetICMOInfoByID(oCn, grdICMO, sICMOInterID);
|
//ÏÔʾ¹¤ÒÕÁ÷ÐÅÏ¢
|
//Int64 sMaterID = 0;
|
sMaterID = DBUtility.ClsPub.isLong(grdSourceBill.Rows[grdSourceBill.CurrentRow.Index].Cells[HMaterIDCol].Value);
|
Sc_ICMOSortBillFun.GetProcFlowInfoByMaterID(oCn, grdProcFlow, sMaterID);
|
//
|
DBUtility.ClsPub.GetGridView(grdSource, this.Name + "grdSource", DBUtility.ClsPub.AppPath);
|
DBUtility.ClsPub.GetGridView(grdICMO, this.Name + "grdICMO", DBUtility.ClsPub.AppPath);
|
DBUtility.ClsPub.GetGridView(grdProcFlow, this.Name + "grdProcFlow", DBUtility.ClsPub.AppPath);
|
|
}
|
}
|
//µÃµ½ËùÐèÒª¹¤Ê±
|
private void GetWorkTime()
|
{
|
//BLL.Sc_ICMOAutoSortBillFun.GetWorkTimeByID(oCn, lblWorkTime, grdSourceBill, HMaterIDCol, HSourceIDCol, FixCols);
|
}
|
|
//ÉèÖÃÓÅÏȼ¶
|
private void yxj_Click(object sender, EventArgs e)
|
{
|
|
SetYXNum();
|
}
|
|
private void sb_Click(object sender, EventArgs e)
|
{
|
//°´É豸·ÖÎö
|
Sc_WorkBillSortSumBySource oSc_WorkBillSortSumBySource = new Sc_WorkBillSortSumBySource();
|
oSc_WorkBillSortSumBySource.txtHBDeptID.Tag = txtHDeptID.Tag;
|
oSc_WorkBillSortSumBySource.ShowDialog();
|
}
|
|
private void cp_Click(object sender, EventArgs e)
|
{
|
//°´²úÆ··ÖÎö
|
Sc_WorkBillSortSumByMaterial oSc_WorkBillSortSumByMaterial = new Sc_WorkBillSortSumByMaterial();
|
oSc_WorkBillSortSumByMaterial.txtHBDeptID.Tag = txtHDeptID.Tag;
|
oSc_WorkBillSortSumByMaterial.ShowDialog();
|
}
|
|
//Êý¾Ý·ÖÎö
|
private void fx_Click(object sender, EventArgs e)
|
{
|
//½»»õÆÚ·ÖÎö ±³¾°É«ÑÕÉ«·ÖÎö£¨³¬ÆÚºìÉ«£¬ÈýÌìÄÚ»ÆÉ«£¬°²È«ÂÌÉ«£©
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
DataSet oDs = new DataSet();
|
DateTime dtimePai;
|
DateTime dtimeJiao;
|
//Ñ»·grdMain£¬Ã¿¸öÈÎÎñµ¥£¬¸ù¾Ý×îºóÅųÌÈÕÆÚ£¬·ÖÎö½»»õÆÚÊÇ·ñ³åÍ»
|
for (int i = 0; i <= grdMain.Rows.Count - 1; i++)
|
{
|
for (int c = grdMain.ColumnCount - 1; c >= FixCols; c--)
|
{
|
//ÕÒµ½×î³Ù¼Æ»®ÈÕÆÚ
|
if (DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[c].Value) != "")
|
{
|
dtimePai = DBUtility.ClsPub.isDate(grdMain.Columns[c].HeaderText);
|
dtimeJiao = DBUtility.ClsPub.isDate(grdMain.Rows[i].Cells[HSecPlanEndDateCol].Value);
|
if (dtimePai <= dtimeJiao) //×îºóÅųÌÈÕÆÚСÓÚµÈÓÚ½»»õ
|
{
|
for (int m =c; m >= FixCols; m--)
|
{
|
if (DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[m].Value) != "")
|
{
|
grdMain.Rows[i].Cells[m].Style.BackColor = Color.LightGreen;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[m].Style.BackColor = Color.White;
|
}
|
}
|
break;
|
}
|
else if (dtimeJiao.AddDays(-3) <= dtimePai && dtimePai < dtimeJiao) //×îºóÅųÌÈÕÆÚ Àë½»»õ3ÌìÄÚ
|
{
|
for (int m = c; m >= FixCols; m--)
|
{
|
if (DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[m].Value) != "")
|
{
|
grdMain.Rows[i].Cells[m].Style.BackColor = Color.Gold;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[m].Style.BackColor = Color.White;
|
}
|
}
|
break;
|
}
|
else if (dtimePai > dtimeJiao) //×îºóÅųÌÈÕÆÚ´óÓÚ½»»õ
|
{
|
for (int m = c; m >= FixCols; m--)
|
{
|
if (DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[m].Value) != "")
|
{
|
grdMain.Rows[i].Cells[m].Style.BackColor = Color.Red;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[m].Style.BackColor = Color.White;
|
}
|
}
|
break;
|
}
|
}
|
}
|
}
|
//ȱÁÏ·ÖÎö
|
//дһ¸ö¹ý³Ì£¬ÅжÏÊÇ·ñ ȱÁÏ
|
for (int i = 0; i <= grdMain.Rows.Count - 1; i++)
|
{
|
oDs = oCn.RunProcReturn("exec h_p_Sc_GetNeedMaterialQty " + txtHDeptID.Tag + "," + DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HSecICMOInterIDCol].Value), "Gy_Czygl");
|
if (oDs == null || oDs.Tables[0].Rows.Count == 0)
|
{
|
for (int m = FixCols; m < grdMain.ColumnCount; m++)
|
{
|
grdMain.Rows[i].Cells[m].Style.ForeColor = Color.Black;
|
}
|
}
|
else
|
{
|
for (int m = FixCols; m < grdMain.ColumnCount; m++)
|
{
|
grdMain.Rows[i].Cells[m].Style.ForeColor = Color.Blue;
|
}
|
}
|
}
|
}
|
|
|
|
|
//Ë«»÷²é¿´ ȱÁÏÇé¿ö
|
private void grdMain_DoubleClick(object sender, EventArgs e)
|
{
|
//Sc_ICMOAutoSortBillQL oQL = new Sc_ICMOAutoSortBillQL();
|
//if (grdMain.CurrentRow == null)
|
// return;
|
//oQL.HDeptID = DBUtility.ClsPub.isLong(txtHDeptID.Tag);
|
//oQL.HICMOInterID = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[HSecICMOInterIDCol].Value);
|
//oQL.ShowDialog();
|
}
|
|
//ÈÎÎñµ¥ÉÏÉý
|
private void up_Click(object sender, EventArgs e)
|
{
|
//grdMain.ReadOnly = false;
|
|
//ÅжÏÊÇ·ñÑ¡ÖÐÐÐ £¬Ìø³ö
|
if (grdSourceBill.CurrentRow == null)
|
return;
|
//ÅжÏÊÇ·ñÊǵÚÒ»ÐÐ £¬Ìø³ö
|
if (grdSourceBill.CurrentRow.Index == 0)
|
return;
|
//ÓëÉÏÒ»ÐжԻ»
|
//Ôö¼ÓÒ»¸ö±¸ÓÃÐÐ
|
grdSourceBill.RowCount = grdSourceBill.RowCount + 1;
|
Sc_ICMOSortBillFun.ChangeGridItemUp(grdSourceBill, grdSourceBill.CurrentRow.Index);
|
//ɾ³ý±¸ÓÃÐÐ
|
grdSourceBill.RowCount = grdSourceBill.RowCount - 1;
|
|
|
}
|
|
//ÈÎÎñµ¥Ï½µ
|
private void down_Click(object sender, EventArgs e)
|
{
|
//ÅжÏÊÇ·ñÑ¡ÖÐÐÐ £¬Ìø³ö
|
if (grdSourceBill.CurrentRow == null)
|
return;
|
//ÅжÏÊÇ·ñÊǵÚÒ»ÐÐ £¬Ìø³ö
|
if (grdSourceBill.CurrentRow.Index == grdSourceBill.ColumnCount - 1)
|
return;
|
//ÓëÉÏÒ»ÐжԻ»
|
//Ôö¼ÓÒ»¸ö±¸ÓÃÐÐ
|
grdSourceBill.RowCount = grdSourceBill.RowCount + 1;
|
Sc_ICMOSortBillFun.ChangeGridItem(grdSourceBill, grdSourceBill.CurrentRow.Index);
|
//ɾ³ý±¸ÓÃÐÐ
|
grdSourceBill.RowCount = grdSourceBill.RowCount - 1;
|
}
|
|
private void msg_Click(object sender, EventArgs e)
|
{
|
BLL.OA_EmpMessageBill oEmpMessageBill;
|
Int64 lngBillKey = 0;
|
//ÕÒµ½ Ô´µ¥ÀàÐͺÍID
|
|
oEmpMessageBill = new BLL.OA_EmpMessageBill();
|
oEmpMessageBill.HRelationInterID = lngBillKey;
|
oEmpMessageBill.HRelationEntryID = lngBillKey;
|
oEmpMessageBill.HRelationBillType = ModName;
|
oEmpMessageBill.HRelationBillNo = "";
|
oEmpMessageBill.Show();
|
}
|
|
private void grdSourceBill_CellBeginEdit(object sender, DataGridViewCellCancelEventArgs e)
|
{
|
sAllowCol = "," + sAllowCol + ",";
|
int i = grdSourceBill.CurrentCell.ColumnIndex;
|
string srow = "," + i.ToString() + ",";
|
if (sAllowCol.IndexOf(srow) == -1)
|
{
|
e.Cancel = true;
|
}
|
}
|
|
DataGridViewTextBoxEditingControl EditingControl;
|
private void grdSourceBill_CellEndEdit(object sender, DataGridViewCellEventArgs e)
|
{
|
if (this.EditingControl != null) //ÊÍ·Åʼþ
|
{
|
EditingControl.KeyDown -= new KeyEventHandler(this.EditingControl_KeyDown);
|
this.EditingControl = null;
|
}
|
}
|
|
private void EditingControl_KeyDown(object sender, KeyEventArgs e)
|
{
|
//ÒµÎñ´¦Àí
|
Sub_GridKey(e.KeyValue, grdSourceBill.CurrentRow.Index, grdSourceBill.CurrentCell.ColumnIndex, EditingControl);
|
}
|
|
private void grdSourceBill_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e)
|
{
|
if (grdSourceBill.CurrentCell != null)
|
{
|
if (e.Control is DataGridViewTextBoxEditingControl)
|
{
|
this.EditingControl = (DataGridViewTextBoxEditingControl)e.Control;
|
//Ôö¼ÓίÍд¦Àí
|
this.EditingControl.KeyDown += new KeyEventHandler(this.EditingControl_KeyDown);
|
}
|
}
|
}
|
|
//ÇåÀíÒѽ᰸ÈÎÎñµ¥
|
private void ql_Click(object sender, EventArgs e)
|
{
|
if (MessageBox.Show("ÊÇ·ñÆô¶¯ÇåÀí£¿", "Ìáʾ", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.Cancel)
|
{
|
return;
|
}
|
else
|
{
|
ICMOBill_Clear();
|
}
|
}
|
|
|
private void ICMOBill_Clear()
|
{
|
// ÒÑÍ깤+ÒÑÈë¿â>¼Æ»®ÊýÁ¿ µÄÈÎÎñµ¥ ɾ³ýµô¡£
|
for (int i = grdSourceBill.Rows.Count - 1; i >= 0; i--)
|
{
|
if (DBUtility.ClsPub.isDoule(grdSourceBill.Rows[i].Cells[HRelationQtyCol].Value) >= DBUtility.ClsPub.isDoule(grdSourceBill.Rows[i].Cells[HPlanQtyCol].Value))
|
{
|
grdSourceBill.Rows.RemoveAt(i);
|
}
|
}
|
}
|
|
private void grdSourceBill_CellClick(object sender, DataGridViewCellEventArgs e)
|
{
|
SetBillRelationInfo();
|
}
|
|
private void grdMain_CellBeginEdit(object sender, DataGridViewCellCancelEventArgs e)
|
{
|
if (grdMain.CurrentCell == null)
|
{
|
e.Cancel = true;
|
}
|
int i = grdMain.CurrentCell.ColumnIndex;
|
if (i < FixCols)
|
{
|
e.Cancel = true;
|
}
|
}
|
|
private void grdSourceBill_KeyDown(object sender, KeyEventArgs e)
|
{
|
Sub_GridKey(e.KeyValue, grdSourceBill.CurrentRow.Index, grdSourceBill.CurrentCell.ColumnIndex, EditingControl);
|
}
|
}
|
}
|
