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