public DataSet GetEmployeeAttendanceRealTimeInsertAndDelete(HistoryAttendanceModel haModel, out string strErrMsg)
{
SqlParameter[] sqlpara = new SqlParameter[]
{
new SqlParameter("@BlockID", SqlDbType.Int, 4),
new SqlParameter("@EmployeeName", SqlDbType.VarChar, 10),
new SqlParameter("@DeptID", SqlDbType.Int, 4),
new SqlParameter("@ClassID", SqlDbType.Int, 4),
new SqlParameter("@ClassShortName", SqlDbType.VarChar, 10),
new SqlParameter("@BeginWorkTime", SqlDbType.VarChar, 20),
new SqlParameter("@EndWorkTime", SqlDbType.VarChar, 20),
new SqlParameter("@OperatorID", SqlDbType.Int, 4),
new SqlParameter("@Remark", SqlDbType.VarChar, 200),
new SqlParameter("@TimerIntervalID", SqlDbType.Int, 4),
new SqlParameter("@DataAttendance", SqlDbType.VarChar, 20)
};
sqlpara[0].Value = haModel.BlockID;
sqlpara[1].Value = haModel.EmployeeName;
sqlpara[2].Value = haModel.DeptID;
sqlpara[3].Value = haModel.ClassID;
sqlpara[4].Value = haModel.ClassShortName;
sqlpara[5].Value = haModel.BeginWorkTime;
sqlpara[6].Value = haModel.EndWorkTime;
sqlpara[7].Value = haModel.OperatorID;
sqlpara[8].Value = haModel.Remark;
sqlpara[9].Value = haModel.TimerIntervalID;
sqlpara[10].Value = haModel.DataAttendance;
return(DB.RunProcedureByDataSet("Shine_Shen_EmployeeAttendanceRealTimeDeleteAndInsert", "dst", sqlpara, out strErrMsg));
}
/// <summary>
/// 更新历史出勤数据
/// </summary>
/// <param name="haModel">历史出勤对象</param>
/// <param name="strErrMsg">带出的结果</param>
/// <returns>返回的参数 -1为操作失败 1为操作成功</returns>
public int UpdateEmployeeAttendanceHistory(HistoryAttendanceModel haModel, out string strErrMsg)
{
SqlParameter[] sqlpara = new SqlParameter[]
{
new SqlParameter("@ID", SqlDbType.BigInt),
new SqlParameter("@BlockID", SqlDbType.Int, 4),
new SqlParameter("@EmployeeName", SqlDbType.VarChar, 10),
new SqlParameter("@DeptID", SqlDbType.Int, 4),
new SqlParameter("@ClassID", SqlDbType.Int, 4),
new SqlParameter("@ClassShortName", SqlDbType.VarChar, 20),
new SqlParameter("@BeginWorkTime", SqlDbType.VarChar, 20),
new SqlParameter("@EndWorkTime", SqlDbType.VarChar, 20),
new SqlParameter("@OperatorID", SqlDbType.Int, 4),
new SqlParameter("@Remark", SqlDbType.VarChar, 200),
new SqlParameter("@TimerIntervalID", SqlDbType.Int, 4),
new SqlParameter("@DataAttendance", SqlDbType.VarChar, 20)
};
sqlpara[0].Value = haModel.ID_HistoryAttendance;
sqlpara[1].Value = haModel.BlockID;
sqlpara[2].Value = haModel.EmployeeName;
sqlpara[3].Value = haModel.DeptID;
sqlpara[4].Value = haModel.ClassID;
sqlpara[5].Value = haModel.ClassShortName;
sqlpara[6].Value = haModel.BeginWorkTime;
sqlpara[7].Value = haModel.EndWorkTime;
sqlpara[8].Value = haModel.OperatorID;
sqlpara[9].Value = haModel.Remark;
sqlpara[10].Value = haModel.TimerIntervalID;
sqlpara[11].Value = haModel.DataAttendance;
return(DB.RunProcedureByInt("Shine_Shen_HistoryAttendanceUpdate", sqlpara, out strErrMsg));
}
private void AddHisInOutStation(HistoryAttendanceModel haModel)
{
string strStatHead = hisWellBll.GetStationHeadInfo();
DataTable dtHisInOutMine = CreateHisInOutMine();
DataRow drHis = dtHisInOutMine.NewRow();
DataSet dsEmp = hisWellBll.GetEmpInfoBll(haModel.EmployeeID.ToString());
if (String.IsNullOrEmpty(strStatHead))
{
strStatHead = "0,0,0";
}
string[] strSta = strStatHead.Split(',');
if (dsEmp != null && dsEmp.Tables.Count > 0)
{
drHis["HisInOutMineID"] = Int64.Parse(DateTime.Now.ToString("yyyyMMddHHmmss") + int.Parse(haModel.BlockID.ToString()).ToString("0000"));
drHis["InStationAddress"] = Int32.Parse(strSta[0].ToString());
drHis["InStationHeadAddress"] = Int32.Parse(strSta[1].ToString());
drHis["InWellPlace"] = strSta[2].ToString();
drHis["CodeSenderAddress"] = haModel.BlockID.ToString();
drHis["UserID"] = dsEmp.Tables[0].Rows[0]["EmpId"];
drHis["UserNo"] = dsEmp.Tables[0].Rows[0]["EmpNo"];
drHis["UserName"] = dsEmp.Tables[0].Rows[0]["EmpName"];
drHis["DeptID"] = dsEmp.Tables[0].Rows[0]["DeptID"];
drHis["DeptName"] = dsEmp.Tables[0].Rows[0]["DeptName"];
drHis["DutyID"] = dsEmp.Tables[0].Rows[0]["DutyID"];
drHis["DutyName"] = dsEmp.Tables[0].Rows[0]["DutyName"];
drHis["WorkTypeID"] = dsEmp.Tables[0].Rows[0]["workTypeID"];
drHis["WorkTypeName"] = dsEmp.Tables[0].Rows[0]["WorkTypeName"];
drHis["InTime"] = haModel.BeginWorkTime;
drHis["OutStationAddress"] = Int32.Parse(strSta[0].ToString());
drHis["OutStationHeadAddress"] = Int32.Parse(strSta[1].ToString());
drHis["OutWellPlace"] = strSta[2].ToString();
drHis["OutTime"] = haModel.EndWorkTime;
drHis["ContinueTime"] = (int)(((TimeSpan)(DateTime.Parse(haModel.EndWorkTime) - DateTime.Parse(haModel.BeginWorkTime))).TotalSeconds);
drHis["IsMend"] = 1;
hisWellBll.AddHisInOutMineBll(drHis, DateTime.Parse(haModel.BeginWorkTime).ToString("yyyyM"));
}
}
/// <summary>
/// 添加到历史考勤信息
/// </summary>
/// <returns></returns>
public int AddEmployeeAttendanceHistory(HistoryAttendanceModel haModel, string strTableName, out string strErrMsg)
{
SqlParameter[] sqlParmeters =
{
new SqlParameter("ID", SqlDbType.BigInt),
new SqlParameter("BlockID", SqlDbType.Int),
new SqlParameter("EmployeeID", SqlDbType.Int),
new SqlParameter("EmployeeName", SqlDbType.VarChar, 10),
new SqlParameter("DeptID", SqlDbType.Int),
new SqlParameter("ClassID", SqlDbType.VarChar, 20),
new SqlParameter("ClassShortName", SqlDbType.VarChar, 10),
new SqlParameter("BeginWorkTime", SqlDbType.VarChar, 50),
new SqlParameter("EndWorkTime", SqlDbType.VarChar, 50),
new SqlParameter("WorkTime", SqlDbType.Int),
new SqlParameter("TimerIntervalID", SqlDbType.Int),
new SqlParameter("DataAttendance", SqlDbType.VarChar, 50),
new SqlParameter("IsMend", SqlDbType.Bit),
new SqlParameter("TableName", SqlDbType.VarChar, 20)
};
sqlParmeters[0].Value = Int64.Parse(DateTime.Now.ToString("yyyyMMddHHmmss") + haModel.BlockID.ToString("0000"));
sqlParmeters[1].Value = haModel.BlockID;
sqlParmeters[2].Value = haModel.EmployeeID;
sqlParmeters[3].Value = haModel.EmployeeName;
sqlParmeters[4].Value = haModel.DeptID;
sqlParmeters[5].Value = haModel.ClassID;
sqlParmeters[6].Value = haModel.ClassShortName;
sqlParmeters[7].Value = haModel.BeginWorkTime;
sqlParmeters[8].Value = haModel.EndWorkTime;
sqlParmeters[9].Value = (int)(((TimeSpan)(DateTime.Parse(haModel.EndWorkTime) - DateTime.Parse(haModel.BeginWorkTime))).TotalSeconds);
sqlParmeters[10].Value = haModel.TimerIntervalID;
sqlParmeters[11].Value = haModel.DataAttendance;
sqlParmeters[12].Value = true;
sqlParmeters[13].Value = strTableName;
return(DB.RunProcedureByInt("proc_AddHisAttendance", sqlParmeters, out strErrMsg));
}
public DataSet GetEmployeeAttendanceRealTimeInsertAndDelete(HistoryAttendanceModel haModel, out string strErrMsg)
{
return(dal.GetEmployeeAttendanceRealTimeInsertAndDelete(haModel, out strErrMsg));
}
public int AddEmployeeAttendanceHistory(HistoryAttendanceModel haModel, string strTableName, out string strErrMsg)
{
return(dal.AddEmployeeAttendanceHistory(haModel, strTableName, out strErrMsg));
}
/// <summary>
/// 更新历史出勤数据
/// </summary>
/// <param name="haModel">历史出勤对象</param>
/// <param name="strErrMsg">带出的结果</param>
/// <returns>返回的参数 -1为操作失败 1为操作成功</returns>
public int UpdateEmployeeAttendanceHistory(HistoryAttendanceModel haModel, out string strErrMsg)
{
return(dal.UpdateEmployeeAttendanceHistory(haModel, out strErrMsg));
}
/// <summary>
/// 判断历史表中是不是有该员工补单日的班次信息
/// </summary>
/// <param name="haModel"></param>
/// <returns></returns>
private bool IsExists(HistoryAttendanceModel haModel)
{
return(hisWellBll.GetEmpClassInfo(DateTime.Parse(haModel.BeginWorkTime).ToString("yyyyM"), haModel.BlockID.ToString(), haModel.EmployeeID.ToString(), haModel.ClassID.ToString(), haModel.ClassShortName, haModel.DataAttendance));
}
