Dal/BusinessNewsManage.cs

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

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

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

namespace US.Dal
{
  public  class BusinessNewsManage
    {
      public int BusinessNewsAdd(BusinessNewsInfo g)
      {
          SqlParameter[] parameter;
          parameter = SQLHelper.GetCachedParameters("AddBusinessNews");
          if (parameter == null)
          {
              parameter = new SqlParameter[] {
                  new SqlParameter("@flag",SqlDbType.Int,4),
                  new SqlParameter("@i_BNId",SqlDbType.Int,4),
                  new SqlParameter("@i_BUId",SqlDbType.Int,4),
                  new SqlParameter("@vc_BusinessName",SqlDbType.VarChar,50),
                  new SqlParameter("@vc_Department",SqlDbType.VarChar,50),
                  new SqlParameter("@vc_Trade",SqlDbType.VarChar,50),
                  new SqlParameter("@vc_Position",SqlDbType.VarChar,50),
                  new SqlParameter("@vc_PostDescribe",SqlDbType.VarChar,1000),
                  new SqlParameter("@vc_JobQuality",SqlDbType.VarChar,50),
                  new SqlParameter("@vc_Sage",SqlDbType.VarChar,50),
                  new SqlParameter("@vc_Quantity",SqlDbType.VarChar,50),
                  new SqlParameter("@vc_JobArea",SqlDbType.VarChar,50),
                  new SqlParameter("@vc_Wages",SqlDbType.VarChar,50),
                  new SqlParameter("@vc_SexClaim",SqlDbType.VarChar,50),
                  new SqlParameter("@vc_BeginTime",SqlDbType.DateTime,8),
                  new SqlParameter("@vc_EndTime",SqlDbType.DateTime,8),
                  new SqlParameter("@vc_LookTimes",SqlDbType.VarChar,20),
                  new SqlParameter("@vc_Experience",SqlDbType.VarChar,50),
                  new SqlParameter("@vc_Age",SqlDbType.VarChar,50),
                 
                  new SqlParameter("@vc_Deadline",SqlDbType.VarChar,20),
                  new SqlParameter("@vc_Tel",SqlDbType.VarChar,50),
                  new SqlParameter("@vc_Email",SqlDbType.VarChar,50),
                  new SqlParameter("@vc_Web",SqlDbType.VarChar,50),
                  new SqlParameter("@vc_Address",SqlDbType.VarChar,100),
                  new SqlParameter("@i_SHNews",SqlDbType.Int,4),
                  new SqlParameter("@vc_Manages",SqlDbType.VarChar,50),
                  new SqlParameter("@ret",SqlDbType.Int,4)
                 
              };
              SQLHelper.CacheParameters("AddBusinessNews", parameter);
          }
          parameter[0].Value=1;
          parameter[1].Value = 0;
          parameter[2].Value = g.I_BUId;
          parameter[3].Value =g.Vc_BusinessName;
          parameter[4].Value = g.Vc_Department;
          parameter[5].Value = g.Vc_Trade;
          parameter[6].Value = g.Vc_Position;
          parameter[7].Value = g.Vc_PostDescribe;
          parameter[8].Value = g.Vc_JobQuality;