public int Add(Employee emp)
{
///('xp', '男','2/1/1989','1')
string str = "INSERT INTO Employee (empName, empSex,empBirthday,deptId,postId) VALUES (@empName,@empSex,@empBirthday,@deptId,@postId)";
SqlParameter[] param = new SqlParameter[5];
param[0] = new SqlParameter("@empName", emp.empName);
param[1] = new SqlParameter("@empSex", emp.empSex);
param[2] = new SqlParameter("@empBirthday", emp.empBirthday);
param[3] = new SqlParameter("@deptId", emp.deptId);
param[4] = new SqlParameter("@postId", emp.postId);
return(SQLHelper.ExecuteSql(str, param));
}
public int Update(Employee emp)
{
///('xp', '男','2/1/1989','1')
string str = "update Employee set empName=@empName,empSex=@empSex,empBirthday=@empBirthday where empId =@empId";
SqlParameter[] param = new SqlParameter[4];
// param[0] = new SqlParameter("@empId", emp.empId);
param[0] = new SqlParameter("@empName", emp.empName);
param[1] = new SqlParameter("@empSex", emp.empSex);
param[2] = new SqlParameter("@empBirthday", emp.empBirthday);
param[3] = new SqlParameter("@empId", emp.empId);
return(SQLHelper.ExecuteSql(str, param));
}
/// <summary>
///
/// 创建点菜菜单
/// </summary>
/// <param name="tableid"></param>
/// <param name="personamount"></param>
/// <returns></returns>
public int CreateOrder(string tableid, int personamount)
{
string strSql = "insert into dbo.[Order](OrderID,OrderTime,TableID,AmountofCustomer,CheckStatus) values(dbo.getOrderID(),getdate(),@TableID,@AmountofCustomer,2)";
SqlParameter[] parameters =
{
new SqlParameter("@TableID", tableid),
new SqlParameter("@AmountofCustomer", personamount)
};
int i = SQLHelper.ExecuteSql(strSql.ToString(), parameters);
return(i);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="u_account"></param>
/// <returns></returns>
public string deleteuser(int u_account)
{
string result = "";
string strSql = string.Format("delete dbo.UserInfo where u_account={0} ", u_account);
int i = SQLHelper.ExecuteSql(strSql);
if (i > 0)
{
result = "delete sucess";
}
else
{
result = "delete wrong";
}
return(result);
}
/// <summary>
/// 更新信息
/// </summary>
/// <param name="name"></param>
/// <param name="pwd"></param>
/// <param name="sex"></param>
/// <param name="u_privilege"></param>
/// <param name="id"></param>
/// <returns></returns>
public bool updateuser(string name, string pwd, string sex, int u_privilege, int id)
{
bool result;
string sql = string.Format("update dbo.UserInfo set u_name='{0}',u_password='******',u_sex='{2}',u_privilege={3} where u_account={4}", name, pwd, sex, u_privilege, id);
int i = SQLHelper.ExecuteSql(sql);
if (i > 0)
{
result = true;
}
else
{
result = false;
}
return(result);
}
/// <summary>
/// 根据id删除user
/// </summary>
/// <param name="u_accounts"></param>
/// <returns></returns>
public bool deleteUserbyIds(string u_accounts)
{
bool result;
string strSql = string.Format("delete dbo.UserInfo where u_account in ({0}) ", u_accounts);
int i = SQLHelper.ExecuteSql(strSql);
if (i > 0)
{
result = true;
}
else
{
result = false;
}
return(result);
}
/// <summary>
/// 添加用户
/// </summary>
/// <param name="u_name"></param>
/// <param name="u_password"></param>
/// <param name="u_sex"></param>
/// <param name="u_privilege"></param>
/// <returns></returns>
public string adduser(string u_name, string u_password, string u_sex, int u_privilege)
{
string result = "";
string strSql = string.Format("insert into dbo.UserInfo(u_name,u_password,u_sex,u_privilege) values('{0}','{1}','{2}',{3})", u_name, u_password, u_sex, u_privilege);
int i = SQLHelper.ExecuteSql(strSql);
if (i > 0)
{
result = "add sucess";
}
else
{
result = "add wrong";
}
return(result);
}
/// <summary>
/// 批量删除
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public string deleteMenuByIds(string ids)
{
string result = "";
string strSql = string.Format("delete dbo.Menu where Menu_ID in ({0}) ", ids);
int i = SQLHelper.ExecuteSql(strSql);
if (i > 0)
{
result = "delete sucess";
}
else
{
result = "delete wrong";
}
return(result);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public string addMenu(string Menu_Name, int TypeID, float Menu_Price, string Type)
{
string result = "";
string strSql = string.Format("insert into Menu(Menu_ID,Menu_Name,Menu_Type,Menu_Price,Menu_picture)values (dbo.CreateMenu_ID('{0}'),'{1}',{2},{3},dbo.CreateMenu_ID('{4}'))", Type, Menu_Name, TypeID, Menu_Price, Type);
int i = SQLHelper.ExecuteSql(strSql);
if (i > 0)
{
result = "add sucess";
}
else
{
result = "add wrong";
}
return(result);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public string updateMenu(string name, int type, float price, string Menu_picture, string id)
{
string result = "";
string strSql = string.Format(" update dbo.Menu set Menu_Name='{0}' ,Menu_Type={1},Menu_Price={2},Menu_picture='{3}' where Menu_ID='{4}'", name, type, price, Menu_picture, id);
int i = SQLHelper.ExecuteSql(strSql);
if (i > 0)
{
result = "update sucess";
}
else
{
result = "update wrong";
}
return(result);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public string deleteTable(string u_account)
{
string result = "";
string strSql = string.Format("delete dbo.[table] where table_id ='{0}' ", u_account);
int i = SQLHelper.ExecuteSql(strSql);
if (i > 0)
{
result = "delete sucess";
}
else
{
result = "delete wrong";
}
return(result);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public string addTable(int id, int status)
{
string result = "";
string strSql = string.Format("insert into [table](table_id,table_status) values(dbo.table_id({0}),{1})", id, status);
int i = SQLHelper.ExecuteSql(strSql);
if (i > 0)
{
result = "add sucess";
}
else
{
result = "add wrong";
}
return(result);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public string updateTable(string id, int table_status)
{
string result = "";
string strSql = string.Format("update dbo.[table] set table_status={0} where table_id='{1}'", table_status, id);
int i = SQLHelper.ExecuteSql(strSql);
if (i > 0)
{
result = "update sucess";
}
else
{
result = "update wrong";
}
return(result);
}
/// <summary>
/// 修改点餐结束的桌子状态
/// </summary>
/// <param name="yeschecked"></param>
/// <returns></returns>
public string UpdateStatus(string yeschecked)
{
string result = "";
//string strSql = "update dbo.[table] set table_status=2 where table_id in (" + yeschecked + ")";
string strSql = string.Format("update dbo.[table] set table_status=2 where table_id in ({0})", yeschecked);
int num1 = SQLHelper.ExecuteSql(strSql);
if (num1 > 0)
{
result = "order table sucess!";
}
else
{
result = "order table fail！";
}
return(result);
}
