DAL/TallysService.cs

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

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

using System;
using System.Collections.Generic;
using Models;
using DBHelp;
using System.Data;
using System.Data.SqlClient;

namespace DAL
{
    public class TallysService
    {
        /// <summary>
        /// 增加
        /// </summary>
        /// <param name="Tallys">Tallys实体对象</param>
        /// <returns>bool值,判断是否操作成功</returns>
        public bool add(Tallys model)
        {
            SqlParameter[] param = new SqlParameter[]
            {
                new SqlParameter ("@Sort_ID",model.Sort_ID),
                new SqlParameter ("@Tallys_Time",model.Tallys_Time),
                new SqlParameter ("@Payment",model.Payment),
                new SqlParameter ("@Tallys_Detail",model.Tallys_Detail),
                new SqlParameter ("@Tallys_Price",model.Tallys_Price),
                new SqlParameter ("@Tallys_CreateUserID",model.Tallys_CreateUserID)
            };
           return Helper.ExecuteNonQuery("Tallys_Add",param);
        }
        /// <summary>
        /// 增加
        /// </summary>
        /// <param name="Tallys">Tallys实体对象</param>
        /// <returns>int值,返回自增ID</returns>
        public int addReturnId(Tallys model)
        {
            SqlParameter[] param = new SqlParameter[]
            {
                new SqlParameter ("@Sort_ID",model.Sort_ID),
                new SqlParameter ("@Tallys_Time",model.Tallys_Time),
                new SqlParameter ("@Payment",model.Payment),
                new SqlParameter ("@Tallys_Detail",model.Tallys_Detail),
                new SqlParameter ("@Tallys_Price",model.Tallys_Price),
                new SqlParameter ("@Tallys_CreateUserID",model.Tallys_CreateUserID)
            };
           return Convert.ToInt32(Helper.ExecuteScalar ("Tallys_AddReturnId",param));
        }
        /// <summary>
        /// 修改
        /// </summary>
        /// <param name="Tallys">Tallys实体对象</param>
        /// <returns>bool值,判断是否操作成功</returns>
        public bool change(Tallys model)
        {
            SqlParameter[] param = new SqlParameter[]
            {
                new SqlParameter ("@Tallys_ID",model.Tallys_ID),
                new SqlParameter ("@Sort_ID",model.Sort_ID),
                new SqlParameter ("@Tallys_Time",model.Tallys_Time),
                new SqlParameter ("@Payment",model.Payment),