using System;
|
using System.Collections.Generic;
|
using System.ComponentModel;
|
using System.Data;
|
using System.Drawing;
|
using System.Text;
|
using System.Windows.Forms;
|
|
namespace CostM
|
{
|
public partial class Pay_AccPayMentDayBill4 : Form
|
{
|
public int HCode;
|
public string HPathBakServer;
|
public string HHardDisk;
|
public int HDelDays;
|
public string HBMaterNumber;
|
public string HEMaterNumber;
|
public int HMaterType; //ÎïÁ϶Î
|
public int HSetType; //ºËË㷽ʽ
|
public int HYear; //»á¼ÆÄê
|
public int HPeriod; //»á¼ÆÔÂ
|
public DateTime HBDate; //¿ªÊ¼ÈÕÆÚ
|
public DateTime HEDate; //½áÊøÈÕÆÚ
|
public DateTime HDate; //µ±Ç°ºËËãÈÕÆÚ
|
public long HGroupID; //µ±Ç°ºËËã°à×é
|
public long HEmpID; //µ±Ç°ºËËãÈËÔ±
|
public double HMoney; //µ±Ç°ºËËãÈËÔ±¹¤×Ê
|
public DAL.ClsPay_PayMentDayBill BillNew = new DAL.ClsPay_PayMentDayBill(); //¶ÔÓ¦µ¥¾ÝÀà
|
public Pay_AccPayMentDayBill4()
|
{
|
InitializeComponent();
|
}
|
|
private void Pay_AccPayMentDayBill4_Load(object sender, EventArgs e)
|
{
|
timer1.Enabled = true;
|
}
|
|
private void button1_Click(object sender, EventArgs e)
|
{
|
HCode=1;
|
this.Hide();
|
}
|
|
private void button2_Click(object sender, EventArgs e)
|
{
|
HCode = 2;
|
this.Hide();
|
}
|
|
private void button3_Click(object sender, EventArgs e)
|
{
|
HCode = 3;
|
this.Hide();
|
}
|
|
private void timer1_Tick(object sender, EventArgs e)
|
{
|
timer1.Enabled = false;
|
SetMateStdPrice();
|
|
}
|
//ÅжϺËËãÐÅÏ¢
|
private bool AllowBegin()
|
{
|
return true;
|
}
|
//ºËËã
|
private void SetMateStdPrice()
|
{
|
if (!AllowBegin())
|
{
|
MessageBox.Show("ÄúÉèÖúËËãÐÅÏ¢ÓдíÎ󣬲»ÄܽøÐкËË㣡ÇëÓë¹ÜÀíÔ±ÁªÏµ");
|
return;
|
}
|
//ºËËãÀàÐÍ
|
switch (HSetType)
|
{
|
case 0://¼ÓȨ
|
SetMateStdPrice_JQ();
|
break;
|
case 1://Òƶ¯¼ÓȨ
|
break;
|
case 2://×îÐÂ
|
SetMateStdPrice_ZuiXin();
|
break;
|
case 3://×îµÍ
|
break;
|
case 4://×î¸ß
|
break;
|
default:
|
break;
|
}
|
|
}
|
//¼ÓȨƽ¾ù
|
private void SetMateStdPrice_JQ()
|
{
|
//µÃµ½ºËËãµÄ ÎïÁ϶Î
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
DataSet oDs;
|
oDs = oCn.RunProcReturn("exec h_p_CB_getMaterialAToB '" + DBUtility.ClsPub.CBCurBDate.ToShortDateString() + "','" + DBUtility.ClsPub.CBCurEDate.ToShortDateString() + "','" + this.HBMaterNumber.Trim() + "','" + this.HEMaterNumber.Trim() + "'," + this.HMaterType.ToString(), "gy_czygl");
|
if (oDs == null || oDs.Tables[0].Rows.Count == 0)
|
{
|
MessageBox.Show("´íÎóµÄÎïÁ϶Σ¡");
|
return;
|
}
|
pb1.Maximum = oDs.Tables[0].Rows.Count;
|
pb1.Value = 0;
|
for (int i = 0; i < oDs.Tables[0].Rows.Count; i++)
|
{
|
System.Windows.Forms.Application.DoEvents();
|
//ºËËã±¾ÎïÁÏ
|
oCn.RunProc("exec h_p_K3_AccMateOutPrice " + DBUtility.ClsPub.CBCurYear.ToString() + "," + DBUtility.ClsPub.CBCurPeriod.ToString() + ",'" + DBUtility.ClsPub.CBCurBDate.ToShortDateString() + "','" + DBUtility.ClsPub.CBCurEDate.ToShortDateString() + "'," + DBUtility.ClsPub.isStrNull(oDs.Tables[0].Rows[i]["HMaterID"]));
|
System.Windows.Forms.Application.DoEvents();
|
pb1.Value = i + 1;
|
lblHCount.Text = pb1.Value.ToString() + "/" + pb1.Maximum.ToString();
|
System.Windows.Forms.Application.DoEvents();
|
}
|
}
|
//×îе¥¼Û
|
private void SetMateStdPrice_ZuiXin()
|
{
|
HBDate = DBUtility.ClsPub.isDate(HYear + "-" + HPeriod + "-01");
|
HEDate = HBDate.AddMonths(1);
|
|
//µÃµ½ºËËãµÄ ¹¤×÷×é
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
DataSet oDs;
|
DataSet oDsDate;
|
DataSet oDsOld;
|
DataSet oDsJT;
|
DataSet oDsDR;
|
oDs = oCn.RunProcReturn("select * from Gy_ClassTimePrjGroup where hstopflag=0", "Gy_ClassTimePrjGroup");
|
if (oDs == null || oDs.Tables[0].Rows.Count == 0)
|
{
|
MessageBox.Show("´íÎóµÄ¹¤×÷×飡");
|
return;
|
}
|
oDsDate = oCn.RunProcReturn("select dateadd(dd,number,'" + HBDate + "') AS hdate from master..spt_values where type='p' and dateadd(dd,number,'" + HBDate + "')<'"+ HEDate+"'","gy_czygl");
|
pb1.Maximum = oDsDate.Tables[0].Rows.Count;
|
pb1.Value = 0;
|
for (int j = 0; j < oDsDate.Tables[0].Rows.Count; j++)
|
{
|
HDate = DBUtility.ClsPub.isDate(oDsDate.Tables[0].Rows[j][0]);
|
System.Windows.Forms.Application.DoEvents();
|
for (int i = 0; i < oDs.Tables[0].Rows.Count; i++)
|
{
|
System.Windows.Forms.Application.DoEvents();
|
//ºËËã¸Ã¹¤×÷×éÿÈÕ¹¤×Ê
|
oDsJT=oCn.RunProcReturn("exec h_p_Pay_AccPayMentDayBillJT '" + HDate + "'," + DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[i]["HItemID"]),"Pay_PayMentDayBillMain");
|
if (oDsJT.Tables[0].Rows.Count > 0)
|
{
|
for (int k = 0; k < oDsJT.Tables[0].Rows.Count; k++)
|
{
|
System.Windows.Forms.Application.DoEvents();
|
HEmpID = DBUtility.ClsPub.isLong(oDsJT.Tables[0].Rows[k]["HEmpID"]);
|
HGroupID = DBUtility.ClsPub.isLong(oDsJT.Tables[0].Rows[k]["HGroupID"]);
|
HMoney = DBUtility.ClsPub.isDoule(oDsJT.Tables[0].Rows[k]["HMoney"]);
|
oDsOld = oCn.RunProcReturn("select a.HInterID from Pay_PayMentDayBillMain a inner join Pay_PayMentDayBillSub b on a.hinterid=b.hinterid where HDate='" + HDate + "' and b.HEmpID=" + HEmpID, "Pay_PayMentDayBillMain");
|
if (oDsOld.Tables[0].Rows.Count > 0)
|
{
|
oCn.RunProc("delete Pay_PayMentDayBillMain where HInterID=" + DBUtility.ClsPub.isLong(oDsOld.Tables[0].Rows[0][0]));
|
oCn.RunProc("delete Pay_PayMentDayBillSub where HInterID=" + DBUtility.ClsPub.isLong(oDsOld.Tables[0].Rows[0][0]));
|
}
|
DAL.ClsPay_PayMentDayBill oMain = new DAL.ClsPay_PayMentDayBill();
|
oMain.omodel.HBillNo = DBUtility.ClsPub.CreateBillCode(BillNew.BillType, ref DBUtility.ClsPub.sExeReturnInfo, true);
|
oMain.omodel.HDate = HDate;
|
oMain.omodel.HDeptID = 0;
|
oMain.omodel.HDeptName = "";
|
oMain.omodel.HExplanation = "";
|
oMain.omodel.HGroupID = HGroupID;
|
oMain.omodel.HGroupName = "";
|
oMain.omodel.HInnerBillNo = "";
|
oMain.omodel.HMakeDate = DBUtility.ClsPub.isStrNull(DateTime.Now);
|
oMain.omodel.HMaker = "admin";
|
oMain.omodel.HPeriod = HPeriod;
|
oMain.omodel.HRemark = "";
|
oMain.omodel.HYear = HYear;
|
|
oMain.DetailColl = new List<Model.ClsPay_PayMentDayBillSub>();
|
Model.ClsPay_PayMentDayBillSub oSub = new Model.ClsPay_PayMentDayBillSub();
|
oSub.HEmpID = HEmpID;
|
oSub.HEntryID = 1;
|
|
oSub.HRemark = "";
|
oSub.HSourceInterID = 0;
|
oSub.HSourceEntryID = 0;
|
oSub.HSourceBillType = "";
|
oSub.HSourceBillNo ="";
|
oSub.HRelationQty =0;
|
oSub.HRelationMoney = 0;
|
oSub.HCloseMan = "";
|
oSub.HEntryCloseDate = DBUtility.ClsPub.isDate("");
|
oSub.HCloseType = false;
|
|
|
oSub.HPostID = DBUtility.ClsPub.isLong(oDsJT.Tables[0].Rows[k]["HPostID"]);
|
|
oSub.HEmpName = "";
|
oSub.HEmpType = DBUtility.ClsPub.isStrNull(oDsJT.Tables[0].Rows[k]["HEmpType"]);
|
//
|
oSub.HPiecePay = DBUtility.ClsPub.isSingle(HMoney);
|
oSub.HTimesPay = 0;
|
|
oSub.HWorkTimes = DBUtility.ClsPub.isSingle(oDsJT.Tables[0].Rows[k]["HTimes"]);
|
oSub.HPayTotal = DBUtility.ClsPub.isSingle(HMoney);
|
if (DBUtility.ClsPub.isSingle(oDsJT.Tables[0].Rows[k]["HTimes"]) == 0)
|
{
|
oSub.HAvghourPay = 0;
|
}
|
else
|
{
|
oSub.HAvghourPay = DBUtility.ClsPub.isSingle(HMoney) / DBUtility.ClsPub.isSingle(oDsJT.Tables[0].Rows[k]["HTimes"]);
|
}
|
oMain.DetailColl.Add(oSub);
|
if (!oMain.AddBill(ref DBUtility.ClsPub.sExeReturnInfo))
|
{
|
MessageBox.Show("±£´æʧ°Ü!ÔÒò:" + DBUtility.ClsPub.sExeReturnInfo, "Ìáʾ");
|
return;
|
}
|
}
|
}
|
}
|
oDsDR = oCn.RunProcReturn("exec h_p_Pay_AccPayMentDayBillDR '" + HDate + "'", "Pay_PayMentDayBillMain");
|
if (oDsDR.Tables[0].Rows.Count > 0)
|
{
|
for (int p = 0; p < oDsDR.Tables[0].Rows.Count; p++)
|
{
|
System.Windows.Forms.Application.DoEvents();
|
HEmpID = DBUtility.ClsPub.isLong(oDsDR.Tables[0].Rows[p]["HEmpID"]);
|
HGroupID = DBUtility.ClsPub.isLong(oDsDR.Tables[0].Rows[p]["HGroupID"]);
|
HMoney = DBUtility.ClsPub.isDoule(oDsDR.Tables[0].Rows[p]["HMoney"]);
|
oDsOld = oCn.RunProcReturn("select a.HInterID from Pay_PayMentDayBillMain a inner join Pay_PayMentDayBillSub b on a.hinterid=b.hinterid where HDate='" + HDate + "' and b.HEmpID=" + HEmpID, "Pay_PayMentDayBillMain");
|
if (oDsOld.Tables[0].Rows.Count > 0)
|
{
|
oCn.RunProc("delete Pay_PayMentDayBillMain where HInterID=" + DBUtility.ClsPub.isLong(oDsOld.Tables[0].Rows[0][0]));
|
oCn.RunProc("delete Pay_PayMentDayBillSub where HInterID=" + DBUtility.ClsPub.isLong(oDsOld.Tables[0].Rows[0][0]));
|
}
|
DAL.ClsPay_PayMentDayBill oMain = new DAL.ClsPay_PayMentDayBill();
|
oMain.omodel.HBillNo = DBUtility.ClsPub.CreateBillCode(BillNew.BillType, ref DBUtility.ClsPub.sExeReturnInfo, true);
|
oMain.omodel.HDate = HDate;
|
oMain.omodel.HDeptID = 0;
|
oMain.omodel.HDeptName = "";
|
oMain.omodel.HExplanation = "";
|
oMain.omodel.HGroupID = HGroupID;
|
oMain.omodel.HGroupName = "";
|
oMain.omodel.HInnerBillNo = "";
|
oMain.omodel.HMakeDate = DBUtility.ClsPub.isStrNull(DateTime.Now);
|
oMain.omodel.HMaker = "admin";
|
oMain.omodel.HPeriod = HPeriod;
|
oMain.omodel.HRemark = "";
|
oMain.omodel.HYear = HYear;
|
|
oMain.DetailColl = new List<Model.ClsPay_PayMentDayBillSub>();
|
Model.ClsPay_PayMentDayBillSub oSub = new Model.ClsPay_PayMentDayBillSub();
|
oSub.HEmpID = HEmpID;
|
oSub.HEntryID = 1;
|
|
oSub.HRemark = "";
|
oSub.HSourceInterID = 0;
|
oSub.HSourceEntryID = 0;
|
oSub.HSourceBillType = "";
|
oSub.HSourceBillNo = "";
|
oSub.HRelationQty = 0;
|
oSub.HRelationMoney = 0;
|
oSub.HCloseMan = "";
|
oSub.HEntryCloseDate = DBUtility.ClsPub.isDate("");
|
oSub.HCloseType = false;
|
|
|
oSub.HPostID = DBUtility.ClsPub.isLong(oDsDR.Tables[0].Rows[p]["HPostID"]);
|
|
oSub.HEmpName = "";
|
oSub.HEmpType = DBUtility.ClsPub.isStrNull(oDsDR.Tables[0].Rows[p]["HEmpType"]);
|
//
|
oSub.HPiecePay = DBUtility.ClsPub.isSingle(HMoney);
|
oSub.HTimesPay = 0;
|
|
oSub.HWorkTimes = DBUtility.ClsPub.isSingle(oDsDR.Tables[0].Rows[p]["HTimes"]);
|
oSub.HPayTotal = DBUtility.ClsPub.isSingle(HMoney);
|
if (DBUtility.ClsPub.isSingle(oDsDR.Tables[0].Rows[p]["HTimes"]) == 0)
|
{
|
oSub.HAvghourPay = 0;
|
}
|
else
|
{
|
oSub.HAvghourPay = DBUtility.ClsPub.isSingle(HMoney) / DBUtility.ClsPub.isSingle(oDsDR.Tables[0].Rows[p]["HTimes"]);
|
}
|
oMain.DetailColl.Add(oSub);
|
if (!oMain.AddBill(ref DBUtility.ClsPub.sExeReturnInfo))
|
{
|
MessageBox.Show("±£´æʧ°Ü!ÔÒò:" + DBUtility.ClsPub.sExeReturnInfo, "Ìáʾ");
|
return;
|
}
|
}
|
}
|
System.Windows.Forms.Application.DoEvents();
|
pb1.Value = j + 1;
|
lblHCount.Text = pb1.Value.ToString() + "/" + pb1.Maximum.ToString();
|
lblHMaterName.Text = HDate.ToString();
|
System.Windows.Forms.Application.DoEvents();
|
}
|
}
|
}
|
}
|
