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