/// <summary>
/// 得到一个对象实体
/// </summary>
public KryptonAccessController.AccessDataBase.Model.PlayMediaInfo GetModel(int PlayMediaID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 PlayMediaID,PlayMediaName,PlayReaderID,PlayLoop,PlayMediaGroupID1,STime1,ETime1,PlayMediaGroupID2,STime2,ETime2,PlayMediaGroupID3,STime3,ETime3,PlayMediaGroupID4,STime4,ETime4,PlayMediaGroupID5,STime5,ETime5,PlayMediaGroupID6,STime6,ETime6 from PlayMediaInfo ");
strSql.Append(" where PlayMediaID=@PlayMediaID ");
SqlParameter[] parameters =
{
new SqlParameter("@PlayMediaID", SqlDbType.Int, 4)
};
parameters[0].Value = PlayMediaID;
KryptonAccessController.AccessDataBase.Model.PlayMediaInfo model = new KryptonAccessController.AccessDataBase.Model.PlayMediaInfo();
DataSet ds = DbHelperSQL.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.AccessDataBase.Model.PlayMediaInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into PlayMediaInfo(");
strSql.Append("PlayMediaID,PlayMediaName,PlayReaderID,PlayLoop,PlayMediaGroupID1,STime1,ETime1,PlayMediaGroupID2,STime2,ETime2,PlayMediaGroupID3,STime3,ETime3,PlayMediaGroupID4,STime4,ETime4,PlayMediaGroupID5,STime5,ETime5,PlayMediaGroupID6,STime6,ETime6)");
strSql.Append(" values (");
strSql.Append("@PlayMediaID,@PlayMediaName,@PlayReaderID,@PlayLoop,@PlayMediaGroupID1,@STime1,@ETime1,@PlayMediaGroupID2,@STime2,@ETime2,@PlayMediaGroupID3,@STime3,@ETime3,@PlayMediaGroupID4,@STime4,@ETime4,@PlayMediaGroupID5,@STime5,@ETime5,@PlayMediaGroupID6,@STime6,@ETime6)");
SqlParameter[] parameters =
{
new SqlParameter("@PlayMediaID", SqlDbType.Int, 4),
new SqlParameter("@PlayMediaName", SqlDbType.NVarChar, 50),
new SqlParameter("@PlayReaderID", SqlDbType.Int, 4),
new SqlParameter("@PlayLoop", SqlDbType.Bit, 1),
new SqlParameter("@PlayMediaGroupID1", SqlDbType.Int, 4),
new SqlParameter("@STime1", SqlDbType.NVarChar, 8),
new SqlParameter("@ETime1", SqlDbType.NVarChar, 8),
new SqlParameter("@PlayMediaGroupID2", SqlDbType.Int, 4),
new SqlParameter("@STime2", SqlDbType.NVarChar, 8),
new SqlParameter("@ETime2", SqlDbType.NVarChar, 8),
new SqlParameter("@PlayMediaGroupID3", SqlDbType.Int, 4),
new SqlParameter("@STime3", SqlDbType.NVarChar, 8),
new SqlParameter("@ETime3", SqlDbType.NVarChar, 8),
new SqlParameter("@PlayMediaGroupID4", SqlDbType.Int, 4),
new SqlParameter("@STime4", SqlDbType.NVarChar, 8),
new SqlParameter("@ETime4", SqlDbType.NVarChar, 8),
new SqlParameter("@PlayMediaGroupID5", SqlDbType.Int, 4),
new SqlParameter("@STime5", SqlDbType.NVarChar, 8),
new SqlParameter("@ETime5", SqlDbType.NVarChar, 8),
new SqlParameter("@PlayMediaGroupID6", SqlDbType.Int, 4),
new SqlParameter("@STime6", SqlDbType.NVarChar, 8),
new SqlParameter("@ETime6", SqlDbType.NVarChar, 8)
};
parameters[0].Value = model.PlayMediaID;
parameters[1].Value = model.PlayMediaName;
parameters[2].Value = model.PlayReaderID;
parameters[3].Value = model.PlayLoop;
parameters[4].Value = model.PlayMediaGroupID1;
parameters[5].Value = model.STime1;
parameters[6].Value = model.ETime1;
parameters[7].Value = model.PlayMediaGroupID2;
parameters[8].Value = model.STime2;
parameters[9].Value = model.ETime2;
parameters[10].Value = model.PlayMediaGroupID3;
parameters[11].Value = model.STime3;
parameters[12].Value = model.ETime3;
parameters[13].Value = model.PlayMediaGroupID4;
parameters[14].Value = model.STime4;
parameters[15].Value = model.ETime4;
parameters[16].Value = model.PlayMediaGroupID5;
parameters[17].Value = model.STime5;
parameters[18].Value = model.ETime5;
parameters[19].Value = model.PlayMediaGroupID6;
parameters[20].Value = model.STime6;
parameters[21].Value = model.ETime6;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public KryptonAccessController.AccessDataBase.Model.PlayMediaInfo DataRowToModel(DataRow row)
{
KryptonAccessController.AccessDataBase.Model.PlayMediaInfo model = new KryptonAccessController.AccessDataBase.Model.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["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["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["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["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["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["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.AccessDataBase.Model.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("PlayMediaGroupID1=@PlayMediaGroupID1,");
strSql.Append("STime1=@STime1,");
strSql.Append("ETime1=@ETime1,");
strSql.Append("PlayMediaGroupID2=@PlayMediaGroupID2,");
strSql.Append("STime2=@STime2,");
strSql.Append("ETime2=@ETime2,");
strSql.Append("PlayMediaGroupID3=@PlayMediaGroupID3,");
strSql.Append("STime3=@STime3,");
strSql.Append("ETime3=@ETime3,");
strSql.Append("PlayMediaGroupID4=@PlayMediaGroupID4,");
strSql.Append("STime4=@STime4,");
strSql.Append("ETime4=@ETime4,");
strSql.Append("PlayMediaGroupID5=@PlayMediaGroupID5,");
strSql.Append("STime5=@STime5,");
strSql.Append("ETime5=@ETime5,");
strSql.Append("PlayMediaGroupID6=@PlayMediaGroupID6,");
strSql.Append("STime6=@STime6,");
strSql.Append("ETime6=@ETime6");
strSql.Append(" where PlayMediaID=@PlayMediaID ");
SqlParameter[] parameters =
{
new SqlParameter("@PlayMediaName", SqlDbType.NVarChar, 50),
new SqlParameter("@PlayReaderID", SqlDbType.Int, 4),
new SqlParameter("@PlayLoop", SqlDbType.Bit, 1),
new SqlParameter("@PlayMediaGroupID1", SqlDbType.Int, 4),
new SqlParameter("@STime1", SqlDbType.NVarChar, 8),
new SqlParameter("@ETime1", SqlDbType.NVarChar, 8),
new SqlParameter("@PlayMediaGroupID2", SqlDbType.Int, 4),
new SqlParameter("@STime2", SqlDbType.NVarChar, 8),
new SqlParameter("@ETime2", SqlDbType.NVarChar, 8),
new SqlParameter("@PlayMediaGroupID3", SqlDbType.Int, 4),
new SqlParameter("@STime3", SqlDbType.NVarChar, 8),
new SqlParameter("@ETime3", SqlDbType.NVarChar, 8),
new SqlParameter("@PlayMediaGroupID4", SqlDbType.Int, 4),
new SqlParameter("@STime4", SqlDbType.NVarChar, 8),
new SqlParameter("@ETime4", SqlDbType.NVarChar, 8),
new SqlParameter("@PlayMediaGroupID5", SqlDbType.Int, 4),
new SqlParameter("@STime5", SqlDbType.NVarChar, 8),
new SqlParameter("@ETime5", SqlDbType.NVarChar, 8),
new SqlParameter("@PlayMediaGroupID6", SqlDbType.Int, 4),
new SqlParameter("@STime6", SqlDbType.NVarChar, 8),
new SqlParameter("@ETime6", SqlDbType.NVarChar, 8),
new SqlParameter("@PlayMediaID", SqlDbType.Int, 4)
};
parameters[0].Value = model.PlayMediaName;
parameters[1].Value = model.PlayReaderID;
parameters[2].Value = model.PlayLoop;
parameters[3].Value = model.PlayMediaGroupID1;
parameters[4].Value = model.STime1;
parameters[5].Value = model.ETime1;
parameters[6].Value = model.PlayMediaGroupID2;
parameters[7].Value = model.STime2;
parameters[8].Value = model.ETime2;
parameters[9].Value = model.PlayMediaGroupID3;
parameters[10].Value = model.STime3;
parameters[11].Value = model.ETime3;
parameters[12].Value = model.PlayMediaGroupID4;
parameters[13].Value = model.STime4;
parameters[14].Value = model.ETime4;
parameters[15].Value = model.PlayMediaGroupID5;
parameters[16].Value = model.STime5;
parameters[17].Value = model.ETime5;
parameters[18].Value = model.PlayMediaGroupID6;
parameters[19].Value = model.STime6;
parameters[20].Value = model.ETime6;
parameters[21].Value = model.PlayMediaID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public KryptonAccessController.AccessDataBase.Model.PlayMediaInfo GetModel(int PlayMediaID)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 PlayMediaID,PlayMediaName,PlayReaderID,PlayLoop,PlayMediaGroupID1,STime1,ETime1,PlayMediaGroupID2,STime2,ETime2,PlayMediaGroupID3,STime3,ETime3,PlayMediaGroupID4,STime4,ETime4,PlayMediaGroupID5,STime5,ETime5,PlayMediaGroupID6,STime6,ETime6 from PlayMediaInfo ");
strSql.Append(" where PlayMediaID=@PlayMediaID ");
SqlParameter[] parameters = {
new SqlParameter("@PlayMediaID", SqlDbType.Int,4) };
parameters[0].Value = PlayMediaID;
KryptonAccessController.AccessDataBase.Model.PlayMediaInfo model=new KryptonAccessController.AccessDataBase.Model.PlayMediaInfo();
DataSet ds=DbHelperSQL.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.AccessDataBase.Model.PlayMediaInfo DataRowToModel(DataRow row)
{
KryptonAccessController.AccessDataBase.Model.PlayMediaInfo model=new KryptonAccessController.AccessDataBase.Model.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["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["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["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["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["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["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;
}
