MQ12345_API/CallCenterApi/CallCenterAp.../T_Bus_WorkOr...

using CallCenterApi.DB;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace CallCenterApi.DAL
{
    /// <summary>
	/// 数据访问类:T_Bus_WorkOrder_WXDocking_logs
	/// </summary>
	public partial class T_Bus_WorkOrder_WXDocking_logs
    {
        public T_Bus_WorkOrder_WXDocking_logs()
        { }
        #region  Method

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(CallCenterApi.Model.T_Bus_WorkOrder_WXDocking_logs model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into T_Bus_WorkOrder_WXDocking_logs(");
            strSql.Append("F_CusName,F_CusPhone,F_ComTitle,F_ComContent,F_SourceArea,F_SourceAddress,F_Key,F_InfoType,F_IsProtect,F_File,F_openid,F_uuid,F_port_password,F_MapID,F_Direction,F_AddTime,F_Message,F_Action)");
            strSql.Append(" values (");
            strSql.Append("@F_CusName,@F_CusPhone,@F_ComTitle,@F_ComContent,@F_SourceArea,@F_SourceAddress,@F_Key,@F_InfoType,@F_IsProtect,@F_File,@F_openid,@F_uuid,@F_port_password,@F_MapID,@F_Direction,@F_AddTime,@F_Message,@F_Action)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@F_CusName", SqlDbType.NVarChar,20),
                    new SqlParameter("@F_CusPhone", SqlDbType.NVarChar,20),
                    new SqlParameter("@F_ComTitle", SqlDbType.NVarChar,200),
                    new SqlParameter("@F_ComContent", SqlDbType.NVarChar),
                    new SqlParameter("@F_SourceArea", SqlDbType.Int,4),
                    new SqlParameter("@F_SourceAddress", SqlDbType.NVarChar,200),
                    new SqlParameter("@F_Key", SqlDbType.VarChar,500),
                    new SqlParameter("@F_InfoType", SqlDbType.Int,4),
                    new SqlParameter("@F_IsProtect", SqlDbType.Int,4),
                    new SqlParameter("@F_File", SqlDbType.VarChar,500),
                    new SqlParameter("@F_openid", SqlDbType.NVarChar,50),
                    new SqlParameter("@F_uuid", SqlDbType.NVarChar,50),
                    new SqlParameter("@F_port_password", SqlDbType.NVarChar,200),
                    new SqlParameter("@F_MapID", SqlDbType.Int,4),
                    new SqlParameter("@F_Direction", SqlDbType.NVarChar,20),
                    new SqlParameter("@F_AddTime", SqlDbType.DateTime),
                    new SqlParameter("@F_Message", SqlDbType.NVarChar),
                    new SqlParameter("@F_Action", SqlDbType.NVarChar,200)};
            parameters[0].Value = model.F_CusName;
            parameters[1].Value = model.F_CusPhone;
            parameters[2].Value = model.F_ComTitle;
            parameters[3].Value = model.F_ComContent;
            parameters[4].Value = model.F_SourceArea;
            parameters[5].Value = model.F_SourceAddress;
            parameters[6].Value = model.F_Key;
            parameters[7].Value = model.F_InfoType;
            parameters[8].Value = model.F_IsProtect;
            parameters[9].Value = model.F_File;
            parameters[10].Value = model.F_openid;
            parameters[11].Value = model.F_uuid;
            parameters[12].Value = model.F_port_password;
            parameters[13].Value = model.F_MapID;
            parameters[14].Value = model.F_Direction;
            parameters[15].Value = model.F_AddTime;
            parameters[16].Value = model.F_Message;
            parameters[17].Value = model.F_Action;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
        #endregion  Method
    }
}