using System;
|
using System.Collections.Generic;
|
using System.ComponentModel;
|
using System.Data;
|
using System.Drawing;
|
using System.Text;
|
using System.Windows.Forms;
|
|
namespace BaseSet
|
{
|
public partial class Gy_DataIn_ProcessPrice :BLL.Gy_DataInTmp
|
{
|
public Gy_DataIn_ProcessPrice()
|
{
|
InitializeComponent();
|
}
|
|
public int HCollectIDCol = 1; //²É¼¯Æ÷ÄÚÂë
|
public int HRoomIDCol = 5; //Òµ»§ÄÚÂë
|
public int HBeginDateCol = 13; //¿ªÊ¼ÈÕÆÚ
|
public int HEndDateCol = 10; //½áÊøÈÕÆÚ
|
public int HItMoneyIDCol = 5; //·ÑÓÃÏîÄ¿
|
public int HQtyCol = 6; //ÊýÁ¿
|
public int HPriceCol = 7; //µ¥¼Û
|
public int HMoneyCol = 8; //½ð¶î
|
public int HBeginBalanceCol = 12; //¿ªÊ¼ÊýÖµ
|
public int HEndBalanceCol = 9; //½áÊøÊýÖµ
|
//
|
public const int HBeginRow = 2; //ÓÐЧÊý¾Ý£¬¿ªÊ¼ÐÐÊý
|
//
|
|
//
|
//public DAL.ClsGy_Process_Ctl oProc = new DAL.ClsGy_Process_Ctl();
|
//public DAL.ClsGy_Process_View oProcHlp = new DAL.ClsGy_Process_View();
|
//public DAL.ClsGy_Department_View oFactory = new DAL.ClsGy_Department_View();
|
|
public DAL.ClsGy_ProcPrice_Ctl BillNew = new DAL.ClsGy_ProcPrice_Ctl();
|
//DAL.ClsGy_Material_Ctl oMater = new DAL.ClsGy_Material_Ctl();
|
//DAL.ClsGy_Material_View oMaterHlp = new DAL.ClsGy_Material_View();
|
|
DAL.ClsIF_Process_View oProc = new DAL.ClsIF_Process_View();
|
DAL.ClsIF_Material_View oMater = new DAL.ClsIF_Material_View();
|
DAL.ClsIF_Source_View oSource = new DAL.ClsIF_Source_View();
|
DAL.ClsIF_Department_View oDept = new DAL.ClsIF_Department_View();
|
|
/// <summary>
|
/// ³õʼ»¯½çÃæ
|
/// </summary>
|
public override void initData()
|
{
|
base.initData();
|
base.sSheetName = "¹¤Ðò¹¤¼Û";
|
base.ModRightName = "Gy_DataIn_ProcessPrice";
|
base.ModRightNameCheck = base.ModRightName + base.ModRightNameCheck;
|
base.ModRightNameClose = base.ModRightName + base.ModRightNameClose;
|
base.ModRightNameDelete = base.ModRightName + base.ModRightNameDelete;
|
base.ModRightNameEdit = base.ModRightName + base.ModRightNameEdit;
|
base.ModRightNameMoney = base.ModRightName + base.ModRightNameMoney;
|
base.ModRightNameQty = base.ModRightName + base.ModRightNameQty;
|
base.ModCaption = "¹¤Ðò¹¤¼Û";
|
this.Text = base.ModCaption;
|
lblCaption.Text = base.ModCaption;
|
//
|
DBUtility.Gy_BaseFun.SetComboxYear(cmbHYear);
|
DBUtility.Gy_BaseFun.SetComboxPeriod(cmbHPeriod);
|
//
|
}
|
|
public override void Sub_DataIn()
|
{
|
int sMaterNumberCol = DBUtility.Gy_BaseFun.Fun_GetCol("²úÆ·´úÂë", grdMain);
|
int sMaterNameCol = DBUtility.Gy_BaseFun.Fun_GetCol("²úÆ·Ãû³Æ", grdMain);
|
int sModelCol = DBUtility.Gy_BaseFun.Fun_GetCol("¹æ¸ñÐͺÅ", grdMain);
|
int sProcNumberCol = DBUtility.Gy_BaseFun.Fun_GetCol("¹¤Ðò´úÂë", grdMain);
|
int sProcNameCol = DBUtility.Gy_BaseFun.Fun_GetCol("¹¤Ðò", grdMain);
|
int sSourceNumberCol = DBUtility.Gy_BaseFun.Fun_GetCol("×ÊÔ´´úÂë", grdMain);
|
int sSourceNameCol = DBUtility.Gy_BaseFun.Fun_GetCol("Éú²ú×ÊÔ´", grdMain);
|
int sPriceCol = DBUtility.Gy_BaseFun.Fun_GetCol("µ¥¼Û", grdMain);
|
int sFixPriceCol = DBUtility.Gy_BaseFun.Fun_GetCol("¶¨¶î", grdMain);
|
int sBadPriceCol = DBUtility.Gy_BaseFun.Fun_GetCol("²»Á¼¿Û¿î", grdMain);
|
int sWasterPriceCol = DBUtility.Gy_BaseFun.Fun_GetCol("±¨·Ï¿Û¿î", grdMain);
|
int sDeptNumberCol = DBUtility.Gy_BaseFun.Fun_GetCol("²¿ÃÅ´úÂë", grdMain);
|
int sDeptNameCol = DBUtility.Gy_BaseFun.Fun_GetCol("²¿ÃÅ", grdMain);
|
int sCostFlagCol = DBUtility.Gy_BaseFun.Fun_GetCol("Á÷תĬÈÏ", grdMain);
|
int sPayFlagCol = DBUtility.Gy_BaseFun.Fun_GetCol("¹¤×ÊĬÈÏ", grdMain);
|
int sFlowFlagCol = DBUtility.Gy_BaseFun.Fun_GetCol("³É±¾Ä¬ÈÏ", grdMain);
|
int sBeginDateCol = DBUtility.Gy_BaseFun.Fun_GetCol("ÉúЧÈÕÆÚ", grdMain);
|
int sEndDateCol = DBUtility.Gy_BaseFun.Fun_GetCol("ʧЧÈÕÆÚ", grdMain);
|
|
for (int i = 0; i <= grdMain.Rows.Count - 1; i++)
|
{
|
if (DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[sMaterNumberCol].Value) != "" && DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[sProcNumberCol].Value) != "" && DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[sPriceCol].Value) != "")
|
{
|
//дÈëÀà
|
if (WriteClass(i))
|
{
|
//±£´æ¼Ç¼
|
if (!BillNew.AddNew())
|
{
|
MessageBox.Show("µ¼Èëʧ°Ü!ÔÒò:" + DBUtility.ClsPub.sExeReturnInfo, "Ìáʾ");
|
return;
|
}
|
}
|
}
|
else
|
{
|
MessageBox.Show("¹¤Ðò´úÂë»òÎïÁÏ´úÂëΪ¿Õ!ÔÒò:" + DBUtility.ClsPub.sExeReturnInfo, "Ìáʾ");
|
return;
|
}
|
}
|
MessageBox.Show("µ¼ÈëÍê±Ï");
|
grdMain.DataSource = null;
|
}
|
|
//дÈëÀà ´Ó¿Ø¼þ
|
private bool WriteClass(int row)
|
{
|
BillNew.DetailColl.Clear();
|
//string sHNumber = "";
|
//string sProcNumber = "";
|
//double Price = 0 ;
|
string sMaterNumber = "";
|
string sMaterName = "";
|
string sModel = "";
|
string sProcNumber = "";
|
string sProcName = "";
|
string sSourceNumber = "";
|
string sSourceName = "";
|
double sPrice = 0;
|
double sFixPrice = 0;
|
double sBadPrice = 0;
|
double sWasterPrice = 0;
|
string sDeptNumber = "";
|
string sDeptName = "";
|
bool sCostFlag = false;
|
bool sPayFlag = false;
|
bool sFlowFlag = false;
|
DateTime sBeginDate = DateTime.Today.Date;
|
DateTime sEndDate = DateTime.Today.Date;
|
int sMaterNumberCol = DBUtility.Gy_BaseFun.Fun_GetCol("²úÆ·´úÂë", grdMain);
|
int sMaterNameCol = DBUtility.Gy_BaseFun.Fun_GetCol("²úÆ·Ãû³Æ", grdMain);
|
int sModelCol = DBUtility.Gy_BaseFun.Fun_GetCol("¹æ¸ñÐͺÅ", grdMain);
|
int sProcNumberCol = DBUtility.Gy_BaseFun.Fun_GetCol("¹¤Ðò´úÂë", grdMain);
|
int sProcNameCol = DBUtility.Gy_BaseFun.Fun_GetCol("¹¤Ðò", grdMain);
|
int sSourceNumberCol = DBUtility.Gy_BaseFun.Fun_GetCol("×ÊÔ´´úÂë", grdMain);
|
int sSourceNameCol = DBUtility.Gy_BaseFun.Fun_GetCol("Éú²ú×ÊÔ´", grdMain);
|
int sPriceCol = DBUtility.Gy_BaseFun.Fun_GetCol("µ¥¼Û", grdMain);
|
int sFixPriceCol = DBUtility.Gy_BaseFun.Fun_GetCol("¶¨¶î", grdMain);
|
int sBadPriceCol = DBUtility.Gy_BaseFun.Fun_GetCol("²»Á¼¿Û¿î", grdMain);
|
int sWasterPriceCol = DBUtility.Gy_BaseFun.Fun_GetCol("±¨·Ï¿Û¿î", grdMain);
|
int sDeptNumberCol = DBUtility.Gy_BaseFun.Fun_GetCol("²¿ÃÅ´úÂë", grdMain);
|
int sDeptNameCol = DBUtility.Gy_BaseFun.Fun_GetCol("²¿ÃÅ", grdMain);
|
int sCostFlagCol = DBUtility.Gy_BaseFun.Fun_GetCol("Á÷תĬÈÏ", grdMain);
|
int sPayFlagCol = DBUtility.Gy_BaseFun.Fun_GetCol("¹¤×ÊĬÈÏ", grdMain);
|
int sFlowFlagCol = DBUtility.Gy_BaseFun.Fun_GetCol("³É±¾Ä¬ÈÏ", grdMain);
|
int sBeginDateCol = DBUtility.Gy_BaseFun.Fun_GetCol("ÉúЧÈÕÆÚ", grdMain);
|
int sEndDateCol = DBUtility.Gy_BaseFun.Fun_GetCol("ʧЧÈÕÆÚ", grdMain);
|
//
|
sMaterNumber = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[sMaterNumberCol].Value);
|
sMaterName = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[sMaterNameCol].Value);
|
sModel = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[sModelCol].Value);
|
sProcNumber = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[sProcNumberCol].Value);
|
sProcName = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[sProcNameCol].Value);
|
sSourceNumber = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[sSourceNumberCol].Value);
|
sSourceName = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[sSourceNameCol].Value);
|
sPrice = DBUtility.ClsPub.isDoule(grdMain.Rows[row].Cells[sPriceCol].Value);
|
sFixPrice = DBUtility.ClsPub.isDoule(grdMain.Rows[row].Cells[sFixPriceCol].Value);
|
sBadPrice = DBUtility.ClsPub.isDoule(grdMain.Rows[row].Cells[sBadPriceCol].Value);
|
sWasterPrice = DBUtility.ClsPub.isDoule(grdMain.Rows[row].Cells[sWasterPriceCol].Value);
|
sDeptNumber = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[sDeptNumberCol].Value);
|
sDeptName = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[sDeptNameCol].Value);
|
sCostFlag = DBUtility.ClsPub.StringToBool(grdMain.Rows[row].Cells[sCostFlagCol].Value);
|
sPayFlag = DBUtility.ClsPub.StringToBool(grdMain.Rows[row].Cells[sPayFlagCol].Value);
|
sFlowFlag = DBUtility.ClsPub.StringToBool(grdMain.Rows[row].Cells[sFlowFlagCol].Value);
|
sBeginDate = DBUtility.ClsPub.isDate(grdMain.Rows[row].Cells[sBeginDateCol].Value);
|
sEndDate = DBUtility.ClsPub.isDate(grdMain.Rows[row].Cells[sEndDateCol].Value);
|
|
//ÅжÏÊÇ·ñÔÊÐí ±£´æ
|
//ÉóºË´úÂëÊÇ·ñºÏÀí
|
if (!DBUtility.ClsPub.AllowNumber(sMaterNumber))
|
{
|
MessageBox.Show("²úÆ·´úÂëÖв»ÄܳöÏÖÁ¬Ðø¡®.¡¯²¢ÇÒÊ×λĩλ²»ÄÜΪ¡®.¡¯£¡", "Ìáʾ");
|
return false;
|
}
|
if (!DBUtility.ClsPub.AllowNumber(sProcNumber))
|
{
|
MessageBox.Show("¹¤Ðò´úÂëÖв»ÄܳöÏÖÁ¬Ðø¡®.¡¯²¢ÇÒÊ×λĩλ²»ÄÜΪ¡®.¡¯£¡", "Ìáʾ");
|
return false;
|
}
|
if (!DBUtility.ClsPub.AllowNumber(sSourceNumber))
|
{
|
MessageBox.Show("×ÊÔ´´úÂëÖв»ÄܳöÏÖÁ¬Ðø¡®.¡¯²¢ÇÒÊ×λĩλ²»ÄÜΪ¡®.¡¯£¡", "Ìáʾ");
|
return false;
|
}
|
if (!DBUtility.ClsPub.AllowNumber(sDeptNumber))
|
{
|
MessageBox.Show("²¿ÃÅ´úÂëÖв»ÄܳöÏÖÁ¬Ðø¡®.¡¯²¢ÇÒÊ×λĩλ²»ÄÜΪ¡®.¡¯£¡", "Ìáʾ");
|
return false;
|
}
|
Model.ClsGy_ProcPrice_Model oSub=new Model.ClsGy_ProcPrice_Model();
|
//µÃµ½ÎïÁÏÄÚÂë
|
if (oMater.GetInfoByNumber(sMaterNumber))
|
{
|
oSub.HMaterID = oMater.omodel.HItemID;
|
}
|
else
|
{
|
oSub.HMaterID = 0;
|
MessageBox.Show("µÚ" + row.ToString() + "ÐÐ," + sMaterNumber + "ûÓÐÕÒµ½¶ÔÓ¦µÄÎïÁÏ£¡");
|
return false;
|
}
|
//µÃµ½¹¤ÐòÄÚÂë
|
if (oProc.GetInfoByNumber(sProcNumber))
|
{
|
oSub.HProcID = oProc.omodel.HItemID;
|
}
|
else
|
{
|
oSub.HProcID = 0;
|
MessageBox.Show("µÚ" + row.ToString() + "ÐÐ," + sProcNumber + "ûÓÐÕÒµ½¶ÔÓ¦µÄ¹¤Ðò£¡");
|
return false;
|
}
|
//µÃµ½×ÊÔ´ÄÚÂë
|
if (oSource.GetInfoByNumber(sSourceNumber))
|
{
|
oSub.HSourceID = oSource.omodel.HItemID;
|
}
|
else
|
{
|
oSub.HSourceID = 0;
|
//MessageBox.Show("µÚ" + row.ToString() + "ÐÐ," + sSourceNumber + "ûÓÐÕÒµ½¶ÔÓ¦µÄ×ÊÔ´£¡");
|
//return false;
|
}
|
//µÃµ½²¿ÃÅÄÚÂë
|
if (oDept.GetInfoByNumber(sDeptNumber))
|
{
|
oSub.HDeptID = oDept.omodel.HItemID;
|
}
|
else
|
{
|
oSub.HDeptID = 0;
|
//MessageBox.Show("µÚ" + row.ToString() + "ÐÐ," + sDeptNumber + "ûÓÐÕÒµ½¶ÔÓ¦µÄ²¿ÃÅ£¡");
|
//return false;
|
}
|
//дÈëÐÅÏ¢
|
oSub.HCostFlag = sCostFlag;
|
oSub.HFlowFlag =sFlowFlag;
|
oSub.HPayFlag = sPayFlag;
|
if ( DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[sBeginDateCol].Value)!= "" )
|
oSub.HBeginDate = DBUtility.ClsPub.isDate(grdMain.Rows[row].Cells[sBeginDateCol].Value);
|
else
|
oSub.HBeginDate =DateTime.Today.Date;
|
|
if ( DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[sBeginDateCol].Value)!= "" )
|
oSub.HEndDate = DBUtility.ClsPub.isDate(grdMain.Rows[row].Cells[sEndDateCol].Value);
|
else
|
oSub.HEndDate = DateTime.Today.Date.AddYears(100);
|
|
oSub.HRemark = "";
|
oSub.HPrice = sPrice;
|
oSub.HFixPrice = sFixPrice;
|
oSub.HBadPrice = sBadPrice;
|
oSub.HWasterPrice = sWasterPrice;
|
oSub.HMaker = DBUtility.ClsPub.CurUserName;
|
oSub.HMakeDate = DateTime.Today.ToShortDateString();
|
BillNew.DetailColl.Add(oSub);
|
//oProc.oModel.HBillSubType = DBUtility.ClsPub.isStrNull(txtHBillSubType.Text);
|
|
return true;
|
}
|
|
private void button1_Click(object sender, EventArgs e)
|
{
|
|
}
|
|
|
|
}
|
}
|
