public IList <User> GetUserinfo(String UserId, String Type)
{
String sql = "";
//if (Type == "NotAll")
// sql = "select UserName,UserImg from users where UserNumber='" + UserId + "'";
sql = "select * from users where UserNumber='" + UserId + "'";
DBHelper.SqlHelper b = new DBHelper.SqlHelper();
// String sql = "select * from Users where Type='" + type + "' and PassWord='******'";
return(b.ExcuteQuery <User>(sql));
}
public int MenuAdd(string menunumber, string menuname, string menutype, string menuimg, string Account, string TimeMade)//菜品制作
{
DBHelper.SqlHelper b = new DBHelper.SqlHelper();
string TeachingVideoAddress = "none";
String TeachingMenuNumber = "none";
String Positives = "none";
String Negatives = "none";
String KeyWord = "none";
// MenuName,MenuNumber,Introduces,Type,TimeMade,Collection,CoverImg,TeachingVideoAddress,TeachingMenuNumber,ProducerNumber,Status,Positives,Negatives,KeyWord
String sql = "insert into mainmenus ( MenuName,MenuNumber,Type,TimeMade,Collection,CoverImg,TeachingVideoAddress,TeachingMenuNumber,ProducerNumber,Status,Positives,Negatives,KeyWord) ";
sql += "values ('" + menuname + "','" + menunumber + "','" + menutype + "','" + TimeMade + "','" + "0" + "','" + menuimg + "','" + TeachingVideoAddress + "','" + TeachingMenuNumber + "','" + Account + "','" + "none" + "','" + Positives + "','" + Negatives + "','" + KeyWord + "')";
//String sql = "select count(*) from Users ";
return(b.ExecuteSql(sql));
}
public int AdminClassAdd(string classid, string classchild, string classparent)//用户菜品删除
{
DBHelper.SqlHelper b = new DBHelper.SqlHelper();
// String number ="none";
// String Category_parent = "none";
// String Classification_contents ="none";
String Navigation = "none";
String sql = "insert into menu_classification (number,Category_parent,Classification_contents,Navigation)";
sql += "values('" + classid + "','" + classchild + "','" + classparent + "','" + Navigation + "')";
return(b.ExecuteSql(sql));
}
public int AdminIngredientAdd(string IngredientNumber, string IngredientName, string IngredientIntroduction, string NutritiveValue, string Negatives, string CookingTips, string EdibleEffect, string CoverImg)//用户菜品删除
{
DBHelper.SqlHelper b = new DBHelper.SqlHelper();
String Taboo = "none";
String FoodTaboo = "none";
String Choose = "none";
String Storage = "none";
String Positives = "none";
String sql = "insert into ingredient (IngredientNumber,IngredientName,CoverImg,IngredientIntroduction,Positives,Negatives,Taboo,NutritiveValue,EdibleEffect,FoodTaboo,Choose,Storage,CookingTips)";
sql += "values('" + IngredientNumber + "','" + IngredientName + "','" + CoverImg + "','" + IngredientIntroduction + "','" + Positives + "','" + Negatives + "','" + Taboo + "','" + NutritiveValue + "','" + EdibleEffect + "','" + FoodTaboo + "','" + Choose + "','" + Storage + "','" + CookingTips + "')";
return(b.ExecuteSql(sql));
}
public IList <User> GetUserSearch(String orderby, string sval, string sby, int size, int index)
{
DBHelper.SqlHelper b = new DBHelper.SqlHelper();
String bywhat = "";
if (sby == "zh")
{
bywhat = " Account='" + sval + "'";
}
else if (sby == "yhm")
{
bywhat = " UserName like '%" + sval + "%'";
}
string sql = "select * from user where " + bywhat + orderby + " limit " + index + "," + size;
return(b.ExcuteQuery <User>(sql));
}
public IList <UserNotices> getRecord(String Account, String ctype, int size, int index)
{
DBHelper.SqlHelper b = new DBHelper.SqlHelper();
String sql = "";
//if (ctype == "userPnoticeunread")
//{
// sql = "select * from usernotices where Account='" + Account + "' and ctype='' limit " + index + "," + size;
//}
//else if (ctype == "usernoticeunread")
//{
sql = "select * from usernotices where Account='" + Account + "' and ctype='" + ctype + "' limit " + index + "," + size;
return(b.ExcuteQuery <UserNotices>(sql));
}
public int GetDataCount(String bywhat, String tablename)
{
String sql = "";
DBHelper.SqlHelper b = new DBHelper.SqlHelper();
if (bywhat == "")
{
sql = "select count(*) from " + tablename;
}
else
{
sql = "select count(*) from " + tablename + " where " + bywhat;
}
// sql = "select count(*) from user where UserName='******' and PassWord='******'";
//String sql = "select count(*) from Users ";
int r = int.Parse(b.GetSingle(sql).ToString());
return(r);
}
public int AdminClassAlter(string classid, string classchild, string classparent)//用户菜品删除
{
DBHelper.SqlHelper b = new DBHelper.SqlHelper();
// String number ="none";
// String Category_parent = "none";
// String Classification_contents ="none";
String Navigation = "none";
String sql = "update menu_classification set ";
// sql +=" IngredientNumber='"+menunumber+"',";
// sql += "number='" + IngredientName + "',";
sql += "Category_parent='" + classparent + "',";
sql += "Classification_contents='" + classchild + "',";
sql += "Navigation='" + Navigation + "'";
sql += " where number='" + classid + "'";
return(b.ExecuteSql(sql));
}
public int FoodProductionUpdate(string menunumber, string menuname, string menutype, string menuimg, string introduce, string Tips, string Account, String kw, String gy, String mainsc, String fl, String bzall)//菜品制作
{
DBHelper.SqlHelper b = new DBHelper.SqlHelper();
String sql = "update userproduction set ";
//sql +=" MenuNumber='"+menunumber+"',";
sql += "MenuName='" + menuname + "',";
sql += "Type='" + menutype + "',";
sql += "Introduce='" + introduce + "',";
sql += "Tips='" + Tips + "',";
sql += "MenuKW='" + kw + "',";
sql += "MenuGY='" + gy + "',";
sql += "MenuMainIngredient='" + mainsc + "',";
sql += "MenuFuliao='" + fl + "',";
sql += "MenuSteps='" + bzall + "' ";
sql += " where MenuNumber='" + menunumber + "'";
//String sql = "select count(*) from Users ";
return(b.ExecuteSql(sql));
}
public int UpdateFollowNum(string ObjectNumber, string ObCollection, String tablename)
{
DBHelper.SqlHelper b = new DBHelper.SqlHelper();
string sql = "";
if (tablename == "user")
{
sql = "update user set FollowersNum='" + ObCollection + "' where Account='" + ObjectNumber + "'";
}
if (tablename == "menu")
{
sql = "update mainmenus set Collection='" + ObCollection + "' where MenuNumber='" + ObjectNumber + "'";
}
if (tablename == "userfollow")
{
sql = "update user set FollowersNum='" + ObCollection + "' where Account='" + ObjectNumber + "'";
}
if (tablename == "useradd")
{
sql = "update user set FriendNum='" + ObCollection + "' where Account='" + ObjectNumber + "'";
}
return(b.ExecuteSql(sql));;
}
public IList <MenuAll> GetMenuByIdenticalGY(String sql)
{
DBHelper.SqlHelper b = new DBHelper.SqlHelper();
return(b.ExcuteQuery <MenuAll>(sql));
}
public IList <MenuPractices> GetCurrentMenuElseGY(String sql)
{
DBHelper.SqlHelper b = new DBHelper.SqlHelper();
return(b.ExcuteQuery <MenuPractices>(sql));
}
public IList <SimpleMenu> GetSimpleMenuByOneAttribute(String sql)
{
DBHelper.SqlHelper b = new DBHelper.SqlHelper();
return(b.ExcuteQuery <SimpleMenu>(sql));
}
