protected static SqlParameter[] GetParameters(V_testdddInfo item)
{
return(new SqlParameter[] {
new SqlParameter {
ParameterName = "@category_id", SqlDbType = SqlDbType.Int, Size = 4, Value = item.Category_id
},
new SqlParameter {
ParameterName = "@content", SqlDbType = SqlDbType.NVarChar, Size = -1, Value = item.Content
},
new SqlParameter {
ParameterName = "@create_time", SqlDbType = SqlDbType.DateTime, Size = 8, Value = item.Create_time
},
new SqlParameter {
ParameterName = "@id", SqlDbType = SqlDbType.Int, Size = 4, Value = item.Id
},
new SqlParameter {
ParameterName = "@imgs", SqlDbType = SqlDbType.NVarChar, Size = 1024, Value = item.Imgs
},
new SqlParameter {
ParameterName = "@name", SqlDbType = SqlDbType.NVarChar, Size = 128, Value = item.Name
},
new SqlParameter {
ParameterName = "@stock", SqlDbType = SqlDbType.Int, Size = 4, Value = item.Stock
},
new SqlParameter {
ParameterName = "@title", SqlDbType = SqlDbType.NVarChar, Size = 256, Value = item.Title
},
new SqlParameter {
ParameterName = "@update_time", SqlDbType = SqlDbType.DateTime, Size = 8, Value = item.Update_time
}
});
}
private void CopyItemAllField(V_testdddInfo item, V_testdddInfo newitem)
{
item.Category_id = newitem.Category_id;
item.Content = newitem.Content;
item.Create_time = newitem.Create_time;
item.Id = newitem.Id;
item.Imgs = newitem.Imgs;
item.Name = newitem.Name;
item.Stock = newitem.Stock;
item.Title = newitem.Title;
item.Update_time = newitem.Update_time;
}
public object GetItem(SqlDataReader dr, ref int dataIndex)
{
V_testdddInfo item = new V_testdddInfo();
if (!dr.IsDBNull(++dataIndex))
{
item.Category_id = dr.GetInt32(dataIndex);
}
if (!dr.IsDBNull(++dataIndex))
{
item.Content = dr.GetString(dataIndex);
}
if (!dr.IsDBNull(++dataIndex))
{
item.Create_time = dr.GetDateTime(dataIndex);
}
if (!dr.IsDBNull(++dataIndex))
{
item.Id = dr.GetInt32(dataIndex);
}
if (!dr.IsDBNull(++dataIndex))
{
item.Imgs = dr.GetString(dataIndex);
}
if (!dr.IsDBNull(++dataIndex))
{
item.Name = dr.GetString(dataIndex);
}
if (!dr.IsDBNull(++dataIndex))
{
item.Stock = dr.GetInt32(dataIndex);
}
if (!dr.IsDBNull(++dataIndex))
{
item.Title = dr.GetString(dataIndex);
}
if (!dr.IsDBNull(++dataIndex))
{
item.Update_time = dr.GetDateTime(dataIndex);
}
return(item);
}
async public Task <(object result, int dataIndex)> GetItemAsync(SqlDataReader dr, int dataIndex)
{
V_testdddInfo item = new V_testdddInfo();
if (!await dr.IsDBNullAsync(++dataIndex))
{
item.Category_id = await dr.GetFieldValueAsync <int>(dataIndex);
}
if (!await dr.IsDBNullAsync(++dataIndex))
{
item.Content = await dr.GetFieldValueAsync <string>(dataIndex);
}
if (!await dr.IsDBNullAsync(++dataIndex))
{
item.Create_time = await dr.GetFieldValueAsync <DateTime>(dataIndex);
}
if (!await dr.IsDBNullAsync(++dataIndex))
{
item.Id = await dr.GetFieldValueAsync <int>(dataIndex);
}
if (!await dr.IsDBNullAsync(++dataIndex))
{
item.Imgs = await dr.GetFieldValueAsync <string>(dataIndex);
}
if (!await dr.IsDBNullAsync(++dataIndex))
{
item.Name = await dr.GetFieldValueAsync <string>(dataIndex);
}
if (!await dr.IsDBNullAsync(++dataIndex))
{
item.Stock = await dr.GetFieldValueAsync <int>(dataIndex);
}
if (!await dr.IsDBNullAsync(++dataIndex))
{
item.Title = await dr.GetFieldValueAsync <string>(dataIndex);
}
if (!await dr.IsDBNullAsync(++dataIndex))
{
item.Update_time = await dr.GetFieldValueAsync <DateTime>(dataIndex);
}
return(item, dataIndex);
}
public static string ToJson(this V_testdddInfo item) => string.Concat(item);