/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WebApi_Model.T_Gift model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_Gift set ");
strSql.Append("GiftName=@GiftName,");
strSql.Append("GiftICO=@GiftICO,");
strSql.Append("TuiMao=@TuiMao,");
strSql.Append("IsActive=@IsActive");
strSql.Append(" where GiftID=@GiftID");
SqlParameter[] parameters =
{
new SqlParameter("@GiftName", SqlDbType.NVarChar, 30),
new SqlParameter("@GiftICO", SqlDbType.NVarChar, 30),
new SqlParameter("@TuiMao", SqlDbType.Int, 4),
new SqlParameter("@IsActive", SqlDbType.Int, 4),
new SqlParameter("@GiftID", SqlDbType.Int, 4)
};
parameters[0].Value = model.GiftName;
parameters[1].Value = model.GiftICO;
parameters[2].Value = model.TuiMao;
parameters[3].Value = model.IsActive;
parameters[4].Value = model.GiftID;
int rows = DBHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WebApi_Model.T_Gift model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_Gift(");
strSql.Append("GiftName,GiftICO,TuiMao,IsActive)");
strSql.Append(" values (");
strSql.Append("@GiftName,@GiftICO,@TuiMao,@IsActive)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@GiftName", SqlDbType.NVarChar, 30),
new SqlParameter("@GiftICO", SqlDbType.NVarChar, 30),
new SqlParameter("@TuiMao", SqlDbType.Int, 4),
new SqlParameter("@IsActive", SqlDbType.Int, 4)
};
parameters[0].Value = model.GiftName;
parameters[1].Value = model.GiftICO;
parameters[2].Value = model.TuiMao;
parameters[3].Value = model.IsActive;
object obj = DBHelper.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebApi_Model.T_Gift DataRowToModel(DataRow row)
{
WebApi_Model.T_Gift model = new WebApi_Model.T_Gift();
if (row != null)
{
if (row["GiftID"] != null && row["GiftID"].ToString() != "")
{
model.GiftID = int.Parse(row["GiftID"].ToString());
}
if (row["GiftName"] != null)
{
model.GiftName = row["GiftName"].ToString();
}
if (row["GiftICO"] != null)
{
model.GiftICO = row["GiftICO"].ToString();
}
if (row["TuiMao"] != null && row["TuiMao"].ToString() != "")
{
model.TuiMao = int.Parse(row["TuiMao"].ToString());
}
if (row["IsActive"] != null && row["IsActive"].ToString() != "")
{
model.IsActive = int.Parse(row["IsActive"].ToString());
}
}
return(model);
}
public IHttpActionResult SendGift(dynamic model)
{
WebApi_BLL.T_Forum_Gift bll = new WebApi_BLL.T_Forum_Gift();
WebApi_BLL.T_User userbll = new WebApi_BLL.T_User();
WebApi_BLL.T_Gift giftbll = new WebApi_BLL.T_Gift();
WebApi_Model.T_Forum_Gift forumgift = (WebApi_Model.T_Forum_Gift)Newtonsoft.Json.JsonConvert.DeserializeObject(model, typeof(WebApi_Model.T_Forum_Gift));
WebApi_Model.T_User sendUser = userbll.GetModel((int)forumgift.PostUID);
WebApi_Model.T_User receiptUser = userbll.GetModel((int)forumgift.ReceiptUID);
WebApi_Model.T_Gift gift = giftbll.GetModel((int)forumgift.GiftID);
if (sendUser != null && receiptUser != null && gift != null)
{
int TotalTM = (int)gift.TuiMao * (int)forumgift.Qty;
if (sendUser.TuiMao >= TotalTM)
{
sendUser.TuiMao = sendUser.TuiMao - TotalTM;
receiptUser.TuiMao = receiptUser.TuiMao + TotalTM;
userbll.Update(sendUser);
userbll.Update(receiptUser);
forumgift.PostTime = DateTime.Now;
bll.Add(forumgift);
#region update giftcount
DBHelper.GetSingle("update T_Forum_Comment set giftcount = (select giftcount from V_Forum_Gift where ForumID = " + forumgift.ForumID + " and PostUID = " + forumgift.PostUID + ")");
#endregion
return(Ok(ReturnJsonResult.GetJsonResult(1, "OK", "腿毛不足！")));
}
else
{
return(Ok(ReturnJsonResult.GetJsonResult(-1, "Error", "腿毛不足！")));
}
}
else
{
return(Ok(ReturnJsonResult.GetJsonResult(-1, "Error", "数据格式错误！")));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebApi_Model.T_Gift GetModel(int GiftID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 GiftID,GiftName,GiftICO,TuiMao,IsActive from T_Gift ");
strSql.Append(" where GiftID=@GiftID");
SqlParameter[] parameters =
{
new SqlParameter("@GiftID", SqlDbType.Int, 4)
};
parameters[0].Value = GiftID;
WebApi_Model.T_Gift model = new WebApi_Model.T_Gift();
DataSet ds = DBHelper.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}