DAL/TCWL_D_GhApply.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_GhApply
    {
        public bool Add(TCWL_M_GhApply model)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("insert into TCWL_GhApply(");
            builder.Append("ID,CustomID,Applicant,ApplicationReason,TimeStr)");
            builder.Append(" values (");
            builder.Append("@ID,@CustomID,@Applicant,@ApplicationReason,@TimeStr)");
            SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@ID", SqlDbType.NVarChar, 0x24), new SqlParameter("@CustomID", SqlDbType.NVarChar, 0x24), new SqlParameter("@Applicant", SqlDbType.NVarChar, 50), new SqlParameter("@ApplicationReason", SqlDbType.Text), new SqlParameter("@TimeStr", SqlDbType.DateTime) };
            cmdParms[0].Value = model.ID;
            cmdParms[1].Value = model.CustomID;
            cmdParms[2].Value = model.Applicant;
            cmdParms[3].Value = model.ApplicationReason;
            cmdParms[4].Value = model.TimeStr;
            return DBHelper.Exists(builder.ToString(), cmdParms);
        }

        public bool Add_SQ(TCWL_M_GhApply model)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("insert into TCWL_GhApply(");
            builder.Append("CustomID,Applicant,ApplicationReason)");
            builder.Append(" values (");
            builder.Append("@CustomID,@Applicant,@ApplicationReason);");
            builder.Append("update TCWL_KeHuXinXi set ApplyNum=ApplyNum+1 where ID=@CustomID");
            SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@CustomID", SqlDbType.NVarChar, 50), new SqlParameter("@Applicant", SqlDbType.NVarChar, 50), new SqlParameter("@ApplicationReason", SqlDbType.Text) };
            cmdParms[0].Value = model.CustomID;
            cmdParms[1].Value = model.Applicant;
            cmdParms[2].Value = model.ApplicationReason;
            if (DBHelper.ExecuteSql(builder.ToString(), cmdParms) > 0)
            {
                DataTable dataTable = new DataTable();
                dataTable = DBHelper.GetDataTable("select userXM,serviceID from TCWL_User where userName ='" + model.Applicant + "' ");
                DataTable table2 = new DataTable();
                table2 = DBHelper.GetDataTable("select KeHuMingCheng from TCWL_KeHuXinXi where ID ='" + model.CustomID + "' ");
                DataTable table3 = new DataTable();
                table3 = DBHelper.GetDataTable("select u.userName,u.userXM from TCWL_User u inner join TCWL_Role r on u.belongRole=r.ID where u.serviceID='" + dataTable.Rows[0]["serviceID"].ToString() + "' and r.permission like '%M_500%'");
                string sqlString = "";
                Guid guid = Guid.NewGuid();
                for (int i = 0; i < table3.Rows.Count; i++)
                {
                    object obj2 = sqlString;
                    sqlString = string.Concat(new object[] { obj2, "insert into TCWL_StationNews( Title,Sender,Recipient,Type,RelevantNumber,RelevantNews,Recipient_Name) values ('用户：", dataTable.Rows[0]["userXM"].ToString(), "申请公海客户<", table2.Rows[0]["KeHuMingCheng"].ToString(), ">请及时处理！','系统提醒','", table3.Rows[i]["userName"].ToString(), "','14','", model.CustomID, "','", guid, "','", table3.Rows[i]["userXM"].ToString(), "');" });
                }
                DBHelper.ExecuteSQL(sqlString);
                return true;
            }
            return false;
        }