/// <summary>
/// 更新历史安灯记录
/// </summary>
/// <param name="openSftwTime">首次打开软件的时间</param>
/// <param name="playerIndex">播放器序列号</param>
/// <returns>受影响记录条数</returns>
public int UpdateHistroyAdn(DateTime openSftwTime, int playerIndex)
{
string where = string.Format(" call_time<='{0}' and SUBSTRING(play_record,{1},1)='1' order by call_time desc", openSftwTime.ToString("yyyy-MM-dd HH:mm:ss.fff"), playerIndex);
DAO.SqlServerHelper dbEngine = DAO.SqlServerHelper.CreateInstance(SqlConStr);
List <Model.TableModel.Adn> listAnd = dbEngine.QueryList <Model.TableModel.Adn>(where);
foreach (Model.TableModel.Adn item in listAnd)
{
string newPlayRecord = CaclNewPlayRecord(item.play_record, playerIndex);
item.play_record = newPlayRecord;
}
return(dbEngine.QueryInt <Model.TableModel.Adn>("Update", listAnd));
}
/// <summary>
/// 播放安灯呼叫
/// </summary>
/// <param name="dtOpenSftwDateTime">初次打开软件的事件</param>
/// <param name="andonEqmIndex">安灯播放器编号</param>
internal void Play(DateTime dtOpenSftwDateTime, int andonEqmIndex)
{
AndonPlayerIsRun = false;
DAO.SqlServerHelper dbEngine = DAO.SqlServerHelper.CreateInstance(SqlConStr);
string where = string.Format(" call_time>'{0}' and SUBSTRING(play_record,{1},1)='1' and is_finished='false' and andon_type_no in ({2}) order by call_time desc", dtOpenSftwDateTime.ToString("yyyy-MM-dd HH:mm:ss.fff"), andonEqmIndex, AndonType);
List <Model.TableModel.Adn> listAdn = dbEngine.QueryList <Model.TableModel.Adn>(where);
if (listAdn.Count <= 0)
{
return;
}
string musicName = listAdn[0].andon_music_no;
_mp3.Play(AndonFilePath + "\\" + musicName, 5);
int tim = _mp3.GetTimeLong();
List <Model.TableModel.Adn> newListAdn = new List <Model.TableModel.Adn>();
string newPlayRecord = CaclNewPlayRecord(listAdn[0].play_record, andonEqmIndex);
listAdn[0].play_record = newPlayRecord;
newListAdn.Add(listAdn[0]);
dbEngine.QueryInt <Model.TableModel.Adn>("Update", newListAdn);
}