/// <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; } } }