BLL/OutStoreInvoice.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data;
using System.Data.SqlClient;
namespace BLL
{
    public class OutStoreInvoice
    {
        public string ErrorMessage = "";//错误信息
        //添加
        public int Add(
        out int ID
        , int InStoresID
        , string InvoiceNumber
        , double InvoiceAmount
        , string InvoiceDate
        , string InvoiceExpireDate
        , string InvoiceAbstract
        , int StaffsID
        , int ApproveState
        , int LockFLag
        )
        {
            int flag = 0;
            try
            {
                DAL.ExecuteProcedure exec = new DAL.ExecuteProcedure();
                SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,32)
,new SqlParameter("@OutStoresID", InStoresID)
,new SqlParameter("@InvoiceNumber", InvoiceNumber.Trim())
,new SqlParameter("@InvoiceAmount", InvoiceAmount)
,new SqlParameter("@InvoiceDate", InvoiceDate.Trim())
,new SqlParameter("@InvoiceExpireDate", InvoiceExpireDate.Trim())
,new SqlParameter("@InvoiceAbstract", InvoiceAbstract.Trim())
,new SqlParameter("@StaffsID", StaffsID)
,new SqlParameter("@ApproveState", ApproveState)
,new SqlParameter("@LockFLag", LockFLag)
, new SqlParameter("@Flag",SqlDbType.Int,32)
};
                parameters[0].Direction = ParameterDirection.Output;
                parameters[10].Direction = ParameterDirection.ReturnValue;
                flag = exec.run("Pr_OutStoreInvoice_Add", parameters);
                if (flag == 1)
                {
                    if (Convert.ToInt32(parameters[10].Value) == 10)
                    {
                        ID = Convert.ToInt32(parameters[0].Value);
                    }
                    else if (Convert.ToInt32(parameters[10].Value) == -2)
                    {
                        ID = 0;
                        flag = 0;
                        this.ErrorMessage = "发票金额大于应收账款金额！";
                    }
                    else
                    {