IAAccount/AccountHelper.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Windows.Forms;

/// <summary>
/// 记帐辅助
/// </summary>
/// <remarks></remarks>
namespace IAAccount
{
    internal class AccountHelper
    {

        private string str;

        public static AccountHelper Create()
        {
            return new AccountHelper();
        }

        public void Account(int iYear, int iMonth, DateTime dAccountDate, string cVouchType, bool bBlue, bool bRed, System.Data.Common.DbCommand cmd)
        {
            this.Sqeer(iYear, iMonth, cVouchType, bBlue, bRed, cmd);

            if (cVouchType == Model.Constant.VouchType.A25_存货调整单)
                this.Account存货调整单(iYear, iMonth, dAccountDate, cVouchType, bBlue, bRed, cmd);
            else
                this.Account出入库单(iYear, iMonth, dAccountDate, cVouchType, bBlue, bRed, cmd);
        }

        private void Sqeer(int iYear, int iMonth, string cVouchType, bool bBlue, bool bRed, System.Data.Common.DbCommand cmd)
        {
            string msg = this.getInfo(iYear, iMonth, cVouchType, bBlue, bRed, cmd);
            msg += '\n' + "是否继续?";
            if (Common.Functions.Speer(msg, "") == DialogResult.No)
            {
                throw (new Exception("操作已被取消"));
            }
        }
        /// <summary>
        /// 获取信息
        /// </summary>
        /// <param name="cmd"></param>
        /// <returns></returns>
        /// <remarks></remarks>
        public string getInfo(int iYear, int iMonth, string cVouchType, bool bBlue, bool bRed, System.Data.Common.DbCommand cmd)
        {
            string cRed = "";
            if (bBlue == true && bRed == false)
            {
                cRed = " and bRed=" + Common.DataBase.getBoolean(false);
            }
            else if (bBlue == false && bRed == true)
            {
                cRed = " and bRed=" + Common.DataBase.getBoolean(true);
            }

            if (cVouchType == Model.Constant.VouchType.A25_存货调整单)
            {
                str = "select count(*) from JustVouch where iYear=" + iYear + " and iMonth=" + iMonth;