BLL/InStoreLists.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 InStoreLists
    {
        public string ErrorMessage = "";//错误信息
        //添加
        public int Add(
        out int ID
        , int InStoresID
        , int DrugsID
        , int InVolume
        , string Maker
        , string ExpireDate
        , double InPrice
        , double Discount
        , int DataState
        , int OrderFLag
        , int OrdersID
        )
        {
            int flag = 0;
            try
            {
                DAL.ExecuteProcedure exec = new DAL.ExecuteProcedure();
                SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,32)
,new SqlParameter("@InStoresID", InStoresID)
,new SqlParameter("@DrugsID", DrugsID)
,new SqlParameter("@InVolume", InVolume)
,new SqlParameter("@Maker", Maker.Trim())
,new SqlParameter("@ExpireDate", ExpireDate.Trim())
,new SqlParameter("@InPrice", InPrice)
,new SqlParameter("@Discount", Discount)
,new SqlParameter("@DataState", DataState)
,new SqlParameter("@OrderFLag", OrderFLag)
,new SqlParameter("@OrdersID", OrdersID)
, new SqlParameter("@Flag",SqlDbType.Int,32)
};
                parameters[0].Direction = ParameterDirection.Output;
                parameters[11].Direction = ParameterDirection.ReturnValue;
                flag = exec.run("Pr_InStoreLists_Add", parameters);
                if (flag == 1)
                {
                    int flagff = Convert.ToInt32(parameters[11].Value);
                    if (flagff == 10)
                    {
                        ID = Convert.ToInt32(parameters[0].Value);
                    }
                    else if (flagff == -1)
                    {
                        ID = 0;
                        flag = 0;