Dal/MessagedManage.cs

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

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

using System;
using System.Collections.Generic;
using System.Text;
using US.Model;
using System.Data;
using System.Data.SqlClient;
using US.DBUtility;

namespace US.Dal
{
   public class MessagedManage
    {
       public int MessageAdd(MessagesInfo g)
       {

           SqlParameter[] parameter;
           parameter = SQLHelper.GetCachedParameters("AddMessage");
           if (parameter == null)
           {
               parameter = new SqlParameter[] { 
                   new SqlParameter("@flag",SqlDbType.Int,4),
                   new SqlParameter("@i_MId",SqlDbType.Int,4),
                   new SqlParameter("@vc_Status",SqlDbType.VarChar,50),
                   new SqlParameter("@vc_Mname",SqlDbType.VarChar,50),
                   new SqlParameter("@vc_Phone",SqlDbType.VarChar,50),
                   new SqlParameter("@vc_Email",SqlDbType.VarChar,50),
                   new SqlParameter("@vc_Title",SqlDbType.VarChar,50),
                   new SqlParameter("@vc_form",SqlDbType.VarChar,1000),
                   new SqlParameter("@dt_TianTime",SqlDbType.DateTime,8),
                   new SqlParameter("@ret",SqlDbType.Int,4)
               };
               SQLHelper.CacheParameters("AddMessage", parameter);
           }
           parameter[0].Value = 1;
           parameter[1].Value = 0;
           parameter[2].Value = g.Vc_Status;
           parameter[3].Value = g.Vc_Nname;
           parameter[4].Value = g.Vc_Phone;
           parameter[5].Value = g.Vc_Email;
           parameter[6].Value = g.Vc_Title;
           parameter[7].Value = g.Vc_form;
           parameter[8].Value = g.Dt_TianTime;
           parameter[9].Direction = ParameterDirection.Output;
           SQLHelper.ExecuteNonQuery(SQLHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "AddMessage", parameter);
           return Convert.ToInt32(parameter[9].Value);
       }
       public int Messageupdate(MessagesInfo g)
       {
           SqlParameter[] parameter;
           parameter = SQLHelper.GetCachedParameters("AddMessage");
           if (parameter == null)
           {
               parameter = new SqlParameter[] { 
                   new SqlParameter("@flag",SqlDbType.Int,4),
                   new SqlParameter("@i_MId",SqlDbType.Int,4),
                   new SqlParameter("@vc_Status",SqlDbType.VarChar,50),
                   new SqlParameter("@vc_Mname",SqlDbType.VarChar,50),
                   new SqlParameter("@vc_Phone",SqlDbType.VarChar,50),
                   new SqlParameter("@vc_Email",SqlDbType.VarChar,50),
                   new SqlParameter("@vc_Title",SqlDbType.VarChar,50),