DAL/TCWL_D_SalesApplication.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_SalesApplication
    {
        public string Add(TCWL_M_SalesApplication model)
        {
            string str5;
            string str = string.Format("insert into TCWL_SalesApplication(SalesID,Applicant,ApplicationReason) values ('" + model.SalesID + "','" + model.Applicant + "','" + model.ApplicationReason + "')", new object[0]);
            string str2 = string.Format("Update TCWL_XiaoShouJiHui set ApplyNum = ApplyNum+1 where id= '" + model.SalesID + "'", new object[0]);
            using (SqlConnection connection = new SqlConnection(DBHelper.ConnectionString))
            {
                if (connection.State != ConnectionState.Open)
                {
                    connection.Open();
                }
                using (SqlCommand command = new SqlCommand())
                {
                    command.Connection = connection;
                    SqlTransaction transaction = null;
                    transaction = connection.BeginTransaction();
                    command.CommandType = CommandType.Text;
                    command.Transaction = transaction;
                    DataTable dataTable = new DataTable();
                    dataTable = DBHelper.GetDataTable("select * from TCWL_SalesApplication where SalesID='" + model.SalesID + "' and Applicant='" + model.Applicant + "' ");
                    DataTable table2 = new DataTable();
                    table2 = DBHelper.GetDataTable("select userXM,serviceID from TCWL_User where userName ='" + model.Applicant + "' ");
                    DataTable table3 = new DataTable();
                    table3 = DBHelper.GetDataTable("select KeHuMingCheng from TCWL_XiaoShouJiHui where ID ='" + model.SalesID + "' ");
                    DataTable table4 = new DataTable();
                    table4 = DBHelper.GetDataTable("select u.userName,u.userXM from TCWL_User u inner join TCWL_Role r on u.belongRole=r.ID where u.serviceID='" + table2.Rows[0]["serviceID"].ToString() + "' and r.permission like '%M_119%'");
                    string format = "";
                    Guid guid = Guid.NewGuid();
                    for (int i = 0; i < table4.Rows.Count; i++)
                    {
                        object obj2 = format;
                        format = string.Concat(new object[] { obj2, "insert into TCWL_StationNews( Title,Sender,Recipient,Type,RelevantNumber,RelevantNews,Recipient_Name) values ('用户：", table2.Rows[0]["userXM"].ToString(), "申请公海机会<", table3.Rows[0]["KeHuMingCheng"].ToString(), ">请及时处理！','系统提醒','", table4.Rows[i]["userName"].ToString(), "','12','", model.SalesID, "','", guid, "','", table4.Rows[i]["userXM"].ToString(), "');" });
                    }
                    string str4 = string.Format(format, new object[0]);
                    try
                    {
                        if (dataTable.Rows.Count > 0)
                        {
                            return "exist";
                        }
                        command.CommandText = str;
                        command.ExecuteNonQuery();
                        command.CommandText = str2;
                        command.ExecuteNonQuery();
                        if (str4.Length > 0)
                        {
                            command.CommandText = str4;
                            command.ExecuteNonQuery();