using System;
|
using System.Collections.Generic;
|
using System.ComponentModel;
|
using System.Data;
|
using System.Drawing;
|
using System.Text;
|
using System.Windows.Forms;
|
|
namespace WorkM
|
{
|
public partial class Sc_MpsResultBill_CG : Form
|
{
|
public Sc_MpsResultBill_CG()
|
{
|
InitializeComponent();
|
}
|
|
//³õʼ»¯Íø¸ñ
|
private void initGrid()
|
{
|
DBUtility.Xt_BaseBillFun.initGridList(grdSub, this.Name);
|
}
|
int HCheckCol = 10; //Ñ¡ÖÐÁÐ
|
int HQtyCol = 9; //ÊýÁ¿ÁÐ
|
|
public long HSeHInterID;
|
public long HSeHEntryID;
|
public long HDeptID;
|
public long HEmpID;
|
|
public long HMaterID;
|
public double HQty;
|
|
private void grdSub_Show()
|
{
|
grdSub.DataSource = null;
|
grdSub.Columns.Clear();
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
DataSet Ds1;
|
|
Ds1 = oCn.RunProcReturn("exec h_p_Xs_SeOrderBillMulLevBOMQuery " + HMaterID + "," + HQty + "," + HSeHInterID + "," + HSeHEntryID, "h_p_Xs_SeOrderBillMulLevBOMQuery");
|
grdSub.DataSource = Ds1.Tables[0].DefaultView;
|
|
DataGridViewCheckBoxColumn columncb = new DataGridViewCheckBoxColumn();
|
columncb.HeaderText = "Ñ¡Ôñ";
|
columncb.Name = "cb_check";
|
columncb.TrueValue = true;
|
columncb.FalseValue = false;
|
//column9.DataPropertyName = "IsScienceNature";
|
columncb.DataPropertyName = "IsChecked";
|
grdSub.Columns.Add(columncb);
|
|
HQtyCol = Fun_GetColSub("ÉêÇëÊýÁ¿");
|
HCheckCol = grdSub.ColumnCount - 1;
|
//¶³½á
|
int FrCol = 0;
|
string s = "";
|
DBUtility.Xt_BaseBillFun.DisplayGrid(grdSub, this.Name, s, FrCol);
|
grdSub.ReadOnly = false;
|
}
|
|
private void grdSub_CellBeginEdit(object sender, DataGridViewCellCancelEventArgs e)
|
{
|
if (e.ColumnIndex != HQtyCol)
|
{
|
e.Cancel = true;
|
}
|
}
|
|
private void grdSub_CellClick(object sender, DataGridViewCellEventArgs e)
|
{
|
if (grdSub.CurrentRow == null)
|
return;
|
|
if (e.ColumnIndex == HCheckCol && DBUtility.ClsPub.isInt(grdSub.Rows[grdSub.CurrentRow.Index].Cells[Fun_GetColSub("herpclsid")].Value) == 1)
|
{
|
if (DBUtility.ClsPub.isBool(grdSub.Rows[grdSub.CurrentRow.Index].Cells[e.ColumnIndex].Value) == false)
|
{
|
grdSub.Rows[grdSub.CurrentRow.Index].Cells[e.ColumnIndex].Value = true;
|
}
|
else
|
{
|
grdSub.Rows[grdSub.CurrentRow.Index].Cells[e.ColumnIndex].Value = false;
|
}
|
}
|
}
|
|
private void bclk_Click(object sender, EventArgs e)
|
{
|
|
DBUtility.Xt_BaseBillFun.SaveGrid(grdSub, this.Name);
|
}
|
|
private void mrlk_Click(object sender, EventArgs e)
|
{
|
|
DBUtility.Xt_BaseBillFun.DefaultGridView(grdSub, this.Name);
|
}
|
|
private void cg_Click(object sender, EventArgs e)
|
{
|
string HBillNo;
|
//ÅжÏÓÐûÓÐÑ¡ÖÐÐÐ
|
bool isCheck = false;
|
for (int i = 0; i < grdSub.Rows.Count; i++)
|
{
|
if (DBUtility.ClsPub.isBool(grdSub.Rows[i].Cells[HCheckCol].Value) == true)
|
{
|
if (DBUtility.ClsPub.isDoule(grdSub.Rows[i].Cells[Fun_GetColSub("ÉêÇëÊýÁ¿")].Value) > DBUtility.ClsPub.isDoule(grdSub.Rows[i].Cells[Fun_GetColSub("δÉêÇëÊýÁ¿")].Value))
|
{
|
MessageBox.Show("ÎïÁÏ´úÂ룺" + DBUtility.ClsPub.isStrNull(grdSub.Rows[i].Cells[Fun_GetColSub("ÎïÁÏ´úÂë")].Value) + "ÉêÇëÊýÁ¿²»ÄÜ´óÓÚδÉêÇëÊýÁ¿£¡", "Ìáʾ");
|
return;
|
}
|
isCheck = true;
|
}
|
}
|
if (isCheck == false)
|
{
|
MessageBox.Show("ûÓÐÑ¡ÔñÐèÒª²É¹ºµÄÎïÁÏ£¡", "Ìáʾ");
|
return;
|
}
|
|
|
long HSourceInterID = HSeHInterID;
|
long HSourceEntryID = HSeHEntryID;
|
string HSourceBillNo = DBUtility.ClsPub.isStrNull(txtHSeBillNo.Text);
|
string HSourceTranType = "81";
|
SQLHelper.ClsCNK3 oCnK3 = new SQLHelper.ClsCNK3();
|
try
|
{
|
HBillNo = DBUtility.Xt_BaseBillFun.get_MaxBillNo_K3("70", oCnK3);
|
|
//µÃµ½Óû§ID
|
long HBillerID;
|
DataSet DsBiller;
|
string HSourceBillType = "";
|
DsBiller = oCnK3.RunProcReturn("select top 1 fuserid from t_User where fname='" + DBUtility.ClsPub.CurUserName + "'", "t_User");
|
if (DsBiller.Tables[0].Rows.Count != 0)
|
{
|
HBillerID = DBUtility.ClsPub.isLong(DsBiller.Tables[0].Rows[0][0]);
|
}
|
else
|
{
|
HBillerID = 16394;
|
}
|
//
|
DataSet Ds1;
|
//µÃµ½mainid
|
long HInterID = 0;
|
Ds1 = oCnK3.RunProcReturn("declare @InterID int set @InterID=0 exec GetICMaxNum 'POrequest', @InterID output, 1, " + HBillerID.ToString() + " select ltrim(@InterID)", "GetICMaxNum");
|
if (Ds1.Tables[0].Rows.Count != 0)
|
{
|
HInterID = DBUtility.ClsPub.isLong(Ds1.Tables[0].Rows[0][0]);
|
}
|
if (HInterID == 0)
|
{
|
MessageBox.Show("Éú³ÉHInterIDʧ°Ü£¡");
|
return;
|
}
|
|
oCnK3.BeginTran();
|
int j = 0;
|
long HMaterID;
|
long HUnitID;
|
double HQty;
|
for (int i = 0; i < grdSub.Rows.Count; i++)
|
{
|
if (DBUtility.ClsPub.isBool(grdSub.Rows[i].Cells[HCheckCol].Value) == true)
|
{
|
j = j + 1;
|
HMaterID = DBUtility.ClsPub.isLong(grdSub.Rows[i].Cells[Fun_GetColSub("hmaterid")].Value);
|
HUnitID = DBUtility.ClsPub.isLong(grdSub.Rows[i].Cells[Fun_GetColSub("HUnitID")].Value);
|
HQty = DBUtility.ClsPub.isLong(grdSub.Rows[i].Cells[Fun_GetColSub("ÉêÇëÊýÁ¿")].Value);
|
|
////»ªÔ£
|
//oCnK3.RunProc("INSERT INTO POrequestEntry " +
|
// "(FInterID,FEntryID,FBrNo,FItemID,FAuxPropID,FQty,FUnitID,Fauxqty" +
|
// ",FSecCoefficient,FSecQty,FAPurchTime,FBOMCategory,FBomInterID,Fuse" +
|
// ",FSupplyID,FFetchTime,FPlanOrderInterID,FSourceBillNo,FSourceTranType" +
|
// ",FSourceInterId,FSourceEntryID,FMrpLockFlag,FPlanMode,FIsInquiry,FMTONo) " +
|
// "Values (" + HInterID + "," + j + ",'0'," + HMaterID + ",0," + HQty + "," + HUnitID + "," + HQty +
|
// ",0,0,CONVERT(CHAR(10),GETDATE(),120),0,0,''" +
|
// ",0,CONVERT(CHAR(10),GETDATE(),120),0,'" + HSourceBillNo + "'," + HSourceTranType +
|
// "," + HSourceInterID + "," + HSourceEntryID + ",0,14036,0,'' )");
|
|
//±¾µØ
|
oCnK3.RunProc("INSERT INTO POrequestEntry " +
|
"(FInterID,FEntryID,FBrNo,FItemID,FAuxPropID,FQty,FUnitID,Fauxqty" +
|
",FSecCoefficient,FSecQty,FAPurchTime,FBomInterID,Fuse" +
|
",FSupplyID,FFetchTime,FPlanOrderInterID,FSourceBillNo,FSourceTranType" +
|
",FSourceInterId,FSourceEntryID,FMrpLockFlag,FPlanMode,FMTONo) " +
|
"Values (" + HInterID + "," + j + ",'0'," + HMaterID + ",0," + HQty + "," + HUnitID + "," + HQty +
|
",0,0,CONVERT(CHAR(10),GETDATE(),120),0,''" +
|
",0,CONVERT(CHAR(10),GETDATE(),120),0,'" + HSourceBillNo + "'," + HSourceTranType +
|
"," + HSourceInterID + "," + HSourceEntryID + ",0,14036,'' )");
|
}
|
}
|
//////»ªÔ£
|
//oCnK3.RunProc("INSERT INTO POrequest" +
|
// "(FInterID,FBillNo,FBrNo,FTranType,FCancellation,FStatus,Fdate" +
|
// ",FDeptID,FBizType,Fnote,FRequesterID,FCheckTime,FBillerID,FMRP" +
|
// ",FMultiCheckDate1,FMultiCheckDate2,FMultiCheckDate3" +
|
// ",FMultiCheckDate4,FMultiCheckDate5,FMultiCheckDate6" +
|
// ",FSelTranType,FPrintCount,FPlanConfirmed,FPlanCategory" +
|
// ",FGeneratePurBudQty,FHeadSelfP0131,FHeadSelfP0133,FHeadSelfP0132) " +
|
// "Values (" + HInterID + ",'" + HBillNo + "','0',70,0,0,CONVERT(CHAR(10),GETDATE(),120) " +
|
// "," + HDeptID + ",12510,''," + HEmpID + ",Null," + HBillerID + ",0" +
|
// ",Null,Null,Null,Null,Null,Null" +
|
// ",81,0,0,'1'" +
|
// ",0,40274,'','')");
|
|
//±¾µØ
|
oCnK3.RunProc("INSERT INTO POrequest" +
|
"(FInterID,FBillNo,FBrNo,FTranType,FCancellation,FStatus,Fdate" +
|
",FDeptID,FBizType,Fnote,FRequesterID,FCheckTime,FBillerID,FMRP" +
|
",FMultiCheckDate1,FMultiCheckDate2,FMultiCheckDate3" +
|
",FMultiCheckDate4,FMultiCheckDate5,FMultiCheckDate6" +
|
",FSelTranType,FPlanConfirmed" +
|
",FGeneratePurBudQty) " +
|
"Values (" + HInterID + ",'" + HBillNo + "','0',70,0,0,CONVERT(CHAR(10),GETDATE(),120) " +
|
"," + HDeptID + ",12510,''," + HBillerID + ",Null," + HBillerID + ",0" +
|
",Null,Null,Null,Null,Null,Null" +
|
",81,0" +
|
",0)");
|
|
oCnK3.Commit();
|
}
|
catch (Exception ex)
|
{
|
oCnK3.RollBack();
|
throw (ex);
|
}
|
|
MessageBox.Show("µ¥¾ÝºÅ£º" + HBillNo + "£¬±£´æÍê±Ï£¡");
|
this.Close();
|
|
}
|
|
private void sx_Click(object sender, EventArgs e)
|
{
|
grdSub_Show();
|
}
|
|
private void tc_Click(object sender, EventArgs e)
|
{
|
this.Close();
|
}
|
|
private Int32 Fun_GetColSub(string sCol)
|
{
|
return DBUtility.Xt_BaseBillFun.Fun_GetCol(sCol, grdSub);
|
}
|
|
private void timer1_Tick(object sender, EventArgs e)
|
{
|
timer1.Enabled = false;
|
initGrid();
|
grdSub_Show();
|
}
|
}
|
}
|
