/// <summary> /// 添加报表信息 /// </summary> /// <param name="AttendanceReportM">报表信息</param> /// <param name="reportdatas">报表详细</param> /// <returns>添加是否成功 false:失败,true:成功</returns> public static bool AddAttendanceReportInfo(AttendanceReportModel AttendanceReportM, string reportdatas) { try { StringBuilder AttendanceReportSql = new StringBuilder(); AttendanceReportSql.AppendLine("INSERT INTO officedba.AttendanceReport"); AttendanceReportSql.AppendLine(" (ReprotNo "); AttendanceReportSql.AppendLine(" ,CompanyCD "); AttendanceReportSql.AppendLine(" ,ReportName "); AttendanceReportSql.AppendLine(" ,Month "); AttendanceReportSql.AppendLine(" ,StartDate "); AttendanceReportSql.AppendLine(" ,EndDate "); AttendanceReportSql.AppendLine(" ,CreateUserID "); AttendanceReportSql.AppendLine(" ,CreateDate "); AttendanceReportSql.AppendLine(" ,Status"); AttendanceReportSql.AppendLine(" ,ModifiedDate "); AttendanceReportSql.AppendLine(" ,ModifiedUserID) "); AttendanceReportSql.AppendLine("VALUES "); AttendanceReportSql.AppendLine(" ('" + AttendanceReportM.ReprotNo + "' "); AttendanceReportSql.AppendLine(" ,'" + AttendanceReportM.CompanyCD + "' "); AttendanceReportSql.AppendLine(" ,'" + AttendanceReportM.ReportName + "' "); AttendanceReportSql.AppendLine(" ,'" + AttendanceReportM.Month + "' "); AttendanceReportSql.AppendLine(" ,'" + AttendanceReportM.StartDate + "' "); AttendanceReportSql.AppendLine(" ,'" + AttendanceReportM.EndDate + "' "); AttendanceReportSql.AppendLine(" ,'" + AttendanceReportM.CreateUserID + "' "); AttendanceReportSql.AppendLine(" ,'" + AttendanceReportM.CreateDate + "' "); AttendanceReportSql.AppendLine(" ,'" + AttendanceReportM.Status + "'"); AttendanceReportSql.AppendLine(" ,'" + AttendanceReportM.ModifiedDate + "' "); AttendanceReportSql.AppendLine(" ,'" + AttendanceReportM.ModifiedUserID + "') "); return InsertAll(AttendanceReportSql.ToString(), reportdatas, AttendanceReportM.CompanyCD, AttendanceReportM.ModifiedUserID); } catch { return false; } }
/// <summary> /// 确认报表信息 /// </summary> /// <param name="AttendanceReportM">报表信息</param> /// <returns>添加是否成功 false:失败,true:成功</returns> public static bool ConfirmAttendanceChangeInfo(AttendanceReportModel AttendanceReportM) { return AttendanceReportDBHelper.ConfirmAttendanceChangeInfo(AttendanceReportM); }
/// <summary> /// 修改考勤报表信息 /// </summary> /// <param name="AttendanceReportM">报表信息</param> /// <param name="reportdatas">报表详细</param> /// <returns>更新是否成功 false:失败,true:成功</returns> public static bool UpdateAttendanceReportInfo(AttendanceReportModel AttendanceReportM, string reportdatas) { return AttendanceReportDBHelper.UpdateAttendanceReportInfo(AttendanceReportM, reportdatas); }
/// <summary> /// 确认报表信息 /// </summary> /// <param name="AttendanceReportDetailM">报表信息</param> /// <returns>更新是否成功 false:失败,true:成功</returns> public static bool ConfirmAttendanceChangeInfo(AttendanceReportModel AttendanceReportM) { try { #region 报表调整信息SQL拼写 StringBuilder sql = new StringBuilder(); sql.AppendLine("UPDATE officedba.AttendanceReport SET "); sql.AppendLine(" Status=@Status "); sql.AppendLine(" ,ModifiedDate=@ModifiedDate "); sql.AppendLine(" ,ModifiedUserID=@ModifiedUserID "); sql.AppendLine(" WHERE "); sql.AppendLine(" ReprotNo = @ReprotNo "); sql.AppendLine(" AND CompanyCD = @CompanyCD "); #endregion #region 报表调整信息参数设置 SqlParameter[] param; param = new SqlParameter[5]; param[0] = SqlHelper.GetParameter("@Status", AttendanceReportM.Status); param[1] = SqlHelper.GetParameter("@ModifiedDate", AttendanceReportM.ModifiedDate); param[2] = SqlHelper.GetParameter("@ModifiedUserID", AttendanceReportM.ModifiedUserID); param[3] = SqlHelper.GetParameter("@ReprotNo", AttendanceReportM.ReprotNo); param[4] = SqlHelper.GetParameter("@CompanyCD", AttendanceReportM.CompanyCD); #endregion SqlHelper.ExecuteTransSql(sql.ToString(), param); return SqlHelper.Result.OprateCount > 0 ? true : false; } catch { return false; } }
/// <summary> /// 修改报表信息 /// </summary> /// <param name="AttendanceReportM">报表信息</param> /// <param name="reportdatas">报表详细</param> /// <returns>修改是否成功 false:失败,true:成功</returns> public static bool UpdateAttendanceReportInfo(AttendanceReportModel AttendanceReportM, string reportdatas) { try { StringBuilder AttendanceReportSql = new StringBuilder(); AttendanceReportSql.AppendLine("UPDATE officedba.AttendanceReport"); AttendanceReportSql.AppendLine(" SET ReportName='" + AttendanceReportM.ReportName + "' "); AttendanceReportSql.AppendLine(" ,StartDate='" + AttendanceReportM.StartDate + "' "); AttendanceReportSql.AppendLine(" ,EndDate='" + AttendanceReportM.EndDate + "' "); AttendanceReportSql.AppendLine(" ,CreateUserID='" + AttendanceReportM.CreateUserID + "' "); AttendanceReportSql.AppendLine(" ,CreateDate='" + AttendanceReportM.CreateDate + "' "); AttendanceReportSql.AppendLine(" ,Status='" + AttendanceReportM.Status + "'"); AttendanceReportSql.AppendLine(" ,ModifiedDate='" + AttendanceReportM.ModifiedDate + "' "); AttendanceReportSql.AppendLine(" ,ModifiedUserID='" + AttendanceReportM.ModifiedUserID + "' "); AttendanceReportSql.AppendLine(" WHERE ReprotNo='" + AttendanceReportM .ReprotNo+ "' "); AttendanceReportSql.AppendLine(" AND CompanyCD='" + AttendanceReportM.CompanyCD + "' "); AttendanceReportSql.AppendLine(" AND Month='" + AttendanceReportM.Month + "' "); return UpdateAll(AttendanceReportSql.ToString(), reportdatas, AttendanceReportM.CompanyCD, AttendanceReportM.ReprotNo, AttendanceReportM.ModifiedUserID); } catch { return false; } }