DAL/TCWL_D_FunctionApplication.cs

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

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

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

    public class TCWL_D_FunctionApplication
    {
        public string Add(string srvid, string userID, string gnlist)
        {
            int num3;
            string[] strArray2;
            decimal num4;
            string str8;
            object obj2;
            string[] strArray = gnlist.Split(new char[] { ';' });
            string format = "";
            string str2 = "";
            string str3 = "";
            string str4 = "";
            string str5 = "";
            string str6 = "";
            string str7 = "";
            decimal num = 0M;
            decimal num2 = 0M;
            if (gnlist != "")
            {
                for (num3 = 0; num3 < strArray.Length; num3++)
                {
                    strArray2 = strArray[num3].Split(new char[] { ',' });
                    num4 = Convert.ToDecimal(strArray2[1]) * Convert.ToDecimal(strArray2[2]);
                    num += num4;
                    obj2 = format;
                    format = string.Concat(new object[] { 
                        obj2, "insert into TCWL_Tree_Receivables (ModularID,Money,UnitPrice,long,Entry,Beizhu,ApplicationTime,State,ServiceID) values ('", strArray2[4], "','", num4, "','", strArray2[1], "','", strArray2[2], "','", userID, "','", strArray2[3], "','", DateTime.Now, "','0','", 
                        srvid, "');"
                     });
                }
            }
            using (SqlConnection connection = new SqlConnection(DBHelper.ConnectionString))
            {
                if (connection.State != ConnectionState.Open)
                {
                    connection.Open();
                }
                using (SqlCommand command = new SqlCommand())
                {
                    DataTable table = new DataTable();
                    num2 = Convert.ToDecimal(DBHelper.GetDataTable("select * from TCWL_All_CompanyInformation where ServiceID = '" + srvid + "'").Rows[0]["Balance"].ToString()) - num;
                    if (num2 >= 0M)
                    {
                        str4 = string.Format(format, new object[0]);
                        if (gnlist != "")
                        {
                            for (num3 = 0; num3 < strArray.Length; num3++)
                            {
                                strArray2 = strArray[num3].Split(new char[] { ',' });