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_Process :BLL.Gy_DataInTmp
|
{
|
public Gy_DataIn_Process()
|
{
|
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.ClsIF_Department_View oFactory = new DAL.ClsIF_Department_View();
|
//public DAL.ClsCB_ItemMoneyBill_Tmp oBill = new DAL.ClsCB_ItemMoneyBill_Tmp();
|
|
//public DAL.ClsGy_ItemMoney_View oItemMoney = new DAL.ClsGy_ItemMoney_View();
|
//public DAL.ClsGy_Room_View oRoom = new DAL.ClsGy_Room_View();
|
//public DAL.ClsGy_Collect_View oCollect = new DAL.ClsGy_Collect_View();
|
//public DAL.ClsGy_Building_View oBuilding = new DAL.ClsGy_Building_View();
|
|
/// <summary>
|
/// ³õʼ»¯½çÃæ
|
/// </summary>
|
public override void initData()
|
{
|
base.initData();
|
base.sSheetName = "¹¤Ðò";
|
base.ModRightName = "Gy_DataIn_Process";
|
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()
|
{
|
|
for (int i = 0; i <= grdMain.Rows.Count - 1; i++)
|
{
|
if (DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[0].Value) != "" && DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[1].Value) != "")
|
{
|
//дÈëÀà
|
if (WriteClass(i))
|
{
|
//±£´æ¼Ç¼
|
if (!oProc.AddNew())
|
{
|
MessageBox.Show("µ¼Èëʧ°Ü!ÔÒò:" + DBUtility.ClsPub.sExeReturnInfo, "Ìáʾ");
|
return;
|
}
|
}
|
}
|
else
|
{
|
MessageBox.Show("¹¤Ðò´úÂë»òÃû³ÆΪ¿Õ!ÔÒò:" + DBUtility.ClsPub.sExeReturnInfo, "Ìáʾ");
|
return;
|
}
|
}
|
MessageBox.Show("µ¼ÈëÍê±Ï");
|
grdMain.DataSource = null;
|
}
|
|
//дÈëÀà ´Ó¿Ø¼þ
|
private bool WriteClass(int row)
|
{
|
string sHNumber = "";
|
string sHName = "";
|
string sWorkNumber = "";
|
long HItemID = 0;
|
int sCol = DBUtility.Gy_BaseFun.Fun_GetCol("¹¤Ðò´úÂë", grdMain);
|
int sHNameCol=DBUtility.Gy_BaseFun.Fun_GetCol("¹¤Ðò", grdMain);
|
int sWorkCol = DBUtility.Gy_BaseFun.Fun_GetCol("ËùÊô²¿ÃÅ", grdMain);
|
//
|
sHNumber = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[sCol].Value);
|
sWorkNumber = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[sWorkCol].Value);
|
sHName=DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[sHNameCol].Value);
|
//ÅжÏÊÇ·ñÔÊÐí ±£´æ
|
//ÉóºË´úÂëÊÇ·ñºÏÀí
|
if (!DBUtility.ClsPub.AllowNumber(sHNumber))
|
{
|
MessageBox.Show("´úÂëÖв»ÄܳöÏÖÁ¬Ðø¡®.¡¯²¢ÇÒÊ×λĩλ²»ÄÜΪ¡®.¡¯£¡", "Ìáʾ");
|
return false;
|
}
|
|
//ÊÇ·ñÖظ´´úÂë
|
if (oProc.HavSameNumber(HItemID, sHNumber))
|
{
|
MessageBox.Show("´úÂëÖظ´£¡", "Ìáʾ");
|
return false;
|
}
|
//¼ì²é¸¸¼¶ÊÇ·ñ´æÔÚ
|
string sParent;
|
sParent = DBUtility.ClsPub.GetParentCode(sHNumber);
|
if (sParent.Trim() == "")
|
{
|
oProc.oModel.HParentID = 0;
|
}
|
else
|
{
|
if (oProc.HavParentCode(sParent.Trim(), HItemID))
|
{
|
oProc.oModel.HParentID = oProc.oModel.HItemID;
|
}
|
else
|
{
|
MessageBox.Show("Éϼ¶´úÂë²»´æÔÚ»ò±»½ûÓã¡", "Ìáʾ");
|
return false;
|
}
|
}
|
//µÃµ½¶Ì´úÂë
|
string sShortNumber;
|
sShortNumber = DBUtility.ClsPub.GetShortNumber(sHNumber);
|
if (sShortNumber.Trim() == "")
|
{
|
return false;
|
}
|
//±£´æÔ´úÂë
|
if (oProcHlp.GetInfoByID(HItemID))
|
{
|
oProc.HOldNumber = oProcHlp.oModel.HNumber;
|
//ÊÇ·ñдúÂëÊÇ×Ô¼º×ÓÏîÄ¿µÄ¡¡×ÓÏîÄ¿
|
if (sParent.Length >= oProc.HOldNumber.Length)
|
{
|
if (sParent.Substring(0, oProc.HOldNumber.ToString().Length) == oProc.HOldNumber.Trim())
|
{
|
MessageBox.Show("дúÂë²»ÄÜÊÇ×Ô¼ºµÄϼ¶µÄ×ÓÏîÄ¿£¡", "Ìáʾ");
|
return false;
|
}
|
}
|
}
|
else
|
{
|
oProc.HOldNumber = "";
|
}
|
|
//µÃµ½³µ¼äÄÚÂë
|
if (oFactory.GetInfoByNumber(sWorkNumber))
|
{
|
oProc.oModel.HDeptID = oFactory.omodel.HItemID;
|
}
|
else
|
{
|
oProc.oModel.HDeptID = 0;
|
MessageBox.Show("µÚ" + row.ToString() + "ÐÐ," + sWorkNumber + "ûÓÐÕÒµ½¶ÔÓ¦µÄ²¿ÃÅ£¡");
|
return false;
|
}
|
//дÈëÐÅÏ¢
|
oProc.oModel.HShortNumber = sShortNumber;
|
oProc.oModel.HEndFlag = true;
|
oProc.oModel.HLevel = DBUtility.ClsPub.GetLevel(sHNumber);
|
oProc.oModel.HNumber = sHNumber;
|
oProc.oModel.HHelpCode = "";
|
oProc.oModel.HName = sHName;
|
oProc.oModel.HStopflag = false;
|
oProc.oModel.HRemark = "";
|
oProc.oModel.HBarCode = "";
|
if (oFactory.GetInfoByName(sWorkNumber))
|
{
|
oProc.oModel.HDeptID = oFactory.omodel.HItemID;
|
}
|
else
|
{
|
oProc.oModel.HDeptID = 0;
|
return false;
|
}
|
//oProc.oModel.HDeptNumber = sWorkNumber;
|
oProc.oModel.HSNo = 0;
|
oProc.oModel.HProcessID_K3 = 0;
|
//oProc.oModel.HBillSubType = DBUtility.ClsPub.isStrNull(txtHBillSubType.Text);
|
|
return true;
|
}
|
|
private void button1_Click(object sender, EventArgs e)
|
{
|
|
}
|
|
|
|
}
|
}
|
