erp/BizCom/Dao/CeErpTradeResponsible.cs

using Castle.ActiveRecord;
using NHibernate.Criterion;
using System;
using System.Text;

namespace BizCom
{
    [ActiveRecord("CE_ErpTradeResponsible")]
    public class CeErpTradeResponsible : ComBase<CeErpTradeResponsible>
    {

        /// <summary>
        /// 
        /// </summary>
        [PrimaryKey(PrimaryKeyType.Native)]
        public int ID { get; set; }

        private string _tid = "";
        /// <summary>
        ///
        /// </summary>
        [Property]
        public string tid
        {
            get { return _tid; }
            set { _tid = value; }
        }

        private int _userId = 0;
        /// <summary>
        ///责任人id
        /// </summary>
        [Property]
        public int UserId
        {
            get { return _userId; }
            set { _userId = value; }
        }

        private int _verifyState = 0;
        /// <summary>
        ///审核状态-1作废0主管审核1认可完成2拒绝3个人审核4自动完成5强制完成
        /// </summary>
        [Property]
        public int VerifyState
        {
            get { return _verifyState; }
            set { _verifyState = value; }
        }

        /// <summary>
        ///审核时间
        /// </summary>
        [Property]
        public DateTime? VerifyTime { get; set; }

        /// <summary>
        ///创建时间
        /// </summary>
        [Property]
        public DateTime? createdTime { get; set; }


        private int _isArbitrate = 0;
        /// <summary>
        ///是否申请仲裁
        /// </summary>
        [Property]
        public int IsArbitrate
        {
            get { return _isArbitrate; }
            set { _isArbitrate = value; }
        }
        private int _isSup = 0;
        /// <summary>
        ///是否供应商
        /// </summary>
        [Property]
        public int IsSup
        {
            get { return _isSup; }
            set { _isSup = value; }
        }
        private int _isFlow = 0;
        /// <summary>
        ///是否供应商
        /// </summary>
        [Property]
        public int IsFlow
        {
            get { return _isFlow; }
            set { _isFlow = value; }
        }

        private string _arbitradeMemo = "";
        /// <summary>
        ///申请仲裁原因
        /// </summary>
        [Property]
        public string ArbitradeMemo
        {
            get { return _arbitradeMemo; }
            set { _arbitradeMemo = value; }
        }

        private int _backNum = 0;
        /// <summary>
        ///打回次数
        /// </summary>
        [Property]
        public int BackNum
        {
            get { return _backNum; }
            set { _backNum = value; }

        }
        private int _isTem = 0;
        /// <summary>
        ///是否终止
        /// </summary>
        [Property]
        public int IsTem
        {
            get { return _isTem; }
            set { _isTem = value; }
        }

        private double _refundFee = 0;
        /// <summary>
        ///扣款金额
        /// </summary>
        [Property]
        public double RefundFee
        {
            get { return _refundFee; }
            set { _refundFee = value; }
        }

        private int _type = 0;
        /// <summary>
        /// 类型 0普通1供应商2物流3系统
        /// </summary>
        [Property]
        public int type
        {
            get { return _type; }
            set { _type = value; }
        }

        public static void Del(object id)
        {
            StringBuilder sql = new StringBuilder();
            sql.AppendFormat("update CE_ErpTradeResponsible set VerifyState = -1 where id=" + id);
            ExecuteNonQuery(sql.ToString());
        }
        public static void DelByTid(object id, int state)
        {
            StringBuilder sql = new StringBuilder();
            sql.AppendFormat("update CE_ErpTradeResponsible set VerifyState = " + state + ", VerifyTime=GETDATE() where tid='" + id + "' and VerifyState > -1");
            ExecuteNonQuery(sql.ToString());
        }
        public static void DelById(object id, int state)
        {
            StringBuilder sql = new StringBuilder();
            sql.AppendFormat("update CE_ErpTradeResponsible set VerifyState = " + state + ", VerifyTime=GETDATE() where ID='" + id + "' and VerifyState > -1");
            ExecuteNonQuery(sql.ToString());
        }
        public static void NumByTid(int backNum, object tid)
        {
            StringBuilder sql = new StringBuilder();
            sql.AppendFormat(string.Format("update CE_ErpTradeResponsible set BackNum={0} where tid='{1}'", backNum, tid));
            ExecuteNonQuery(sql.ToString());
        }
        public static void dateByTid(string tid)
        {
            StringBuilder sql = new StringBuilder();
            sql.AppendFormat(string.Format("update CE_ErpTradeResponsible set VerifyTime=GETDATE() where tid='{0}'", tid));
            ExecuteNonQuery(sql.ToString());
        }

        public static CeErpTradeResponsible GetByUserId(string ctid, int userId, int isSup, int isFlow)
        {
            return FindFirst(Expression.Sql(string.Format("tid='{0}' and UserId='{1}' and IsSup='{2}' and IsFlow = {3}", ctid, userId, isSup, isFlow)));
        }
        public static CeErpTradeResponsible GetByUserIdType(string ctid, int userId, int type)
        {
            return FindFirst(Expression.Sql(string.Format("tid='{0}' and UserId='{1}' and type={2}", ctid, userId, type)));
        }
        public static CeErpTradeResponsible GetByCtid(string ctid)
        {
            return FindFirst(Expression.Sql(string.Format("tid='{0}'", ctid)));
        }
        public static CeErpTradeResponsible GetById(string id)
        {
            return FindFirst(Expression.Sql(string.Format("ID='{0}'", id)));
        }
    }
}