DAL/TCWL_D_SMSRecord.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_SMSRecord
    {
        public string Add(string xmlist, string dhlist, string srvid, string userid, string Content, string Number)
        {
            string str5;
            string[] strArray = dhlist.Split(new char[] { ',' });
            string str = "";
            string str2 = "";
            string str3 = "";
            int length = strArray.Length;
            int num2 = Content.Length;
            int num3 = Convert.ToInt32(Number);
            float num4 = ((float) num2) / ((float) num3);
            int num5 = Convert.ToInt32(Math.Ceiling((double) num4));
            DataTable table = new DataTable();
            string str4 = "";
            using (SqlConnection connection = new SqlConnection(DBHelper.ConnectionString))
            {
                if (connection.State != ConnectionState.Open)
                {
                    connection.Open();
                }
                using (SqlCommand command = new SqlCommand())
                {
                    int num6 = Convert.ToInt32(DBHelper.GetDataTable("select MessageNumber from TCWL_All_CompanyInformation where ServiceID = '" + srvid + "'").Rows[0]["MessageNumber"].ToString());
                    int num7 = length * num5;
                    int num8 = num6 - num7;
                    if (num8 >= 0)
                    {
                        str4 = "True";
                    }
                    else
                    {
                        str4 = "False";
                        return "slbg";
                    }
                    str = string.Format(string.Concat(new object[] { "update TCWL_All_CompanyInformation set MessageNumber = '", num8, "' where ServiceID = '", srvid, "'" }), new object[0]);
                    str2 = string.Format(string.Concat(new object[] { "insert into TCWL_SMSRecord (UserLiset,PhoneList,Content,Despatcher,State,ServiceID,Number) values ('", xmlist, "','", dhlist, "','", Content, "','", userid, "','0','", srvid, "','", num7, "')" }), new object[0]);
                    str3 = string.Format(string.Concat(new object[] { "insert into TCWL_SMSRecord (UserLiset,PhoneList,Content,Despatcher,State,ServiceID,Number) values ('", xmlist, "','", dhlist, "','", Content, "','", userid, "','1','", srvid, "','", num7, "')" }), new object[0]);
                    command.Connection = connection;
                    SqlTransaction transaction = null;
                    transaction = connection.BeginTransaction();
                    command.CommandType = CommandType.Text;
                    command.Transaction = transaction;
                    try
                    {
                        if (str4 == "True")
                        {
                            command.CommandText = str;
                            command.ExecuteNonQuery();