110,536
社区成员
发帖
与我相关
我的任务
分享
if (sender == this.buttonJRDL)//加入队列
{
lock (ServiceBase.TBLInfoEntityMessageBase)
{
selectrs = (DataRow[])ServiceBase.TBLInfoEntityMessageBase.Select("infoarea = '待发' and infosendsoure2 = '紧急信息' and uiunique like '%(新)'").SyncRoot;
}
}
if (sender == this.buttonLJFS) //立即发送
{
lock (ServiceBase.TBLInfoEntityMessageBase)
{
selectrs = (DataRow[])ServiceBase.TBLInfoEntityMessageBase.Select("infoarea = '已发' and infosendsoure2 = '紧急信息' and uiunique like '%(新)'").SyncRoot;
}
}
for (int i = 0; i < selectrs.Length; i++)
{
selectrs[i].BeginEdit();
selectrs[i]["uiunique"] = selectrs[i]["uiunique"].ToString().Replace("(新)", "");
selectrs[i].EndEdit();
}
if (sendcommand == SendCommand.发送)
{
filterExpression = "infoid =" + messageentity.UIID + " and infotype = 'group' and infosendtype = '" + sendcommand.ToString() + "' and infoarea = '已发' and infosendtime >='" + DateTime.Now.ToString("yyyy-MM-dd 00:00:00.0000") + "' and infosendtime <='" + DateTime.Now.ToString("yyyy-MM-dd 23:59:59.9999") + "'";
lock (ServiceBase.TBLInfoEntityMessageBase)
{
pidcount = (new DataView(ServiceBase.TBLInfoEntityMessageBase, filterExpression, string.Empty, DataViewRowState.CurrentRows))[0]["infopointidcount"].ToString();
}
}
else
{
filterExpression = "infoid =" + messageentity.UIID + " and infotype = 'point' and infosendtype = '" + sendcommand.ToString() + "' and infoarea = '已发' and infosendtime >='" + DateTime.Now.ToString("yyyy-MM-dd 00:00:00.0000") + "' and infosendtime <='" + DateTime.Now.ToString("yyyy-MM-dd 23:59:59.9999") + "'";
lock (ServiceBase.TBLInfoEntityMessageBase)
{
pidcount = (new DataView(ServiceBase.TBLInfoEntityMessageBase, filterExpression, string.Empty, DataViewRowState.CurrentRows)).Count.ToString();
}
}