/// <summary>
/// 增改
/// </summary>
/// <param name="data"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int insertTimeAttendance_AttendanceScheduleDal(TimeAttendance_AttendanceSchedule data, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[]
{
new SqlParameter("@JobNumber", SqlDbType.VarChar, 50)
{
Value = data.JobNumber
},
new SqlParameter("@Name", SqlDbType.VarChar, 80)
{
Value = data.Name
},
new SqlParameter("@AttendanceTime", SqlDbType.DateTime)
{
Value = data.AttendanceTime
},
new SqlParameter("@UpdateTime", SqlDbType.DateTime)
{
Value = data.UpdateTime
},
new SqlParameter("@MachineID", SqlDbType.VarChar, 50)
{
Value = data.MachineID
},
new SqlParameter("@MachinePosition", SqlDbType.VarChar, 50)
{
Value = data.MachinePosition
},
};
return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
}
/// <summary>
/// 增加、修改
/// </summary>
/// <param name="data"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public bool insertTimeAttendance_AttendanceScheduleBll(TimeAttendance_AttendanceSchedule data, string SQLCommand)
{
if (tasDal.insertTimeAttendance_AttendanceScheduleDal(data, SQLCommand) > 0)
{
return(true);
}
else
{
return(false);
}
}
