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