private static void SetParameters(Business.DataObjectDocument item, SqlParameterCollection parameters)
{
parameters.AddWithValue("@SizeByte", item.SizeByte);
if (!string.IsNullOrEmpty(item.URLDocument))
{
parameters.AddWithValue("@URLDocument", item.URLDocument);
}
else
{
parameters.AddWithValue("@URLDocument", DBNull.Value);
}
if (!string.IsNullOrEmpty(item.Author))
{
parameters.AddWithValue("@Author", item.Author);
}
else
{
parameters.AddWithValue("@Author", DBNull.Value);
}
if (!string.IsNullOrEmpty(item.Version))
{
parameters.AddWithValue("@Version", item.Version);
}
else
{
parameters.AddWithValue("@Version", DBNull.Value);
}
}
public static void FillObject(Business.DataObjectDocument item, SqlDataReader sqlReader)
{
item.SizeByte = (long)sqlReader["SizeByte"];
if (sqlReader["URLDocument"] != DBNull.Value)
{
item.URLDocument = sqlReader["URLDocument"].ToString();
}
if (sqlReader["Author"] != DBNull.Value)
{
item.Author = sqlReader["Author"].ToString();
}
if (sqlReader["Version"] != DBNull.Value)
{
item.Version = sqlReader["Version"].ToString();
}
}
public static string GetUpdateSQL(Business.DataObjectDocument item, SqlParameterCollection parameters)
{
SetParameters(item, parameters);
return("UPDATE hiobj_Document SET [SizeByte] = @SizeByte, [URLDocument] = @URLDocument, [Author] = @Author, [Version] = @Version");
}
public static string GetInsertSQL(Business.DataObjectDocument item, SqlParameterCollection parameters)
{
SetParameters(item, parameters);
return("INSERT INTO hiobj_Document ([OBJ_ID],[SizeByte],[URLDocument],[Author],[Version]) VALUES (@OBJ_ID,@SizeByte,@URLDocument,@Author,@Version)");
}
