DAL/TCWL_D_RechargeHistory.cs

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

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

namespace DAL
{
    using Common;
    using Model;
    using System;
    using System.Data;
    using System.Data.SqlClient;
    using System.Runtime.InteropServices;
    using System.Text;

    public class TCWL_D_RechargeHistory
    {
        public bool Add(TCWL_M_RechargeHistory model)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("insert into TCWL_All_CompanyInformation_Receivables(");
            builder.Append("ApplicationTime,money,Beizhu,State,Payment,Invoice,Entry,ServiceID)");
            builder.Append(" values (");
            builder.Append("@ApplicationTime,@money,@Beizhu,@State,@Payment,@Invoice,@Entry,@ServiceID)");
            SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@ApplicationTime", SqlDbType.DateTime), new SqlParameter("@money", SqlDbType.Float, 8), new SqlParameter("@Beizhu", SqlDbType.Text), new SqlParameter("@State", SqlDbType.NVarChar, 50), new SqlParameter("@Payment", SqlDbType.NVarChar, 50), new SqlParameter("@Invoice", SqlDbType.NVarChar, 50), new SqlParameter("@Entry", SqlDbType.NVarChar, 50), new SqlParameter("@ServiceID", SqlDbType.NVarChar, 50) };
            cmdParms[0].Value = model.ApplicationTime;
            cmdParms[1].Value = model.money;
            cmdParms[2].Value = model.Beizhu;
            cmdParms[3].Value = 0;
            cmdParms[4].Value = model.Payment;
            cmdParms[5].Value = model.Invoice;
            cmdParms[6].Value = model.Entry;
            cmdParms[7].Value = model.ServiceID;
            return (DBHelper.ExecuteSql(builder.ToString(), cmdParms) > 0);
        }

        public bool Delete(string ID)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("delete from TCWL_All_CompanyInformation_Receivables ");
            builder.Append(" where ID=@ID ");
            SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@ID", SqlDbType.NVarChar, 0x24) };
            cmdParms[0].Value = ID;
            return (DBHelper.ExecuteSql(builder.ToString(), cmdParms) > 0);
        }

        public bool DeleteList(string IDlist)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("delete from TCWL_All_CompanyInformation_Receivables ");
            builder.Append(" where ID in (" + IDlist + ")  ");
            return (DBHelper.ExecuteSql(builder.ToString(), new SqlParameter[0]) > 0);
        }

        public string GetID(TCWL_M_RechargeHistory model)
        {
            StringBuilder builder = new StringBuilder();
            string str = Guid.NewGuid().ToString();
            builder.Append("insert into TCWL_All_CompanyInformation_Receivables(");
            builder.Append("ApplicationTime,money,Beizhu,State,Payment,Invoice,Entry,ServiceID,ID)");
            builder.Append(" values (");
            builder.Append("@ApplicationTime,@money,@Beizhu,@State,@Payment,@Invoice,@Entry,@ServiceID,'" + str + "');");
            builder.Append("insert into TCWL_All_business(");
            builder.Append("type,money,memo,state,doSomething,ServiceID,ID,userID)");
            builder.Append(" values (");