/// <summary>
/// 添加
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public int Add(Department entity)
{
string sql = "insert into Department(DepartmentName,DepartmentRemarks) values(@DepartmentName,@DepartmentRemarks)";
db.PrepareSql(sql);
db.SetParameter("DepartmentName", entity.DepartmentName);
db.SetParameter("DepartmentRemarks", entity.DepartmentRemarks);
return(db.ExecNonQuery());
}
/// <summary>
/// 添加
/// </summary>
/// <returns></returns>
public int Add(Role entity)
{
string sql = "insert into Role(RoleName,RoleNumber)values(@RoleName,@RoleNumber)";
db.PrepareSql(sql);
db.SetParameter("RoleName", entity.RoleName);
db.SetParameter("RoleNumber", entity.RoleNumber);
return(db.ExecNonQuery());
}
/// <summary>
/// 添加
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public int Add(SystemLog entity)
{
string sql = "insert into SystemLog(userID,LogTime,LogOperation) values(@userID,@LogTime,@LogOperation)";
db.PrepareSql(sql);
db.SetParameter("userID", entity.userID);
db.SetParameter("LogTime", entity.LogTime);
db.SetParameter("LogOperation", entity.LogOperation);
return(db.ExecNonQuery());
}
/// <summary>
/// 添加
/// </summary>
/// <returns></returns>
public int Add(CategoryItems entity)
{
string sql = "insert into CategoryItems(C_Category,CI_ID,CI_Name)values(@C_Category,@CI_ID,@CI_Name)";
db.PrepareSql(sql);
db.SetParameter("C_Category", entity.C_Category);
db.SetParameter("CI_ID", entity.CI_ID);
db.SetParameter("CI_Name", entity.CI_Name);
return(db.ExecNonQuery());
}
/// <summary>
/// 添加
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public int Add(PaySlipID entity)
{
string sql = "insert into PaySlipID(UserID,BasicSalary,AttendanceBonus,Fine,SalaryTime,SalarySum) values(@UserID,@BasicSalary,@AttendanceBonus,@Fine,@SalaryTime,@SalarySum)";
db.PrepareSql(sql);
db.SetParameter("UserID", entity.UserID);
db.SetParameter("BasicSalary", entity.BasicSalary);
db.SetParameter("AttendanceBonus", entity.AttendanceBonus);
db.SetParameter("Fine", entity.Fine);
db.SetParameter("SalaryTime", entity.SalaryTime);
db.SetParameter("SalarySum", entity.SalarySum);
return(db.ExecNonQuery());
}
/// <summary>
/// 添加
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public int Add(PayRise entity)
{
string sql = "insert into PayRise(UserID,PayRiseMoney,Reason,ApplicationTime,ApprovalContent,ApprovalState,ApprovalTime) values(@UserID,@PayRiseMoney,@Reason,@ApplicationTime,@ApprovalContent,@ApprovalState,@ApprovalTime)";
db.PrepareSql(sql);
db.SetParameter("UserID", entity.UserID);
db.SetParameter("PayRiseMoney", entity.PayRiseMoney);
db.SetParameter("Reason", entity.Reason);
db.SetParameter("ApplicationTime", entity.ApplicationTime);
db.SetParameter("ApprovalContent", entity.ApprovalContent);
db.SetParameter("ApprovalState", entity.ApprovalState);
db.SetParameter("ApprovalTime", entity.ApprovalTime);
return(db.ExecNonQuery());
}
/// <summary>
/// 添加
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public int Add(Overtime entity)
{
string sql = "insert into Overtime(OvertimeStateTime,OvertimeEndTime,OvertimeDuration,UserID,ApplyTime,OvertimeState,ApproverReason) values(@OvertimeStateTime,@OvertimeEndTime,@OvertimeDuration,@UserID,@ApplyTime,@OvertimeState,@ApproverReason)";
db.PrepareSql(sql);
db.SetParameter("OvertimeStateTime", entity.OvertimeStateTime);
db.SetParameter("OvertimeEndTime", entity.OvertimeEndTime);
db.SetParameter("OvertimeDuration", entity.OvertimeDuration);
db.SetParameter("UserID", entity.UserID);
db.SetParameter("ApplyTime", entity.ApplyTime);
db.SetParameter("OvertimeState", entity.OvertimeState);
db.SetParameter("ApproverReason", entity.ApproverReason);
return(db.ExecNonQuery());
}
/// <summary>
/// 添加
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public int Add(Notice entity)
{
string sql = "insert into Notice(NoticeType,NoticeTitle,NoticeContent,UserID,NoticeStateTime,NoticeEndTime,NoticeState)values(@NoticeType,@NoticeTitle,@NoticeContent,@UserID,@NoticeStateTime,@NoticeEndTime,@NoticeState)";
db.PrepareSql(sql);
db.SetParameter("NoticeType", entity.NoticeType);
db.SetParameter("NoticeTitle", entity.NoticeTitle);
db.SetParameter("NoticeContent", entity.NoticeContent);
db.SetParameter("UserID", entity.UserID);
db.SetParameter("NoticeStateTime", entity.NoticeStateTime);
db.SetParameter("NoticeEndTime", entity.NoticeEndTime);
db.SetParameter("NoticeState", entity.NoticeState);
return(db.ExecNonQuery());
}
/// <summary>
/// 添加
/// </summary>
/// <returns></returns>
public int Add(AttendanceSheet entity)
{
string sql = "insert into AttendanceSheet(AttendanceStartTime,AttendanceType,UserID,ClockTime,ClockOutTime,Workinghours,remake,Late,Absenteeism) values(@AttendanceStartTime,@AttendanceType,@UserID,@ClockTime,@ClockOutTime,@Workinghours,@remake,@Late,@Absenteeism)";
db.PrepareSql(sql);
db.SetParameter("AttendanceStartTime", entity.AttendanceStartTime);
db.SetParameter("AttendanceType", entity.AttendanceType);
db.SetParameter("UserID", entity.UserID);
db.SetParameter("ClockTime", entity.ClockTime);
db.SetParameter("ClockOutTime", entity.ClockOutTime);
db.SetParameter("Workinghours", entity.Workinghours);
db.SetParameter("remake", entity.remake);
db.SetParameter("Late", entity.Late);
db.SetParameter("Absenteeism", entity.Absenteeism);
return(db.ExecNonQuery());
}
/// <summary>
/// 添加
/// </summary>
/// <returns></returns>
public int Add(Assessment entity)
{
string sql = "insert into Assessment(PerformanceTime,UserID,WorkSummary,UpperGoal,CompletionDegree,ExaminationItems,NextStageObjectives,PerformanceScore,comments,perstate) values(@PerformanceTime,@UserID,@WorkSummary,@UpperGoal, @CompletionDegree,@ExaminationItems,@NextStageObjectives,@PerformanceScore,@comments,@perstate)";
db.PrepareSql(sql);
db.SetParameter("PerformanceTime", entity.PerformanceTime);
db.SetParameter("UserID", entity.UserID);
db.SetParameter("WorkSummary", entity.WorkSummary);
db.SetParameter("UpperGoal", entity.UpperGoal);
db.SetParameter("CompletionDegree", entity.CompletionDegree);
db.SetParameter("ExaminationItems", entity.ExaminationItems);
db.SetParameter("NextStageObjectives", entity.NextStageObjectives);
db.SetParameter("PerformanceScore", entity.PerformanceScore);
db.SetParameter("comments", entity.comments);
db.SetParameter("perstate", entity.perstate);
return(db.ExecNonQuery());
}
/// <summary>
/// 添加
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public int Add(Leave entity)
{
string sql = "insert into Leave(UserID,LeaveState,LeaveTime,LeaveStartTime,LeaveEndTime,LeaveHalfDay,LeaveDays,LeaveReason,ApproverID,ApprovalTime,ApproverReason)values(UserID,LeaveState,LeaveTime,LeaveStartTime,LeaveEndTime,LeaveHalfDay,LeaveDays,LeaveReason,ApproverID,ApprovalTime,ApproverReason)";
db.PrepareSql(sql);
db.SetParameter("UserID", entity.UserID);
db.SetParameter("LeaveState", entity.LeaveState);
db.SetParameter("LeaveTime", entity.LeaveTime);
db.SetParameter("LeaveStartTime", entity.LeaveStartTime);
db.SetParameter("LeaveEndTime", entity.LeaveEndTime);
db.SetParameter("LeaveHalfDay", entity.LeaveHalfDay);
db.SetParameter("LeaveDays", entity.LeaveDays);
db.SetParameter("LeaveReason", entity.LeaveReason);
db.SetParameter("ApproverID", entity.ApproverID);
db.SetParameter("ApprovalTime", entity.ApprovalTime);
db.SetParameter("ApproverReason", entity.ApproverReason);
return(db.ExecNonQuery());
}
/// <summary>
/// 添加
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public int Add(Entity.UserInfo entity)
{
string sql = "insert into UserInfo(DepartmentID,RoleID,UserNumber,LoginName,LoginPwd,UserName,UserAge,UserSex,UserTel,UserAddress,UserIphone,UserRemarks,UserStatr,EntryTime,DimissionTime,BasePay) values(@UserID,@DepartmentID,@RoleID,@UserNumber,@LoginName,@LoginPwd,@UserName,@UserAge,@UserSex,@UserTel,@UserAddress,@UserIphone,@UserRemarks,@UserStatr,@EntryTime,@DimissionTime,@BasePay)";
db.PrepareSql(sql);
db.SetParameter("DepartmentID", entity.DepartmentID);
db.SetParameter("RoleID", entity.RoleID);
db.SetParameter("UserNumber", entity.UserNumber);
db.SetParameter("LoginName", entity.LoginName);
db.SetParameter("LoginPwd", entity.LoginPwd);
db.SetParameter("UserName", entity.UserName);
db.SetParameter("UserAge", entity.UserAge);
db.SetParameter("UserSex", entity.UserSex);
db.SetParameter("UserTel", entity.UserTel);
db.SetParameter("UserAddress", entity.UserAddress);
db.SetParameter("UserIphone", entity.UserIphone);
db.SetParameter("UserRemarks", entity.UserRemarks);
db.SetParameter("UserStatr", entity.UserStatr);
db.SetParameter("EntryTime", entity.EntryTime);
db.SetParameter("DimissionTime", entity.DimissionTime);
db.SetParameter("BasePay", entity.BasePay);
return(db.ExecNonQuery());
}
public bool DeleteItemInShoppingCartByIdItem(int?ShoesId)
{
if (ShoesId == null)
{
return(false);
}
query = @"DELETE FROM Orderdetails where item_id = " + ShoesId + ";";
MySqlConnection connection = DBHelper.OpenConnection();
if (DBHelper.ExecNonQuery(query, connection) == 0)
{
DBHelper.CloseConnection();
return(false);
}
DBHelper.CloseConnection();
return(true);
}
public bool DeleteItemInShoppingCartByItemID(int?itemID)
{
if (itemID == null)
{
return(false);
}
query = $@"delete from OrderDetails where itemID = {itemID}; ";
MySqlConnection connection = DBHelper.OpenConnection();
if (DBHelper.ExecNonQuery(query, connection) == 0)
{
DBHelper.CloseConnection();
return(false);
}
DBHelper.CloseConnection();
return(true);
}
public bool UpdateStatusShoppingCartById(bool isHave, int?userID)
{
if (userID == null)
{
return(false);
}
switch (isHave)
{
case true:
query = $@"update Users set userShoppingCart = false where userID = {userID}";
break;
case false:
query = $@"update Users set userShoppingCart = true where userID = {userID}";
break;
}
DBHelper.ExecNonQuery(query, DBHelper.OpenConnection());
DBHelper.CloseConnection();
return(true);
}
public bool UpdateStatusShoppingCartById(bool isHave, int?UserID)
{
if (UserID == null)
{
return(false);
}
switch (isHave)
{
case true:
query = @"update Customers set UserShoppingCart = false where customer_id = " + UserID + ";";
break;
case false:
query = @"update Customers set UserShoppingCart = true where customer_id = " + UserID + ";";
break;
}
DBHelper.ExecNonQuery(query, DBHelper.OpenConnection());
DBHelper.CloseConnection();
return(true);
}
