/// <summary> /// 修改CPS信息. /// </summary> /// <param name="cps"> /// Cps对象实例. /// </param> public void Modify(Cps cps) { this.cpsDA.Update(cps); }
/// <summary> /// 添加CPS信息. /// </summary> /// <param name="cps"> /// The cps. /// </param> /// <returns> /// The <see cref="int"/>. /// </returns> public int Insert(Cps cps) { if (cps == null) { throw new ArgumentNullException("cps"); } var parameters = new List<SqlParameter> { this.SqlServer.CreateSqlParameter( "Name", SqlDbType.NVarChar, cps.Name, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "UserName", SqlDbType.NVarChar, cps.UserName, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "URL", SqlDbType.NVarChar, cps.URL, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "Linkman", SqlDbType.NVarChar, cps.Linkman, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "Mobile", SqlDbType.VarChar, cps.Mobile, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "Tel", SqlDbType.VarChar, cps.Tel, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "Email", SqlDbType.VarChar, cps.Email, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "QQ", SqlDbType.VarChar, cps.QQ, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "Company", SqlDbType.NVarChar, cps.Company, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "CompanyAddress", SqlDbType.NVarChar, cps.CompanyAddress, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "ZipCode", SqlDbType.VarChar, cps.ZipCode, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "TrackingURL", SqlDbType.VarChar, cps.TrackingURL, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "CreateTime", SqlDbType.DateTime, cps.CreateTime, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "ReferenceID", SqlDbType.Int, null, ParameterDirection.Output) }; this.SqlServer.ExecuteNonQuery(CommandType.StoredProcedure, "sp_Cps_Insert", parameters, null); return (int)parameters.Find(parameter => parameter.ParameterName == "ReferenceID").Value; }
/// <summary> /// 添加CPS信息. /// </summary> /// <param name="cps"> /// Cps的对象实例. /// </param> /// <returns> /// 编号. /// </returns> public int AddCps(Cps cps) { return this.cpsDA.Insert(cps); }
/// <summary> /// 更新Cps信息. /// </summary> /// <param name="cps"> /// Cps的对象实例. /// </param> public void Update(Cps cps) { if (cps == null) { throw new ArgumentNullException("cps"); } var parameters = new List<SqlParameter> { this.SqlServer.CreateSqlParameter( "ID", SqlDbType.NVarChar, cps.ID, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "Name", SqlDbType.NVarChar, cps.Name, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "UserName", SqlDbType.NVarChar, cps.UserName, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "URL", SqlDbType.NVarChar, cps.URL, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "Linkman", SqlDbType.NVarChar, cps.Linkman, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "Mobile", SqlDbType.VarChar, cps.Mobile, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "Tel", SqlDbType.VarChar, cps.Tel, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "Email", SqlDbType.VarChar, cps.Email, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "QQ", SqlDbType.VarChar, cps.QQ, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "Company", SqlDbType.NVarChar, cps.Company, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "CompanyAddress", SqlDbType.NVarChar, cps.CompanyAddress, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "ZipCode", SqlDbType.VarChar, cps.ZipCode, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "TrackingURL", SqlDbType.VarChar, cps.TrackingURL, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "CreateTime", SqlDbType.DateTime, cps.CreateTime, ParameterDirection.Input), }; this.SqlServer.ExecuteNonQuery(CommandType.StoredProcedure, "sp_Cps_Update", parameters, null); }