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_ICMOSub : Form
|
{
|
public Sc_MpsResultBill_ICMOSub()
|
{
|
InitializeComponent();
|
}
|
|
//³õʼ»¯Íø¸ñ
|
private void initGrid()
|
{
|
DBUtility.Xt_BaseBillFun.initGridList(grdSub, this.Name);
|
}
|
int HCheckCol = 8; //Ñ¡ÖÐÁÐ
|
int HQtyCol = 7; //ÊýÁ¿ÁÐ
|
|
public long HMPSInterID;
|
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_Sc_MpsResultBill_ICMOSubList " + HMaterID + "," + HQty, "h_p_Sc_MpsResultBill_ICMOSubList");
|
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) == 2)
|
{
|
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;
|
}
|
|
|
|
string HICMOBillNo;
|
string HPPBOMBillNo;
|
SQLHelper.ClsCNK3 oCnK3 = new SQLHelper.ClsCNK3();
|
try
|
{
|
HICMOBillNo = DBUtility.Xt_BaseBillFun.get_MaxBillNo_K3("85", oCnK3);
|
HPPBOMBillNo = DBUtility.Xt_BaseBillFun.get_MaxBillNo_K3("88", 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 HICMOInterID = 0;
|
Ds1 = oCnK3.RunProcReturn("declare @InterID int set @InterID=0 exec GetICMaxNum 'ICMO', @InterID output, 1, " + HBillerID.ToString() + " select ltrim(@InterID)", "GetICMaxNum");
|
if (Ds1.Tables[0].Rows.Count != 0)
|
{
|
HICMOInterID = DBUtility.ClsPub.isLong(Ds1.Tables[0].Rows[0][0]);
|
}
|
if (HICMOInterID == 0)
|
{
|
MessageBox.Show("Éú³ÉÈÎÎñµ¥ÄÚÂëʧ°Ü£¡");
|
return;
|
}
|
|
DataSet Ds2;
|
//µÃµ½mainid
|
long HPPBOMInterID = 0;
|
Ds2 = oCnK3.RunProcReturn("declare @InterID int set @InterID=0 exec GetICMaxNum 'PPBOM', @InterID output, 1, " + HBillerID.ToString() + " select ltrim(@InterID)", "GetICMaxNum");
|
if (Ds2.Tables[0].Rows.Count != 0)
|
{
|
HPPBOMInterID = DBUtility.ClsPub.isLong(Ds2.Tables[0].Rows[0][0]);
|
}
|
if (HPPBOMInterID == 0)
|
{
|
MessageBox.Show("Éú³ÉͶÁϵ¥ÄÚÂëʧ°Ü£¡");
|
return;
|
}
|
|
oCnK3.BeginTran();
|
for (int i = 0; i < grdSub.Rows.Count; i++)
|
{
|
if (DBUtility.ClsPub.isBool(grdSub.Rows[i].Cells[HCheckCol].Value) == true)
|
{
|
long HSubMaterID = DBUtility.ClsPub.isLong(grdSub.Rows[i].Cells[Fun_GetColSub("hmaterid")].Value);
|
double HSubQty = DBUtility.ClsPub.isDoule(grdSub.Rows[i].Cells[Fun_GetColSub("Éú²úÊýÁ¿")].Value);
|
//²ÎÊý MPSÄÚÂ룬ÊýÁ¿£¬ÖƵ¥ÈË£¬ÈÎÎñµ¥ÄÚÂ룬ÈÎÎñµ¥ºÅ£¬Í¶Áϵ¥ÄÚÂ룬ͶÁϵ¥ºÅ
|
oCnK3.RunProc("exec h_p_Sc_MpsResultBill_ICMOSub " + HMPSInterID + "," + HSubQty + "," + HBillerID + "," + HICMOInterID + ",'" + HICMOBillNo + "'," + HPPBOMInterID + ",'" + HPPBOMBillNo + "'," + HSubMaterID);
|
|
}
|
}
|
|
oCnK3.Commit();
|
}
|
catch (Exception ex)
|
{
|
oCnK3.RollBack();
|
throw (ex);
|
}
|
|
MessageBox.Show("ÈÎÎñµ¥ºÅ£º" + HICMOBillNo + "£¬Í¶Áϵ¥ºÅ£º" + HPPBOMBillNo + "£¬±£´æÍê±Ï£¡");
|
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();
|
}
|
}
|
}
|
