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