/// <summary> /// 得到一个对象实体 /// </summary> public BCW.Model.Network GetNetwork(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,Types,Title,UsID,UsName,OverTime,AddTime,IsUbb from tb_Network "); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = ID; BCW.Model.Network model = new BCW.Model.Network(); using (SqlDataReader reader = SqlHelper.ExecuteReader(strSql.ToString(), parameters)) { if (reader.HasRows) { reader.Read(); model.ID = reader.GetInt32(0); model.Types = reader.GetInt32(1); model.Title = reader.GetString(2); model.UsID = reader.GetInt32(3); model.UsName = reader.GetString(4); model.OverTime = reader.GetDateTime(5); model.AddTime = reader.GetDateTime(6); model.IsUbb = reader.GetByte(7); return(model); } else { return(null); } } }
/// <summary> /// 更新一条数据 /// </summary> public void UpdateBasic(BCW.Model.Network model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_Network set "); strSql.Append("Types=@Types,"); strSql.Append("Title=@Title,"); strSql.Append("UsID=@UsID,"); strSql.Append("UsName=@UsName"); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4), new SqlParameter("@Types", SqlDbType.Int, 4), new SqlParameter("@Title", SqlDbType.NVarChar, 500), new SqlParameter("@UsID", SqlDbType.Int, 4), new SqlParameter("@UsName", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.ID; parameters[1].Value = model.Types; parameters[2].Value = model.Title; parameters[3].Value = model.UsID; parameters[4].Value = model.UsName; SqlHelper.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 更新一条数据 /// </summary> public void UpdateGroupChat(BCW.Model.Network model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_Network set "); strSql.Append("UsName=@UsName,"); strSql.Append("Title=@Title,"); strSql.Append("OverTime=@OverTime,"); strSql.Append("OnIDs=@OnIDs"); strSql.Append(" where Types=@Types "); strSql.Append(" and UsID=@UsID "); SqlParameter[] parameters = { new SqlParameter("@UsID", SqlDbType.Int, 4), new SqlParameter("@Types", SqlDbType.Int, 4), new SqlParameter("@UsName", SqlDbType.NVarChar, 50), new SqlParameter("@Title", SqlDbType.NVarChar, 500), new SqlParameter("@OverTime", SqlDbType.DateTime), new SqlParameter("@OnIDs", SqlDbType.NText) }; parameters[0].Value = model.UsID; parameters[1].Value = model.Types; parameters[2].Value = model.UsName; parameters[3].Value = model.Title; parameters[4].Value = model.OverTime; parameters[5].Value = model.OnIDs; SqlHelper.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 更新一条数据 /// </summary> public void UpdateOther(BCW.Model.Network model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_Network set "); strSql.Append("Types=@Types,"); strSql.Append("Title=@Title,"); strSql.Append("OverTime=@OverTime,"); strSql.Append("IsUbb=@IsUbb"); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4), new SqlParameter("@Types", SqlDbType.Int, 4), new SqlParameter("@Title", SqlDbType.NVarChar, 500), new SqlParameter("@OverTime", SqlDbType.DateTime), new SqlParameter("@IsUbb", SqlDbType.TinyInt, 1) }; parameters[0].Value = model.ID; parameters[1].Value = model.Types; parameters[2].Value = model.Title; parameters[3].Value = model.OverTime; parameters[4].Value = model.IsUbb; SqlHelper.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(BCW.Model.Network model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_Network("); strSql.Append("Types,Title,UsID,UsName,OverTime,AddTime,OnIDs,IsUbb)"); strSql.Append(" values ("); strSql.Append("@Types,@Title,@UsID,@UsName,@OverTime,@AddTime,@OnIDs,@IsUbb)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Types", SqlDbType.Int, 4), new SqlParameter("@Title", SqlDbType.NVarChar, 500), new SqlParameter("@UsID", SqlDbType.Int, 4), new SqlParameter("@UsName", SqlDbType.NVarChar, 50), new SqlParameter("@OverTime", SqlDbType.DateTime), new SqlParameter("@AddTime", SqlDbType.DateTime), new SqlParameter("@OnIDs", SqlDbType.NText), new SqlParameter("@IsUbb", SqlDbType.TinyInt, 1) }; parameters[0].Value = model.Types; parameters[1].Value = model.Title; parameters[2].Value = model.UsID; parameters[3].Value = model.UsName; parameters[4].Value = model.OverTime; parameters[5].Value = model.AddTime; parameters[6].Value = model.OnIDs; parameters[7].Value = model.IsUbb; object obj = SqlHelper.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 取得每页记录 /// </summary> /// <param name="p_pageIndex">当前页</param> /// <param name="p_pageSize">分页大小</param> /// <param name="p_recordCount">返回总记录数</param> /// <param name="strWhere">查询条件</param> /// <returns>IList Network</returns> public IList <BCW.Model.Network> GetNetworks(int p_pageIndex, int p_pageSize, string strWhere, out int p_recordCount) { IList <BCW.Model.Network> listNetworks = new List <BCW.Model.Network>(); string sTable = "tb_Network"; string sPkey = "id"; string sField = "ID,Types,Title,UsID,UsName,OverTime,AddTime,IsUbb"; string sCondition = strWhere; string sOrder = "ID Desc"; int iSCounts = 0; using (SqlDataReader reader = SqlHelper.RunProcedureMe(sTable, sPkey, sField, p_pageIndex, p_pageSize, sCondition, sOrder, iSCounts, out p_recordCount)) { //计算总页数 if (p_recordCount > 0) { int pageCount = BasePage.CalcPageCount(p_recordCount, p_pageSize, ref p_pageIndex); } else { return(listNetworks); } while (reader.Read()) { BCW.Model.Network objNetwork = new BCW.Model.Network(); objNetwork.ID = reader.GetInt32(0); objNetwork.Types = reader.GetInt32(1); objNetwork.Title = reader.GetString(2); objNetwork.UsID = reader.GetInt32(3); objNetwork.UsName = reader.GetString(4); objNetwork.OverTime = reader.GetDateTime(5); objNetwork.AddTime = reader.GetDateTime(6); objNetwork.IsUbb = reader.GetByte(7); listNetworks.Add(objNetwork); } } return(listNetworks); }
public RspAddSuona AddSuonaItem(ReqAddSuona _reqData) { RspAddSuona _rspAddSuona = new RspAddSuona(); //验证用户ID格式 if (_reqData.userId < 0) { _rspAddSuona.header.status = ERequestResult.faild; _rspAddSuona.header.statusCode = Error.MOBILE_ERROR_CODE.MOBILE_PARAMS_ERROR; return(_rspAddSuona); } //检查是否登录状态 if (Common.Common.CheckLogin(_reqData.userId, _reqData.userKey) == 0) { _rspAddSuona.header.status = ERequestResult.faild; _rspAddSuona.header.statusCode = Error.MOBILE_ERROR_CODE.SYS_USER_NOLOGIN; return(_rspAddSuona); } int RegDay = Utils.ParseInt(ub.GetSub("NetworkRegDay", xmlPath)); int Grade = Utils.ParseInt(ub.GetSub("NetworkGrade", xmlPath)); if (RegDay > 0 || Grade > 0) { DataSet ds = new BCW.BLL.User().GetList("RegTime,Leven", "id=" + _reqData.userId + ""); if (ds != null && ds.Tables[0].Rows.Count > 0) { DateTime RegTime = DateTime.Parse(ds.Tables[0].Rows[0]["RegTime"].ToString()); int Leven = int.Parse(ds.Tables[0].Rows[0]["Leven"].ToString()); if (RegDay > 0 && RegTime > DateTime.Now.AddDays(-RegDay)) { _rspAddSuona.header.status = ERequestResult.faild; _rspAddSuona.header.statusCode = Error.MOBILE_ERROR_CODE.NETWORK_SUONA_REGDAY_NOT_ENOUGH; _rspAddSuona.header.statusMsg = string.Format(_rspAddSuona.header.statusMsg, (ub.GetSub("NetworkRegDay", xmlPath))); return(_rspAddSuona); } if (Grade > 0 && Leven < Grade) { _rspAddSuona.header.status = ERequestResult.faild; _rspAddSuona.header.statusCode = Error.MOBILE_ERROR_CODE.NETWORK_SUONA_LEVEL_NOT_ENOUGH; _rspAddSuona.header.statusMsg = string.Format(_rspAddSuona.header.statusMsg, ub.GetSub("NetworkGrade", xmlPath)); return(_rspAddSuona); } } } //自身权限不足 if (new BCW.User.Limits().IsUserLimit(BCW.User.Limits.enumRole.Role_NetWork, _reqData.userId) == true) { _rspAddSuona.header.status = ERequestResult.faild; _rspAddSuona.header.statusCode = Error.MOBILE_ERROR_CODE.SYS_USER_LIMIT_NOT_ENOUGH; return(_rspAddSuona); } string mename = new BCW.BLL.User().GetUsName(_reqData.userId); long megold = new BCW.BLL.User().GetGold(_reqData.userId); //每分钟收费多少 int bMinute = Convert.ToInt32(ub.GetSub("NetworkiGold", xmlPath)); //检查内容是否超限 if (Regex.IsMatch(_reqData.content, @"^[^\^]{" + ub.GetSub("NetworksLength", xmlPath) + "," + ub.GetSub("NetworkbLength", xmlPath) + "}$") == false) { _rspAddSuona.header.status = ERequestResult.faild; _rspAddSuona.header.statusCode = Error.MOBILE_ERROR_CODE.NETWORK_SUONA_CONTENT_LENGTH_ERROR; _rspAddSuona.header.statusMsg = string.Format(_rspAddSuona.header.statusMsg, ub.GetSub("NetworksLength", xmlPath), ub.GetSub("NetworkbLength", xmlPath)); return(_rspAddSuona); } //检查显示时限 if (Regex.IsMatch(_reqData.minute.ToString(), @"^[0-9]\d*$") == false) { _rspAddSuona.header.status = ERequestResult.faild; _rspAddSuona.header.statusCode = Error.MOBILE_ERROR_CODE.NETWORK_SUONA_TIME_LENGTH_ERROR; _rspAddSuona.header.statusMsg = string.Format(_rspAddSuona.header.statusMsg, ub.GetSub("NetworkbMinute", xmlPath)); return(_rspAddSuona); } if (_reqData.minute < 1 || _reqData.minute > Convert.ToInt32(ub.GetSub("NetworkbMinute", xmlPath))) { _rspAddSuona.header.status = ERequestResult.faild; _rspAddSuona.header.statusCode = Error.MOBILE_ERROR_CODE.NETWORK_SUONA_TIME_LENGTH_ERROR; _rspAddSuona.header.statusMsg = string.Format(_rspAddSuona.header.statusMsg, ub.GetSub("NetworkbMinute", xmlPath)); return(_rspAddSuona); } //扣币 if (megold < Convert.ToInt64(_reqData.minute * bMinute)) { _rspAddSuona.header.status = ERequestResult.faild; _rspAddSuona.header.statusCode = Error.MOBILE_ERROR_CODE.SYS_USER_COBI_NOT_ENOUGH; return(_rspAddSuona); } new BCW.BLL.User().UpdateiGold(_reqData.userId, mename, -Convert.ToInt64(_reqData.minute * bMinute), "发布广播"); BCW.Model.Network model = new BCW.Model.Network(); model.Title = _reqData.content; model.Types = 0; model.UsID = _reqData.userId; model.UsName = mename; model.OverTime = DateTime.Now.AddMinutes(_reqData.minute); model.AddTime = DateTime.Now; model.OnIDs = ""; int _id = new BCW.BLL.Network().Add(model); _rspAddSuona.header.status = ERequestResult.success; _rspAddSuona.suonaId = _id; _rspAddSuona.cobi = -(_reqData.minute * bMinute); _rspAddSuona.totalCobi = new BCW.BLL.User().GetGold(_reqData.userId); return(_rspAddSuona); }