/// <summary> /// 修改信息 /// </summary> /// <param name="AttendanceApplyM">加班信息</param> /// <returns>更新是否成功 false:失败,true:成功</returns> public static bool UpdateOverTimeData(AttendanceApplyModel AttendanceApplyM, string ID) { return AttendanceApplyDBHelper.UpdateOverTimeData(AttendanceApplyM, ID); }
/// <summary> /// 修改年休信息 /// </summary> /// <param name="AttendanceApplyM">年休信息</param> /// <returns>更新是否成功 false:失败,true:成功</returns> public static bool UpdateYearHolidayApplyData(AttendanceApplyModel AttendanceApplyM, string ID) { return AttendanceApplyDBHelper.UpdateYearHolidayApplyData(AttendanceApplyM,ID); }
/// <summary> /// 添加加班信息 /// </summary> /// <param name="AttendanceApplyM">加班信息</param> /// <returns>添加是否成功 false:失败,true:成功</returns> public static bool InsertOverTimeData(AttendanceApplyModel AttendanceApplyM,out int RetValID) { return AttendanceApplyDBHelper.InsertOverTimeData(AttendanceApplyM, out RetValID); }
/// <summary> /// 添加年休信息 /// </summary> /// <param name="AttendanceApplyM">年休信息</param> /// <returns>添加是否成功 false:失败,true:成功</returns> public static bool InsertYearHolidayData(AttendanceApplyModel AttendanceApplyM,out int RetValID) { return AttendanceApplyDBHelper.InsertYearHolidayData(AttendanceApplyM, out RetValID); }
/// <summary> /// 修改出差信息 /// </summary> /// <param name="AttendanceApplyM">出差信息</param> /// <returns>更新是否成功 false:失败,true:成功</returns> public static bool UpdateBusinessData(AttendanceApplyModel AttendanceApplyM, string ID) { return AttendanceApplyDBHelper.UpdateBusinessData(AttendanceApplyM, ID); }
/// <summary> /// 修改年休信息 /// </summary> /// <param name="AttendanceApplyM">年休信息</param> /// <returns>更新是否成功 false:失败,true:成功</returns> public static bool UpdateYearHolidayApplyData(AttendanceApplyModel AttendanceApplyM, string ID) { try { StringBuilder sql = new StringBuilder(); sql.AppendLine("UPDATE officedba.AttendanceApply"); sql.AppendLine(" Set CompanyCD=@CompanyCD "); //sql.AppendLine(" ,EmployeeID=@EmployeeID "); sql.AppendLine(" ,ApplyDate=@ApplyDate "); sql.AppendLine(" ,StartDate=@StartDate "); sql.AppendLine(" ,EndDate=@EndDate "); sql.AppendLine(" ,StartTime=@StartTime "); sql.AppendLine(" ,EndTime=@EndTime "); sql.AppendLine(" ,ApplyReason=@ApplyReason "); sql.AppendLine(" ,ModifiedDate=@ModifiedDate "); sql.AppendLine(" ,ModifiedUserID=@ModifiedUserID "); sql.AppendLine(" where id=" + ID + " "); //设置参数 SqlParameter[] param; param = new SqlParameter[10]; param[0] = SqlHelper.GetParameter("@CompanyCD", AttendanceApplyM.CompanyCD); //param[1] = SqlHelper.GetParameter("@EmployeeID", AttendanceApplyM.EmployeeID); param[1] = SqlHelper.GetParameter("@Flag", AttendanceApplyM.Flag); param[2] = SqlHelper.GetParameter("@ApplyDate", AttendanceApplyM.ApplyDate); param[3] = SqlHelper.GetParameter("@StartDate", AttendanceApplyM.StartDate); param[4] = SqlHelper.GetParameter("@EndDate", AttendanceApplyM.EndDate); param[5] = SqlHelper.GetParameter("@StartTime", AttendanceApplyM.StartTime); param[6] = SqlHelper.GetParameter("@EndTime", AttendanceApplyM.EndTime); param[7] = SqlHelper.GetParameter("@ApplyReason", AttendanceApplyM.ApplyReason); param[8] = SqlHelper.GetParameter("@ModifiedDate", AttendanceApplyM.ModifiedDate); param[9] = SqlHelper.GetParameter("@ModifiedUserID", AttendanceApplyM.ModifiedUserID); SqlHelper.ExecuteTransSql(sql.ToString(), param); return SqlHelper.Result.OprateCount > 0 ? true : false; } catch { return false; } }
/// <summary> /// 添加年休信息 /// </summary> /// <param name="AttendanceApplyM">年休信息</param> /// <returns>添加是否成功 false:失败,true:成功</returns> public static bool InsertYearHolidayData(AttendanceApplyModel AttendanceApplyM,out int RetValID) { try { StringBuilder sql = new StringBuilder(); sql.AppendLine("INSERT INTO officedba.AttendanceApply"); sql.AppendLine(" (CompanyCD "); sql.AppendLine(" ,EmployeeID "); sql.AppendLine(" ,ApplyUserID "); sql.AppendLine(" ,Flag "); sql.AppendLine(" ,ApplyNo "); sql.AppendLine(" ,ApplyDate "); sql.AppendLine(" ,StartDate "); sql.AppendLine(" ,EndDate "); sql.AppendLine(" ,StartTime "); sql.AppendLine(" ,EndTime "); sql.AppendLine(" ,ApplyReason "); sql.AppendLine(" ,ModifiedDate "); sql.AppendLine(" ,ModifiedUserID) "); sql.AppendLine("VALUES "); sql.AppendLine(" (@CompanyCD "); sql.AppendLine(" ,@EmployeeID "); sql.AppendLine(" ,@ApplyUserID "); sql.AppendLine(" ,@Flag "); sql.AppendLine(" ,@ApplyNo "); sql.AppendLine(" ,@ApplyDate "); sql.AppendLine(" ,@StartDate "); sql.AppendLine(" ,@EndDate "); sql.AppendLine(" ,@StartTime "); sql.AppendLine(" ,@EndTime "); sql.AppendLine(" ,@ApplyReason "); sql.AppendLine(" ,@ModifiedDate "); sql.AppendLine(" ,@ModifiedUserID) "); sql.AppendLine("set @ID=@@IDENTITY"); //设置参数 SqlParameter[] param; param = new SqlParameter[14]; param[0] = SqlHelper.GetParameter("@CompanyCD", AttendanceApplyM.CompanyCD); param[1] = SqlHelper.GetParameter("@EmployeeID", AttendanceApplyM.EmployeeID); param[2] = SqlHelper.GetParameter("@Flag", AttendanceApplyM.Flag); param[3] = SqlHelper.GetParameter("@ApplyDate", AttendanceApplyM.ApplyDate); param[4] = SqlHelper.GetParameter("@StartDate", AttendanceApplyM.StartDate); param[5] = SqlHelper.GetParameter("@EndDate", AttendanceApplyM.EndDate); param[6] = SqlHelper.GetParameter("@StartTime", AttendanceApplyM.StartTime); param[7] = SqlHelper.GetParameter("@EndTime", AttendanceApplyM.EndTime); param[8] = SqlHelper.GetParameter("@ApplyReason", AttendanceApplyM.ApplyReason); param[9] = SqlHelper.GetParameter("@ModifiedDate", AttendanceApplyM.ModifiedDate); param[10] = SqlHelper.GetParameter("@ModifiedUserID", AttendanceApplyM.ModifiedUserID); param[11] = SqlHelper.GetParameter("@ApplyNo", AttendanceApplyM.ApplyNo); param[12] = SqlHelper.GetParameter("@ApplyUserID", AttendanceApplyM.ApplyUserID); param[13] = SqlHelper.GetOutputParameter("@ID", SqlDbType.Int); SqlHelper.ExecuteTransSql(sql.ToString(), param); RetValID = Convert.ToInt32(param[13].Value.ToString()); return SqlHelper.Result.OprateCount > 0 ? true : false; } catch { RetValID = 0; return false; } }
/// <summary> /// 修改出差信息 /// </summary> /// <param name="AttendanceApplyM">出差信息</param> /// <returns>更新是否成功 false:失败,true:成功</returns> public static bool UpdateBusinessData(AttendanceApplyModel AttendanceApplyM, string ID) { try { StringBuilder sql = new StringBuilder(); sql.AppendLine("UPDATE officedba.AttendanceApply"); sql.AppendLine(" Set CompanyCD=@CompanyCD "); //sql.AppendLine(" ,EmployeeID=@EmployeeID "); sql.AppendLine(" ,Flag=@Flag "); sql.AppendLine(" ,ApplyDate=@ApplyDate "); sql.AppendLine(" ,BusinessDate=@BusinessDate "); sql.AppendLine(" ,BusinessPlanDate=@BusinessPlanDate "); sql.AppendLine(" ,BusinessPlace=@BusinessPlace "); sql.AppendLine(" ,BusinessTransport=@BusinessTransport "); sql.AppendLine(" ,BusinessAdvance=@BusinessAdvance "); sql.AppendLine(" ,ApplyReason=@ApplyReason "); sql.AppendLine(" ,BusinessPeer=@BusinessPeer "); sql.AppendLine(" ,BusinessRemark=@BusinessRemark "); sql.AppendLine(" ,ModifiedDate=@ModifiedDate "); sql.AppendLine(" ,ModifiedUserID=@ModifiedUserID "); sql.AppendLine(" where id=" + ID + " "); //设置参数 SqlParameter[] param; param = new SqlParameter[13]; param[0] = SqlHelper.GetParameter("@CompanyCD", AttendanceApplyM.CompanyCD); // param[1] = SqlHelper.GetParameter("@EmployeeID", AttendanceApplyM.EmployeeID); param[1] = SqlHelper.GetParameter("@Flag", AttendanceApplyM.Flag); param[2] = SqlHelper.GetParameter("@ApplyDate", AttendanceApplyM.ApplyDate); param[3] = SqlHelper.GetParameter("@BusinessDate", AttendanceApplyM.BusinessDate); param[4] = SqlHelper.GetParameter("@BusinessPlanDate", AttendanceApplyM.BusinessPlanDate); param[5] = SqlHelper.GetParameter("@BusinessPlace", AttendanceApplyM.BusinessPlace); param[6] = SqlHelper.GetParameter("@BusinessTransport", AttendanceApplyM.BusinessTransport); param[7] = SqlHelper.GetParameter("@BusinessAdvance", AttendanceApplyM.BusinessAdvance); param[8] = SqlHelper.GetParameter("@ApplyReason", AttendanceApplyM.ApplyReason); param[9] = SqlHelper.GetParameter("@BusinessPeer", AttendanceApplyM.BusinessPeer); param[10] = SqlHelper.GetParameter("@BusinessRemark", AttendanceApplyM.BusinessRemark); param[11] = SqlHelper.GetParameter("@ModifiedDate", AttendanceApplyM.ModifiedDate); param[12] = SqlHelper.GetParameter("@ModifiedUserID", AttendanceApplyM.ModifiedUserID); SqlHelper.ExecuteTransSql(sql.ToString(), param); return SqlHelper.Result.OprateCount > 0 ? true : false; } catch { return false; } }