/// <summary>
/// 删除单个颜色信息
/// </summary>
/// <param name="id">颜色ID</param>
/// <returns>是否删除成功 1 = 成功 0 = 失败</returns>
public static int RemoveColor(int id)
{
string sql = "delete Colors where ColorId = @id";
SqlParameter[] parameter =
{
new SqlParameter("@id", id)
};
return(SQLHelper.ExecuteNonQurery(sql, CommandType.Text, parameter));
}
/// <summary>
/// 删除单个新闻信息
/// </summary>
/// <param name="id">新闻ID</param>
/// <returns>新闻是否删除成功 1 = 成功 0 = 失败</returns>
public static int RemoveNews(int id)
{
string sql = "delete newsInfo where newsId = @ID";
SqlParameter[] parameter =
{
new SqlParameter("@ID", id)
};
return(SQLHelper.ExecuteNonQurery(sql, CommandType.Text, parameter));
}
/// <summary>
/// 用户注册方法
/// </summary>
/// <param name="user">用户输入信息</param>
/// <returns>是否注册成功 1 = 成功 0 = 失败</returns>
public static int UserResgist(Model.Login user)
{
string sql = "insert into Login values(@Name,@Pwd,@sex,@date)";
SqlParameter[] parameter =
{
new SqlParameter("@Name", user.UserName),
new SqlParameter("@Pwd", user.PassWord),
new SqlParameter("@date", user.Birthday),
new SqlParameter("@sex", user.Sex),
};
return(SQLHelper.ExecuteNonQurery(sql, CommandType.Text, parameter));
}
/// <summary>
/// 添加员工订餐信息
/// </summary>
/// <param name="_Dinner">员工订餐信息类</param>
/// <returns>是否添加成功</returns>
public static int AddOrder(Model.Book_Dinner _Dinner)
{
string sql = "insert into Book_Dinner values(@No,@Time,@Name)";
SqlParameter[] parameter =
{
new SqlParameter("@No", _Dinner.work_no),
new SqlParameter("@Time", _Dinner.book_time),
new SqlParameter("@Name", _Dinner.Emp_Name),
};
return(SQLHelper.ExecuteNonQurery(sql, CommandType.Text, parameter));
}
/// <summary>
/// 修改单个颜色信息
/// </summary>
/// <param name="colors">修改之后的颜色信息</param>
/// <returns>是否修改成功 1 = 成功 0 = 失败</returns>
public static int UpdateColor(Model.Colors colors)
{
string sql = "update Colors set ColorCode = @code, Name = @name , Matching =@match where ColorId = @id ";
SqlParameter[] parameter =
{
new SqlParameter("@code", colors.ColorCode),
new SqlParameter("@name", colors.Name),
new SqlParameter("@match", colors.Matching),
new SqlParameter("@id", colors.ColorId),
};
return(SQLHelper.ExecuteNonQurery(sql, CommandType.Text, parameter));
}
/// <summary>
/// 添加员工信息
/// </summary>
/// <param name="employee">员工实体类</param>
/// <returns>是否添加成功数据信息</returns>
public static int AddEmployee(Model.Employee employee)
{
string sql = "insert into Employee values(@Name,@Age,@Sex,@Did)";
SqlParameter[] sqlParameter =
{
new SqlParameter("@Name", employee.Name),
new SqlParameter("@Age", employee.Age),
new SqlParameter("@Sex", employee.Sex),
new SqlParameter("@Did", employee.DID),
};
return(SQLHelper.ExecuteNonQurery(sql, CommandType.Text, sqlParameter));
}
