public bool Update(Model_FileSyncExecRecordDetail model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update FileSyncExecRecordDetail set ");
builder.Append("FileSyncExecRecord_id=@FileSyncExecRecord_id,");
builder.Append("Book_Id=@Book_Id,");
builder.Append("ResourceToResourceFolder_Id=@ResourceToResourceFolder_Id,");
builder.Append("TestQuestions_Id=@TestQuestions_Id,");
builder.Append("Resource_Type=@Resource_Type,");
builder.Append("FileUrl=@FileUrl,");
builder.Append("Detail_TimeStart=@Detail_TimeStart,");
builder.Append("Detail_TimeEnd=@Detail_TimeEnd,");
builder.Append("Detail_Status=@Detail_Status,");
builder.Append("Detail_Remark=@Detail_Remark");
builder.Append(" where FileSyncExecRecordDetail_id=@FileSyncExecRecordDetail_id ");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@FileSyncExecRecord_id", SqlDbType.Char, 0x24), new SqlParameter("@Book_Id", SqlDbType.Char, 0x24), new SqlParameter("@ResourceToResourceFolder_Id", SqlDbType.Char, 0x24), new SqlParameter("@TestQuestions_Id", SqlDbType.Char, 0x24), new SqlParameter("@Resource_Type", SqlDbType.Char, 0x24), new SqlParameter("@FileUrl", SqlDbType.VarChar, 0x3e8), new SqlParameter("@Detail_TimeStart", SqlDbType.DateTime), new SqlParameter("@Detail_TimeEnd", SqlDbType.DateTime), new SqlParameter("@Detail_Status", SqlDbType.VarChar, 10), new SqlParameter("@Detail_Remark", SqlDbType.VarChar, 500), new SqlParameter("@FileSyncExecRecordDetail_id", SqlDbType.Char, 0x24) };
cmdParms[0].Value = model.FileSyncExecRecord_id;
cmdParms[1].Value = model.Book_Id;
cmdParms[2].Value = model.ResourceToResourceFolder_Id;
cmdParms[3].Value = model.TestQuestions_Id;
cmdParms[4].Value = model.Resource_Type;
cmdParms[5].Value = model.FileUrl;
cmdParms[6].Value = model.Detail_TimeStart;
cmdParms[7].Value = model.Detail_TimeEnd;
cmdParms[8].Value = model.Detail_Status;
cmdParms[9].Value = model.Detail_Remark;
cmdParms[10].Value = model.FileSyncExecRecordDetail_id;
return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public Model_FileSyncExecRecordDetail DataRowToModel(DataRow row)
{
Model_FileSyncExecRecordDetail detail = new Model_FileSyncExecRecordDetail();
if (row != null)
{
if (row["FileSyncExecRecordDetail_id"] != null)
{
detail.FileSyncExecRecordDetail_id = row["FileSyncExecRecordDetail_id"].ToString();
}
if (row["FileSyncExecRecord_id"] != null)
{
detail.FileSyncExecRecord_id = row["FileSyncExecRecord_id"].ToString();
}
if (row["Book_Id"] != null)
{
detail.Book_Id = row["Book_Id"].ToString();
}
if (row["ResourceToResourceFolder_Id"] != null)
{
detail.ResourceToResourceFolder_Id = row["ResourceToResourceFolder_Id"].ToString();
}
if (row["TestQuestions_Id"] != null)
{
detail.TestQuestions_Id = row["TestQuestions_Id"].ToString();
}
if (row["Resource_Type"] != null)
{
detail.Resource_Type = row["Resource_Type"].ToString();
}
if (row["FileUrl"] != null)
{
detail.FileUrl = row["FileUrl"].ToString();
}
if ((row["Detail_TimeStart"] != null) && (row["Detail_TimeStart"].ToString() != ""))
{
detail.Detail_TimeStart = new DateTime?(DateTime.Parse(row["Detail_TimeStart"].ToString()));
}
if ((row["Detail_TimeEnd"] != null) && (row["Detail_TimeEnd"].ToString() != ""))
{
detail.Detail_TimeEnd = new DateTime?(DateTime.Parse(row["Detail_TimeEnd"].ToString()));
}
if (row["Detail_Status"] != null)
{
detail.Detail_Status = row["Detail_Status"].ToString();
}
if (row["Detail_Remark"] != null)
{
detail.Detail_Remark = row["Detail_Remark"].ToString();
}
}
return(detail);
}
public List <Model_FileSyncExecRecordDetail> DataTableToList(DataTable dt)
{
List <Model_FileSyncExecRecordDetail> list = new List <Model_FileSyncExecRecordDetail>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
Model_FileSyncExecRecordDetail item = this.dal.DataRowToModel(dt.Rows[i]);
if (item != null)
{
list.Add(item);
}
}
}
return(list);
}
public bool Add(Model_FileSyncExecRecordDetail model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into FileSyncExecRecordDetail(");
builder.Append("FileSyncExecRecordDetail_id,FileSyncExecRecord_id,Book_Id,ResourceToResourceFolder_Id,TestQuestions_Id,Resource_Type,FileUrl,Detail_TimeStart,Detail_TimeEnd,Detail_Status,Detail_Remark)");
builder.Append(" values (");
builder.Append("@FileSyncExecRecordDetail_id,@FileSyncExecRecord_id,@Book_Id,@ResourceToResourceFolder_Id,@TestQuestions_Id,@Resource_Type,@FileUrl,@Detail_TimeStart,@Detail_TimeEnd,@Detail_Status,@Detail_Remark)");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@FileSyncExecRecordDetail_id", SqlDbType.Char, 0x24), new SqlParameter("@FileSyncExecRecord_id", SqlDbType.Char, 0x24), new SqlParameter("@Book_Id", SqlDbType.Char, 0x24), new SqlParameter("@ResourceToResourceFolder_Id", SqlDbType.Char, 0x24), new SqlParameter("@TestQuestions_Id", SqlDbType.Char, 0x24), new SqlParameter("@Resource_Type", SqlDbType.Char, 0x24), new SqlParameter("@FileUrl", SqlDbType.VarChar, 0x3e8), new SqlParameter("@Detail_TimeStart", SqlDbType.DateTime), new SqlParameter("@Detail_TimeEnd", SqlDbType.DateTime), new SqlParameter("@Detail_Status", SqlDbType.VarChar, 10), new SqlParameter("@Detail_Remark", SqlDbType.VarChar, 500) };
cmdParms[0].Value = model.FileSyncExecRecordDetail_id;
cmdParms[1].Value = model.FileSyncExecRecord_id;
cmdParms[2].Value = model.Book_Id;
cmdParms[3].Value = model.ResourceToResourceFolder_Id;
cmdParms[4].Value = model.TestQuestions_Id;
cmdParms[5].Value = model.Resource_Type;
cmdParms[6].Value = model.FileUrl;
cmdParms[7].Value = model.Detail_TimeStart;
cmdParms[8].Value = model.Detail_TimeEnd;
cmdParms[9].Value = model.Detail_Status;
cmdParms[10].Value = model.Detail_Remark;
return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public bool Add(Model_FileSyncExecRecordDetail model)
{
return(this.dal.Add(model));
}
public bool Update(Model_FileSyncExecRecordDetail model)
{
return(this.dal.Update(model));
}
