HN.DAL/PayMent.cs

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

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

using System;
using System.Text;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Data;
using HN.Utility;
using HN.Model;

namespace HN.DAL
{
    /// <summary>
    /// 收支表
    /// Author 2016-04-15
    /// </summary>
    public class PayMent
    {
        #region 判断是否存在 Exists(object tran, int PayID)
        /// <summary>
        /// 判断是否存在
        /// Author 2016-04-15
        /// </summary>
        public bool Exists(object tran, int PayID)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select count(1) from PayMent");
            strSql.Append(" where ");
            strSql.Append(" PayID = @PayID  ");
            SqlParameter[] parameters = {
					new SqlParameter("@PayID", SqlDbType.Int,4)
			};
            parameters[0].Value = PayID;

            object obj = SQLHelper.ExecuteScalar((SqlTransaction)tran, strSql.ToString(), parameters);
            return obj.ToString() == "0" ? false : true;
        }
        #endregion

        #region 增加一条数据 Add(object tran,PayMentInfo model)
        /// <summary>
        /// 增加一条数据
        /// Author 2016-04-15
        /// </summary>
        public bool Add(object tran, PayMentInfo model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into PayMent(");
            strSql.Append("BillNo,BillDate,Type,Mark,OrgID,BkID,VenID,CustID,Money,UserName,PayType,PayDate,AuditStatus,AuditID,AuditName,AuditDate,AuditIdea,CreateID,CreateName,CreateDate,Remark");
            strSql.Append(") values (");
            strSql.Append("@BillNo,@BillDate,@Type,@Mark,@OrgID,@BkID,@VenID,@CustID,@Money,@UserName,@PayType,@PayDate,@AuditStatus,@AuditID,@AuditName,@AuditDate,@AuditIdea,@CreateID,@CreateName,@CreateDate,@Remark");
            strSql.Append(") ");
            SqlParameter[] parameters = {
			            new SqlParameter("@BillNo", SqlDbType.VarChar,20) ,            
                        new SqlParameter("@BillDate", SqlDbType.Date,3) ,            
                        new SqlParameter("@Type", SqlDbType.Int,4) ,        
                        new SqlParameter("@Mark", SqlDbType.TinyInt,1) ,            
                        new SqlParameter("@OrgID", SqlDbType.Int,4) ,            
                        new SqlParameter("@BkID", SqlDbType.Int,4) ,            
                        new SqlParameter("@VenID", SqlDbType.Int,4) ,            
                        new SqlParameter("@CustID", SqlDbType.Int,4) ,            
                        new SqlParameter("@Money", SqlDbType.Decimal,9) ,