Dal/PersonalRusumesManage.cs

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

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

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

namespace US.Dal
{
  public  class PersonalRusumesManage
    {
      public int PersonalRusumesAdd(PersonalRusumesInfo g)
      {
          SqlParameter[] parameter;
          parameter = SQLHelper.GetCachedParameters("AddPersonalRusumes");
          if (parameter == null)
          {
              parameter = new SqlParameter[] { 
                  new SqlParameter("@flag",SqlDbType.Int,4),
                  new SqlParameter("@i_PRId",SqlDbType.Int,4),
                  new SqlParameter("@i_PUId",SqlDbType.Int,4),
                  new SqlParameter("@vc_PRName",SqlDbType.VarChar,20),
                  new SqlParameter("@vc_Sex",SqlDbType.VarChar,50),
                  new SqlParameter("@vc_Nation",SqlDbType.VarChar,50),
                  new SqlParameter("@vc_BronTime",SqlDbType.VarChar,50),
                  new SqlParameter("@vc_MarryState",SqlDbType.VarChar,50),
                  new SqlParameter("@vc_ID",SqlDbType.VarChar,50),
                  new SqlParameter("@vc_Height",SqlDbType.VarChar,50),
                  new SqlParameter("@vc_HomeTown",SqlDbType.VarChar,50),
                  new SqlParameter("@vc_City",SqlDbType.VarChar,50),
                  new SqlParameter("@vc_SAge",SqlDbType.VarChar,50),
                  new SqlParameter("@vc_Experience",SqlDbType.VarChar,50),
                  new SqlParameter("@vc_Appreise",SqlDbType.VarChar,50),
                  new SqlParameter("@vc_Phone",SqlDbType.VarChar,50),
                  new SqlParameter("@vc_QQ",SqlDbType.VarChar,50),
                  new SqlParameter("@vc_Email",SqlDbType.VarChar,50),
                  new SqlParameter("@vc_Postcode",SqlDbType.VarChar,50),
                  new SqlParameter("@vc_University",SqlDbType.VarChar,50),
                  new SqlParameter("@vc_GTime",SqlDbType.DateTime,8),
                  new SqlParameter("@vc_Specialty",SqlDbType.VarChar,50),
                  new SqlParameter("@vc_Class",SqlDbType.VarChar,50),
                  new SqlParameter("@vc_SId",SqlDbType.VarChar,50),
                  new SqlParameter("@vc_Address",SqlDbType.VarChar,200),
                  new SqlParameter("@vc_PersonalEn",SqlDbType.VarChar,50),
                  new SqlParameter("@vc_PoliticsFace",SqlDbType.VarChar,50),
                  new SqlParameter("@vc_zhaopian",SqlDbType.VarChar,200),
                  new SqlParameter("@dt_TJTime",SqlDbType.DateTime,8),
                  new SqlParameter("@ret",SqlDbType.Int,4)

           
              };
              SQLHelper.CacheParameters("AddPersonalRusumes", parameter);
             
          }
          parameter[0].Value = 1;
          parameter[1].Value = 0;
          parameter[2].Value = g.I_PUId;
          parameter[3].Value = g.Vc_PRName;
          parameter[4].Value = g.Vc_Sex;