/// <summary>
/// 得到一个对象实体
/// </summary>
public KryptonAccessController.SQLite.Model.LCDRelation.PlayMediaInfo GetModel(int PlayMediaID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select PlayMediaID,PlayMediaName,PlayReaderID,PlayLoop,PlayType1,PlayMediaGroupID1,STime1,ETime1,PlayType2,PlayMediaGroupID2,STime2,ETime2,PlayType3,PlayMediaGroupID3,STime3,ETime3,PlayType4,PlayMediaGroupID4,STime4,ETime4,PlayType5,PlayMediaGroupID5,STime5,ETime5,PlayType6,PlayMediaGroupID6,STime6,ETime6 from PlayMediaInfo ");
strSql.Append(" where PlayMediaID=@PlayMediaID ");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@PlayMediaID", DbType.Int32, 4)
};
parameters[0].Value = PlayMediaID;
KryptonAccessController.SQLite.Model.LCDRelation.PlayMediaInfo model = new KryptonAccessController.SQLite.Model.LCDRelation.PlayMediaInfo();
DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(KryptonAccessController.SQLite.Model.LCDRelation.PlayMediaInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into PlayMediaInfo(");
strSql.Append("PlayMediaID,PlayMediaName,PlayReaderID,PlayLoop,PlayType1,PlayMediaGroupID1,STime1,ETime1,PlayType2,PlayMediaGroupID2,STime2,ETime2,PlayType3,PlayMediaGroupID3,STime3,ETime3,PlayType4,PlayMediaGroupID4,STime4,ETime4,PlayType5,PlayMediaGroupID5,STime5,ETime5,PlayType6,PlayMediaGroupID6,STime6,ETime6)");
strSql.Append(" values (");
strSql.Append("@PlayMediaID,@PlayMediaName,@PlayReaderID,@PlayLoop,@PlayType1,@PlayMediaGroupID1,@STime1,@ETime1,@PlayType2,@PlayMediaGroupID2,@STime2,@ETime2,@PlayType3,@PlayMediaGroupID3,@STime3,@ETime3,@PlayType4,@PlayMediaGroupID4,@STime4,@ETime4,@PlayType5,@PlayMediaGroupID5,@STime5,@ETime5,@PlayType6,@PlayMediaGroupID6,@STime6,@ETime6)");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@PlayMediaID", DbType.Int32, 4),
new SQLiteParameter("@PlayMediaName", DbType.String),
new SQLiteParameter("@PlayReaderID", DbType.Int32, 4),
new SQLiteParameter("@PlayLoop", DbType.Boolean, 1),
new SQLiteParameter("@PlayType1", DbType.Int32, 4),
new SQLiteParameter("@PlayMediaGroupID1", DbType.Int32, 4),
new SQLiteParameter("@STime1", DbType.String),
new SQLiteParameter("@ETime1", DbType.String),
new SQLiteParameter("@PlayType2", DbType.Int32, 4),
new SQLiteParameter("@PlayMediaGroupID2", DbType.Int32, 4),
new SQLiteParameter("@STime2", DbType.String),
new SQLiteParameter("@ETime2", DbType.String),
new SQLiteParameter("@PlayType3", DbType.Int32, 4),
new SQLiteParameter("@PlayMediaGroupID3", DbType.Int32, 4),
new SQLiteParameter("@STime3", DbType.String),
new SQLiteParameter("@ETime3", DbType.String),
new SQLiteParameter("@PlayType4", DbType.Int32, 4),
new SQLiteParameter("@PlayMediaGroupID4", DbType.Int32, 4),
new SQLiteParameter("@STime4", DbType.String),
new SQLiteParameter("@ETime4", DbType.String),
new SQLiteParameter("@PlayType5", DbType.Int32, 4),
new SQLiteParameter("@PlayMediaGroupID5", DbType.Int32, 4),
new SQLiteParameter("@STime5", DbType.String),
new SQLiteParameter("@ETime5", DbType.String),
new SQLiteParameter("@PlayType6", DbType.Int32, 4),
new SQLiteParameter("@PlayMediaGroupID6", DbType.Int32, 4),
new SQLiteParameter("@STime6", DbType.String),
new SQLiteParameter("@ETime6", DbType.String)
};
parameters[0].Value = model.PlayMediaID;
parameters[1].Value = model.PlayMediaName;
parameters[2].Value = model.PlayReaderID;
parameters[3].Value = model.PlayLoop;
parameters[4].Value = model.PlayType1;
parameters[5].Value = model.PlayMediaGroupID1;
parameters[6].Value = model.STime1;
parameters[7].Value = model.ETime1;
parameters[8].Value = model.PlayType2;
parameters[9].Value = model.PlayMediaGroupID2;
parameters[10].Value = model.STime2;
parameters[11].Value = model.ETime2;
parameters[12].Value = model.PlayType3;
parameters[13].Value = model.PlayMediaGroupID3;
parameters[14].Value = model.STime3;
parameters[15].Value = model.ETime3;
parameters[16].Value = model.PlayType4;
parameters[17].Value = model.PlayMediaGroupID4;
parameters[18].Value = model.STime4;
parameters[19].Value = model.ETime4;
parameters[20].Value = model.PlayType5;
parameters[21].Value = model.PlayMediaGroupID5;
parameters[22].Value = model.STime5;
parameters[23].Value = model.ETime5;
parameters[24].Value = model.PlayType6;
parameters[25].Value = model.PlayMediaGroupID6;
parameters[26].Value = model.STime6;
parameters[27].Value = model.ETime6;
int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public KryptonAccessController.SQLite.Model.LCDRelation.PlayMediaInfo DataRowToModel(DataRow row)
{
KryptonAccessController.SQLite.Model.LCDRelation.PlayMediaInfo model = new KryptonAccessController.SQLite.Model.LCDRelation.PlayMediaInfo();
if (row != null)
{
if (row["PlayMediaID"] != null && row["PlayMediaID"].ToString() != "")
{
model.PlayMediaID = int.Parse(row["PlayMediaID"].ToString());
}
if (row["PlayMediaName"] != null)
{
model.PlayMediaName = row["PlayMediaName"].ToString();
}
if (row["PlayReaderID"] != null && row["PlayReaderID"].ToString() != "")
{
model.PlayReaderID = int.Parse(row["PlayReaderID"].ToString());
}
if (row["PlayLoop"] != null && row["PlayLoop"].ToString() != "")
{
if ((row["PlayLoop"].ToString() == "1") || (row["PlayLoop"].ToString().ToLower() == "true"))
{
model.PlayLoop = true;
}
else
{
model.PlayLoop = false;
}
}
if (row["PlayType1"] != null && row["PlayType1"].ToString() != "")
{
model.PlayType1 = int.Parse(row["PlayType1"].ToString());
}
if (row["PlayMediaGroupID1"] != null && row["PlayMediaGroupID1"].ToString() != "")
{
model.PlayMediaGroupID1 = int.Parse(row["PlayMediaGroupID1"].ToString());
}
if (row["STime1"] != null)
{
model.STime1 = row["STime1"].ToString();
}
if (row["ETime1"] != null)
{
model.ETime1 = row["ETime1"].ToString();
}
if (row["PlayType2"] != null && row["PlayType2"].ToString() != "")
{
model.PlayType2 = int.Parse(row["PlayType2"].ToString());
}
if (row["PlayMediaGroupID2"] != null && row["PlayMediaGroupID2"].ToString() != "")
{
model.PlayMediaGroupID2 = int.Parse(row["PlayMediaGroupID2"].ToString());
}
if (row["STime2"] != null)
{
model.STime2 = row["STime2"].ToString();
}
if (row["ETime2"] != null)
{
model.ETime2 = row["ETime2"].ToString();
}
if (row["PlayType3"] != null && row["PlayType3"].ToString() != "")
{
model.PlayType3 = int.Parse(row["PlayType3"].ToString());
}
if (row["PlayMediaGroupID3"] != null && row["PlayMediaGroupID3"].ToString() != "")
{
model.PlayMediaGroupID3 = int.Parse(row["PlayMediaGroupID3"].ToString());
}
if (row["STime3"] != null)
{
model.STime3 = row["STime3"].ToString();
}
if (row["ETime3"] != null)
{
model.ETime3 = row["ETime3"].ToString();
}
if (row["PlayType4"] != null && row["PlayType4"].ToString() != "")
{
model.PlayType4 = int.Parse(row["PlayType4"].ToString());
}
if (row["PlayMediaGroupID4"] != null && row["PlayMediaGroupID4"].ToString() != "")
{
model.PlayMediaGroupID4 = int.Parse(row["PlayMediaGroupID4"].ToString());
}
if (row["STime4"] != null)
{
model.STime4 = row["STime4"].ToString();
}
if (row["ETime4"] != null)
{
model.ETime4 = row["ETime4"].ToString();
}
if (row["PlayType5"] != null && row["PlayType5"].ToString() != "")
{
model.PlayType5 = int.Parse(row["PlayType5"].ToString());
}
if (row["PlayMediaGroupID5"] != null && row["PlayMediaGroupID5"].ToString() != "")
{
model.PlayMediaGroupID5 = int.Parse(row["PlayMediaGroupID5"].ToString());
}
if (row["STime5"] != null)
{
model.STime5 = row["STime5"].ToString();
}
if (row["ETime5"] != null)
{
model.ETime5 = row["ETime5"].ToString();
}
if (row["PlayType6"] != null && row["PlayType6"].ToString() != "")
{
model.PlayType6 = int.Parse(row["PlayType6"].ToString());
}
if (row["PlayMediaGroupID6"] != null && row["PlayMediaGroupID6"].ToString() != "")
{
model.PlayMediaGroupID6 = int.Parse(row["PlayMediaGroupID6"].ToString());
}
if (row["STime6"] != null)
{
model.STime6 = row["STime6"].ToString();
}
if (row["ETime6"] != null)
{
model.ETime6 = row["ETime6"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(KryptonAccessController.SQLite.Model.LCDRelation.PlayMediaInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update PlayMediaInfo set ");
strSql.Append("PlayMediaName=@PlayMediaName,");
strSql.Append("PlayReaderID=@PlayReaderID,");
strSql.Append("PlayLoop=@PlayLoop,");
strSql.Append("PlayType1=@PlayType1,");
strSql.Append("PlayMediaGroupID1=@PlayMediaGroupID1,");
strSql.Append("STime1=@STime1,");
strSql.Append("ETime1=@ETime1,");
strSql.Append("PlayType2=@PlayType2,");
strSql.Append("PlayMediaGroupID2=@PlayMediaGroupID2,");
strSql.Append("STime2=@STime2,");
strSql.Append("ETime2=@ETime2,");
strSql.Append("PlayType3=@PlayType3,");
strSql.Append("PlayMediaGroupID3=@PlayMediaGroupID3,");
strSql.Append("STime3=@STime3,");
strSql.Append("ETime3=@ETime3,");
strSql.Append("PlayType4=@PlayType4,");
strSql.Append("PlayMediaGroupID4=@PlayMediaGroupID4,");
strSql.Append("STime4=@STime4,");
strSql.Append("ETime4=@ETime4,");
strSql.Append("PlayType5=@PlayType5,");
strSql.Append("PlayMediaGroupID5=@PlayMediaGroupID5,");
strSql.Append("STime5=@STime5,");
strSql.Append("ETime5=@ETime5,");
strSql.Append("PlayType6=@PlayType6,");
strSql.Append("PlayMediaGroupID6=@PlayMediaGroupID6,");
strSql.Append("STime6=@STime6,");
strSql.Append("ETime6=@ETime6");
strSql.Append(" where PlayMediaID=@PlayMediaID ");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@PlayMediaName", DbType.String),
new SQLiteParameter("@PlayReaderID", DbType.Int32, 4),
new SQLiteParameter("@PlayLoop", DbType.Boolean, 1),
new SQLiteParameter("@PlayType1", DbType.Int32, 4),
new SQLiteParameter("@PlayMediaGroupID1", DbType.Int32, 4),
new SQLiteParameter("@STime1", DbType.String),
new SQLiteParameter("@ETime1", DbType.String),
new SQLiteParameter("@PlayType2", DbType.Int32, 4),
new SQLiteParameter("@PlayMediaGroupID2", DbType.Int32, 4),
new SQLiteParameter("@STime2", DbType.String),
new SQLiteParameter("@ETime2", DbType.String),
new SQLiteParameter("@PlayType3", DbType.Int32, 4),
new SQLiteParameter("@PlayMediaGroupID3", DbType.Int32, 4),
new SQLiteParameter("@STime3", DbType.String),
new SQLiteParameter("@ETime3", DbType.String),
new SQLiteParameter("@PlayType4", DbType.Int32, 4),
new SQLiteParameter("@PlayMediaGroupID4", DbType.Int32, 4),
new SQLiteParameter("@STime4", DbType.String),
new SQLiteParameter("@ETime4", DbType.String),
new SQLiteParameter("@PlayType5", DbType.Int32, 4),
new SQLiteParameter("@PlayMediaGroupID5", DbType.Int32, 4),
new SQLiteParameter("@STime5", DbType.String),
new SQLiteParameter("@ETime5", DbType.String),
new SQLiteParameter("@PlayType6", DbType.Int32, 4),
new SQLiteParameter("@PlayMediaGroupID6", DbType.Int32, 4),
new SQLiteParameter("@STime6", DbType.String),
new SQLiteParameter("@ETime6", DbType.String),
new SQLiteParameter("@PlayMediaID", DbType.Int32, 4)
};
parameters[0].Value = model.PlayMediaName;
parameters[1].Value = model.PlayReaderID;
parameters[2].Value = model.PlayLoop;
parameters[3].Value = model.PlayType1;
parameters[4].Value = model.PlayMediaGroupID1;
parameters[5].Value = model.STime1;
parameters[6].Value = model.ETime1;
parameters[7].Value = model.PlayType2;
parameters[8].Value = model.PlayMediaGroupID2;
parameters[9].Value = model.STime2;
parameters[10].Value = model.ETime2;
parameters[11].Value = model.PlayType3;
parameters[12].Value = model.PlayMediaGroupID3;
parameters[13].Value = model.STime3;
parameters[14].Value = model.ETime3;
parameters[15].Value = model.PlayType4;
parameters[16].Value = model.PlayMediaGroupID4;
parameters[17].Value = model.STime4;
parameters[18].Value = model.ETime4;
parameters[19].Value = model.PlayType5;
parameters[20].Value = model.PlayMediaGroupID5;
parameters[21].Value = model.STime5;
parameters[22].Value = model.ETime5;
parameters[23].Value = model.PlayType6;
parameters[24].Value = model.PlayMediaGroupID6;
parameters[25].Value = model.STime6;
parameters[26].Value = model.ETime6;
parameters[27].Value = model.PlayMediaID;
int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public KryptonAccessController.SQLite.Model.LCDRelation.PlayMediaInfo GetModel(int PlayMediaID)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select PlayMediaID,PlayMediaName,PlayReaderID,PlayLoop,PlayType1,PlayMediaGroupID1,STime1,ETime1,PlayType2,PlayMediaGroupID2,STime2,ETime2,PlayType3,PlayMediaGroupID3,STime3,ETime3,PlayType4,PlayMediaGroupID4,STime4,ETime4,PlayType5,PlayMediaGroupID5,STime5,ETime5,PlayType6,PlayMediaGroupID6,STime6,ETime6 from PlayMediaInfo ");
strSql.Append(" where PlayMediaID=@PlayMediaID ");
SQLiteParameter[] parameters = {
new SQLiteParameter("@PlayMediaID", DbType.Int32,4) };
parameters[0].Value = PlayMediaID;
KryptonAccessController.SQLite.Model.LCDRelation.PlayMediaInfo model=new KryptonAccessController.SQLite.Model.LCDRelation.PlayMediaInfo();
DataSet ds=DbHelperSQLite.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public KryptonAccessController.SQLite.Model.LCDRelation.PlayMediaInfo DataRowToModel(DataRow row)
{
KryptonAccessController.SQLite.Model.LCDRelation.PlayMediaInfo model=new KryptonAccessController.SQLite.Model.LCDRelation.PlayMediaInfo();
if (row != null)
{
if(row["PlayMediaID"]!=null && row["PlayMediaID"].ToString()!="")
{
model.PlayMediaID=int.Parse(row["PlayMediaID"].ToString());
}
if(row["PlayMediaName"]!=null)
{
model.PlayMediaName=row["PlayMediaName"].ToString();
}
if(row["PlayReaderID"]!=null && row["PlayReaderID"].ToString()!="")
{
model.PlayReaderID=int.Parse(row["PlayReaderID"].ToString());
}
if(row["PlayLoop"]!=null && row["PlayLoop"].ToString()!="")
{
if((row["PlayLoop"].ToString()=="1")||(row["PlayLoop"].ToString().ToLower()=="true"))
{
model.PlayLoop=true;
}
else
{
model.PlayLoop=false;
}
}
if(row["PlayType1"]!=null && row["PlayType1"].ToString()!="")
{
model.PlayType1=int.Parse(row["PlayType1"].ToString());
}
if(row["PlayMediaGroupID1"]!=null && row["PlayMediaGroupID1"].ToString()!="")
{
model.PlayMediaGroupID1=int.Parse(row["PlayMediaGroupID1"].ToString());
}
if(row["STime1"]!=null)
{
model.STime1=row["STime1"].ToString();
}
if(row["ETime1"]!=null)
{
model.ETime1=row["ETime1"].ToString();
}
if(row["PlayType2"]!=null && row["PlayType2"].ToString()!="")
{
model.PlayType2=int.Parse(row["PlayType2"].ToString());
}
if(row["PlayMediaGroupID2"]!=null && row["PlayMediaGroupID2"].ToString()!="")
{
model.PlayMediaGroupID2=int.Parse(row["PlayMediaGroupID2"].ToString());
}
if(row["STime2"]!=null)
{
model.STime2=row["STime2"].ToString();
}
if(row["ETime2"]!=null)
{
model.ETime2=row["ETime2"].ToString();
}
if(row["PlayType3"]!=null && row["PlayType3"].ToString()!="")
{
model.PlayType3=int.Parse(row["PlayType3"].ToString());
}
if(row["PlayMediaGroupID3"]!=null && row["PlayMediaGroupID3"].ToString()!="")
{
model.PlayMediaGroupID3=int.Parse(row["PlayMediaGroupID3"].ToString());
}
if(row["STime3"]!=null)
{
model.STime3=row["STime3"].ToString();
}
if(row["ETime3"]!=null)
{
model.ETime3=row["ETime3"].ToString();
}
if(row["PlayType4"]!=null && row["PlayType4"].ToString()!="")
{
model.PlayType4=int.Parse(row["PlayType4"].ToString());
}
if(row["PlayMediaGroupID4"]!=null && row["PlayMediaGroupID4"].ToString()!="")
{
model.PlayMediaGroupID4=int.Parse(row["PlayMediaGroupID4"].ToString());
}
if(row["STime4"]!=null)
{
model.STime4=row["STime4"].ToString();
}
if(row["ETime4"]!=null)
{
model.ETime4=row["ETime4"].ToString();
}
if(row["PlayType5"]!=null && row["PlayType5"].ToString()!="")
{
model.PlayType5=int.Parse(row["PlayType5"].ToString());
}
if(row["PlayMediaGroupID5"]!=null && row["PlayMediaGroupID5"].ToString()!="")
{
model.PlayMediaGroupID5=int.Parse(row["PlayMediaGroupID5"].ToString());
}
if(row["STime5"]!=null)
{
model.STime5=row["STime5"].ToString();
}
if(row["ETime5"]!=null)
{
model.ETime5=row["ETime5"].ToString();
}
if(row["PlayType6"]!=null && row["PlayType6"].ToString()!="")
{
model.PlayType6=int.Parse(row["PlayType6"].ToString());
}
if(row["PlayMediaGroupID6"]!=null && row["PlayMediaGroupID6"].ToString()!="")
{
model.PlayMediaGroupID6=int.Parse(row["PlayMediaGroupID6"].ToString());
}
if(row["STime6"]!=null)
{
model.STime6=row["STime6"].ToString();
}
if(row["ETime6"]!=null)
{
model.ETime6=row["ETime6"].ToString();
}
}
return model;
}
