/// <summary>
/// 根据条件得到一个对象实体
/// </summary>
public DB_Talk.Model.Data_MemberState GetModel(string strWhere)
{
StringBuilder strSql=new StringBuilder();
strSql.Append(" select top 1 ");
strSql.Append(" ID, i_DispatchNumber, i_Number, i_PeerNumber, i_State ");
strSql.Append(" from Data_MemberState ");
if(strWhere.Trim()!="")
{
strSql.Append(" where "+strWhere);
}
DB_Talk.Model.Data_MemberState model=new DB_Talk.Model.Data_MemberState();
DataSet ds=GetDataSet(strSql.ToString());
if(ds!=null && ds.Tables[0].Rows.Count>0)
{
model=DataTableToList(ds)[0];
return model;
}
else
{
return null;
}
}
/// <summary>
/// 获得数据列表
/// </summary>
public List<DB_Talk.Model.Data_MemberState> DataTableToList(DataSet ds)
{
List<DB_Talk.Model.Data_MemberState> modelList = new List<DB_Talk.Model.Data_MemberState>();
if (ds == null) return modelList;
DataTable dt = ds.Tables[0];
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
DB_Talk.Model.Data_MemberState model;
for (int n = 0; n < rowsCount; n++)
{
model = new DB_Talk.Model.Data_MemberState();
if(dt.Rows[n]["ID"]!=null && dt.Rows[n]["ID"].ToString()!="")
{
model.ID=int.Parse(dt.Rows[n]["ID"].ToString());
}
if(dt.Rows[n]["i_DispatchNumber"]!=null && dt.Rows[n]["i_DispatchNumber"].ToString()!="")
{
model.i_DispatchNumber=int.Parse(dt.Rows[n]["i_DispatchNumber"].ToString());
}
if(dt.Rows[n]["i_Number"]!=null && dt.Rows[n]["i_Number"].ToString()!="")
{
model.i_Number=int.Parse(dt.Rows[n]["i_Number"].ToString());
}
if(dt.Rows[n]["i_PeerNumber"]!=null && dt.Rows[n]["i_PeerNumber"].ToString()!="")
{
model.i_PeerNumber=int.Parse(dt.Rows[n]["i_PeerNumber"].ToString());
}
if(dt.Rows[n]["i_State"]!=null && dt.Rows[n]["i_State"].ToString()!="")
{
model.i_State=int.Parse(dt.Rows[n]["i_State"].ToString());
}
modelList.Add(model);
}
}
return modelList;
}
/// <summary>
/// 写用户状态
/// </summary>
/// <param name="number"></param>
/// <param name="?"></param>
/// <returns></returns>
public static bool WriteMemberState(long dispatchNumber, long number, long peerNumber, TalkControl.EnumUserLineStatus uState)
{
DB_Talk.BLL.Data_MemberState memberBLL = new DB_Talk.BLL.Data_MemberState();
List<DB_Talk.Model.Data_MemberState> lstMember = new List<DB_Talk.Model.Data_MemberState>();
lstMember = memberBLL.GetModelList(string.Format("i_Number={0} and i_State={1} and i_dispatchNumber={2}", number, uState.GetHashCode(), dispatchNumber));
if (lstMember.Count > 0)
{
lstMember[0].i_State = uState.GetHashCode();
lstMember[0].i_PeerNumber = peerNumber;
lstMember[0].i_DispatchNumber = dispatchNumber;
return memberBLL.Update(lstMember[0]);
}
else
{
DB_Talk.Model.Data_MemberState model = new DB_Talk.Model.Data_MemberState();
model.i_Number = number;
model.i_State = uState.GetHashCode();
model.i_PeerNumber = peerNumber;
model.i_DispatchNumber = dispatchNumber;
if ((new DB_Talk.BLL.Data_MemberState()).Add(model) > 0)
{
return true;
}
else
{
return false;
}
}
}
