/// <summary>
/// 添加报表信息
/// </summary>
/// <param name="AttendanceReportSql">主表SQL</param>
/// <param name="reportdatas">报表详细数据</param>
/// <returns>添加是否成功 false:失败，true:成功</returns>
public static bool InsertAll(string AttendanceReportSql, string reportdatas, string CompanyCD, string UserID)
{
AttendanceReportDetailModel AttendanceReportDetailM = new AttendanceReportDetailModel();
string[] strarray = null;
string recorditems = "";
string[] inseritems = null;
try
{
strarray = reportdatas.Split('|');
string[] sqlarray = new string[strarray.Length+1];
sqlarray[0] = AttendanceReportSql;
for (int i = 0; i < strarray.Length; i++)
{
StringBuilder ReportDetailSql = new StringBuilder();
recorditems = strarray[i];
inseritems = recorditems.Split(',');
if (recorditems.Length != 0)
{
string ReportNo = inseritems[0].ToString();//报表编号
string EmployeeID = inseritems[1].ToString();//员工ID
string Hours = inseritems[2].ToString();//应出勤时长
string WorkHour=inseritems[3].ToString();//实际出勤时长
string Leave=inseritems[4].ToString();//请假时长
string Overtime=inseritems[5].ToString();//加班时长
string Out=inseritems[6].ToString();//外出时长
string Business=inseritems[7].ToString();//出差时长
string Instead=inseritems[8].ToString();//替班时长
string Transferred=inseritems[9].ToString();//年休时长
string LateMinute=inseritems[10].ToString();//迟到时长
string LeaveEarlyMinute=inseritems[11].ToString();//早退时长
string AttendanceRate = inseritems[12].ToString();//出勤率
string AttendanceType = inseritems[13].ToString();//考勤类型
string NomalHour = inseritems[14].ToString();//正常考勤时间
AttendanceReportDetailM.ReprotNo = ReportNo;
AttendanceReportDetailM.CompanyCD = CompanyCD;
AttendanceReportDetailM.EmployeeID =Convert.ToInt32(EmployeeID);
//AttendanceReportDetailM.StartDate =Convert.ToDateTime(StartDate);
//AttendanceReportDetailM.EndDate = EndDate;
AttendanceReportDetailM.Hours = Convert.ToDecimal(Hours);
AttendanceReportDetailM.WorkHour = Convert.ToDecimal(WorkHour);
AttendanceReportDetailM.Leave =Convert.ToDecimal(Leave);
AttendanceReportDetailM.Overtime = Convert.ToDecimal(Overtime);
AttendanceReportDetailM.Out = Convert.ToDecimal(Out);
AttendanceReportDetailM.Business = Convert.ToDecimal(Business);
AttendanceReportDetailM.Instead = Convert.ToDecimal(Instead);
AttendanceReportDetailM.Transferred = Convert.ToDecimal(Transferred);
AttendanceReportDetailM.LateMinute = Convert.ToDecimal(LateMinute);
AttendanceReportDetailM.LeaveEarlyMinute = Convert.ToDecimal(LeaveEarlyMinute);
AttendanceReportDetailM.ModifiedDate = System.DateTime.Now;
AttendanceReportDetailM.ModifiedUserID = UserID;
ReportDetailSql.AppendLine("INSERT INTO officedba.AttendanceReportMonth");
ReportDetailSql.AppendLine(" (ReprotNo ");
ReportDetailSql.AppendLine(" ,CompanyCD ");
ReportDetailSql.AppendLine(" ,EmployeeID ");
ReportDetailSql.AppendLine(" ,NomalHour ");
ReportDetailSql.AppendLine(" ,AttendanceType ");
ReportDetailSql.AppendLine(" ,Hours ");
ReportDetailSql.AppendLine(" ,WorkHour ");
ReportDetailSql.AppendLine(" ,Leave ");
ReportDetailSql.AppendLine(" ,Overtime ");
ReportDetailSql.AppendLine(" ,Out ");
ReportDetailSql.AppendLine(" ,Business ");
ReportDetailSql.AppendLine(" ,[Instead] ");
ReportDetailSql.AppendLine(" ,Transferred ");
ReportDetailSql.AppendLine(" ,LateMinute ");
ReportDetailSql.AppendLine(" ,LeaveEarlyMinute ");
ReportDetailSql.AppendLine(" ,AttendanceRate ");
ReportDetailSql.AppendLine(" ,ModifiedDate ");
ReportDetailSql.AppendLine(" ,ModifiedUserID) ");
ReportDetailSql.AppendLine("VALUES ");
ReportDetailSql.AppendLine(" ('" + AttendanceReportDetailM.ReprotNo + "' ");
ReportDetailSql.AppendLine(" ,'" + AttendanceReportDetailM.CompanyCD + "' ");
ReportDetailSql.AppendLine(" ,'" + AttendanceReportDetailM.EmployeeID + "' ");
ReportDetailSql.AppendLine(" ," + NomalHour + " ");
ReportDetailSql.AppendLine(" ,'" + AttendanceType + "' ");
ReportDetailSql.AppendLine(" ," + AttendanceReportDetailM.Hours + " ");
ReportDetailSql.AppendLine(" ," + AttendanceReportDetailM.WorkHour + " ");
ReportDetailSql.AppendLine(" ," + AttendanceReportDetailM.Leave + " ");
ReportDetailSql.AppendLine(" ," + AttendanceReportDetailM.Overtime + " ");
ReportDetailSql.AppendLine(" ," + AttendanceReportDetailM.Out + " ");
ReportDetailSql.AppendLine(" ," + AttendanceReportDetailM.Business + " ");
ReportDetailSql.AppendLine(" ," + AttendanceReportDetailM.Instead + " ");
ReportDetailSql.AppendLine(" ," + AttendanceReportDetailM.Transferred + " ");
ReportDetailSql.AppendLine(" ," + AttendanceReportDetailM.LateMinute + " ");
ReportDetailSql.AppendLine(" ," + AttendanceReportDetailM.LeaveEarlyMinute + " ");
ReportDetailSql.AppendLine(" ," +Convert.ToDecimal(AttendanceRate) + " ");
ReportDetailSql.AppendLine(" ,'" + AttendanceReportDetailM.ModifiedDate + "' ");
ReportDetailSql.AppendLine(" ,'" + AttendanceReportDetailM.ModifiedUserID + "') ");
sqlarray[i+1] = ReportDetailSql.ToString();
}
}
SqlHelper.ExecuteTransForListWithSQL(sqlarray);
return SqlHelper.Result.OprateCount > 0 ? true : false;
}
catch
{
return false;
}
}
/// <summary>
/// 保存报表调整信息
/// </summary>
/// <param name="AttendanceReportM">报表信息</param>
/// <returns>添加是否成功 false:失败，true:成功</returns>
public static bool SaveAttendanceChangeInfo(AttendanceReportDetailModel AttendanceReportDetailM, string AttendanceType)
{
return AttendanceReportDBHelper.SaveAttendanceChangeInfo(AttendanceReportDetailM, AttendanceType);
}
/// <summary>
/// 保存报表调整信息
/// </summary>
/// <param name="AttendanceReportDetailM">报表调整信息</param>
/// <returns>更新是否成功 false:失败，true:成功</returns>
public static bool SaveAttendanceChangeInfo(AttendanceReportDetailModel AttendanceReportDetailM, string AttendanceType)
{
try
{
#region 报表调整信息SQL拼写
StringBuilder sql = new StringBuilder();
sql.AppendLine("UPDATE officedba.AttendanceReportMonth SET ");
sql.AppendLine(" ChangeTimes=@ChangeTimes ");
sql.AppendLine(" ,ChangeType=@ChangeType ");
sql.AppendLine(" ,ChangeNote=@ChangeNote ");
sql.AppendLine(" ,AttendanceRate=@AttendanceRate ");
sql.AppendLine(" ,ModifiedDate=@ModifiedDate ");
sql.AppendLine(" ,ModifiedUserID=@ModifiedUserID ");
sql.AppendLine(" WHERE ");
sql.AppendLine(" ReprotNo = @ReprotNo ");
sql.AppendLine(" AND CompanyCD = @CompanyCD ");
sql.AppendLine(" AND EmployeeID = @EmployeeID ");
sql.AppendLine(" AND AttendanceType = @AttendanceType ");
#endregion
#region 报表调整信息参数设置
SqlParameter[] param;
param = new SqlParameter[10];
param[0] = SqlHelper.GetParameter("@ChangeTimes", AttendanceReportDetailM.ChangeTimes);
param[1] = SqlHelper.GetParameter("@ChangeType", AttendanceReportDetailM.ChangeType);
param[2] = SqlHelper.GetParameter("@ChangeNote", AttendanceReportDetailM.ChangeNote);
param[3] = SqlHelper.GetParameter("@AttendanceRate", AttendanceReportDetailM.AttendanceRate);
param[4] = SqlHelper.GetParameter("@ModifiedDate", AttendanceReportDetailM.ModifiedDate);
param[5] = SqlHelper.GetParameter("@ModifiedUserID", AttendanceReportDetailM.ModifiedUserID);
param[6] = SqlHelper.GetParameter("@ReprotNo", AttendanceReportDetailM.ReprotNo);
param[7] = SqlHelper.GetParameter("@CompanyCD", AttendanceReportDetailM.CompanyCD);
param[8] = SqlHelper.GetParameter("@EmployeeID", AttendanceReportDetailM.EmployeeID);
param[9] = SqlHelper.GetParameter("@AttendanceType", AttendanceType);
#endregion
SqlHelper.ExecuteTransSql(sql.ToString(), param);
return SqlHelper.Result.OprateCount > 0 ? true : false;
}
catch
{
return false;
}
}
