public bool Add(Model_FileSyncRecordFail model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into FileSyncRecordFail("); builder.Append("FileSyncRecordFail_Id,Book_Id,ResourceToResourceFolder_Id,FileUrl,SyncFailTime,Resource_Type,File_Type)"); builder.Append(" values ("); builder.Append("@FileSyncRecordFail_Id,@Book_Id,@ResourceToResourceFolder_Id,@FileUrl,@SyncFailTime,@Resource_Type,@File_Type)"); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@FileSyncRecordFail_Id", SqlDbType.Char, 0x24), new SqlParameter("@Book_Id", SqlDbType.Char, 0x24), new SqlParameter("@ResourceToResourceFolder_Id", SqlDbType.Char, 0x24), new SqlParameter("@FileUrl", SqlDbType.NVarChar, 500), new SqlParameter("@SyncFailTime", SqlDbType.DateTime), new SqlParameter("@Resource_Type", SqlDbType.Char, 0x24), new SqlParameter("@File_Type", SqlDbType.NVarChar, 200) }; cmdParms[0].Value = model.FileSyncRecordFail_Id; cmdParms[1].Value = model.Book_Id; cmdParms[2].Value = model.ResourceToResourceFolder_Id; cmdParms[3].Value = model.FileUrl; cmdParms[4].Value = model.SyncFailTime; cmdParms[5].Value = model.Resource_Type; cmdParms[6].Value = model.File_Type; return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public List <Model_FileSyncRecordFail> DataTableToList(DataTable dt) { List <Model_FileSyncRecordFail> list = new List <Model_FileSyncRecordFail>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { Model_FileSyncRecordFail item = this.dal.DataRowToModel(dt.Rows[i]); if (item != null) { list.Add(item); } } } return(list); }
/// <summary> /// 插入失败表中 /// </summary> /// <param name="ResourceToResourceFolder_id"></param> /// <param name="BookId"></param> /// <param name="FileUrl"></param> /// <param name="Resource_Type"></param> /// <param name="Text"></param> public void InsertFail(string ResourceToResourceFolder_id, string BookId, string FileUrl, string Resource_Type, string Text) { try { Model_FileSyncRecordFail fsrf = new Model_FileSyncRecordFail(); BLL_FileSyncRecordFail fsrfbll = new BLL_FileSyncRecordFail(); fsrf.FileSyncRecordFail_Id = Guid.NewGuid().ToString(); fsrf.Book_Id = BookId; fsrf.SyncFailTime = DateTime.Now; fsrf.ResourceToResourceFolder_Id = ResourceToResourceFolder_id; fsrf.FileUrl = FileUrl; fsrf.File_Type = Text; fsrf.Resource_Type = Resource_Type; fsrfbll.Add(fsrf); } catch (Exception) { throw; } }
public bool Update(Model_FileSyncRecordFail model) { StringBuilder builder = new StringBuilder(); builder.Append("update FileSyncRecordFail set "); builder.Append("Book_Id=@Book_Id,"); builder.Append("ResourceToResourceFolder_Id=@ResourceToResourceFolder_Id,"); builder.Append("FileUrl=@FileUrl,"); builder.Append("SyncFailTime=@SyncFailTime,"); builder.Append("Resource_Type=@Resource_Type,"); builder.Append("File_Type=@File_Type"); builder.Append(" where FileSyncRecordFail_Id=@FileSyncRecordFail_Id "); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@Book_Id", SqlDbType.Char, 0x24), new SqlParameter("@ResourceToResourceFolder_Id", SqlDbType.Char, 0x24), new SqlParameter("@FileUrl", SqlDbType.NVarChar, 500), new SqlParameter("@SyncFailTime", SqlDbType.DateTime), new SqlParameter("@Resource_Type", SqlDbType.Char, 0x24), new SqlParameter("@File_Type", SqlDbType.NVarChar, 200), new SqlParameter("@FileSyncRecordFail_Id", SqlDbType.Char, 0x24) }; cmdParms[0].Value = model.Book_Id; cmdParms[1].Value = model.ResourceToResourceFolder_Id; cmdParms[2].Value = model.FileUrl; cmdParms[3].Value = model.SyncFailTime; cmdParms[4].Value = model.Resource_Type; cmdParms[5].Value = model.File_Type; cmdParms[6].Value = model.FileSyncRecordFail_Id; return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public Model_FileSyncRecordFail DataRowToModel(DataRow row) { Model_FileSyncRecordFail fail = new Model_FileSyncRecordFail(); if (row != null) { if (row["FileSyncRecordFail_Id"] != null) { fail.FileSyncRecordFail_Id = row["FileSyncRecordFail_Id"].ToString(); } if (row["Book_Id"] != null) { fail.Book_Id = row["Book_Id"].ToString(); } if (row["ResourceToResourceFolder_Id"] != null) { fail.ResourceToResourceFolder_Id = row["ResourceToResourceFolder_Id"].ToString(); } if (row["FileUrl"] != null) { fail.FileUrl = row["FileUrl"].ToString(); } if ((row["SyncFailTime"] != null) && (row["SyncFailTime"].ToString() != "")) { fail.SyncFailTime = new DateTime?(DateTime.Parse(row["SyncFailTime"].ToString())); } if (row["Resource_Type"] != null) { fail.Resource_Type = row["Resource_Type"].ToString(); } if (row["File_Type"] != null) { fail.File_Type = row["File_Type"].ToString(); } } return(fail); }
public bool Add(Model_FileSyncRecordFail model) { return(this.dal.Add(model)); }
public bool Update(Model_FileSyncRecordFail model) { return(this.dal.Update(model)); }