BLL/OrderLists.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 OrderLists
    {
        public string ErrorMessage = "";//错误信息
        //添加
        public int Add(
        out int ID
        , int OrdersID
        , int DrugsID
        , int OrderVolume
        )
        {
            int flag = 0;
            try
            {
                DAL.ExecuteProcedure exec = new DAL.ExecuteProcedure();
                SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,32)
,new SqlParameter("@OrdersID", OrdersID)
,new SqlParameter("@DrugsID", DrugsID)
,new SqlParameter("@OrderVolume", OrderVolume)
, new SqlParameter("@Flag",SqlDbType.Int,32)
};
                parameters[0].Direction = ParameterDirection.Output;
                parameters[4].Direction = ParameterDirection.ReturnValue;
                flag = exec.run("Pr_OrderLists_Add", parameters);
                if (flag == 1)
                {
                    if (Convert.ToInt32(parameters[4].Value) == 10)
                    {
                        ID = Convert.ToInt32(parameters[0].Value);
                    }
                    else
                    {
                        ID = 0;
                        flag = 0;
                        this.ErrorMessage = "添加失败，已存在同样的数据！";
                    }
                }
                else
                {
                    ID = 0;
                    this.ErrorMessage = exec.ErrorMessage;
                }
            }
            catch (Exception e)
            {
                ID = 0;
                this.ErrorMessage = e.Message.ToString();
            }
            return flag;
        }