DAL/TCWL_D_Process.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_Process
    {
        public bool Add(TCWL_M_Process model, TCWL_M_ProcessForm model1)
        {
            string str = Guid.NewGuid().ToString();
            StringBuilder builder = new StringBuilder();
            builder.Append("insert into TCWL_Process(");
            builder.Append("ID,Title,AddUser,ModelId,Department,CuType,EmerType,UserIds,UserNames,AttachUserids,AttachUserNames,Type,ServiceID,CuAnnotater,CuTypeDes)");
            builder.Append(" values (");
            builder.Append(string.Concat(new object[] { 
                "'", str, "','", model.Title, "','", model.AddUser, "','", model.ModelId, "','", model.Department, "',", model.CuType, ",", model.EmerType, ",'", model.UserIds, 
                "','", model.UserNames, "','", model.AttachUserids, "','", model.AttachUserNames, "','", model.Type, "','", model.ServiceID, "','", model.CuAnnotater, "','", model.CuTypeDes, "')"
             }));
            StringBuilder builder2 = new StringBuilder();
            builder2.Append("insert into TCWL_ProcessForm(");
            builder2.Append("ID,Instruction,SDate,EDate,FormType,District,Money,UserDate,WorkSdate,WorkEdate,ProcessType)");
            builder2.Append(" values (");
            builder2.Append(string.Concat(new object[] { 
                "'", str, "','", model1.Instruction, "','", model1.SDate, "','", model1.EDate, "','", model1.FormType, "','", model1.District, "','", model1.Money, "','", model1.UserDate, 
                "','", model1.WorkSdate, "','", model1.WorkEdate, "',", model1.ProcessType, ")"
             }));
            if (DBHelper.ExecuteSQL(new string[] { builder.ToString(), builder2.ToString() }))
            {
                if (model.CuType > 0)
                {
                    DataTable dataTable = new DataTable();
                    dataTable = DBHelper.GetDataTable("select userXM from TCWL_User where userName = '" + model.CuAnnotater + "'");
                    Guid guid = Guid.NewGuid();
                    if (dataTable != null)
                    {
                        DBHelper.ExecuteSQL(string.Concat(new object[] { "insert into TCWL_StationNews( Title,Sender,Recipient,Type,RelevantNumber,RelevantNews,Recipient_Name,State) values ('您有一个待审核的流程，请及时查看！','系统提醒','", model.CuAnnotater, "','0','", str, "','", guid, "','", dataTable.Rows[0]["userXM"].ToString(), "','", model.EmerType, "');" })).ToString();
                    }
                    if (model.AttachUserids != "")
                    {
                        int num;
                        string[] strArray2 = model.AttachUserids.Split(new char[] { ',' });
                        string str3 = "";
                        for (num = 0; num < strArray2.Length; num++)
                        {
                            str3 = str3 + "'" + strArray2[num] + "',";
                        }
                        str3 = str3.Substring(0, str3.Length - 1);
                        DataTable table2 = new DataTable();
                        table2 = DBHelper.GetDataTable("select userXM from TCWL_User where userName = '" + model.AddUser + "'");
                        DataTable table3 = new DataTable();
                        table3 = DBHelper.GetDataTable("select userXM,userName from TCWL_User where userName in (" + str3 + ")");
                        string sqlString = "";
                        Guid guid2 = Guid.NewGuid();
                        for (num = 0; num < table3.Rows.Count; num++)
                        {