public bool GetOpenConference()
{
SqlConnection sc = MSSQLDB.CreateDBConnet();
try
{
// 0 1 2 3 4 5 6 7 8
string ss = "select mID,mName,mContent,mFileType,mFilePath,mRoomID,mclientShowID,mNoteID,mEnterpriseID from dbo.ConMeeting where getdate()>mstarttime and getdate()<mendtime";
sc.Open();
SqlCommand scmd = new SqlCommand(ss, sc);
DataTable dt = new DataTable();
SqlDataAdapter sda = new SqlDataAdapter(scmd);
sda.Fill(dt);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
string sid = dr[0].ToString();
ss = @"select mPersonID,mStatus from dbo.ConPersonAddress where mConID=" + sid + " and mMacAddress='" + sMac + "'";
scmd.CommandText = ss;
SqlDataReader sdr = scmd.ExecuteReader();
if (sdr.Read())
{
sId = sid;
//ver2.0
sConname = dr[1].ToString();
sConferencecontent = dr[2].ToString();
mUser = new User(sdr[0].ToString(), int.Parse(sdr[1].ToString()));
sdr.Close();
sc.Close();
GetAgendos(sid);
return true;//ApplyValue(dr);
}
}
sc.Close();
sfailedopen = "不是匹配的客户端！" + sMac;
return false;
}
else
{
sfailedopen = "没有正在召开的会议！";
sc.Close();
return false;
}
}
catch { sfailedopen = MSSQLDB.error; }
return false;
}
private void initDatetime(DateTime dtstart, DateTime dtend)
{
dtssend = dtend;
dtsstart = dtstart;
if (!(isHoster=initHoster()))
{
mUser = null;
}
InitFile();//获取附件必须在指定的时间段内
}
private bool initHoster()
{
SqlConnection sc = MSSQLDB.CreateDBConnet();
try
{
string sscmd = "SELECT mPersonID FROM ConPersonAddress where mStatus=0 and mAgendoID=" + mID;
sc.Open();
SqlCommand scmd = new SqlCommand(sscmd, sc);
mUser = new User(scmd.ExecuteScalar().ToString(), 0);
sc.Close();
return true;
}
catch { }
return false;
}
private void initDatetime(DateTime dtstart, DateTime dtend)
{
dtssend = dtend;
dtsstart = dtstart;
if (!(isHoster=initHoster()))
{
mUser = null;
}
}