public static AttachSegments Insert(string attachId, int segmentContentSize, int sortNo, string pathName) { AttachSegments result = null; try { string cmdTxt = @"insert into TBL_AttachSegments(AttachId,SegmentSize,SerialNumber,SegmentContent,UploadDate,IpAddr) values (@AttachId,@SegmentSize,@SerialNumber,@SegmentContent,@UploadDate,@IpAddr) "; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@AttachId", attachId), new SqlParameter("@SegmentSize", segmentContentSize), new SqlParameter("@SerialNumber", sortNo), new SqlParameter("@SegmentContent", pathName), new SqlParameter("@UploadDate", DateTime.Now.ToString()), new SqlParameter("@IpAddr", ""), }; SqlHelper.ExecuteNonQuery(DBConnectConfig.DBAttach, System.Data.CommandType.Text, cmdTxt, parameters); result = new AttachSegments { AttachId = attachId, IpAddr = "", SegmentSize = segmentContentSize, SegmentContent = pathName, SerialNumber = sortNo }; } catch (Exception ex) { result = null; Logger.SaveLog(ex.ToString()); } return(result); }
public int InsertSegment(byte[] segmentContent, int sortNo, string pathName) { int i = 0; if (this.RemainingCapacity >= segmentContent.Length) { AttachSegments segment = AttachSegments.Insert(this.AttachID, segmentContent.Length, sortNo, pathName); if (segment != null) { this.Segments.Add(segment); } i = 1; } else { throw new Exception("上传的文件片段内容大小超出文件总大小"); } return(i); }