/// <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; }