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));
}
