/// <summary>
/// Delete an existing FirstPageArg
/// </summary>
/// <param name="thisFirstPageArg">FirstPageArg</param>
/// <returns>bool</returns>
public bool Delete(FirstPageArg thisFirstPageArg)
{
string sql = string.Format("exec dbo.sp_firstpagearg_d {0} "
, ToQuote(thisFirstPageArg.ID)
);
try
{
int rowcount = SqlHelper.ExecuteNonQuery(ConnectStr, CommandType.Text, sql);
if (rowcount >= 1)
{
return(true);
}
else
{
throw new Exception("SQL execution failed");
}
}
catch (Exception ex)
{
throw new Exception("SQL execution failed", ex);
}
}
/// <summary>
/// Update an existing FirstPageArg
/// </summary>
/// <param name="thisFirstPageArg">FirstPageArg</param>
/// <returns>bool</returns>
public bool Update(FirstPageArg thisFirstPageArg)
{
string sql = string.Format("EXEC sp_FirstPageArg_u {0},{1},{2},{3},{4},{5},{6},{7}"
, ToQuote(thisFirstPageArg.ID)
, ToQuote(thisFirstPageArg.Type)
, ToQuote(thisFirstPageArg.LikeArg)
, ToQuote(thisFirstPageArg.CommentArg)
, ToQuote(thisFirstPageArg.RecordArg)
, ToQuote(CurrentUserName)
, ToQuote(DateTime.Now)
, ToQuote(thisFirstPageArg.Statues)
);
try
{
int rowcount = SqlHelper.ExecuteNonQuery(ConnectStr, CommandType.Text, sql);
if (rowcount == 1)
{
return(true);
}
else
{
throw new Exception("SQL execution failed");
}
}
catch (Exception ex)
{
throw new Exception("SQL execution failed", ex);
}
}
public void TestCanCreateFirstPageArg()
{
IFirstPageArg firstpageservice = new FirstPageArgService();
FirstPageArg firstpage = new FirstPageArg
{
ID = Guid.NewGuid(),
LikeArg = 300,
RecordArg = 100,
CommentArg = 100,
Statues = 1,
Type = "滑雪衫"
};
Guid id = firstpageservice.Create(firstpage);
Assert.AreEqual(id, firstpage.ID);
}
/// <summary>
/// Don't repeat yourself! This private function is for shared by all query public functions
/// </summary>
/// <param name="sql"></param>
/// <param name="page"></param>
/// <param name="pg"></param>
/// <returns></returns>
IList <FirstPageArg> GetFirstPageArgs(string sql, int page, string sortKey, out PaginationInfo paging)
{
using (DataSet ds = SqlHelper.ExecuteDataset(ConnectStr, CommandType.Text, sql))
{
if (ds == null || ds.Tables.Count != 2)
{
throw new Exception("SQL execution failed");
}
else
{
List <FirstPageArg> Comments = new List <FirstPageArg>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
FirstPageArg Comment = new FirstPageArg()
{
ID = new Guid(dr["id"].ToString()),
CommentArg = ParseInt(dr["CommentArg"]),
LikeArg = ParseInt(dr["LikeArg"]),
RecordArg = ParseInt(dr["RecordArg"]),
Type = ParseStr(dr["Type"]),
Statues = ParseInt(dr["Statues"]),
Createby = ParseStr(dr["Createby"]),
mtype = ParseStr(dr["mtype"]),
Createtime = ParseStr(dr["Createtime"]),
Updateby = ParseStr(dr["Updateby"]),
Updatetime = ParseStr(dr["Updatetime"])
};
Comments.Add(Comment);
}
paging = new PaginationInfo()
{
Current = page,
Size = ParseInt(ds.Tables[1].Rows[0]["pagesize"]),
TotalRecords = ParseInt(ds.Tables[1].Rows[0]["totalrecords"]),
TotalPages = (int)Math.Ceiling(ParseInt(ds.Tables[1].Rows[0]["totalrecords"]) /
ParseFloat(ds.Tables[1].Rows[0]["pagesize"]))
};
return(Comments);
}
}
}
public ActionResult GotoFirst(int?page)
{
try
{
PaginationInfo paging = new PaginationInfo();
PaginationInfo paging2 = new PaginationInfo();
IList <UserStore> userstores = iuserstore.Get(null, UserName, null, 1, page.HasValue ? page.Value : 1, null, out paging);
IList <SettingGroup> systemsettings = isetting.GetSystemSetting();
IList <SettingGroup> usersetings = iusersetting.GetByUsername(UserName);
int likedrate = int.Parse(GetSettingVal(systemsettings, "3C309D27-C774-4E60-8706-17EA2C2B0691"));
int likerate = int.Parse(GetSettingVal(systemsettings, "6C715AE2-2D77-4827-B4C1-7E5352B7D00B"));
float superrate = float.Parse(GetSettingVal(systemsettings, "4657EED5-A7C5-4058-8F37-797B6155B2A0"));
foreach (UserStore userstore in userstores)
{
userstore.Bady = ibady.Get(userstore.Bady.ID);
IList <Like> likes = ilike.Get(null, userstore.Bady.ID.ToString(), UserName, null, 1, 1, 0, null, out paging2);
if (likes != null && likes.Count > 0)
{
userstore.taskstatus = likes[0].Runstatues;
userstore.Like = likes[0];
}
else
{
userstore.taskstatus = null;
}
IList <FirstPageArg> firstpageargs = ifirstpagearg.Get(null, userstore.Type, "hot", 1, 0, null, out paging2);
if (firstpageargs != null && firstpageargs.Count == 1)
{
FirstPageArg firstpagearg = firstpageargs[0];
userstore.needlike = firstpagearg.LikeArg - userstore.Liked > 0 ? firstpagearg.LikeArg - userstore.Liked : 0;
userstore.needrecord = firstpagearg.RecordArg - userstore.Record > 0 ? firstpagearg.RecordArg - userstore.Record : 0;
userstore.needcommment = firstpagearg.CommentArg - userstore.Comment > 0 ? firstpagearg.CommentArg - userstore.Comment : 0;
userstore.needliked = userstore.needlike * likerate / likedrate;
}
else
{
int likearg = 0;
int recordarg = 0;
int commentarg = 0;
if (firstpageargs.Count > 1)
{
foreach (FirstPageArg f in firstpageargs)
{
likearg += f.LikeArg;
recordarg += f.RecordArg;
commentarg += f.CommentArg;
}
likearg = likearg / firstpageargs.Count;
recordarg = recordarg / firstpageargs.Count;
commentarg = commentarg / firstpageargs.Count;
userstore.needlike = likearg - userstore.Liked > 0 ? likearg - userstore.Liked : 0;
userstore.needrecord = recordarg - userstore.Record > 0 ? recordarg - userstore.Record : 0;
userstore.needcommment = commentarg - userstore.Comment > 0 ? commentarg - userstore.Comment : 0;
userstore.needliked = userstore.needlike * likerate / likedrate;
}
else
{
//默认值
likearg = 500;//
recordarg = 50;
commentarg = 20;
userstore.needlike = likearg - userstore.Liked > 0 ? likearg - userstore.Liked : 0;
userstore.needrecord = recordarg - userstore.Record > 0 ? recordarg - userstore.Record : 0;
userstore.needcommment = commentarg - userstore.Comment > 0 ? commentarg - userstore.Comment : 0;
userstore.needliked = userstore.needlike * likerate / likedrate;
}
}
userstore.needrecord = userstore.needrecord - Convert.ToInt32(userstore.needrecord * superrate);
userstore.needsuper = Convert.ToInt32(userstore.needrecord * superrate);
//300 60 0 60
}
ViewBag.likedprice = decimal.Parse(GetSettingVal(systemsettings, "FB8E6B56-DEA6-4D70-9C52-E451E7423F55"));
ViewBag.likeprice = decimal.Parse(GetSettingVal(systemsettings, "65AD5D23-2619-480E-B6A9-84C58AD07DCB"));
ViewBag.commentprice = decimal.Parse(GetSettingVal(systemsettings, "4D2E7311-BA9F-468B-BC3B-3F938C9CC3EA"));
ViewBag.recordprice = decimal.Parse(GetSettingVal(systemsettings, "88841710-5B5F-4581-9557-85103CD65534"));
ViewBag.supperrecordprice = decimal.Parse(GetSettingVal(systemsettings, "6FF927CF-5676-43B2-A9B4-F72C346E22DE"));
ViewBag.pricerate = decimal.Parse(GetSettingVal(systemsettings, "2AADE1C6-59BE-4B0E-927C-7B28BFC8C397"));
PagedList <UserStore> models = userstores.ToPagedList <UserStore>(paging);
return(View(models));
}
catch (Exception ex)
{
string errorMsg = "An application error occurred. Please contact the adminstrator " +
"with the following information:/n/n";
errorMsg += ex.Message + "/n/nStack Trace:/n" + ex.StackTrace + "//" + ex.Source;
WriteLog(errorMsg);
return(View());
}
}
