public static string Update(Model.Video.D_Video Item)
{
DataBase db = new DataBase();
DataBaseVisitor visitor = new DAL.Video.VideoVisitor();
bool bSuc = false;
int nEffectRows = 0;
SqlParameter[] prams ={
db.MakeInParam("@VIDEOname",SqlDbType .Char ,10,Item.VIDEO_name),
db.MakeInParam("@VIDEOtable",SqlDbType .VarChar ,50,Item.VIDEO_table ),
db.MakeInParam("@VIDEOStandard",SqlDbType.Int ,4,Item.VIDEO_Standard ),
db.MakeInParam("@VIDEOSource",SqlDbType.Int,4,Item.VIDEO_Source ),
db.MakeInParam("@VIDEOBrightness",SqlDbType.Int,4,Item.VIDEO_Brightness ),
db.MakeInParam("@VIDEOContrast",SqlDbType.Int,4,Item.VIDEO_Contrast ),
db.MakeInParam("@VIDEOHue",SqlDbType.Int,4,Item.VIDEO_Hue ),
db.MakeInParam("@VIDEOSaturation",SqlDbType.Int,4,Item.VIDEO_Saturation ),
db.MakeInParam("@VIDEOSuality",SqlDbType.Int,4,Item.VIDEO_Suality)
};
try
{
bSuc = db.TransactSql(visitor, "Set_Video", prams, out nEffectRows);
}
catch (Exception ex) { throw new Exception(ex.Message); }
finally
{
db.Dispose();
}
if (bSuc && nEffectRows > 0)
return "0101";
else
return "0";
}
/// <summary>
/// 查询
/// </summary>
/// <param name="Item"> model</param>
public static void DataShow(ref Model.Video.D_Video Item)
{
SqlDataReader dr = null;
DataBase db = new DataBase();
DataBaseVisitor visitor = new DAL.Video.VideoVisitor();
SqlParameter[] prams ={
db.MakeInParam("@VIDEO_name", SqlDbType.VarChar, 50, Item.VIDEO_name),
db.MakeInParam("@table", SqlDbType.VarChar, 50, Item.VIDEO_table),
};
try
{
db.GetDataReader(visitor, prams, out dr, "Select_D_Video");
if (dr.Read())
{
Item.VIDEO_Standard = int.Parse(dr["VIDEO_Standard"].ToString());
Item.VIDEO_Brightness = int.Parse(dr["VIDEO_Brightness"].ToString());
Item.VIDEO_Contrast = int.Parse(dr["VIDEO_Contrast"].ToString());
Item.VIDEO_Hue = int.Parse(dr["VIDEO_Hue"].ToString());
Item.VIDEO_Saturation = int.Parse(dr["VIDEO_Saturation"].ToString());
Item.VIDEO_Suality = int.Parse(dr["VIDEO_Suality"].ToString());
}
else
{
Item.VIDEO_Standard = 2;
Item.VIDEO_Brightness = 80;
Item.VIDEO_Contrast = 44;
Item.VIDEO_Hue = 0;
Item.VIDEO_Saturation = 40;
Item.VIDEO_Suality = 0;
}
}
catch (Exception ex)
{ throw new Exception(ex.Message); }
finally
{
dr.Close();
db.Dispose();
}
}
